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@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@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@iptel.org [mailto:serusers-bounces@lists.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@lists.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

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. _____________________________________________________________________________________________________________________________________________