1 Topic by Keim

  • Keim
  • Member
  • Offline
  • Registered: 2013-01-08
  • Posts: 1

Topic: SQL issue: iRedMail Wizard cannot create tables on existing database

Hi,

After I installed Sogo, I tried to install iRedMail afterwards.

But the wizard was not able to create the vmail table in the existing data base, although I have entered the root login and pw in the wizard. Authentication was not possible according to the log.

How can I re-run the wizard that the SQL table is created correctly?

Best,

Keim

==== Required information ====
- iRedMail version: 0.8.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL 5.5.28-0ubuntu0.12.04.3
- Linux/BSD distribution name and version: Ubuntu precise 12.04.1
- Related log if you're reporting an issue:
====

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: SQL issue: iRedMail Wizard cannot create tables on existing database

The easiest way is re-installing iRedMail on a FRESH system.

if you cannot re-install it, try:

- Create SQL tables manually with iRedMail-0.8.3/samples/iredmail.mysql (or iredmail.pgsql if you're running PostgreSQL)
- Import SQL file generated during iRedMail installation: iRedMail-0.8.3/mysql_init.sql, iRedMail-0.8.3/mysql_vmail.sql.