Page 1 of 1

OpenEMM not sending mails

Posted: Mon Mar 17, 2008 10:39 am
by 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 ...

Posted: Fri Jun 20, 2008 11:05 am
by LgmDan
I got the same problem:

16026 ERROR/scan: Unable to get database cursor

in pickdist-logs.

Dan

16026 ERROR/scan: Unable to get database cursor

Posted: Wed Jun 25, 2008 7:06 am
by 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.