Running AwareIM against MySQL 4.1

using MySQL "almost" works out of the box but not with MySQL 4.1 on linux

If you want to connect AwareIM to a MySQL database you have to make some adjustments to BASServer.props file in awareim/bin. This is well documented in the user's guide.

But in case you have an MySQL 4.1 db (I don't know if this applies to older versions too) then you need to add useServerPrepStmts=false to the 3 lines dealing with you MySQL connection.

DriverURL=jdbc:mysql://localhost/BASDB?user=root&password=idontremember&useServerPrepStmts=false
DriverTestURL=jdbc:mysql://localhost/BASDBTEST?user=root&password=idontremember&useServerPrepStmts=false
BootstrapURL=jdbc:mysql://localhost/?user=root&password=idontremember&useServerPrepStmts=false

 This has also been discussed on the AwareIM Forum