1 Topic by ChristianLJ

  • ChristianLJ
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 6

Topic: iRedMail errors

Hello everybody,

I have a few problems with iRedMail.
I have installed it via this guide: http://www.howtoforge.com/build-a-full- … n-centos-6
It is installed on a freshly formatted, and newly updated CentOS 6 VPS.
It is iRedMail 0.8.1.

The problem is that when i visit mydomain.dk/mail i get the following error:

"DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator."

When i visit mydomain.dk/iredadmin i get the error:

"internal server error"

The installation went fine, and i didn't get any errors.
I think this might be a issue with my MySQL database, but i don't quite know the whole solution on how to fix it.

Therefore i am asking for your help. Have i missed something?

Thank you, on behalf!

- Christian Leicht Jørgensen

----

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: iRedMail errors

Any related log in /var/log/httpd/ssl_error_log?

3 Reply by ChristianLJ

  • ChristianLJ
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 6

Re: iRedMail errors

Hello again.
When i look in /var/log/httpd/ssl_error_log i see the following text:

[Sun Jul 22 04:02:34 2012] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)

Nothing more.
Thank you.

4 Reply by ChristianLJ

  • ChristianLJ
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 6

Re: iRedMail errors

I have enabled debugging.

When i visit mydomain.dk/iredadmin and try to log in with the test@mydomain.dk user, i get the following error:
"(1146, "Table 'vmail.admin' doesn't exist")"

So it seems like the installations didn't create the tables (or databases?), for the respective programs?
Is there anyway, or documentation, on how to do this manually?

Another problem i have, is that postfix doesn't work as MTA. I don't receive any mails, send with a contact form on my website.

5 Reply by ChristianLJ

  • ChristianLJ
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 6

Re: iRedMail errors

I am willing to pay someone to help me with this.

6 Reply by Alir3z4 (edited by Alir3z4 2012-07-23 23:10:12)

  • Alir3z4
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 2

Re: iRedMail errors

Be sure mysql service is started!
Actually couple of mins ago i've installed iredmail on the fresh centos 6.2 with postgresql db backend, just for test, and it's working now very well!
When db issued some error like there is no table such foo and bar, first check database service is started, and also be sure is there any table in database or not!

7 Reply by ChristianLJ

  • ChristianLJ
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 6

Re: iRedMail errors

Well, I have 3 websites up and running with MySQL databases, so it is working.

It is like the installation didn't create the databases and tables for iredmail. Is there any way to do this manually?

When i check which databases there is created it shows:

mysql> show databases;
+-------------------------+
| Database                |
+-------------------------+
| information_schema      |
| advocare                |
| apsc                    |
| ltaps                   |
| mysql                   |
| phpmyadmin_NFezKbeSQcOl |
| phpmyadmin_k0vGGBcXKQga |
| psa                     |
| sitebuilder5            |
| vjkabel                 |
+-------------------------+
10 rows in set (0.08 sec)

So it didn't create the databases! Is it possible to do a reinstall?

8 Reply by ZhangHuangbin

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

Re: iRedMail errors

- You will find SQL template file shipped in iRedMail-0.8.1/samples/iredmail.mysql.
- After iRedMail installation, no matter it was completed successfully or failed, there's another file: iRedMail-0.8.1/conf/mysql_init.sql, it's generated during iRedMail installation, used to create necessary mail accounts.

9 Reply by ChristianLJ

  • ChristianLJ
  • Member
  • Offline
  • Registered: 2012-07-21
  • Posts: 6

Re: iRedMail errors

Ok.
Now i have added everything from the iRedMail-0.8.1/samples/iredmail.mysql file to  an iredamin database.
It now contains the following tables:

mysql> show tables;
+----------------------+
| Tables_in_iredadmin  |
+----------------------+
| admin                |
| alias                |
| alias_domain         |
| domain               |
| domain_admins        |
| log                  |
| mailbox              |
| recipient_bcc_domain |
| recipient_bcc_user   |
| sender_bcc_domain    |
| sender_bcc_user      |
| sessions             |
| share_folder         |
| updatelog            |
| used_quota           |
| user                 |
+----------------------+
16 rows in set (0.00 sec)

The file  iRedMail-0.8.1/conf/mysql_init.sql only contains the following:

/* Delete anonymouse user. */
USE mysql;

DELETE FROM user WHERE User='';
DELETE FROM db WHERE User='';

What to do with this information?

I still have the same errors as describes before. Is there an overview of databases i have to create, and user i have to create?
Any help would be appreciated.

Thanks! smile

10 Reply by ZhangHuangbin

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

Re: iRedMail errors

Dear ChristianLJ,

I suggest you re-install your CentOS and iRedMail, this is the simplest way to get a working iRedMail server.