[Sqlrelay-discussion] Starting listener: unsuccessful completion

[Anthony G. <ant...@gm...>]

I sent this under yahoo but have just seen in the archives that it's totally
HTML. So, sorry about that. Let's see how gmail copes!!

Using the following sqlrelay.conf file .....
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>

  <instance id="sqlitetest"
            port="9000"
            socket="/tmp/sqlitetest.socket"
            dbase="sqlite"
            connections="3"
            maxconnections="5"
            maxqueuelength="0"
            growby="1"
            ttl="60"
            endofsession="commit"
            sessiontimeout="600"
            runasuser="anthony"
            runasgroup="anthony"
            cursors="5"
            authtier="listener"
            handoff="pass"
            debug="listener_and_connection">
    <users>
      <!-- user user="sqlitetest" password="sqlitetest"/ -->
      <user user="" password=""/>
    </users>
    <connections>
      <connection connectionid="sqlitetest"
string="db=/home/anthony/Development/sqlrelay/sqlrelay_test.db" metric="1"/>
    </connections>
  </instance>

</instances>

I get the following output from running ....  sudo sqlr-start -id sqlitetest
-config sqlrelay.conf


Starting listener:
  sqlr-listener-debug -id sqlitetest -config sqlrelay.conf &
Debugging to: /var/cache/sqlrelay/debug/sqlr-listener.10989
Could not open: /var/cache/sqlrelay/tmp/ipc/sqlitetest
Make sure that the file and directory are readable and writable.

unsuccessful completion

Starting 3 connections to sqlitetest :
  sqlr-connection-sqlite-debug -id sqlitetest -connectionid sqlitetest
-config sqlrelay.conf &
Debugging to: /var/cache/sqlrelay/debug/sqlr-connection.10991

sqlr-connection error:
        The pid file /var/cache/sqlrelay/tmp/pids/sqlr-listener-sqlitetest
was not found.
        This usually means that the sqlr-listener
is not running.
        The sqlr-listener must be running for the sqlr-connection to start.

  sqlr-connection-sqlite-debug -id sqlitetest -connectionid sqlitetest
-config sqlrelay.conf &
Debugging to: /var/cache/sqlrelay/debug/sqlr-connection.10996

sqlr-connection error:
        The pid file /var/cache/sqlrelay/tmp/pids/sqlr-listener-sqlitetest
was not found.
        This usually means that the sqlr-listener
is not running.
        The sqlr-listener must be running for the sqlr-connection to start.

  sqlr-connection-sqlite-debug -id sqlitetest -connectionid sqlitetest
-config sqlrelay.conf &
Debugging to: /var/cache/sqlrelay/debug/sqlr-connection.10998

sqlr-connection error:
        The pid file /var/cache/sqlrelay/tmp/pids/sqlr-listener-sqlitetest
was not found.
        This usually means that the sqlr-listener
is not running.
        The sqlr-listener must be running for the sqlr-connection to start.


Starting cache manager:
  sqlr-cachemanager
Warning: using default id.


Thanks to MP3.com for sponsoring:
        Clustered/Replicated database support.
        Perl API.
Thanks to FeedLounge for sponsoring:
        Query routing and filtering.

/var/cache/sqlrelay/tmp/ipc/sqlitetest was automatically created by sqlrelay


I manually created pids and sockets directory
/var/cache/sqlrelay/tmp/pids
/var/cache/sqlrelay/tmp/sockets

I have changed permissions to 777 from /var/cache/sqlrelay downwards

SQL Relay version: 0.38 installed from Ubuntu binaries on 8.04

Any pointers would be great.

-Ants