-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all!
I try to play with DBmail. With the original fedora 7
package and
self-compiled from scratch I am going to be stopped at the
same time.
The las successful step is the creation of the DB (I use
MySQL). I am
unable to start the dbmail.imap daemon:
un 16 22:05:53 h883354 dbmail-imapd[31473]: FATAL:[db]
db.c,db_check_version(+127): pre-2.0 database incompatible.
You need
to run the conversion script
Jun 16 22:05:57 h883354 dbmail-imapd[31476]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT 1=1
FROM
dbmail_physmessage LIMIT 1 OFFSET 0]
Jun 16 22:05:57 h883354 dbmail-imapd[31476]: FATAL:[db]
db.c,db_check_version(+127): pre-2.0 database incompatible.
You need
to run the conversion script
Jun 16 22:06:01 h883354 dbmail-imapd[31478]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT 1=1
FROM
dbmail_physmessage LIMIT 1 OFFSET 0]
Jun 16 22:06:01 h883354 dbmail-imapd[31478]: FATAL:[db]
db.c,db_check_version(+127): pre-2.0 database incompatible.
You need
to run the conversion script
Jun 16 22:06:05 h883354 dbmail-imapd[31481]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT 1=1
FROM
dbmail_physmessage LIMIT 1 OFFSET 0]
Jun 16 22:06:05 h883354 dbmail-imapd[31481]: FATAL:[db]
db.c,db_check_version(+127): pre-2.0 database incompatible.
You need
to run the conversion script
What is the conversion script?
Go ahead: I am unable to create users, the same error
occurs.
I tried to use the dbmail-util command, but without any
success:
[root h883354 ~]# dbmail-util -a -y
Opening connection to database...
Opening connection to authentication...
Ok. Connected.
At this point, it seems to be successful connected to the
database,
but there are "No database selected" messages? I
am confused...
Repairing DBMAIL messageblocks integrity...
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT
mb.messageblk_idnr FROM dbmail_messageblks mb LEFT JOIN
dbmail_physmessage pm ON mb.physmessage_id = pm.id WHERE
pm.id IS NULL]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[db]
db.c,db_icheck_messageblks(+1460): Could not execute query
Failed. An error occured. Please check log.
Repairing DBMAIL for NULL messages...
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT
msg.message_idnr FROM dbmail_messages msg LEFT JOIN
dbmail_physmessage
pm ON msg.physmessage_id = pm.id WHERE pm.id is NULL]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[db]
db.c,db_icheck_null_messages(+1639): could not execute
query
Failed. An error occured. Please check log.
Deleting messages with DELETE status...
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT
message_idnr
FROM dbmail_messages WHERE status=3]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[db]
db.c,db_deleted_purge(+2400): Cound not fetch message ID
numbers
Failed. An error occured. Please check log.
Repairing DBMAIL for rfcsize field...
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [SELECT id
FROM
dbmail_physmessage WHERE rfcsize=0]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[db]
db.c,db_icheck_rfcsize(+1736): could not access physmessage
table
Failed. An error occured. Please check log.
Setting DELETE status for deleted messages...
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [UPDATE
dbmail_messages SET status = 3 WHERE status = 2]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[db]
db.c,db_set_deleted(+2375): Could not execute query
Failed. An error occured. Please check log.
Vacuuming and optimizing database...
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_users]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_users]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_aliases]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_aliases]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_mailboxes]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_mailboxes]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_messages]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_messages]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_physmessage]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_physmessage]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_messageblks]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_messageblks]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_acl]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_acl]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_subscription]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_subscription]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_pbsp]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_pbsp]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_auto_notifications]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_auto_notifications]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_auto_replies]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_auto_replies]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_headername]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_headername]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_headervalue]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_headervalue]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_subjectfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_subjectfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_datefield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_datefield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_referencesfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_referencesfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_fromfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_fromfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_tofield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_tofield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_replytofield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_replytofield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_ccfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_ccfield]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_replycache]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_replycache]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_query(+292): [No database selected] [ANALYZE
TABLE
dbmail_usermap]
Jun 16 22:30:29 h883354 dbmail-util[32004]: Error:[sql]
dbmysql.c,db_do_cleanup(+327): error analyzing table
[dbmail_usermap]
Failed. Please check the log.
Maintenance done. No errors found.
This message is a joke - there many many errors...
Kind regards,
Uwe
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFGdEk5r6SFaBB7DLURAue5AKCiZDnqMfBB/d55Rvb5/6mf/TyFkQCg
kGDU
CtMcCKox1BfL9+npdHR+SoE=
=UiIM
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
DBmail dbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|