Jump to content

Install 6.4.4 into blank database ... nothing populated


Recommended Posts

First time trying this, so could be something I've got wrong, but have tried a number of things, and nothing seems to work.

Have checked host details, user names privlidges and all seem correct.

I get no warnings or error messages during the install, and it all goes through without any obvious issues, but when I check the database there is nothing, not even the tables?

My back end is a SME server, version 10

Even tried changing the php version to 7.3 instead of 7.5 still no joy.

 

Is there a way to get more feed back from the installer as to where the problem might be?

Link to comment
Share on other sites

Maybe you can decipher this for me ...

Not the whole file, just a bit from the beginning:

[04-Jan-2022 22:35:45 UTC] PHP Notice:  Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 280
[04-Jan-2022 22:35:45 UTC] PHP Notice:  Undefined index: FORM in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 283
[04-Jan-2022 22:35:45 UTC] PHP Notice:  Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 283
[04-Jan-2022 22:35:45 UTC] PHP Notice:  Undefined index: FORM in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 286
[04-Jan-2022 22:35:45 UTC] PHP Notice:  Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 286
[04-Jan-2022 22:35:45 UTC] PHP Notice:  Undefined index: FORM in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 289
[04-Jan-2022 22:35:45 UTC] PHP Notice:  Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 289
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::__construct() expects parameter 5 to be int, string given in /home/e-smith/files/ibays/cc_2022/html/setup/setup.install.php on line 100
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli_options() [<a href='http://docs.php.net/manual/en/function.mysqli-options.php'>function.mysqli-options.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/setup/setup.install.php on line 102
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::close() [<a href='http://docs.php.net/manual/en/mysqli.close.php'>mysqli.close.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/setup/setup.install.php on line 109
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::__construct() expects parameter 5 to be int, string given in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 37
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli_options() [<a href='http://docs.php.net/manual/en/function.mysqli-options.php'>function.mysqli-options.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 39
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217
[04-Jan-2022 22:36:20 UTC] PHP Warning:  Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97
[04-Jan-2022 22:36:20 UTC] PHP Notice:  Undefined offset: 0 in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 258
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217
[04-Jan-2022 22:36:20 UTC] PHP Warning:  Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217
[04-Jan-2022 22:36:20 UTC] PHP Warning:  Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97
[04-Jan-2022 22:36:20 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217
[04-Jan-2022 22:36:20 UTC] PHP Warning:  Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97

 

Link to comment
Share on other sites

When entering the details of where and what to use to connect to the database, are you entering something other than 3306 for the "database port"? If anything at all?

If not entering anything, then there should be a relevant directive in the system's PHP.INI file, [mysqli] section.

 

Link to comment
Share on other sites

39 minutes ago, bsmither said:

When entering the details of where and what to use to connect to the database, are you entering something other than 3306 for the "database port"? If anything at all?

 

I didn't see any option to enter a database port,  the server has port 3306 open and set to listen (as reported by: netstat -ant )

The SMEServer FAQ file ( https://wiki.koozali.org/MySQL#Optimizing_MYSQL_default_settings ) does talk about not using ports any more, and is using sockets instead, not sure if this will have any impact on what is happening? But that FAQ file is for version 9 and I now have version 10 installed. Which says "MySQL is provided by MariaDB" so I'm thinking it is using port 3306 again, especially since the netstat reported the the port is actively in LISTEN mode.

That all said, this is getting above my limited understanding on how things work, so I could be totally wrong.

Link to comment
Share on other sites

Posted (edited)

Looking at the error log, and pondering bsmither's comments.  I looked at line 100 of file setup.install.php, parameter 5 is the port number, so the code above that might be returning blank:

 $dbport = !empty($_POST['global']['dbport']) ? $_POST['global']['dbport'] : ini_get('mysqli.default_port');

So I'm looking to see what the mysqli.default_port is set for the SME server, if anyone has any hints that would be great, if I find it first I'll post it here.

SME Server is based on CentOS 7 if that is any help

Edited by Junkman
Adding more details
Link to comment
Share on other sites

Please visit this URL:

https://www.MY_STORE_DOMAIN.com/setup/info.php

where MY_STORE_DOMAIN is the web name of your server (however you access CubeCart).

In the top table, you will find the location of the Loaded Configuration File. In this file, in the [mysqli] section, you will find the details PHP is expecting to use.

Then, scroll down to the mysqli table. Here , it will show the specific details that PHP is expecting to use, if any are stated.

Unfortunately, I cannot make suggestions on where to find the Maria database configuration file. It might be at:

etc/mysql/my.cnf

In that file, the [client] section, will be the details on how to connect to the database -- I assume.

Link to comment
Share on other sites

On 1/5/2022 at 10:26 PM, bsmither said:

Please visit this URL:

https://www.MY_STORE_DOMAIN.com/setup/info.php

where MY_STORE_DOMAIN is the web name of your server (however you access CubeCart).

 

Which give me

[08-Jan-2022 17:50:43 Pacific/Auckland] PHP Warning:  phpinfo() has been disabled for security reasons in /home/e-smith/files/ibays/cc_2022/html/setup/info.php on line 14

So, somewhere in the SME server it is locking down the phpinfo() option, which might also be causing issues in other places ... I'll do some hunting.

Thanks

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...