[Serusers] mysql configuration issue

Fri Jun 9 07:00:55 CEST 2006

Hi,

We tried in that way also ...but didn't work!

So we reinstalled the SER binary once again (debian packages including mysql module) after that it starts working properly.

Thanks!

Regards,

Benjamin.

  _____  

From: Greger V. Teigre [mailto:greger at teigre.com] 
Sent: Friday, June 09, 2006 1:52 AM
To: George, Benjamin
Cc: serusers at iptel.org
Subject: Re: [Serusers] mysql configuration issue

:-) I just assumed you had run ser_mysql.sh and that maybe the error was a result of a connection error. But you're probably right. The value for register in the version needs to match what this version of SER register module requires. If you rename you ser DB and let ser_mysql.sh reinitialize it, you will have the reference.
g-)

Benjamin.George at t-systems.com <mailto:Benjamin.George at t-systems.com>  wrote: 

Hi,

I feel it is not a linking issue. This is something related to table version of table 'subscriber'/'domain'/'location', I think so. So it will be great if some body can throw some light in to this issue. Here go the error messages once again:

[

stateless - initializing

root at ubuntu:/usr/local/etc/ser #  0(0) Maxfwd module- initializing

textops - initializing

 0(0) register_udomain(): Invalid table version (use ser_mysql.sh reinstall)

 0(0) domain_fixup(): Error while registering domain

ERROR: error -1 while trying to fix configuration

]

My SER version is 0.9.x

And MySql version is 4.1.x

OS: Ubuntu linux

Thanks and regards,

Benjamin.

  _____  

From: Greger V. Teigre [mailto:greger at teigre.com <mailto:greger at teigre.com> ] 
Sent: Thursday, June 01, 2006 11:40 AM
To: George, Benjamin
Cc: serusers at iptel.org <mailto:serusers at iptel.org> 
Subject: Re: [Serusers] mysql configuration issue

Have you linked against the right libraries?
This is for 0.9.x on CentOS 4:
[greger at siprouter modules]$ ldd mysql.so                                          
        libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14 (0x00111000)
        libz.so.1 => /usr/lib/libz.so.1 (0x002aa000)
        libc.so.6 => /lib/tls/libc.so.6 (0x00c94000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x006a6000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x00376000)
        libm.so.6 => /lib/tls/libm.so.6 (0x00530000)
        libssl.so.4 => /lib/libssl.so.4 (0x00c0a000)
        libcrypto.so.4 => /lib/libcrypto.so.4 (0x00e29000)
        /lib/ld-linux.so.2 (0x00987000)
        libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00baa000)
        libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x0022a000)
        libcom_err.so.2 => /lib/libcom_err.so.2 (0x00faa000)
        libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x003fc000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x00a5e000)
        libdl.so.2 => /lib/libdl.so.2 (0x0028f000)

[greger at siprouter modules]$ rpm -q mysql
mysql-4.1.12-3.RHEL4.1

Benjamin.George at t-systems.com <mailto:Benjamin.George at t-systems.com>  wrote: 

Hi All,

Thanks Adam for providing the link.
But as mentioned by zhangshuai, I am also getting the same error after doing those procedures. Error messages are pasted below:

stateless - initializing
 0(0) Maxfwd module- initializing
textops - initializing
root at ubuntu:/usr/local/sbin #  0(0) register_udomain(): Invalid table version (use ser_mysql.sh reinstall)
 0(0) domain_fixup(): Error while registering domain
ERROR: error -1 while trying to fix configuration

It will be great somebody gives some pointer to resolve this issue.

Regards,
Benjamin.

-----Original Message-----
From: serusers-bounces at lists.iptel.org <mailto:serusers-bounces at lists.iptel.org>  [mailto:serusers-bounces at lists.iptel.org <mailto:serusers-bounces at lists.iptel.org> ] On Behalf Of zhangshuai
Sent: Thursday, June 01, 2006 6:57 AM
To: serusers
Subject: Re: Re: [Serusers] mysql configuration issue

Dear All,

I use mysql-4.1.15 and encountered the same error. After I did as the webpage said, I got another error: "invalid table version".

I compiled the source code from cvs:

cvs -d :pserver:anonymous at cvs.berlios.de:/cvsroot/ser checkout sip_router 

Is it the latest stable version?

Thanks for your answers.

Benjamin.George at t-systems.com <mailto:Benjamin.George at t-systems.com>  wrote:

*root at ubuntu:/usr/local/sbin #  0(0) new_connection(): Client does not 
support authentication protocol requested by server; consider upgrading 
MySQL client*

http://dev.mysql.com/doc/refman/5.0/en/old-client.html <http://dev.mysql.com/doc/refman/5.0/en/old-client.html> 

Regards
Adam
_______________________________________________
Serusers mailing list
Serusers at lists.iptel.org <mailto:Serusers at lists.iptel.org> 
http://lists.iptel.org/mailman/listinfo/serusers <http://lists.iptel.org/mailman/listinfo/serusers> 

= = = = = = = = = = = = = = = = = = = =

_______________________________________________
Serusers mailing list
Serusers at lists.iptel.org <mailto:Serusers at lists.iptel.org> 
http://lists.iptel.org/mailman/listinfo/serusers <http://lists.iptel.org/mailman/listinfo/serusers> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060609/0b4b4217/attachment.htm>