List Info

Thread: Unable to use DBmail




Unable to use DBmail
country flaguser name
Spain
2007-06-16 15:34:02
-----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:
[rooth883354 ~]# 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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: Unable to use DBmail
country flaguser name
Netherlands
2007-06-16 16:08:05
Uwe Kiewel wrote:
> 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

Did you follow the instructions in INSTALL?

Sounds like you have a very basic problem with your database
setup.

Please make sure the relevant keys in dbmail.conf are
correct, and that
you have tested them using the commandline mysql client.

Also make sure that the database schema
(sql/mysql/create_tables.mysql)
has been properly loaded.

All the errors you show seem to indicate you are trying to
connect to an
empty database.

> 
> Maintenance done. No errors found.
> 
> This message is a joke - there many many errors...

Yes that is a known issue with the output from dbmail-util.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: Unable to use DBmail *solved*
country flaguser name
Spain
2007-06-16 16:36:37
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Uwe Kiewel wrote:
> Hi all!
>
[DB problem]

okay okay - I should not drink so much German Wheat Beer
...
The db = dbmail entry was missing in /etc/dbmail.conf

Thanks,
Uwe
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org


iD8DBQFGdFfkr6SFaBB7DLURAk9oAJ0VTSXWq4oZXebSyI6LaB+7uLGT7ACe
L81k
EKcfiBcAD4ZrJ5OZvm6I3Ws=
=a1Ke
-----END PGP SIGNATURE-----

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )