I've been struggling with mysql and dbmail. (SLES 10) I finally believed I had mysql 5.0.18 converted to utf8 by putting the following in /etc/mycnf
default-character-set = utf8 character-set-server = utf8 init-connect='SET NAMES utf8' show variables; now give all character sets in utf8. The three collation setting show. utf8_general_ci Errors in dbmail.err are: cannot load modules/.libs/libmysql.so: cannot open shared object file: No such file or directory query [SET NAMES latin1] Debug:[sql] dbmysql.c,db_query(+286): query [SHOW VARIABLES LIKE 'collation_%'] Debug:[sql] dbmysql.c,db_mysql_check_collations(+116): does [collation_database:utf8_general_ci] mat ch [collation_connection:latin1_swedish_ci]? Error:[sql] dbmysql.c,db_mysql_check_collations(+133): collation mismatch, your MySQL configuration specifies a different charset than the data currently in your DBMail database. Debug:[db] dbmodule.c,db_load_driver(+67): looking for mysql as /usr/local/lib/dbmail/libmysql.so Debug:[sql] dbmysql.c,db_query(+286): query [SET NAMES latin1] Debug:[sql] dbmysql.c,db_query(+286): query [SHOW VARIABLES LIKE 'collation_%'] Debug:[sql] dbmysql.c,db_mysql_check_collations(+116): does [collation_database:utf8_general_ci] mat ch [collation_connection:latin1_swedish_ci]? Do I need to set three of the character variables(client, connection, and results) back to latin1? thx, -Jim McIver _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
