[Serusers] mysql configuration issue

[Greger V. Teigre]

Good to hear. You probably had a leftover so file or something, making 
the db inconsistent with the binaries...
g-)

Benjamin.George at t-systems.com wrote:
>
> 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]
> *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] 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
>>  
>> Regards
>> Adam
>> _______________________________________________
>> Serusers mailing list
>> Serusers at lists.iptel.org <mailto:Serusers at lists.iptel.org>
>> 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
>  
>  
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060609/e047a14c/attachment.htm>