[Sqlrelay-discussion] listener not listening on port

[Andre H. <and...@gm...>]

Hello List,

do my first steps with sqlrelay.

I installed original packages which were delivered by Ubuntu 8.04.4 LTS, 
Version should be 0.38

My conf is still simple. i created a listener and a connection to mysql on 
other host. the connection to mysql is created and seems to work but there 
is no listener listening on host where sqlrelay is running. also no socket 
is created.

i cant find a explanation (no other process on port 9000)
This is the startup output:
###
Starting SQL Relay ...
Starting listener:
  sqlr-listener-debug -id my_server_id -config /etc/sqlrelay/sqlrelay.conf &
Debugging to: /var/cache/sqlrelay/debug/sqlr-listener.7298

Starting 1 connections to db1 :
  sqlr-connection-mysql -id my_server_id -connectionid db1 -config 
/etc/sqlrelay/sqlrelay.conf

Starting 1 connections to defaultid :
  sqlr-connection-mysql -id my_server_id -connectionid defaultid -config 
/etc/sqlrelay/sqlrelay.conf
mysql_real_connect failed: Access denied for user 'sqlrelay'@'localhost' 
(using password: NO)
Couldn't log into database.

sqlr-connection-mysql failed to start.

Starting scaler:
  sqlr-scaler  -id my_server_id -config /etc/sqlrelay/sqlrelay.conf

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.
.
###
i wonder why defaultid  also is used. i dont use it in my conf and dont find 
any part where its used. is this efffecting the listener?

listener debug log only says:
###
creating shared memory and semaphores

id filename:

/var/cache/sqlrelay/tmp/ipc/dd25012

creating shared memory...

creating semaphores...
###


this is my current conf:
###
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instances>

        <!-- Regular SQL Relay Instance -->
        <instance id="my_server_id" addresses="0.0.0.0" port="9000" 
socket="/tmp/sqlrelay.socket" dbase="mysql" connections="3" 
maxconnections="15" maxqueuelength="5" growby="1" ttl="60" 
endofsession="commit" sessiontimeout="600" runasuser="sqlrelay" 
runasgroup="sqlrelay" cursors="5" authtier="listener" handoff="pass" 
deniedips="" allowedips="" debug="listener" maxquerysize="65536" 
maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" 
idleclienttimeout="-1" maxlisteners="25" listenertimeout="0">
                <users>
                        <user user="user1" password="password1"/>
                </users>
                <connections>
                        <connection connectionid="db1" 
string="user=mysqluser;password=mysqlpass;db=mysqldb;host=mysqlhost;port=3306;fakebinds=no" 
metric="1" behindloadbalancer="no"/>
                </connections>
                <router>
                </router>
        </instance>
</instances>
###


What could be the issue? I dont find any fault.

Thanks,
Andre