** Changed in: server-papercuts
Milestone: lucid-beta-2 => lucid-beta-1
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new in ubunt
Fix committed to revision 344.
** Changed in: amavisd-new (Ubuntu)
Status: Confirmed => Fix Released
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is s
Fix committed to revision 344.
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubunt
Fix committed to revision 344.
** Changed in: ubuntu-docs (Ubuntu)
Status: Triaged => Fix Released
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is sub
Great apologies there has been a note about manually setting the
$myhostname variable since at least the 8.10 release. The specific
revision is number 344.
I must have forgot to add this bug number to the commit message, so
marking as fix released now. Thanks Connor and Thierry for the
reminder.
** Changed in: server-papercuts
Importance: Undecided => Low
** Changed in: server-papercuts
Status: New => Triaged
** Changed in: server-papercuts
Milestone: None => lucid-beta-2
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You re
** Changed in: server-papercuts
Assignee: (unassigned) => Adam Sommer (asommer)
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new
** Also affects: server-papercuts
Importance: Undecided
Status: New
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new in ubu
Moving to ubuntu-docs package for doc team policy, keeping Adam
assigned.
Adam, has this been documented in the serverguide yet?
** Also affects: ubuntu-docs (Ubuntu)
Importance: Undecided
Status: New
** Changed in: ubuntu-docs (Ubuntu)
Importance: Undecided => Wishlist
** Changed
** Tags added: serverguide
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-se
Assigning to me and added to ubuntu-doc so that I don't forget to add
information regarding $myhostname to the Server Guide.
** Also affects: ubuntu-doc
Importance: Undecided
Status: New
** Changed in: ubuntu-doc
Assignee: (unassigned) => Adam Sommer (asommer)
Status: New =>
Assigning to me and added to ubuntu-doc so that I don't forget to add
information regarding $myhostname to the Server Guide.
** Changed in: amavisd-new (Ubuntu)
Assignee: (unassigned) => Adam Sommer (asommer)
Status: New => Confirmed
--
Insecure dependency when using sql for Log Repo
My only suggestion would be to say clearly that if $myhostname is not
explicitely declared there are warnings on the log files and the
messages are not stored into the DB (MySQL at least).
Maybe to produce a newer package is not absolutely needed yet...
--
Insecure dependency when using sql for
I'm not sure if it's wontfix or invalid. Either way I don't think
there's any actual amavisd-new fix needed. Perhaps the reporter could
suggest documentation changes that would have made this easier to
solve/prevent?
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad
Cool, thanks Scott. I'm not quite sure what the status of this bug
should then be?
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new
On Monday 07 April 2008 00:13:32 Adam Sommer wrote:
> > Do you have a further explanation?
>
> That's great news! My thought is, and I'm far from an expert, amavisd-new
> didn't know what host to accept mail for. Did you try amavisd-new without
> using a database to store the messages?
>
There ar
>
> Do you have a further explanation?
>
>
That's great news! My thought is, and I'm far from an expert, amavisd-new
didn't know what host to accept mail for. Did you try amavisd-new without
using a database to store the messages?
Either way it's great that it's working now :-).
--
Party On,
A
I have found a solution.
First I have noticed another log in /var/log/mail.err:
...amavis[23324]: (23324-03) ERROR sql_storage: too many retries on
storing preliminary, info not saved
which confirmed that nothing went into the DB.
Googling about this error, I found a message from Mark Martinec
Yes, I can connect to the DB using this user and password. I can write
to the msgs table. I granted all the privileges to the amavis user on
tables on the amavis DB (exactly the same that you sent). Exactly the
same result.
This is coming from the save_info_preliminary subroutine on amavisd-new.
I
Nope, shouldn't have anything to do with the charset, I recreated my
mssgs table using utf8 and it worked fine. Can you connect to the
database using the the username and password used in the
configuration?
I'd think that there would be a more detailed error if that were the
case, but you may wan
Yes, I also recognized that the transaction is not being comitted to the
DB.
This is the schema of msgs on my server:
show create table msgs;
| msgs | CREATE TABLE `msgs` (
`mail_id` varchar(12) NOT NULL default '',
`secret_id` varchar(12) default '',
`am_id` varchar(20) NOT NULL default
Hello,
>From these lines:
... amavis[22796]: (22796-01) sql rollback
... amavis[22796]: (22796-01) save_info_preliminary: rollback done
It appears that the transaction is not being committed to the database.
This is what those two lines look like in my log:
... amavis[21515]: (21515-01) s
An extra note:
The command "INSERT INTO msgs..." never touch MySQL. The msgs table is
empty and the mysql log file doesn't say a thing about 'INSERT INTO
msgs...'.
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification be
libdbd-mysql-perl:
Version: 3.0002-2build1
The error on /var/log/mail.log:
... amavis[22796]: (22796-01) sql begin transaction
... amavis[22796]: (22796-01) sql: executing clause: SELECT id FROM maddr WHERE
email=?
... amavis[22796]: (22796-01) sql: executing clause: INSERT INTO maddr (email,
d
I've setup a test machine and I'm not seeing the error. Just to make
sure I'm looking in the right place, you're seeing the error in
/var/log/mail.log?
Also, what version of libdbd-mysql-perl are you using? I'm using
libdbd-mysql-perl-3.002-2build1. I also set the Amavisd-new log level
to 5 usi
I am running MySQL 4.1.
Source: mysql-dfsg-4.1
Version: 4.1.15-1ubuntu5
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to amavisd-new in ubun
Thank you for reporting this bug and helping to make Ubuntu better.
Which database are you using?
--
Insecure dependency when using sql for Log Reporting
https://bugs.launchpad.net/bugs/211915
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed t
27 matches
Mail list logo
