[Solved]: osclass can't connect to mysql database,

[fahad]

Hi folks,

I seem to have problems with connecting to database using osclass script. However, i have a plain php script to test if connection to database is possible and that works just fine.

During installation, with all green ticks (requirements) i proceed and when i provide database information like db name and username and password, on the very next page, it says "Osclass database is not available. Need more help?".

I have root access to mysql, i tried changing database and dbuser as well several times but futile.
Environment info is below:
OS = centos-release-6-8.el6.centos.12.3.x86_64
Mysql = 5.7.1
apache...

Its making me crazy. Plain php script can connect to database but osclass doesn't.

[SteveJohnson]

Mysql 5.7 is not compatible with osclass (out of the box) at the moment. Try with mysql 5.6 or 5.5

[osclassLover]

have you created database?...did you try to give the mysql user name and password correctly?...

did you give the correct database name?...

[fahad]

Osclasslover, of course I created empty database, also allowed install script to create one for me, tried uploading already installed osclass on localhost and then changed config variables as well. In every case it didn't work.

Stevejohnson thanks for that info, I will try 5.6

[fahad]

Downgraded to 5.6 version but still same problem. How can i generate logs of install script?

[fahad]

It seems there is some problem in step 3 of installation as i debugged more.
It goes inside oc_install function but doesn't seem to process first lines of functions which are below:
  $dbhost      = Params::getParam('dbhost');
    $dbname      = Params::getParam('dbname');
    $username    = Params::getParam('username');
    $password    = Params::getParam('password', false, false);
    $tableprefix = Params::getParam('tableprefix');

after that execution stops... Either i get page not found error or script keeps on asking for changing table prefixes but never resolves.
What kind of permissions i need for which files?
Experts anyone can help?

[teseo]

Hi,

Are you sure your MySQL user (username) has all privileges required?

Try this in PhpMyAdmin or shell MySQL console:

CREATE DATABASE db_name;
CREATE USER 'username' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON db_name.* to 'username';
exit;

(Replace strings in orange)

Regards

[fahad]

@teseo, yes it has access. I tried that script
As script creates all the tables. Now at step 3 page is blank.

Also config.php is generated with correct values. It's just that it doesn't take me to specify admin username and password.

[fahad]

Any expert please? Do you need some kind of logs to make some sense? or anything i can provide.

[fahad]

Tried with osclass 3.3 version and still same issue.

[_CONEJO]

"Osclass database is not available. Need more help?".

Either your database does not exists, or the mysql user you are using is incorrect. I don't think it has to do with Osclass but with your mysql configuration. Please, review the mysql credentials once more.

[fahad]

@_CONEJO,

There was no issue with MySQL credentials at all. If a plain php script can connect to db without any problem why would osclass has any issue with it?

If it generates all tables to the specified database then it means that user has all privileges and db credentials are all correct.

But i figured out what the problem was.
It was PHP's mb_str function. That wasn't installed with PHP.
Installed that and now it's fixed.
I propose one should write a requirement for PHP, MySQL, and Apache and File permissions etc. Maybe i can do that in free time.

[fahad]

Thank you all Experts for your kind help!

[osclassLover]

oh, thats really great news , this would really helpfull for someone, please ad [sovled]...