It doesn't exist... oh, looks like we forgot to remove references to it in the documentation! There's now only one create_tables.mysql and it requires InnoDB tables. Don't worry, you've got the right tables already. The issue is your encoding.
If you bump up the trace level to 5, the dbmail logs will give you lots more information about the encodings it expects and what the server is reporting. Aaron On Thu, May 10, 2007, Jim McIver <[EMAIL PROTECTED]> said: > Any idea where I can get the "create_tables_innoDB.mysql" script? > thx, > -jm > > On 10 May 2007 at 23:42, Jorge Bastos wrote: > >> You see InnoDB because your mysql has InnoDB enabled and so, it starts it. >> And to use dbmail 2.2x you NEED to use InnoDB >> >> >> ----- Original Message ----- >> From: "Jim McIver" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Thursday, May 10, 2007 10:36 PM >> Subject: [Dbmail] postfix, mysql >> >> >> > I'm a newbie looking for a program to store email from postfix. >> > >> > I downloaded dbmail-2.2.4.tar.gz and followed along the instructions >> > in INSTALL. >> > >> > I don't know how to obtain innodb for mysql, so I ran the other >> > script. >> > >> > cp dbmail.conf to /etc >> > driver = mysql >> > authdriver = sql >> > host = localhost >> > sqlport = 3306 >> > sqlsocket = /var/lib/mysql/mysql.sock >> > user = dbmail >> > pass = dbmail >> > db = dbmail >> > >> > left everything else default. >> > >> > Ran configure --with -mysql >> > Ran make all & make install....no errors. >> > >> > Ran dbmail-users -a james -w james -g 0 -m 0 -s [EMAIL PROTECTED] >> > bignickel.com >> > >> > and get "Error collation mismatch, your MySQL configuration specifies >> > a different charset than the data currently in your DBMail database. >> > Failed. Could not connect to database (check log)" >> > >> > mysqld.log has this: >> > 070510 14:08:24 mysqld started >> > 070510 14:08:24 InnoDB: Started; log sequence number 0 167715 >> > 070510 14:08:24 [Note] /usr/sbin/mysqld: ready for connections. >> > Version: '5.0.18' socket: '/var/lib/mysql/mysql.sock' port: 3306 >> > SUSE MySQL RPM >> > >> > Not sure why I see InnoDB? >> > and >> > logfile = /var/log/dbmail.log >> > but there is no dbmail.log? >> > >> > Any thoughts? >> > thx, >> > >> > >> > -Jim McIver >> > >> > _______________________________________________ >> > DBmail mailing list >> > [email protected] >> > https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > >> _______________________________________________ >> DBmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > -Jim McIver > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
