Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - kingmilo

Pages: [1]
1
Installation and Upgrades / /var/log/ebox/ebox.log
« on: April 23, 2009, 04:50:42 pm »
I am getting this error very often (maybe everytime an email is being sent/received i cant tell) in my /var/log/ebox/ebox.log log file.

[i2009/04/23 16:41:14 DEBUG> PgDBEngine.pm:161 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO message ( from_address, message_id, message_size, status, postfix_date, event, message, to_address, client_host_name, relay, client_host_ip) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  null value in column "client_host_ip" violates not-null constraint
 
2009/04/23 16:41:14 ERROR> PgDBEngine.pm:165 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO message ( from_address, message_id, message_size, status, postfix_date, event, message, to_address, client_host_name, relay, client_host_ip) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  null value in column "client_host_ip" violates not-null constraint
 
2009/04/23 16:41:17 DEBUG> PgDBEngine.pm:161 EBox::PgDBEngine::insert - Error inserting data: INSERT INTO message ( from_address, message_id, message_size, status, postfix_date, event, message, to_address, client_host_name, relay, client_host_ip) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR:  null value in column "client_host_ip" violates not-null constraint[/i]


Doest anybody know what it is and how it can be resolved? My guess is that it is related to the Queue Management problem i have where i cannot view my mail queue and this is maybe info that needs to be written there, or maybe its trying to write info the the logfile?

Any help will be appreciated.

Thanks.

2
I have a strange problem here. I only have 1 virtual domain setup, let's call it "domain.com".
For testing purposes when setting up users email i would normally send a test message from their email to myself.
I have mail filtering turned on for this domain.

So i send an email from  admin@domain.com to kingmilo@domain.com and the sender (admin@domain.com) gets BLOCKED, the message is seen as SPAM. I know this because i check the SMTP_FILTERING log files. If i use the same sender (admin@domain.com) sends an email to an external email address for example kingmilo@anotherdomain.com the email is delivered fine.

I must note that i did not only experience this with admin@domain.com but with 4 out of 5 of my email address's i setup. My temporary solution was to add the senders (all of my emails on my virtual domain) to the SPAM whitelist which then allows the local message to be delivered. At one point even this did not resolve the matter and i had to delete and re-create the user, add to whitelist and then i was able to send.

It seems strange that local users are blocked when sending message over the virtual domain, surely the mail filtering should be smart enough to know this, or could this be a bug? Should i disable outgoing mail filtering?

I look forward to any suggestions.

Thanks!

3
When i try and check for mails in the queue i get the following error;
An internal error related to a template has occurred. This is a bug, relevant information can be found in the logs.

If i tail -f the /var/log/ebox/ebox.log file this is the output when trying to access queue management;
2009/04/23 16:34:10 ERROR> Base.pm:343 EBox::CGI::Base::__ANON__ - Can't use an undefined value as an ARRAY reference at (eval 539) line 98.

Stack:
  [(eval 539):98]



I am experiencing he same problem as the post below, however the solution does not work for me;
http://forum.ebox-platform.com/index.php?topic=447.0

Please let me know if you need me to post more info about my setup.

Thanks!

Pages: [1]