1 Topic by Jochen

  • Jochen
  • Member
  • Offline
  • Registered: 2014-03-31
  • Posts: 78

Topic: empty DB after installation

==== Required information ====
- iRedMail version: 0.9.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: Debian 7.8
- Related log if you're reporting an issue:
********************************************************************
* Start iRedMail Configurations
********************************************************************
[ INFO ] Create self-signed SSL certification files (2048 bits).
[ INFO ] Create required system account: vmail, iredadmin, iredapd.
[ INFO ] Configure Apache web server and PHP.
[ INFO ] Configure PHP.
[ INFO ] Configure MySQL database server.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Setup daily cron job to backup SQL databases: /var/vmail/backup/backup_mysql.sh
[ INFO ] Configure Postfix (Message Transfer Agent).
[ INFO ] Configure Cluebringer (postfix policy server).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure Dovecot (pop3/imap/managesieve server).
[ INFO ] Configure ClamAV (anti-virus toolkit).
[ INFO ] Configure Amavisd-new (interface between MTA and content checkers).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure SpamAssassin (content-based spam filter).
[ INFO ] Configure iRedAPD (postfix policy daemon).
[ INFO ] Configure iRedAdmin (official web-based admin panel).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure Fail2ban (authentication failure monitor).
[ INFO ] Configure Roundcube webmail.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure SOGo Groupware (Webmail, Calendar, Address Book, ActiveSync).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

====

Hi,

I just installed iRedMail on a fresh Debian 7.8 Installation went well, ending with:

********************************************************************
* Congratulations, mail server setup completed successfully. Please
* read below file for more information:
*
*   - /root/iRedMail-0.9.1/iRedMail.tips
*
* And it's sent to your mail account postmaster@solutionboxx.com.
*
* Please reboot your system to enable mail services.
*
********************************************************************


But after reboot nothing really worked. RoundCube had a DB-Error, SoGo did not permit logins, iredadmin had an internal server error.

I checked the MySQL-DB then. The root login I set was working, but no databases or tables were created. Scanning through the log, I found the messages posted above.

Any way I can populate the db correctly at this stage?

thanks, regards
Jochen

----

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,165

Re: empty DB after installation

Jochen wrote:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

This is error while importing SQL database.
Could you please show us full content of file 'iRedMail-0.9.1/runtime/install.log'? You can paste it to web site like http://pastebin.com/ (Note: it's better to remove sensitive info in this file before pasting, but please keep it understandable.)

3 Reply by Jochen

  • Jochen
  • Member
  • Offline
  • Registered: 2014-03-31
  • Posts: 78

Re: empty DB after installation

please find the requested log here: http://pastebin.com/Gxs1aJxD

I cannot see anything of interest in there, except that a2enconf seems missing. But that should not have to do with db problems...

Any help appreciated!

Jochen

4 Reply by ZhangHuangbin

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

Re: empty DB after installation

Please paste output of below command:

# grep -v '^#' /etc/mysql/my.cnf | grep -v '^$'

5 Reply by Jochen

  • Jochen
  • Member
  • Offline
  • Registered: 2014-03-31
  • Posts: 78

Re: empty DB after installation

# grep -v '^#' /etc/mysql/my.cnf | grep -v '^$'
[client]
port        = 3306
socket        = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket        = /var/run/mysqld/mysqld.sock
nice        = 0
[mysqld]
innodb_file_per_table
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
port        = 3306
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir        = /tmp
lc-messages-dir    = /usr/share/mysql
skip-external-locking
bind-address        = 127.0.0.1
key_buffer        = 16M
max_allowed_packet    = 16M
thread_stack        = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
query_cache_limit    = 1M
query_cache_size        = 16M
expire_logs_days    = 10
max_binlog_size         = 100M
[mysqldump]
quick
quote-names
max_allowed_packet    = 16M
[mysql]
[isamchk]
key_buffer        = 16M
!includedir /etc/mysql/conf.d/

6 Reply by Jochen

  • Jochen
  • Member
  • Offline
  • Registered: 2014-03-31
  • Posts: 78

Re: empty DB after installation

Sorry, but do you have any further ideas fpor me, pls?

7 Reply by ZhangHuangbin

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

Re: empty DB after installation

Dear Jochen,

Could you try iRedMail-0.9.2 instead? Let's see whether or not this new release fixes your issue.

8 Reply by dexznrl

  • dexznrl
  • Member
  • Offline
  • Registered: 2011-08-29
  • Posts: 9

Re: empty DB after installation

I second Jochen's claim. I installed 0.9.2 tonight on debian 8 with the same results as Jochen. Then tried it in debian 7 with the exact same results, no db initialization.
The database is not setup with the proper data.

The exact samt setup works perfectly with 0.9.0 on debian 7 at least.

It's late in the evening so I havn't started reading my logs yet.

9 Reply by ZhangHuangbin

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

Re: empty DB after installation

*) Could you please paste file content of 'runtime/install.log' (under iRedMail-0.9.2/ directory) here (or post to pastebin.com)? It contains some debug message for installation.

*) It's better to paste full terminal output too. If you don't have it, please help install iRedMail again and get the output. We need terminal output and file 'runtime/install.log' to debug installation.