1 Topic by tomcats

  • tomcats
  • Member
  • Offline
  • Registered: 2011-10-03
  • Posts: 1

Topic: Table 'vmail.log' doesn't exist

https://192.168.10.140/postfixadmin/create-mailbox.php

DEBUG INFORMATION:
Invalid query: Table 'vmail.log' doesn't exist

Please check the documentation and website for more information.

Postfix Admin
Forums


I receive this error when i want to make another virtual user. I used postfixadmin version 2.3.4, but i receive the same errors with another version like 2.3.3 and 2.3.2.

Please tell me, if someone knows how to fix.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by lessentropy

  • lessentropy
  • Member
  • Offline
  • Registered: 2011-01-25
  • Posts: 1

Re: Table 'vmail.log' doesn't exist

tomcats wrote:

Invalid query: Table 'vmail.log' doesn't exist

Have you tried running the postfixadmin upgrade script to allow it add the missing tables back into the vmail database?
It seems like I recall reading that several tables were dropped in recent versions of iRedMail because they were no longer 'necessary', i.e. only required to provide continuing support of postfixadmin. Backup your db, then try running the upgrade.php found in the root of your install, in your case:  https://192.168.10.140/postfixadmin/upgrade.php

Good luck!
-S

3 Reply by martinseener (edited by martinseener 2011-12-02 19:22:17)

  • martinseener
  • Member
  • Offline
  • Registered: 2011-04-02
  • Posts: 31

Re: Table 'vmail.log' doesn't exist

Hey there,

got the same problem but was able to fix it as follows:

go into phpmyadmin with root.
go to rights->vmailadmin and edit the right for vmailadmin to vmail DB.
dd CREATE and ALTER rights - save

run the script like lessentropy mentioned above and youll be fine smile

after finishing remove those 2 rights again!

(tested with squeeze 6.0.1 and iredmail 0.7.3 stable)

greetings from Germany

Martin

4 Reply by tuxtux (edited by tuxtux 2011-12-04 15:42:12)

  • tuxtux
  • Member
  • Offline
  • Registered: 2011-10-28
  • Posts: 29

Re: Table 'vmail.log' doesn't exist

martinseener wrote:

I entered the site and postfixadmin forum, but have not found anything about it.

How this is done step by step?

Is that I am beginner in GNU / Linux.

I installed iRedMail 0.7.3 + MySQL + CentOS 6.
and I have the same error.
Thanks in advance.

Best regards!

5 Reply by jernejp

  • jernejp
  • Member
  • Offline
  • Registered: 2012-04-01
  • Posts: 14

Re: Table 'vmail.log' doesn't exist

You need to create the log table in vmail database:
CREATE TABLE log (
  `TIMESTAMP` datetime NOT NULL default '0000-00-00 00:00:00',
  username varchar(255) NOT NULL default '',
  domain varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  `data` varchar(255) NOT NULL default '',
  KEY `TIMESTAMP` (`TIMESTAMP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;