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(a)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(a)t-systems.com Cc: serusers(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers = = = = = = = = = = = = = = = = = = = = _______________________________________________ Serusers mailing list Serusers(a)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. _____________________________________________________________________________________________________________________________________________