[Serusers] mysql configuration issue

Fri Jun 9 07:48:51 CEST 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 at lists.iptel.org [mailto:serusers-bounces at lists.iptel.org] On Behalf Of Greger V. Teigre
Sent: Friday, June 09, 2006 8:36 AM
To: Benjamin.George at t-systems.com
Cc: serusers at 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 at 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 at teigre.com] 
	Sent: Friday, June 09, 2006 1:52 AM
	To: George, Benjamin
	Cc: serusers at 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 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 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] 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 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
		http://lists.iptel.org/mailman/listinfo/serusers

	= = = = = = = = = = = = = = = = = = = =

	_______________________________________________
	Serusers mailing list
	Serusers at 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.
_____________________________________________________________________________________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060609/cbd256ad/attachment.htm>