1 Topic by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 243

Topic: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

==== 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:
====


CentOS 6 with MySQL upgraing to Admin-Pro 2.5.

bash upgrade_iredadmin.sh

<<< ERROR >>> File /root/.my.cnf not found.
<<< ERROR >>> Please add mysql root user and password in it like below, then run this script again.

[client]
host=127.0.0.1
port=3306
user=root
password="plain_password"

Has the pathing changed in the scripts as I do not recall ever having .my.cnf in root directory?

----

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: 30,770

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

Please add /root/.my.cnf manually

3 Reply by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 243

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

Thought those values were located in another file but do not recall which as I do not think it is the settings.py file.

Also, was looking for /root/iRedMail-0.9.6/tools/upgrade_script_name.sh. 
Yet that is not there. 
Are we now to run what I thought was new install script /root/iRedMail-0.9.6/iRedMail.sh

4 Reply by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 243

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

Sorry but am confused with the upgrade docs here from previous versions. 
Was looking at this page...
    http://www.iredmail.org/docs/upgrade.ir … 0.9.6.html

However, it starts with iRedAPD and then onto iRedAdmin while not ever discussing iRedMail upgrade steps.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

I'm afraid that you mixed iRedMail and iRedAdmin-Pro upgrade process.

*) For iRedAdmin-Pro, it's mentioned in the upgrade tutorial:
http://www.iredmail.org/docs/migrate.or … admin.html

There's a "tools/upgrade_iredadmin.sh" script in iRedAdmin-Pro.

*) For iRedMail, please follow our upgrade tutorials here:
http://www.iredmail.org/docs/iredmail.releases.html

pbf343 wrote:

However, it starts with iRedAPD and then onto iRedAdmin while not ever discussing iRedMail upgrade steps.

You probably didn't read rest sections in the upgrade tutorial. big_smile

6 Reply by emiliojl

  • emiliojl
  • Member
  • Offline
  • Registered: 2016-06-07
  • Posts: 36

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  iRedMail-0.9.5-1
- Linux/BSD distribution name and version: Ubuntu 14
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? iRedAdmin-Pro-SQL-2.5.0
- Related log if you're reporting an issue:
=======================================

Hi, i'm stuck in upgrade too, Same error.

I made the file .my.cnf.
I added to the file 4 lines..:

<<< ERROR >>> MySQL root user name or password is incorrect in /rooease double check.

File details:
host=127.0.0.1
port=3306
user=root
password=1WuMiVtTA|DUMMY|PY4YLAH4VY4

Can't install the upgrade. The password is alright.

Any idea?

Thanks.

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

When you type "mysql" command without argument, does it successfully login?

8 Reply by emiliojl (edited by emiliojl 2017-03-29 10:30:01)

  • emiliojl
  • Member
  • Offline
  • Registered: 2016-06-07
  • Posts: 36

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

Does nothing.

==================================================================================
root@mail:~# mysql
error: Found option without preceding group in config file: /root/.my.cnf at line: 1
Fatal error in defaults handling. Program aborted
================================================================================

But if i try this works..

================================================================================
root@mail:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11026
Server version: 5.5.54-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
================================================================================

I saw that backup script don't run more after  iRedAdmin-Pro-SQL-2.4.1 update.

Any idea?

Thanks.

9 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: iRedAdmin-Pro-SQL-2.5.0 fails to upgrade

emiliojl wrote:

error: Found option without preceding group in config file: /root/.my.cnf at line: 1

You have wrong format in file /root/.my.cnf. It should be:

[client]
user="root"
password="xxx"

Please fix it and try again.