1 (edited by Koenig 2018-01-10 14:06:57)

Topic: Just installed iRedMail but have no databases

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  iRedMail-0.9.7
- Linux/BSD distribution name and version: FreeBSD
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Something vent wrong with the inital install iRedMail and the password for MySQL got lost somehow.

So when the installation came to the part to setup the databases it asked for the password and I didn't know it so I got a failed login to MySQL and therefore no databases were setup.

I tried running the setup script again and the it just skipped the part for setting up databases and unfourtunately it overwrote the original log and all got gotnow is this:

[ INFO ] Total time of ports compiling: 0 seconds, ~= 0 minute(s)
< SKIP > Function: post_install_cleanup.
< SKIP > Function: generate_ssl_keys.
< SKIP > Function: add_required_users.
< SKIP > Function: web_server_config.
< SKIP > Function: mysql_setup.
< SKIP > Function: postfix_setup.
< SKIP > Function: dovecot_setup.
< SKIP > Function: clamav_config.
< SKIP > Function: amavisd_config.
< SKIP > Function: sa_config.
< SKIP > Function: iredapd_setup.
< SKIP > Function: iredadmin_setup.
< SKIP > Function: rcm_setup.
< SKIP > Function: sogo_setup.
< SKIP > Function: awstats_setup.
< SKIP > Function: cleanup.

But I have no databases....

So I need to invoke the script for setting up the databases and permissions, but I don't know how, please help.

EDIT: I still had the terminal open so I could scroll back to that part.
It looks like this:

********************************************************************
* Start iRedMail Configurations
********************************************************************
[ INFO ] Create self-signed SSL certification files (2048 bits).
[ INFO ] Generate Diffie Hellman Group with openssl, please wait.
[ INFO ] Create required system account: vmail, iredadmin, iredapd.
[ INFO ] Configure Apache web server.
[ INFO ] Configure PHP.
[ INFO ] Configure MySQL database server.
tail: /root/.mysql_secret: No such file or directory
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
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 with /var/vmail/backup/backup_mysql.sh
[ INFO ] Configure Postfix (MTA).
[ INFO ] Configure Dovecot (POP3/IMAP/Managesieve/LMTP/LDA).
[ 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).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure iRedAdmin (official web-based admin panel).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ 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)
[ INFO ] Configure Awstats (logfile analyzer for mail and web server).


What to do now?

----

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

2

Re: Just installed iRedMail but have no databases

Koenig wrote:

[ INFO ] Configure MySQL database server.
tail: /root/.mysql_secret: No such file or directory
Enter password:
ERROR 1045 (28000):

Which release of FreeBSD are you running?
Did you update ports tree to the latest version before installing iRedMail?

3

Re: Just installed iRedMail but have no databases

ZhangHuangbin wrote:
Koenig wrote:

[ INFO ] Configure MySQL database server.
tail: /root/.mysql_secret: No such file or directory
Enter password:
ERROR 1045 (28000):

Which release of FreeBSD are you running?
Did you update ports tree to the latest version before installing iRedMail?


FreeBSD 11.1

Yes, ports tree was updated prior to the installation.

4

Re: Just installed iRedMail but have no databases

Well, I solved with a completely new installation.

But perhaps someone else could be help if there's an answer to this.