running - but missing table and configs

[shausch]

Hi everybody,

after some tries I've installed version 6.0.1 on Debian 64bit.

The last package I needed was ia32-libs.

Now I've no more problems with xmlback and I'm able to create and send mailings.

But the mails won't approach on my mail account.

I've still some ERROR output in the logs.

1) bav-update.log

Unable to read mailertable (2, 'No such file or directory')
Unable to read relay-domains (2, 'No such file or directory')
Unable to read local-host-names (2, 'No such file or directory')
Unable to read virtusertable (2, 'No such file or directory')

2) mailgun.log

WARNING/billing/(1/1/7/8): Unable to insert record into world_mailing_backend_log_tbl: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openemm.world_mailing_backend_log_tbl' doesn't exist


So is there a mandatory configuration missing?

I'm very curious about the missing table. I've installed the schema-SQL without problems. But there ist no table named like this.


Greets

[shausch]

Debian has no folder /etc/mail with the sendmail files.
I created it and the bva-updater doesn't logs the errors any more.

But I've still the missing table. I can't find it in the latest 5.x or 6.x scheme.

And my mails are not delivered to my account.

[shausch]

It works now.

Someone installed exim4 as mailer and I didn't recognized it.
Now sendmail works fine and the mails are delivered.


p.s.
I also created a table world_mailing_backend_log_tbl like the mailing_backend_log_tbl.

[Igol]

I noticed you've had the same "Unable to read relay-domains (2, 'No such file or directory')" error as me. How did you end up sorting it out?

I've checked if I have exim installed and I don't

The system has worked without error before, the only difference this time was we did a deferred send?

(note i also had the same table missing and can't find any reference of it in the documentation)

[pbolgar]

It works now.



p.s.
I also created a table world_mailing_backend_log_tbl like the mailing_backend_log_tbl.

How did you add that table? Could you write down the code? Been a while since I worked with SQL and then it was on MS Access - and I am trying to get my OpenEMM working fast... I have the same problem and trying to debug it, my mailings do go to test recipient and admin but not to anyone else...

[Igol]

I copied the structure of mailing_backend_log_tbl and renamed it.

[pbolgar]

Thanks. It looks like missing that table actually was not the problem for me - it was that I did not have the package python-mysqldb installed.

Code: Select all

sudo apt-get install python-mysqldb

was the solution.