[Serusers] mysql configuration issue

[Greger V. Teigre]

:-) 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 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
> *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/20060608/9cda0024/attachment.htm>