1

Topic: Problem accessing email via browser with roundcube

==== Required information ====
- iRedMail version: iRedMail-0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu 13.10 (GNU/Linux 3.12.6-x86_64-linode36 x86_64)
- Related log if you're reporting an issue: log config where http://paste.ubuntu.com/6712791/
====

Hello to all.
I followed the tutorial
http://www.iredmail.org/install_iredmail_on_ubuntu.html

Installed iRedmail, chose the mysql option. When I access the domain / mail via browser, roundclube presented the following message on the screen: "Unable to connect to the database server-Please contact your administrator!."

I did not know what could be. This happened for all domains configured.

Could you explain me what I could have wrong section?

----

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

2

Re: Problem accessing email via browser with roundcube

Any related log in file /var/log/mail.log when you got this error?

3

Re: Problem accessing email via browser with roundcube

Did you restart your server after iRedMail installation?

4

Re: Problem accessing email via browser with roundcube

ZhangHuangbin wrote:

Any related log in file /var/log/mail.log when you got this error?

This file is empty.

In the apache logs showed error connection with iredadmin bank, followed the topic below to try to solve the problem but did not understand what I need to do to change the database password safely without affecting other services that use the bank iredadmin.

http://www.iredmail.org/forum/topic4150 … d-yes.html


[Wed Jan 08 14:59:35.579221 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 507, in _getctx                                               
[Wed Jan 08 14:59:35.579228 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]     self._load_context(self._ctx)

[Wed Jan 08 14:59:35.579235 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 518, in _load_context   

[Wed Jan 08 14:59:35.579243 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]     ctx.db = self._connect(self.keywords)  

[Wed Jan 08 14:59:35.579250 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 546, in _connect                                              

[Wed Jan 08 14:59:35.579257 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]     return self.db_module.connect(**keywords)                                                                           

[Wed Jan 08 14:59:35.579264 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect                                      

[Wed Jan 08 14:59:35.579271 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]     return Connection(*args, **kwargs)                                                                                  [Wed Jan 08 14:59:35.579278 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__                                 

[Wed Jan 08 14:59:35.579286 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]     super(Connection, self).__init__(*args, **kwargs2)                                                                  

[Wed Jan 08 14:59:35.579293 2014] [:error] [pid 3957] [remote 177.220.183.61:51324] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")                        

[Wed Jan 08 14:59:35.579307 2014] [:error] [pid 3957] [remote 177.220.183.61:51324]

Please help me, I need my emails active today.
I migrated to linode and only setup emails is my doubt.


Look examples my domains:

https://www.lcdassistec.com.br/iredadmin/
https://www.lcdassistec.com.br/mail/

Thanks

5

Re: Problem accessing email via browser with roundcube

tyler.vortex wrote:

[Wed Jan 08 14:59:35.579293 2014] [:error] [pid 3957] [remote 177.220.183.61:51324] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")

You don't have correct SQL password for iredadmin database in iredadmin config file (/usr/share/apache2/iredadmin/settings.py).
You can find original password in "iRedMail.tips" file, it's generated under iRedMail folder during installation. or you can reset it.

6

Re: Problem accessing email via browser with roundcube

ZhangHuangbin wrote:
tyler.vortex wrote:

[Wed Jan 08 14:59:35.579293 2014] [:error] [pid 3957] [remote 177.220.183.61:51324] OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")

You don't have correct SQL password for iredadmin database in iredadmin config file (/usr/share/apache2/iredadmin/settings.py).
You can find original password in "iRedMail.tips" file, it's generated under iRedMail folder during installation. or you can reset it.

Solved!!! o/
Thanks ZhangHuangbin.
Very easy now big_smile

But now with roundcube is connection problem too. I need to know the file I change the password for it too.
https://www.lcdassistec.com.br/mail/


One more thing: the panel / iredadmin I create an email, try to login with it and it does not work. Presents a message from User / Password incorrect.

7 (edited by tyler.vortex 2014-01-09 08:24:05)

Re: Problem accessing email via browser with roundcube

I found something here .
Seems to me that the emails are created in the mysql database (it was my choice save to database ) but I can not access or logs for these emails . see :

https://www.lcdassistec.com.br/iredadmin/profile/admin/general/postmaster@lcdassistec.com.br

But when I set up email as global administrator it is accessed normally, but even then if I try to access the logs will return me a message invalid email . It's all buggy 's it .

My SPF record is as follows:

TXT Records

Name TTL Value Options

dkim._domainkey.iredmail.org    "FcMycUvOBd7nsYn/TUrOua3Nns+qKSJBy88IWSh2zHaGbjRYujyWSTjlPELJ0H+5"     3600 (1 hour)

dkim._domainkey.iredmail.org    "EV711qseo/omquskkwIDAQAB"     3600 (1 hour)    

dkim._domainkey.iredmail.org    "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDYArsr2BKbdhv9efugByf7LhaK"     3600 (1 hour)

dkim._domainkey.iredmail.org    "txFUt0ec5+1dWmcDv0WH0qZLFK711sibNN5LutvnaiuH+w3Kr8Ylbw8gq2j0UBok"     3600 (1 hour)

dkim._domainkey.iredmail.org    "v=DKIM1; p="     3600 (1 hour)

iredmail.org    "v=spf1 mx mx:mail.iredmail.org -all"

As Mentioned here:
https://code.google.com/p/iredmail/wiki/DNS_DKIM
Do not know if configured correctly.

Error in config file "/etc/amavis/conf.d/50-user": dkim_key: selector dkim for domain trilhadobrasil.com.br already in use
root@tosystems:~# vim /etc/amavis/conf.d/50-user

My iRedmail.tips :

Admin of domain lcdassistec.com.br:
    * Account: postmaster@lcdassistec.com.br
    * Password: mypassword

    You can login iRedAdmin with this account, login name is full email address.

First mail user:
    * Username: postmaster@lcdassistec.com.br
    * Password: mypassword
    * SMTP/IMAP auth type: login
    * Connection security: STARTTLS or SSL/TLS

    You can login webmail with this account, login name is full email address.


SSL cert keys (size: 2048):
    - /etc/ssl/certs/iRedMail_CA.pem
    - /etc/ssl/private/iRedMail.key

Mail Storage:
    - Root directory: /var/vmail
    - Mailboxes: /var/vmail/vmail1
    - Backup scripts and copies: /var/vmail/backup

Apache:
    * Configuration files:
        - /etc/apache2
        - /etc/apache2/apache2.conf
        - /etc/apache2/conf-available/*
    * Directories:
        - /usr/share/apache2
        - /var/www
    * See also:
        - /var/www/index.html

PHP:
    * Configuration file: /etc/php5/apache2/php.ini
    * Disabled functions: show_source,system,shell_exec,passthru,exec,phpinfo,proc_open

MySQL:
    * Root user: root, Password: rootPassMySQL
    * Bind account (read-only):
        - Username: vmail, Password: uBhPvOPjUnc4MVge7oSvzKYs5PLmzc
    * Vmail admin account (read-write):
        - Username: vmailadmin, Password: jN0AeqzG0klXx0YsN2dLyD3zQZbaU0
    * RC script: /etc/init.d/mysql
    * See also:
        - /srv/lcdassistec/downloads/iRedMail-0.8.6/conf/mysql_init.sql

Virtual Users:
    - /srv/lcdassistec/downloads/iRedMail-0.8.6/samples/iredmail.mysql
    - /srv/lcdassistec/downloads/iRedMail-0.8.6/conf/mysql_vmail.sql

Postfix (basic):
    * Configuration files:
        - /etc/postfix
        - /etc/postfix/aliases
        - /etc/postfix/main.cf
        - /etc/postfix/master.cf

Postfix (MySQL):
    * Configuration files:
        - /etc/postfix/mysql/transport_maps_domain.cf
        - /etc/postfix/mysql/transport_maps_user.cf
        - /etc/postfix/mysql/virtual_mailbox_domains.cf
        - /etc/postfix/mysql/relay_domains.cf
        - /etc/postfix/mysql/virtual_mailbox_maps.cf
        - /etc/postfix/mysql/virtual_alias_maps.cf
        - /etc/postfix/mysql/domain_alias_maps.cf
        - /etc/postfix/mysql/catchall_maps.cf
        - /etc/postfix/mysql/domain_alias_catchall_maps.cf
        - /etc/postfix/mysql/sender_login_maps.cf
        - /etc/postfix/mysql/sender_bcc_maps_domain.cf
        - /etc/postfix/mysql/sender_bcc_maps_user.cf
        - /etc/postfix/mysql/recipient_bcc_maps_domain.cf
        - /etc/postfix/mysql/recipient_bcc_maps_user.cf
Policyd (cluebringer):
    * Web UI:
        - URL: httpS://tosystems.net/cluebringer/
        - Username: postmaster@lcdassistec.com.br
        - Password: mypassword
    * Configuration files:
        - /etc/cluebringer/cluebringer.conf
        - /etc/cluebringer/cluebringer-webui.conf
    * RC script:
        - /etc/init.d/postfix-cluebringer
    * Database:
        - Database name: cluebringer
        - Database user: cluebringer
        - Database password: W3u1XqtLhjxD3eDiTROW2Yp5xGHa0z



Dovecot:
    * Configuration files:
        - /etc/dovecot/dovecot.conf
        - /etc/dovecot/dovecot-ldap.conf (For OpenLDAP backend)
        - /etc/dovecot/dovecot-mysql.conf (For MySQL backend)
        - /etc/dovecot/dovecot-pgsql.conf (For PostgreSQL backend)
        - /etc/dovecot/dovecot-used-quota.conf (For real-time quota usage)
        - /etc/dovecot/dovecot-share-folder.conf (For IMAP sharing folder)
    * RC script: /etc/init.d/dovecot
    * Log files:
        - /var/log/dovecot.log
        - /var/log/sieve.log
    * See also:
        - /var/vmail/sieve/dovecot.sieve
        - Logrotate config file: /etc/logrotate.d/dovecot

ClamAV:
    * Configuration files:
        - /etc/clamav/clamd.conf
        - /etc/clamav/freshclam.conf
        - /etc/logrotate.d/clamav
    * RC scripts:
            + /etc/init.d/clamav-daemon
            + /etc/init.d/clamav-freshclam
    * Log files:
        - /var/log/clamav/clamd.log
        - /var/log/clamav/freshclam.log

DNS record for DKIM support:



Amavisd-new:
    * Configuration files:
        - /etc/amavis/conf.d/50-user
        - /etc/postfix/master.cf
        - /etc/postfix/main.cf
    * RC script:
        - /etc/init.d/amavis
    * MySQL Database:
        - Database name: amavisd
        - Database user: amavisd
        - Database password: ZOKY38RQoQ0h0u3FxgP9BKDhxc9mcA
        - SQL template: /srv/lcdassistec/downloads/iRedMail-0.8.6/samples/amavisd/amavisd-2.7.0.mysql

SpamAssassin:
    * Configuration files and rules:
        - /etc/mail/spamassassin
        - /etc/mail/spamassassin/local.cf

iRedAPD - Postfix Policy Daemon:
    * Version: 1.4.2
    * Listen address: 127.0.0.1, port: 7777
    * Related files:
        - /opt/iRedAPD-1.4.2/
        - /opt/iredapd/
        - /opt/iredapd/etc/settings.py

iRedAdmin - official web-based admin panel:
    * Version: 0.3
    * Configuration files:
        - /usr/share/apache2/iRedAdmin-0.3/
        - /usr/share/apache2/iRedAdmin-0.3/settings.py*
    * URL:
        - https://tosystems.net/iredadmin/
    * Login account:
        - Username: postmaster@lcdassistec.com.br, password: mypassword
    * SQL database account:
        - Database name: iredadmin
        - Username: iredadmin
        - Password: KAGB81GCLqrC3ruuC7Gpf33I6h7h2e
    * Settings:
        - /usr/share/apache2/iRedAdmin-0.3/settings.py
    * See also:
        - /etc/apache2/conf-available/iredadmin.conf

Roundcube webmail:
    * Configuration files:
        - /usr/share/apache2/roundcubemail-0.9.5/
        - /usr/share/apache2/roundcubemail-0.9.5/config/
    * URL:
        - http://tosystems.net/mail/
        - https://tosystems.net/mail/ (Over SSL/TLS)
        - http://tosystems.net/webmail/
        - https://tosystems.net/webmail/ (Over SSL/TLS)
    * Login account:
        - Username: postmaster@lcdassistec.com.br, password: mypassword
    * See also:
        - /etc/apache2/conf-available/roundcubemail.conf

phpMyAdmin:
    * Configuration files:
        - /usr/share/phpmyadmin
        - /usr/share/phpmyadmin/config.inc.php
    * Login account:
        - Username: root, password: rootPassMySQL
        - Username: vmailadmin, password: jN0AeqzG0klXx0YsN2dLyD3zQZbaU0
        - Username (read-only): vmail, password: uBhPvOPjUnc4MVge7oSvzKYs5PLmzc
    * URL:
        - https://tosystems.net/phpmyadmin
    * See also:
        - /etc/apache2/conf-available/phpmyadmin.conf

Backup MySQL database:
    * Script: /var/vmail/backup/backup_mysql.sh
    * See also:
        # crontab -l -u root

It seems to me that another domain is already configured in this policy .

I'm totally lost , my God kkk

Post's attachments

print admin iredAdmin.png
print admin iredAdmin.png 27.13 kb, file has never been downloaded. 

print iredAdmin.png
print iredAdmin.png 28.5 kb, 1 downloads since 2014-01-09 

You don't have the permssions to download the attachments of this post.

8

Re: Problem accessing email via browser with roundcube

iRedAdmin open source edition doesn't support login as a mail user which is marked as domain admin.

9

Re: Problem accessing email via browser with roundcube

ZhangHuangbin wrote:

iRedAdmin open source edition doesn't support login as a mail user which is marked as domain admin.

I think I understand.
So I have to set up in only one domain, log in and create other domains using domain previously configured panel?

If it is not working. I decided to use the domain 10admin.com.br, configured the iRedadmin.sh this field but when I log does not log.

In the vmail (/ var / log / logs vmail.err not appear anything.
He is set to other users / group and maybe the root user does not have access to data that log.

10

Re: Problem accessing email via browser with roundcube

iRedAdmin supports only global domain, so if you mark as mail user as GLOBAL admin, it works.

11

Re: Problem accessing email via browser with roundcube

ZhangHuangbin wrote:

iRedAdmin supports only global domain, so if you mark as mail user as GLOBAL admin, it works.

So I can not register new domains and their users is that? = /
If I pay for a PRO version can I create?

I'll need installation support if you buy the PRO version.