RE: [Serusers] mysql configuration issue - sr-users

9 Jun 2006


      Hi,
No, it's not leftover file or anything else.
Actually I think new CVS version has some problems with usrloc and domain database support.
Because I have the same problem when I use usrloc with db support on new source.
As a solution I used the old binary usrloc module with new ser.
Regards,
ilker
________________________________
From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Greger V. Teigre
Sent: Friday, June 09, 2006 8:36 AM
To: Benjamin.George@t-systems.com
Cc: serusers@iptel.org
Subject: Re: [Serusers] mysql configuration issue
Good to hear. You probably had a leftover so file or something, making the db inconsistent with the binaries...
g-)
Benjamin.George@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@teigre.com] 
    Sent: Friday, June 09, 2006 1:52 AM
    To: George, Benjamin
    Cc: serusers@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@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@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@teigre.com] 
    Sent: Thursday, June 01, 2006 11:40 AM
    To: George, Benjamin
    Cc: serusers@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@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@siprouter modules]$ rpm -q mysql
    mysql-4.1.12-3.RHEL4.1
    
    
    Benjamin.George@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@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@lists.iptel.org [mailto:serusers-bounces@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@cvs.berlios.de:/cvsroot/ser checkout sip_router 
     
    Is it the latest stable version?
     
    Thanks for your answers.
Benjamin.George@t-systems.com wrote:
*root@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@lists.iptel.org
    	http://lists.iptel.org/mailman/listinfo/serusers
= = = = = = = = = = = = = = = = = = = =
                           
     
    _______________________________________________
    Serusers mailing list
    Serusers@lists.iptel.org
    http://lists.iptel.org/mailman/listinfo/serusers
http://387555.sigclick.mailinfo.com/sigclick/010B0604/04044901/04054D03/82311115.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.
_____________________________________________________________________________________________________________________________________________