Jump to content
nuxwin

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

Recommended Posts

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

[email protected]:~# lsb_release -a

No LSB modules are available.

Distributor ID: Debian

Description: Debian GNU/Linux 8.9 (jessie)

Release: 8.9

Codename: jessie

 

PHP

[email protected]:~# 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 by nuxwin

Share this post


Link to post
Share on other sites

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

[email protected]:~# cat /etc/mysql/conf.d/sql_mode.cnf 
[mysqld]
sql_mode = NO_AUTO_CREATE_USER
[email protected]:~# service mysql restart
[email protected]:~

 

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 by nuxwin

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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 ;)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines