I got the folowing error:

# mysql -h 127.0.0.1 -P 3306 -user -pheslo ser
ERROR 1045: Access denied for user: 'ser@asterisk1.local' (Using password: YES)


-----Original Message-----
From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
Sent: Thursday, March 16, 2006 1:58 PM
To: İlker Aktuna (Koç.net)
Cc: serusers@lists.iptel.org
Subject: Re: [Serusers] Problem starting SER with Presence support

Are you able to work with ser database using mysql like this?

mysql -h 127.0.0.1 -P 3306 -user -pheslo ser

You can try to increase debug level in SER's config file (debug=4) and see messages in log.

        Vaclav


On Thu, Mar 16, 2006 at 01:36:20PM +0200, ?lker Aktuna (Koç.net) wrote:
> Hi,
>
> Thanks; I did it that way and now the server starts but then exits.
> I see the following lines in my /var/log/messages file:
>
> Mar 16 13:26:33 asterisk1 ./ser[19374]: new_connection: Access denied
> for user: 'ser@asterisk1.local' (Using password: YES) Mar 16 13:26:33
> asterisk1 ./ser[19374]: uri_db:mod_init: Unable to open database
> connection Mar 16 13:26:33 asterisk1 ./ser[19374]: init_mod(): Error
> while initializing module uri_db
>
> However, I can login to mysql db by user ser/heslo.
> Where might be the problem ?
>
> Thanks,
> ilker
>
> -----Original Message-----
> From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> Sent: Thursday, March 16, 2006 11:10 AM
> To: ?lker Aktuna (Koç.net)
> Cc: serusers@lists.iptel.org
> Subject: Re: [Serusers] Problem starting SER with Presence support
>
> That config file is for last CVS version - do you realy have it? Try download at least that one from yesterday's evening and run:
>
> make install include_modules="pa mysql dialog rls fifo xmlrpc presence_b2b"
>
> And you need to modify paths to modules in the config file!
>
>         Vaclav
>
> On Thu, Mar 16, 2006 at 10:50:04AM +0200, ?lker Aktuna (Koç.net) wrote:
> > Ok, I installed the MySQL-python package. Then initdb script run fine.
> > But this time I have the following error when starting ser:
> >
> > [root@asterisk1 sip_router]# /root/ser/sbin/ser -c
> >  0(13176) set_mod_param_regex: parameter
> > <handle_presence_subscriptions> not found in module <presence_b2b>
> >  0(13176) parse error (127,19-20): Can't set module parameter
> >  0(13176) parse error (203,34-35): unknown command, missing loadmodule?
> >
> >  0(13176) parse error (208,30-31): unknown command, missing loadmodule?
> >
> >  0(13176) parse error (213,25-26): unknown command, missing loadmodule?
> >
> >  0(13176) parse error (216,30-31): unknown command, missing loadmodule?
> >
> > ERROR: bad config file (5 errors)
> >
> >
> > what's wrong with my presence_b2b module ?
> >
> > Thanks,
> > ilker
> >
> >
> > ________________________________
> >
> > From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@iptel.org]
> > On Behalf Of ?lker Aktuna (Koç.net)
> > Sent: Thursday, March 16, 2006 10:26 AM
> > To: Vaclav Kubart
> > Cc: serusers@lists.iptel.org
> > Subject: RE: [Serusers] Problem starting SER with Presence support
> >
> >
> >
> > Hi,
> >
> > Thanks for the files. When I run the initdb script I have the following errors.
> > I guess that I need python-mysqldb. Where can I find this ?
> > (I never used python before)
> >
> > Is that package the required one : MySQL-python 0.9.1-6.i386 ?
> >
> > # ./initdb.sh
> > ser_domain: No module named MySQLdb: ImportError
> > ser_user: No module named MySQLdb: ImportError
> > ser_user: No module named MySQLdb: ImportError
> > ser_user: No module named MySQLdb: ImportError
> > ser_user: No module named MySQLdb: ImportError
> > ser_user: No module named MySQLdb: ImportError
> > ser_user: No module named MySQLdb: ImportError
> > ser_uri: No module named MySQLdb: ImportError
> > ser_uri: No module named MySQLdb: ImportError
> > ser_uri: No module named MySQLdb: ImportError
> > ser_uri: No module named MySQLdb: ImportError
> >
> > Thanks,
> > ilker
> >
> > -----Original Message-----
> > From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> > Sent: Thursday, March 16, 2006 9:45 AM
> > To: ?lker Aktuna (Koç.net)
> > Cc: serusers@lists.iptel.org
> > Subject: Re: [Serusers] Problem starting SER with Presence support
> >
> > There is my testing config file. It needs to have some users stored
> > in database (I attach my script which adds initialization data using
> > serctl). You can try to look on it and modify it according your
> > needs (change paths to modules, ...)
> >
> >         Vaclav
> >
> >
> > On Thu, Mar 16, 2006 at 09:30:23AM +0200, ?lker Aktuna (Koç.net) wrote:
> > > Hi,
> > >
> > > Is there any working configuration sample for Ser with presence ?
> > > I understand that handbook is out of date but if my problem is just the fifo line, may I see a working example ?
> > >
> > > Thanks,
> > > ilker
> > >
> > > -----Original Message-----
> > > From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> > > Sent: Wednesday, March 15, 2006 6:11 PM
> > > To: ?lker Aktuna (Koç.net)
> > > Cc: serusers@lists.iptel.org
> > > Subject: Re: [Serusers] Problem starting SER with Presence support
> > >
> > > Hello,
> > > mysql tables can be created using script scripts/mysql/ser_mysql.sh in source tree (CVS version).
> > >
> > > Presence handbook is a bit out of date, but in few days there will be new version - please be patient.
> > >
> > >         Vaclav
> > >
> > > On Wed, Mar 15, 2006 at 05:57:07PM +0200, ?lker Aktuna (Koç.net) wrote:
> > > > Hi,
> > > >
> > > > Thanks for the presence book. I am reading it now. But I think I
> > > > also need scripts for creating needed tables in Mysql. I
> > > > couldn't find anywhere scripts for mysql.  There is a "make dbinstall"
> > > > command in cvs release but that didn't produce the expected result.
> > > >
> > > > Btw, I just compiled cvs version again and tried the cfg file
> > > > example in the presence book at
> > > > ftp://ftp.iptel.org/pub/ser/presence/ This cfg example still has
> > > > the fifo="/tmp/ser_fifo" in it and I still get the same parse error.
> > > >
> > > > Any help on this ?
> > > >
> > > > Thanks,
> > > > ilker
> > > >
> > > > -----Original Message-----
> > > > From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> > > > Sent: Wednesday, March 15, 2006 8:37 AM
> > > > To: ?lker Aktuna (Koç.net)
> > > > Cc: serusers@lists.iptel.org
> > > > Subject: Re: [Serusers] Problem starting SER with Presence
> > > > support
> > > >
> > > > Hi,
> > > > I am responsible for presence server in ser.
> > > >
> > > > In few days, there will be new version of presence snapshot with new version of "presence handbook" (actualized documentation and configuration samples). Last versions of them are available on ftp://ftp.iptel.org/pub/ser/presence.
> > > >
> > > > Try to read the "presence handbook", all things needed for presence setup should be written there. Let me know if you miss something in it.
> > > >
> > > >         Vaclav
> > > >
> > > > P.S. Old configuration files will probably NOT work with new version of ser (like your fifo problems).
> > > >
> > > > On Tue, Mar 14, 2006 at 05:50:27PM +0200, ?lker Aktuna (Koç.net) wrote:
> > > > > Hi again,
> > > > >
> > > > > isn't there anyone who uses the development SER version ? Anyone using/testing presence server ?
> > > > > How can I contact the developers ? (serdev@lists.iptel.org does not
> > > > > accept my emails)
> > > > >
> > > > > Maybe someone could point me to another presence server. Is there any presence server available for trying ?
> > > > >
> > > > > I am desperately trying to build some presence server. Please help me...
> > > > >
> > > > > Thanks,
> > > > > ilker
> > > > >
> > > > >
> > > > > ________________________________
> > > > >
> > > > > From: serusers-bounces@lists.iptel.org
> > > > > [mailto:serusers-bounces@iptel.org]
> > > > > On Behalf Of ?lker Aktuna (Koç.net)
> > > > > Sent: Tuesday, March 14, 2006 9:12 AM
> > > > > To: serusers@lists.iptel.org
> > > > > Subject: [Serusers] Problem starting SER with Presence support
> > > > >
> > > > >
> > > > > Hi everyone,
> > > > >
> > > > > I am trying to run SER with presence server support. That's why I'm downloading the development sources with command:
> > > > > cvs -d :pserver:anonymous@cvs.berlios.de:/cvsroot/ser checkout
> > > > > sip_router
> > > > >
> > > > > I have libxml2 installed and the sources compile fine.
> > > > > After that I try to start ser with attached config file "ser1.cfg". Actually, it is the simple config from the gettingstarted guide hello world part.
> > > > >
> > > > > Unfortunately ser does not start with the following error:
> > > > >
> > > > > # <mailto:ot@asterisk1>  /root/ser/sbin/ser -c -f
> > > > > /root/ser/etc/ser/ser.cfg
> > > > >  0(28118) parse error (11,1-5): syntax error
> > > > >  0(28118) parse error (11,1-5):
> > > > > ERROR: bad config file (2 errors)
> > > > >
> > > > > Line 11 has the "fifo" file definition. My /tmp folder settings seem ok :
> > > > >
> > > > > # ls -adl /tmp/
> > > > > drwxrwxrwt   14 root     root         4096 Mar 13 09:25 /tmp/
> > > > >
> > > > > If I remove fifo line from the config (as in ser2.cfg) , ser starts but I guess that's not the right way. Because that time I can't register any clients and "serctl" command gives following error:
> > > > >
> > > > > Error opening ser's FIFO /tmp/ser_fifo Make sure you have line
> > > > > fifo=/tmp/ser_fifo in your config
> > > > >
> > > > > By any chance, is there any user/developer who may have dealt with thşs problem before ?
> > > > >
> > > > > Thanks,
> > > > > ilker
> > > > >
> > > > >