1

Topic: Missing databases with new install on FreeBSD 10.3

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6
- Linux/BSD distribution name and version: FreeBSD 10.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue: /var/log/uwsgi-iredadmin.log

  File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1049, "Unknown database 'iredadmin'")
====

Hi,

I am testing iRedMail in my lab for a new setup. Using FreeBSD 10.3 as OS. Install on clean OS install. Chose setting like above. Install went all good. But when connecting to https://<servername/iredadmin get message 'internal server error' in browser.

Further investigation showed above message in /var/log/uwsgi-iredadmin.log

Looking at MySQL users and databases:

root@localhost [(none)]> use mysql;
Database changed
root@localhost [mysql]> select user, host from user;
+-----------+-----------+
| user      | host      |
+-----------+-----------+
| mysql.sys | localhost |
| root      | localhost |
+-----------+-----------+
2 rows in set (0.26 sec)

root@localhost [mysql]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

Not any of the databases have been created. Something went wrong here, but what?

Thank you in advance.

with kind regards,
Lats

----

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

2

Re: Missing databases with new install on FreeBSD 10.3

When did you download the iRedMail-0.9.6 package? We repacked it about 1 week ago to fix this SQL server issue. Is it possible for you to re-download and try again?

3

Re: Missing databases with new install on FreeBSD 10.3

Hi,

first thank you for the quick reply!

I've tried again with new download of 0.9.6 package, on a clean FreeBSD 11.0 install, with same choices and databases have now been created. The .tar.bz2 used on the FreeBSD 10.3 system had a date of March 18th. So this is resolved now.

Thank you!

cheers,
Lars