OpenEMM not sending mails

[CIX88]

I can only send mails to admin or test, but not normally user ((((
With start von OpenEMM:

Code: Select all

Stopping obsolete sendmail processes:   done.
Starting sendmails:   listener 451 4.0.0 /etc/sendmail.cf: line 1579: Xbav: local socket name /home/openemm/var/run/bav.sock unsafe: World writable directory
 admin queue  mail queue  done.

... do not find the error.

sending mails:

Code: Select all

Bereits produzierte E-Mails:   4 
Bereits versendete E-Mails:   0 
E-Mails gesamt:   4

logfiles mail.err, mail.info, mail.warn or maillog have no error.
Only errors in:

/home/openemm/var/log/...mailgun.log

Code: Select all

[17.03.2008  09:41:39] WARNING/emmtag/(1/2/23/48): Query failed for data_tbl: java.lang.Exception: Query SELECT format FROM date_tbl WHERE type = 0 failed: java.sql.SQLException: Table 'openemm.date_tbl' doesn't exist

/home/openemm/var/log/...bav-update.log

Code: Select all

[17.03.2008  10:16:27] 15862 ERROR/data: Unable to get database cursor
[17.03.2008  10:16:27] 15862 ERROR/data: Update failed: readDatabase.cursor

/home/openemm/log/...pickdist.log

Code: Select all

[17.03.2008  10:18:08] 16026 ERROR/scan: Unable to get database cursor

/home/openemm/log/...update.log

Code: Select all

[17.03.2008  10:18:08] 16026 ERROR/scan: Unable to get database cursor

Those does not look for with google finds useful refers to to the problem

[edit]

further errors found ...

/home/openemm/var/log/redirection_stdout.log

Code: Select all

[11:08:15.511]http listening to *:8080
[11:08:15.512]Can't run as openemm(uid=-1), running as root.
[11:08:15.597]Host[] starting

Code: Select all

2008-03-17 11:08:22,196 - Using dialect: org.hibernate.dialect.MySQLDialect
17.03 (11:08:23) AgnUtils - getDefaultValue: Can't find resource for bundle java.util.PropertyResourceBundle, key archive.maxCacheTimeMillis

Code: Select all

2008-03-17 11:08:26,406 - Hibernate 3.1.3
2008-03-17 11:08:26,428 - hibernate.properties not found

... cant not understand ...

[LgmDan]

I got the same problem:

16026 ERROR/scan: Unable to get database cursor

in pickdist-logs.

Dan

[ZenRoe]

I had the same message. In my case, the problem was the use of non default MySQL port and unix socket. I had to edit agn.py and add information about my port and unix socket. Now it works perfectly.