1

Topic: iRedAdminPro settings.py

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
============ Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- iRedAdminPro: iRedAdmin-Pro-SQL-2.1.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mySQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: ubuntu 14-04 LTS
- Related log if you're reporting an issue:
====

I am doing a new install on a clean ubuntu LAMP server, following the installation instructions.

I don't understand the following instructions:


Create MySQL database: iredadmin

mysql -uroot -p
mysql> CREATE DATABASE iredadmin DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> USE iredadmin;
mysql> SOURCE /usr/share/apache2/iredadmin/docs/samples/iredadmin.sql;

I get an error msg that the database already exists.
it looks like the install script has already created the database.

Do I still need to execute the following command:

mysql> SOURCE /usr/share/apache2/iredadmin/docs/samples/iredadmin.sql;

Is this a new password that I have to create and assign to the iredadmin user?

mysql -uroot -p
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON iredadmin.* TO iredadmin@localhost IDENTIFIED BY 'secret_passwd';
mysql> FLUSH PRIVILEGES;

ireadadmin settings.py

Which settings do I have to update with the correct values?

Should I create new passwords for the following users and put it in the settings.py file?


  iredadmin_db_password = 'password'
  vmail_db_password = 'password'
  policyd_db_password = 'password'
  amavisd_db_password = 'password'

regards
jagter6

----

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

2

Re: iRedAdminPro settings.py

Follow this tutorial instead:
http://www.iredmail.org/docs/migrate.or … admin.html

3

Re: iRedAdminPro settings.py

hi,

How can I do an upgrade if there is no iRedMail system installed?

It is a new, clean ubuntu server

jagter6

4

Re: iRedAdminPro settings.py

I have started from scratch again with a new, clean ubuntu server and installed iRedMail and IredAdminPro.

When I try to access iredadmin via the web, I get an error msg:

internal server error

from the apache2 error.log file

[ssl:warn] [pid 2698] AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Tue Jun 23 22:26:56.844061 2015] [ssl:warn] [pid 2700] AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Tue Jun 23 22:26:56.846841 2015] [mpm_prefork:notice] [pid 2700] AH00163: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f mod_wsgi/3.4 Python/2.7.6 configured -- resuming normal operations
[Tue Jun 23 22:26:56.846861 2015] [core:notice] [pid 2700] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 23 22:27:15.070732 2015] [:error] [pid 2703] [remote 31.151.248.52:65474] Traceback (most recent call last):
[Tue Jun 23 22:27:15.070757 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 237, in process
[Tue Jun 23 22:27:15.070760 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     return p(lambda: process(processors))
[Tue Jun 23 22:27:15.070763 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/session.py", line 84, in _processor
[Tue Jun 23 22:27:15.070766 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     self._cleanup()
[Tue Jun 23 22:27:15.070776 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/session.py", line 172, in _cleanup
[Tue Jun 23 22:27:15.070779 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     self.store.cleanup(timeout)
[Tue Jun 23 22:27:15.070782 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/session.py", line 319, in cleanup
[Tue Jun 23 22:27:15.070784 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
[Tue Jun 23 22:27:15.070787 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 906, in delete
[Tue Jun 23 22:27:15.070789 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     db_cursor = self._db_cursor()
[Tue Jun 23 22:27:15.070791 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 566, in _db_cursor
[Tue Jun 23 22:27:15.070794 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     return self.ctx.db.cursor()
[Tue Jun 23 22:27:15.070796 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 507, in _getctx
[Tue Jun 23 22:27:15.070799 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     self._load_context(self._ctx)
[Tue Jun 23 22:27:15.070801 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 518, in _load_context
[Tue Jun 23 22:27:15.070803 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     ctx.db = self._connect(self.keywords)
[Tue Jun 23 22:27:15.070806 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 546, in _connect
[Tue Jun 23 22:27:15.070808 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     return self.db_module.connect(**keywords)
[Tue Jun 23 22:27:15.070811 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
[Tue Jun 23 22:27:15.070813 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     return Connection(*args, **kwargs)
[Tue Jun 23 22:27:15.070815 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
[Tue Jun 23 22:27:15.070818 2015] [:error] [pid 2703] [remote 31.151.248.52:65474]     super(Connection, self).__init__(*args, **kwargs2)
[Tue Jun 23 22:27:15.070820 2015] [:error] [pid 2703] [remote 31.151.248.52:65474] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")
[Tue Jun 23 22:27:15.070827 2015] [:error] [pid 2703] [remote 31.151.248.52:65474] 

Any help?

5

Re: iRedAdminPro settings.py

Problem Solved !!

I did not notice that the default iRedMail installation script also installs the open-source iRedAdmin.

I incorrectly tried to install iRedAdminPro as a clean install, which caused all the errors.

After I upgraded the open-source iRedAdmin to iRedAdminPro, everything worked fine.

Thanks
jagter6

6

Re: iRedAdminPro settings.py

Thanks very much for purchasing iRedAdmin-Pro. smile

Thread closed.