Re: [Sqlrelay-discussion] Starting listener: unsuccessful completion
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2008-05-21 03:10:02
|
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 |