1

Topic: I pressed ctrl+c during install and now need DB setup..

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.8 MYSQL edition.
- Linux/BSD distribution name and version: Ubuntu 18.04 LTS fully patched
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): remote MYSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Not yet (bought, not installed)
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

So I am building this on a server with two network legs - one is the external facing public IP and the other is a leg on a switch with my database server. I started the install and walked away. came back and saw this:
********************************************************************
* Start iRedMail Configurations
********************************************************************
[ INFO ] Generate self-signed SSL cert (2048 bits, expire in 10 years).
[ INFO ] Generate Diffie Hellman Group with openssl, please wait.
[ INFO ] Create required system accounts.
[ INFO ] Configure Nginx web server.
[ INFO ] Configure PHP.
[ INFO ] Configure MySQL database server.
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
[ INFO ] Setup daily cron job to backup SQL databases with /inet/recycler/mail/live/backup/backup_mysql.sh
[ INFO ] Configure Postfix (MTA).
[ INFO ] Configure Dovecot (POP3/IMAP/Managesieve/LMTP/LDA).
[ INFO ] Configure mlmmj (mailing list manager).
[ INFO ] Configure ClamAV (anti-virus toolkit).
[ INFO ] Configure Amavisd-new (interface between MTA and content checkers).
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
[ INFO ] Configure SpamAssassin (content-based spam filter).
[ INFO ] Configure iRedAPD (postfix policy daemon).
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
[ INFO ] Configure iRedAdmin (official web-based admin panel).
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
[ INFO ] Configure Fail2ban (authentication failure monitor).
[ INFO ] Configure Roundcube webmail.
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)
^Croot@promail01:~/iRedMail-0.9.8# ping 192.168.102.113
PING 192.168.102.113 (192.168.102.113) 56(84) bytes of data.
From 192.168.102.210 icmp_seq=1 Destination Host Unreachable
From 192.168.102.210 icmp_seq=2 Destination Host Unreachable
From 192.168.102.210 icmp_seq=3 Destination Host Unreachable
^C
So like the installer said, I pressed ctrl+c to break out so I could troubleshoot my downed interface. It got part way through because there is a roundcube db and roundcube/netdata user in the databse.
How can I re-run just the database setup? I've deleted the mysql .my files in my /root directory and deleted the config file and re-run the setup but at the end it still gets to this:
< SKIP > Function: after_package_installation.

********************************************************************
* Start iRedMail Configurations
********************************************************************
< SKIP > Function: generate_ssl_keys.
[ INFO ] Create required system accounts.
< SKIP > Function: add_user_vmail.
< SKIP > Function: add_user_mlmmj.
< SKIP > Function: add_user_iredadmin.
< SKIP > Function: add_user_iredapd.
< SKIP > Function: add_user_netdata.
< SKIP > Function: web_server_config.
< SKIP > Function: mysql_setup.
< SKIP > Function: postfix_setup.
< SKIP > Function: dovecot_setup.
< SKIP > Function: mlmmj_config.
< SKIP > Function: mlmmjadmin_config.
< SKIP > Function: clamav_config.
< SKIP > Function: amavisd_config.
< SKIP > Function: sa_config.
< SKIP > Function: iredapd_setup.
< SKIP > Function: iredadmin_setup.
< SKIP > Function: fail2ban_config.
< SKIP > Function: rcm_setup.
< SKIP > Function: netdata_setup.
< SKIP > Function: cleanup.

I'd rather not have to run a clean install of the OS again.

----

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

2

Re: I pressed ctrl+c during install and now need DB setup..

PaulCahill wrote:

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.102.113' (113)

Is mysql service accessible from your iRedMail server? you'd better do a quick check.