Community Forums

Discuss, share and get help from our community of friendly WHMCS users

Close
Login to Your Account
Results 1 to 5 of 5
  1. #1
    Join Date
    May 2014
    Location
    France
    Posts
    19

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

    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 (c) 1997-2016 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.0.2, Copyright (c) 2002-2017, by ionCube Ltd.
    with Zend OPcache v7.0.6-dev, Copyright (c) 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.
    Last edited by nuxwin; 09-11-17 at 07:47 PM.

  2. #2
    Join Date
    May 2014
    Location
    France
    Posts
    19

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

    Maybe related: https://forums.whmcs.com/showthread....B-10-2-Problem
    I'll give a try with older MariaDB version then, fallback to MySQL if really needed...

  3. #3
    Join Date
    May 2014
    Location
    France
    Posts
    19

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

    After disabling strict mode (in my case this was the STRICT_TRANS_TABLES), all went fine:
    Code:
    [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:

    Code:
    ...
    $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'"
    ]);
    ...
    Last edited by nuxwin; 09-12-17 at 12:14 PM.

  4. #4
    Join Date
    Jun 2009
    Location
    Sheffield, UK
    Posts
    8,637

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

    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.
    WHMCompleteSolution
    The Complete Client Management, Billing & Support System
    www.whmcs.com

  5. #5
    Join Date
    May 2014
    Location
    France
    Posts
    19

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

    Quote Originally Posted by WHMCS John View Post
    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

Similar Threads

  1. Fresh install with out Database
    By hostingclick in forum Using WHMCS
    Replies: 0
    Last Post: 07-21-15, 04:12 PM
  2. Connect WHMCS to existing DA install
    By Webunity in forum Pre-Sales Questions
    Replies: 2
    Last Post: 12-11-14, 03:11 PM
  3. Restoring WHMCS DB to fresh install - SSL issues
    By f2svpn in forum Developer Corner
    Replies: 1
    Last Post: 04-11-13, 02:00 PM
  4. Fresh install of WHMCS, config won't stop loading
    By TimJacobs in forum Using WHMCS
    Replies: 3
    Last Post: 05-24-10, 04:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •