31 May
2006
31 May
'06
6:30 p.m.
Now I am getting the following error while running SER:
stateless - initializing
0(0) Maxfwd module- initializing
textops - initializing
root@ubuntu:/usr/local/sbin # 0(0) new_connection(): Client does not support
authentication protocol requested by server; consider upgrading MySQL client
0(0) db_init(): Could not create a connection
0(0) register_udomain(): Can not open database connection
0(0) domain_fixup(): Error while registering domain
ERROR: error -1 while trying to fix configuration
It will be great if some one can throw some light on how to resolve this this issue.
MySql version is 5.0
Thanks,
Benjamin.
_____
From: Mindaugas Kuprys [mailto:mindaugask@erdves.lt]
Sent: Tuesday, May 30, 2006 6:40 PM
To: George, Benjamin
Cc: serusers(a)iptel.org
Subject: Re: [Serusers] mysql configuration issue
Check if your mysqld is running. Check if you socket is in the right place (
/var/run/mysqld/mysqld.sock) If not try to connect through tcp/ip insted of socked -
rewrite localhost with 127.0.0.1 in ser.cfg file.
Benjamin.George(a)t-systems.com <mailto:Benjamin.George@t-systems.com> wrote:
Hi,
I put the debug on now and started getting debug messages.
The error which I am getting now is pasted below:
root@ubuntu:/usr/local/etc/ser # ser start
Listening on
udp: 127.0.0.1 [127.0.0.1]:5060
udp: 10.25.119.97 [10.25.119.97]:5060
tcp: 127.0.0.1 [127.0.0.1]:5060
tcp: 10.25.119.97 [10.25.119.97]:5060
Aliases:
tcp: ubuntu:5060
tcp: localhost:5060
tcp: localhost.localdomain:5060
udp: ubuntu:5060
udp: localhost:5060
udp: localhost.localdomain:5060
stateless - initializing
0(0) Maxfwd module- initializing
textops - initializing
0(0) new_connection(): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
0(0) db_init(): Could not create a connection
0(0) ERROR: auth_db_ver: unable to open database connection
0(0) auth_db:str_fixup(): Error while querying table version
0(0) ERROR: fix_expr : fix_actions error
ERROR: error -1 while trying to fix configuration
What might be the possible reason for this error? Can anyone help me out to solve this
issue or it will be great if someone throw some light on why this error happens while
starting SER with MySql.
Thanks,
Benjamin.
-----Original Message-----
From: serusers-bounces(a)lists.iptel.org <mailto:serusers-bounces@lists.iptel.org>
[mailto:serusers-bounces@lists.iptel.org <mailto:serusers-bounces@lists.iptel.org> ]
On Behalf Of Andrey Kouprianov
Sent: Monday, May 29, 2006 7:36 PM
To: serusers(a)iptel.org <mailto:serusers@iptel.org>
Subject: Re: [Serusers] mysql configuration issue
what does /var/log/messages say?
On 5/29/06, Benjamin.George(a)t-systems.com <mailto:Benjamin.George@t-systems.com>
<mailto:Benjamin.George@t-systems.com> <Benjamin.George(a)t-systems.com> wrote:
Hi,
Thanks for the reply!
My installed SER version is >0.9.x. Anyway, my issue is not with presence server for
the time being. Before experimenting with presence server, I have to complete the mysql
configuration with SER. I ran the script to create the Ser DB and tables. It went
successfully and all the tables got created. After this, I modified the ser.cfg file to
configure mysql with SER (.cfg file is attached). After these modifications, ser -c
command was executed and I got an error related to libmysqlclient.so.12. Then I created a
soft link to libmysqlclient.so.10. After this, ser -c command was through but when I tried
to start the server, it is not getting started. I could not understand the real issue why
the SER server is not getting started. I have to configure the mysql to continue my
experiments with presence server. It will be great if somebody can get me some pointers on
configuring mysql with SER. Some links or tutorials are also well being appreciated.
Thanks,
Benjamin
-----Original Message-----
From: Andrey Kouprianov [mailto:andrey.kouprianov@gmail.com
<mailto:andrey.kouprianov@gmail.com> ]
Sent: Monday, May 29, 2006 12:39 PM
To: serusers(a)iptel.org <mailto:serusers@iptel.org>
Subject: Re: [Serusers] mysql configuration issue
you have installed version <= 0.9.x. This version doesnt have any
presence support, except simply forwarding presence/IM messages back
and forth. What you need is to install ser with presence. it's still
unstable, but try it anyway.
ftp.iptel.org/pub/ser/presence/ <ftp://ftp.iptel.org/pub/ser/presence/>
On 5/29/06, Benjamin.George(a)t-systems.com <mailto:Benjamin.George@t-systems.com>
<mailto:Benjamin.George@t-systems.com> <Benjamin.George(a)t-systems.com> wrote:
Hi ,
I am a new user of SER and last week only I started installing and
configuring SER to deploy some presence based applications on top of SER. I
am finiding some configuration issues with mysql and SER. I installed SER
and registerd users (X-Lite) successfully. After that I installed mysql to
store all registration and other information to database instead of in RAM.
After mysql installation, I ran the script to create the Ser database and
tables for SER, every thing got craeted successfully. Then the lines
mentioned to uncomment to use mysql also has been uncommented in ser.cfg
file. But when I registerd the users again, I could not see any users in the
table subsriber. It will be great if somebody can throw some light in to
this issue so that I could complete my mysql configuration with Ser. What
extra configuration has to be done in ser.cfg file to use mysql?
Thanks in advance,
Benjmain.
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers
<http://lists.iptel.org/mailman/listinfo/serusers>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers
<http://lists.iptel.org/mailman/listinfo/serusers>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers
<http://lists.iptel.org/mailman/listinfo/serusers>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org>
http://lists.iptel.org/mailman/listinfo/serusers
<http://lists.iptel.org/mailman/listinfo/serusers>