1 Topic by jkazemitabar

  • jkazemitabar
  • Member
  • Offline
  • Registered: 2013-09-01
  • Posts: 6

Topic: error in roundcube DATABASE ERROR: CONNECTION FAILED!

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
====Hello,

Installed iRedmail on a fresh Amazon EC2 instance.
Roundcube works when I enter the public DNS address noted in Amazon for the instance. e.g. ec2.xyz.xyz.xyz...com/mail
Though, when enter the hostname, roundcube page says DATABASE ERROR: CONNECTION FAILED!
All TCP ports in the Amazon security group are left open just in case.
It seems like a grant access issue.
Any ideas?

==== Required information ====
- iRedMail version: 8.5
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Linux/BSD distribution name and version: ubuntu 13.04
- Related log if you're reporting an issue:
====

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: error in roundcube DATABASE ERROR: CONNECTION FAILED!

iRedMail grants SQL user on 'localhost' by default, maybe you want to grant for other host?

3 Reply by jkazemitabar

  • jkazemitabar
  • Member
  • Offline
  • Registered: 2013-09-01
  • Posts: 6

Re: error in roundcube DATABASE ERROR: CONNECTION FAILED!

what is the SQL username that it uses to connect with?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: error in roundcube DATABASE ERROR: CONNECTION FAILED!

Check Roundcube config file to figure it out: /usr/share/apache2/roundcubemail/config/db.inc.php.

5 Reply by ishraq.1991

  • ishraq.1991
  • Member
  • Offline
  • Registered: 2016-10-24
  • Posts: 17

Re: error in roundcube DATABASE ERROR: CONNECTION FAILED!

At last i can run iredmail and run my mail server mail.deshipro.com
But after i logged in to the server with my postmaster account and created some mail address, all on a sudden it's showing me database error, connection failed.

So what's the issue now?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: error in roundcube DATABASE ERROR: CONNECTION FAILED!

Check the sql server, make sure it's running.

And, please always create a new forum topic for your own issue, do not hijack other's thread. Especially a 3-year old thread.