[Bug 1.2.15] Setup failes: PASSWORD EXPIRES NEVER on MariaDB Remote DB Server

**Starlight** · Mar 6th 2016

I received a couple of errors while installing/updating i-MSCP to version 1.2.14/1.2.15, for example:

Code

Servers::ftpd::proftpd::installer::_setupDatabase: Unable to create the proftpd@<IP>.0/255.255.255.0 SQL user: Error while executing statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PASSWORD EXPIRE NEVER' at line 1

I'm using a remote MariaDB SQL server.

**Nuxwin** · Mar 6th 2016

Which MariaDB version exactly?

Those bugs are normally fixed in 1.2.x and the fixes will be part of 1.2.16 version which will be released soon.

**Starlight** · Mar 6th 2016

Shell-Script

Debian standard.

If fixed, I'm fine. I solved it manually with deleting the SQL string. I will report after installing 1.2.16 (when released).

Share