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

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

Thanks for the help, David. I uninstalled everything and started again but
the package manager didn't build the dirs when installing the packages (it
did delete them when uninstalling, though)

Anyway, some of the dirs were created when running sqlrealy for the first
time, the other dirs I made myself.

All of that was on my local machine. We've had the same problems on our
work's machines and they use RedHat.

Any who, we're getting there. Have another question but will write a new
mail, for that.

2008/5/21 David Muse <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
>
> -------------------------------------------------------------------------
> 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
>

-- 
Disclaimer: Technically speaking, I'm always wrong!