[Sqlrelay-discussion] Starting listener: unsuccessful completion

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

<table cellspacing='0' cellpadding='0' border='0' ><tr><td style='font: inherit;'>Using the following sqlrelay.conf file .....<br>&lt;?xml version="1.0"?&gt;<br>&lt;!DOCTYPE instances SYSTEM "sqlrelay.dtd"&gt;<br>&lt;instances&gt;<br><br>&nbsp; &lt;instance id="sqlitetest"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; port="9000"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; socket="/tmp/sqlitetest.socket"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbase="sqlite"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connections="3"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxconnections="5"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxqueuelength="0"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; growby="1"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 ttl="60"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; endofsession="commit"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sessiontimeout="600"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; runasuser="anthony"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; runasgroup="anthony"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursors="5"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; authtier="listener"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; handoff="pass"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; debug="listener_and_connection"&gt;<br>&nbsp;&nbsp;&nbsp; &lt;users&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!-- user user="sqlitetest" password="sqlitetest"/ --&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;user user="" password=""/&gt;<br>&nbsp;&nbsp;&nbsp;
 &lt;/users&gt;<br>&nbsp;&nbsp;&nbsp; &lt;connections&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connection connectionid="sqlitetest" string="db=/home/anthony/Development/sqlrelay/sqlrelay_test.db" metric="1"/&gt;<br>&nbsp;&nbsp;&nbsp; &lt;/connections&gt;<br>&nbsp; &lt;/instance&gt;<br><br>&lt;/instances&gt;<br><br>I get the following output from running ....&nbsp; sudo sqlr-start -id sqlitetest -config sqlrelay.conf<br><br><br>Starting listener:<br>&nbsp; sqlr-listener-debug -id sqlitetest -config sqlrelay.conf &amp;<br>Debugging to: /var/cache/sqlrelay/debug/sqlr-listener.10989<br>Could not open: /var/cache/sqlrelay/tmp/ipc/sqlitetest<br>Make sure that the file and directory are readable and writable.<br><br>unsuccessful completion<br><br>Starting 3 connections to sqlitetest :<br>&nbsp; sqlr-connection-sqlite-debug -id sqlitetest -connectionid sqlitetest -config sqlrelay.conf &amp;<br>Debugging to:
 /var/cache/sqlrelay/debug/sqlr-connection.10991<br><br>sqlr-connection error:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The pid file /var/cache/sqlrelay/tmp/pids/sqlr-listener-sqlitetest was not found.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This usually means that the sqlr-listener <br>is not running.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The sqlr-listener must be running for the sqlr-connection to start.<br><br>&nbsp; sqlr-connection-sqlite-debug -id sqlitetest -connectionid sqlitetest -config sqlrelay.conf &amp;<br>Debugging to: /var/cache/sqlrelay/debug/sqlr-connection.10996<br><br>sqlr-connection error:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The pid file /var/cache/sqlrelay/tmp/pids/sqlr-listener-sqlitetest was not found.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This usually means that the sqlr-listener <br>is not running.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The sqlr-listener must be running for the
 sqlr-connection to start.<br><br>&nbsp; sqlr-connection-sqlite-debug -id sqlitetest -connectionid sqlitetest -config sqlrelay.conf &amp;<br>Debugging to: /var/cache/sqlrelay/debug/sqlr-connection.10998<br><br>sqlr-connection error:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The pid file /var/cache/sqlrelay/tmp/pids/sqlr-listener-sqlitetest was not found.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This usually means that the sqlr-listener <br>is not running.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The sqlr-listener must be running for the sqlr-connection to start.<br><br><br>Starting cache manager:<br>&nbsp; sqlr-cachemanager<br>Warning: using default id.<br><br><br>Thanks to MP3.com for sponsoring: <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Clustered/Replicated database support.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Perl API.<br>Thanks to FeedLounge for sponsoring: <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Query routing and
 filtering.<br><br>/var/cache/sqlrelay/tmp/ipc/sqlitetest was automatically created by sqlrelay <br><br>I manually created pids and sockets directory<br>/var/cache/sqlrelay/tmp/pids<br>/var/cache/sqlrelay/tmp/sockets<br><br>I have changed permissions to 777 from /var/cache/sqlrelay downwards<br><br>SQL Relay version: 0.38 installed from Ubuntu binaries on 8.04<br><br>Any pointers would be great.<br><br>-Ants<br><br>Disclaimer: Technically speaking, I am always wrong!</td></tr></table><br>


      <hr size=1>
Sent from <a  
href="http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=52418/*http://uk.docs.yahoo.com/nowyoucan.html" target=_blank>Yahoo! Mail</a>.
<br>
A Smarter Email.