Unable to connect as administrator after fresh install (WHMCS v7.2.3)

[nuxwin]

Dear community,

 

I've just made a fresh installation of WHMCS v7.2.3, using your own tarball. All went fine excepted the fact that I'm unable to connect as administrator. I repeated the install process two time with same result. It's appear that the tbladmins table is empty after installation.

 

Info about my environment

 

WHMCS

v7.2.3 (with a DEV license)

 

Distribution

root@jessie:~# lsb_release -a

No LSB modules are available.

Distributor ID: Debian

Description: Debian GNU/Linux 8.9 (jessie)

Release: 8.9

Codename: jessie

 

PHP

root@jessie:~# php -v

PHP 5.6.31-4+0~20170804100521.6+jessie~1.gbpea630b (cli)

Copyright © 1997-2016 The PHP Group

Zend Engine v2.6.0, Copyright © 1998-2016 Zend Technologies

with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.0.2, Copyright © 2002-2017, by ionCube Ltd.

with Zend OPcache v7.0.6-dev, Copyright © 1999-2016, by Zend Technologies

 

RDBMS

Server version: 10.2.8-MariaDB-10.2.8+maria~jessie-log mariadb.org binary distribution.

 

 

Thank you for any advise.

Edited September 11, 2017 by nuxwin

[nuxwin]

Maybe related: https://forums.whmcs.com/showthread.php?132457-MariaDB-10-2-Problem

I'll give a try with older MariaDB version then, fallback to MySQL if really needed...

[nuxwin]

After disabling strict mode (in my case this was the STRICT_TRANS_TABLES), all went fine:

root@jessie:~# cat /etc/mysql/conf.d/sql_mode.cnf 
[mysqld]
sql_mode = NO_AUTO_CREATE_USER
root@jessie:~# service mysql restart
root@jessie:~

 

To WHMCS team: sql_mode can be set on a per session basis. You should considere disabling any strict mode. For instance, with PDO, you could do something like:

 

...
$pdo new PDO("$type:host=$host;dbname=$name;charset=utf8", $user, $pass, [
   ...
   PDO::MYSQL_ATTR_INIT_COMMAND => "SET SESSION sql_mode = 'NO_AUTO_CREATE_USER'"
]);
...

Edited September 12, 2017 by nuxwin

[WHMCS John]

Hi,

I'm pleased to hear you were able to resolve the issue, and thanks for the follow-up post with your found solution. I'm sure other users will find that helpful in future.

[nuxwin]

Hi,

I'm pleased to hear you were able to resolve the issue, and thanks for the follow-up post with your found solution. I'm sure other users will find that helpful in future.

 

You're welcome