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
 
 
  


_____________________________________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________________________________