Aware IM User Forums Forum Index Aware IM User Forums
Discussions, questions, ideas, opinions about Aware IM
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

strange MySql problem

 
Post new topic   Reply to topic    Aware IM User Forums Forum Index -> General discussion and questions about Aware IM
View previous topic :: View next topic  
Author Message
Hubertus



Joined: 11 Feb 2006
Posts: 153
Location: Austria

PostPosted: Tue Aug 01, 2006 8:30 am    Post subject: strange MySql problem Reply with quote

I've just tried installing AwareIM on a headless Linux server.
Starting AwareIM creates the databases BASDB and BASDBTEST correctly, but trying to create the default tables results in
Quote:
Creating database tables...
Database tables have been created
Installing predefined objects...
2006-08-01 09:09:05,298 ERROR -Error adding new record into the history
of business space version Error inserting history record into
persistence Incorrect arguments to mysql_stmt_execute
Dropping database tables...
Database tables have been dropped
Cleaning up...
Could not initialise database tables
Aware IM Server startup error Unable to initialise the database tables
due to the following exception
com.bas.basserver.persistence.PersistenceException Internal error. Error
persisting business object RegularUser Incorrect arguments to
mysql_stmt_execute exiting...


This happens using MySQL 4.1.12-Debian_1ubuntu3-log whereas 4.0.24_Debian-10ubuntu2.1-log works perfectly.

Any ideas ? Confused
Back to top
View user's profile Send private message Send e-mail Visit poster's website
aware_support



Joined: 24 Apr 2005
Posts: 3224

PostPosted: Tue Aug 01, 2006 8:42 am    Post subject: Reply with quote

It looks like a MySQL bug specific for this operating system (actually somewhere between MySQL and MySQL driver). Please try this workaround:

Add "&useServerPrepStmts=false" to 3 MySQL entries in the BASServer.props file, for example:

DriverURL=jdbc:mysql://localhost/BASDB?user=root&useServerPrepStmts=false
DriverTestURL=jdbc:mysql://localhost/BASDBTEST?user=root&useServerPrepStmts=false
BootstrapURL=jdbc:mysql://localhost/?user=root&useServerPrepStmts=false
_________________
Aware IM Support Team
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Hubertus



Joined: 11 Feb 2006
Posts: 153
Location: Austria

PostPosted: Tue Aug 01, 2006 9:42 am    Post subject: Reply with quote

You guys are crazy ! YESSS it works !!!!!!
Thanks a lot
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aware IM User Forums Forum Index -> General discussion and questions about Aware IM All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group