回覆: [Users] get error

[Klaus Darilion]

Hi!

Please always cc the list

Make sure you use the same versions of the openser binaries and the
openser_mysql script.

use
openser_mysql drop
openser_mysql create

watch for error mesages during creating.

regards
klaus


Allan Chao ( 策略性新技術開發處申請 ) wrote:
> Dear  klaus :
> 	thank you for your help.
> 	You say unpdating it with the opensermysql , but I tries many times with "openser_mysql create" command.
> 	
> Allan
> -----原始郵件-----
> 寄件者: Klaus Darilion [mailto:klaus.mailinglists at pernau.at] 
> 寄件日期: 2006年5月3日 下午 04:09
> 收件者: Allan Chao ( 策略性新技術開發處申請 )
> 副本: users at openser.org
> 主旨: Re: [Users] get error
> 
> The usrloc and registrar module checks the schema of the 'location'
> table. This is needed because never versions of openser often needs newer version of the location (and aliases) table.
> 
> Therefore there is a 'version' table, which tells openser the version number of the used tables.
> 
> Thus, make sure you have the proper database table schemas. When using a never version of openser, you also have to update the table schemas.
> 
> If this is just for a testing machine, delete the whole openser DB and create it new. If you a are updating a production system, make a backup of the DB and try to update it with the opensermysql script. If this fails, use the backuped version and update the table definitions manually.
> 
> regards
> klaus
> 
> Allan Chao ( 策略性新技術開發處申請 ) wrote:
>> Dear all:
>>         i got a error when starts openser
>>  
>> 0(0) new_connection: Opening MySQL connection: 
>> mysql://openser:openserrw@172.17.50.128/openser
>>  0(0) new_connection: Connection type is 172.17.50.128via TCP/IP
>>  0(0) new_connection: Protocol version is 10
>>  0(0) new_connection: Server version is 4.0.26-log
>>  0(0) usrloc:preload_udomain: Wrong version v165581944 for table 
>> <location>, expected v1001
>>  0(0) register_udomain(): Error while preloading domain 'location'
>>  0(0) pool_remove: Removing connection from the pool
>>  0(0) domain_fixup(): Error while registering domain
>> ERROR: error -1 while trying to fix configuration what's problem for 
>> it , is any configuration error?  thanks.
>>  
>> Allan
>>
>> DISCLAIMER:
>> This message (and any attachments) may contain information that is 
>> confidential, proprietary, privileged or otherwise protected by law.
>> The message is intended solely for the named addressee (or a person 
>> responsible for delivering it to the addressee).
>> If you are not the
>> intended recipient of this message, you are not authorized to read, 
>> print, retain, copy or disseminate this message or any part of it. If 
>> you have received this message in error, please destroy the message or 
>> delete it from your system immediately and notify the sender.
>>
>>
>> ----------------------------------------------------------------------
>> --
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
> 
> 
> 
> DISCLAIMER:
> Sample Disclaimer added in a VBScript.