[Serusers] Problem starting SER with Presence support
Vaclav Kubart
vaclav.kubart at iptel.org
Thu Mar 16 13:42:07 CET 2006
You have probably badly set privileges in database. Try to tun
GRANT ALL ON ser.* TO 'ser'@'localhost' IDENTIFIED BY 'heslo';
or
GRANT ALL ON ser.* TO 'ser'@'127.0.0.1' IDENTIFIED BY 'heslo';
or something like that in mysql (you must be root for that) and try it
again.
Vaclav
On Thu, Mar 16, 2006 at 02:13:35PM +0200, ?lker Aktuna (Koç.net) wrote:
> I can login with:
> # mysql -P 3306 -user -pheslo ser
>
> but I can't login with:
> # mysql -h 127.0.0.1 -P 3306 -user -pheslo ser
>
> ________________________________
>
> From: ?lker Aktuna (Koç.net)
> Sent: Thursday, March 16, 2006 2:11 PM
> To: 'Vaclav Kubart'
> Cc: serusers at lists.iptel.org
> Subject: RE: [Serusers] Problem starting SER with Presence support
>
>
>
> I got the folowing error:
>
> # mysql -h 127.0.0.1 -P 3306 -user -pheslo ser
> ERROR 1045: Access denied for user: 'ser at asterisk1.local' (Using password: YES)
>
>
> -----Original Message-----
> From: Vaclav Kubart [mailto:vaclav.kubart at iptel.org]
> Sent: Thursday, March 16, 2006 1:58 PM
> To: ?lker Aktuna (Koç.net)
> Cc: serusers at 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 at 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 at iptel.org]
> > Sent: Thursday, March 16, 2006 11:10 AM
> > To: ?lker Aktuna (Koç.net)
> > Cc: serusers at 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 at 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 at iptel.org [mailto:serusers-bounces at lists.iptel.org]
> > > On Behalf Of ?lker Aktuna (Koç.net)
> > > Sent: Thursday, March 16, 2006 10:26 AM
> > > To: Vaclav Kubart
> > > Cc: serusers at 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 at iptel.org]
> > > Sent: Thursday, March 16, 2006 9:45 AM
> > > To: ?lker Aktuna (Koç.net)
> > > Cc: serusers at 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 at iptel.org]
> > > > Sent: Wednesday, March 15, 2006 6:11 PM
> > > > To: ?lker Aktuna (Koç.net)
> > > > Cc: serusers at 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 at iptel.org]
> > > > > Sent: Wednesday, March 15, 2006 8:37 AM
> > > > > To: ?lker Aktuna (Koç.net)
> > > > > Cc: serusers at 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 at 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 at lists.iptel.org
> > > > > > [mailto:serusers-bounces at lists.iptel.org]
> > > > > > On Behalf Of ?lker Aktuna (Koç.net)
> > > > > > Sent: Tuesday, March 14, 2006 9:12 AM
> > > > > > To: serusers at 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 at 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 at 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
> > > > > >
> > > > > >
>
>
>
>
> <http://271570.sigclick.mailinfo.com/sigclick/03030702/0401490A/010C4A05/21467315.jpg>
> _____________________________________________________________________________________________________________________________________________
> Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.
> This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
> _____________________________________________________________________________________________________________________________________________
More information about the sr-users
mailing list