Re: [Serusers] mysql configuration issue

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