Re: [Sqlrelay-discussion] Starting listener: unsuccessful completion

[David M. <dav...@fi...>]

The package installation should have created /var/sqlrelay/tmp and the
necessary subdirectories.  I'm surprised that it didn't.  They would
have been root-owned, but should have 777 permissions.

Make sure that the following directories exist and have 777 perms:

/var/sqlrelay/tmp
/var/sqlrelay/tmp/ipc
/var/sqlrelay/tmp/pids
/var/sqlrelay/tmp/sockets

/var/sqlrelay/cache

/var/sqlrelay/debug

If they already exist, remove any existing files in them.  If you ran
sqlrelay as root once, then try to run it as a different user afterward,
there could still be a file out there owned by root that can't be
overwritten or opened by the new user.

That should take care of it.  Hope this helps.

David
dav...@fi...


On Tue, 2008-05-20 at 17:42 +0200, Anthony Gardner wrote:
> 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 __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
> http://www.doteasy.com 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft 
> Defy all challenges. Microsoft(R) Visual Studio 2008. 
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com