1 Topic by stribouille (edited by stribouille 2024-09-04 15:44:27)

  • stribouille
  • Member
  • Offline
  • Registered: 2020-08-25
  • Posts: 25

Topic: roundcube ko after update

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.8
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: RockyLinux 9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello, I wanted to upgrade iRedMail to 1.6.8 to 1.7.0
The first thing to do is to upgrade Roundcube.
So, I did it, all was ok but now I can't access to mt webmail, it says:
Oops... something went wrong!
An internal error has occurred. Your request cannot be processed at this time.

For administrators: Please check the application and/or server error logs for more information.

In the error file /var/log/nginx/error.log I have this:
PHP Warning:  SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.9/program/lib/Roundcube/rcube.php on line 1503" while reading response header from upstream, client: 10.100.10.4, server: _, request: "GET /mail/ HTTP/2.0", upstream: "fastcgi://127.0.0.1:9999", host: xxx"

But I don't know how to correct it. Please help me thanks.

----

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

2 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 914

Re: roundcube ko after update

Access denied for user 'roundcube'@'localhost' (using password: NO)

Wrong credentials, you hopefully did backup old files?

3 Reply by stribouille

  • stribouille
  • Member
  • Offline
  • Registered: 2020-08-25
  • Posts: 25

Re: roundcube ko after update

Cthulhu wrote:

Access denied for user 'roundcube'@'localhost' (using password: NO)

Wrong credentials, you hopefully did backup old files?

Yes I have a backup of all (application and database).

4 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 914

Re: roundcube ko after update

https://docs.kolab.org/administrator-gu … rence.html

You need to set the database config from the old config files to the new one, than everything should work hopefully

5 Reply by stribouille

  • stribouille
  • Member
  • Offline
  • Registered: 2020-08-25
  • Posts: 25

Re: roundcube ko after update

Cthulhu wrote:

https://docs.kolab.org/administrator-gu … rence.html

You need to set the database config from the old config files to the new one, than everything should work hopefully

Thank you, sorry I do not understand what to do hmm
I replace old RoundCube applicatation and roundcubemail database but I have the same problem.
I think the installation of RoundCube modified mysql database.

6 Reply by stribouille

  • stribouille
  • Member
  • Offline
  • Registered: 2020-08-25
  • Posts: 25

Re: roundcube ko after update

I have restored the mysql database (backup from iRedMail before upgrading RounCube) but the problem is always here.
I'm so disappointed

7 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 914

Re: roundcube ko after update

how did you upgrade roundcube?
The installation just overwrote your sql login credentials, the update/grade doesnt modify the database, because by itself it won't even have access to it to modifyy it

8 Reply by stribouille (edited by stribouille 2024-09-04 21:41:06)

  • stribouille
  • Member
  • Offline
  • Registered: 2020-08-25
  • Posts: 25

Re: roundcube ko after update

Cthulhu wrote:

how did you upgrade roundcube?
The installation just overwrote your sql login credentials, the update/grade doesnt modify the database, because by itself it won't even have access to it to modifyy it

I’ve upgrading RoundCube by Launch the update script.

ANo I have just restore mysql backup before I upgrade Roundcube.
Then I réinstalled RoundCube 1.6.5 and the roundcube database I backup before upgrading.

9 Reply by stribouille

  • stribouille
  • Member
  • Offline
  • Registered: 2020-08-25
  • Posts: 25

Re: roundcube ko after update

Hi again,

When I try to connect to mysql via mysql -u roundcube -p and put the password in /opt/www/roundcubemail/config/config.inc.php it is ok.

I don't understand where is the problem...

10 Reply by pailler25 (edited by pailler25 2024-09-16 23:15:51)

  • pailler25
  • Member
  • Offline
  • Registered: 2022-12-27
  • Posts: 1

Re: roundcube ko after update

++ same issue

error logs below:

[16-Sep-2024 14:41:44 +0000]: <emgh0gdn> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (GET /mail/)
[16-Sep-2024 14:41:48 +0000]: <nfhljbfj> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (POST /mail/?_task=mail&_action=refresh)
[16-Sep-2024 14:41:49 +0000]: <emgh0gdn> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (GET /mail/)
[16-Sep-2024 14:41:50 +0000]: <emgh0gdn> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (GET /mail/)
[16-Sep-2024 14:42:10 +0000]: <npl4qdj2> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (POST /mail/?_task=mail&_action=refresh)
[16-Sep-2024 14:42:44 +0000]: <emgh0gdn> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (GET /mail/)
[16-Sep-2024 14:42:45 +0000]: <emgh0gdn> DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'localhost' (using password: NO) in /opt/www/roundcubemail-1.6.8/program/lib/Roundcube/rcube_db.php on line 201 (GET /mail/)

Btw login and password in config/config.inc.php are correct