photo

Sobhana Narasimhan

shared this question
6 years ago

Employees Involved

photo

PIV Support

Admin

Statistics

22
Comments
7720
Views

Relates to

Share

5
votes

Intalling Open Realty Free version - Unable to connect to database

Hello,

I'm stuck with Step 4. Connecting to MYSQL. I have an empty database set up but still says cannot connect to your database. Please check your configuration. Please help.

Thank you.

Add Comment

Comments (22)

photo Employee
0

You have to also grant the database user you also created full privileges to the database you created.

photo
0

Thank you for your prompt reply. Yes. I did grant the user full privileges to the database. Please help

photo
0

Having the same problems database connections are 100% correct any other suggestions

photo
0

and the error message is very generic. It does not say what exactly is wrong. I check the log files too but nothing was written to the logs about the database error. Please advise.

photo
0

I Have contacted my host and they confirm that the database connections are 100 correct so I am goint to try a fresh install and see if that helps I will let you know

photo Employee
0

A fresh install isn't likely going to get around this.

Verifying connection info also does not verify that the DB user you created has *all* permissions to use the empty DB you created.

photo
0

Well thats not particularly helpful is it? How do you suggest that this is checked considering I used cpanel to create the user and assigned all permissions to that user?

photo Employee
1

Your host should be able to look at their logs for the exact time you caused this to fail and tell you exactly what is wrong.

A typo in the DB name, user, password, or a simple lack of privileges will all be logged in their error logs and timestamped for when you caused it to fail.

Whatever it is, it's going to be simple, and has to do with the credentials you are using, i.e. one of the following bits of info you entered into the installer:

Database Server:

Database Name:

Database User:

Database Password

It could be that your host requires something other than "localhost" for the DB server, or as I already mentioned a simple typo or lack of privileges set for the DB user you entered.

photo
0

I'm running this on my localhost. Both Apache and mysql. This there any other file that I need to look? Please advise. Thank you for your support.

photo Employee
0

@Sobhana Narasimhan

I would suggest installing OR on an actual live hosting account where you are assured the host's services and features meet OR's server requirements and you can receive assistance from the host. Doing a localhost install assumes you have the experience to setup your server software correctly and can handle this kind of situation and are also able to troubleshoot your error logs.

Otherwise I cannot offer you assistance with a localhost install here.

photo
0

Hello,

I want to run the trial/free version of Open Realty on my localhost (doing a Proof Of Concept). I would like to have it set up to run on my local machine before I host it.

Thanks

photo
0

Hello PIV Support

Just to clarify there ar two individuals here with the same problem me and sobhanna Narasimhan whio is trying to install locally I am trying to install on a hosted server I will let you know how I get on

Regards

photo Employee
0

I just noticed that, thank you.

photo
0

Hello please see transcript of tech help from my ISP detailed below within the last few minutes not (GMT) perhaps you can shed some light on this as I really want to be able to evaluate this software prior to purchase

Regards

Boyd Ireland

info: Please wait for a site operator to respond.

info: You are now chatting with 'Silvester J'

Silvester J: Hello and Welcome to Live Chat Support.

Silvester J: How may I assist you today ?

Boyd: Hello silvester J this is killing me I am trying to install a copy or open-reality and had problems one of which was

Boyd: - You have "magic_quotes_gpc" actually set to "ON" at your server while you should have it set to "OFF". Contact your host support and ask to turn it off.

Boyd: My account is xxxxxxxxxxxxxx

Boyd: domain name is www.selfcateringnorthernireland.com

Boyd: No 3 hours ago you guys changed the magic quote settings but I could then not connect to the database

Boyd: Si at your suggestion I did a fress install with the most uptodate version n ow the magic quotes error is back and I dont know why

Silvester J: Give me a moment please. I am looking into this.

Boyd: please help me cause if i was not bald i'd be tearing my hair out

Boyd: the install script is located at http://www.selfcateringnorthernirelan... if that helps you to see the error

Silvester J: Give me a moment please. I am looking into this.

Boyd: OK

Silvester J: try now

Boyd: wait one please

Boyd: OK So far now please go to this url and enter the folowing database information as when I try it fails http://www.selfcateringnorthernirelan...

Boyd: databasename = xxxxxxx username = xxxxxxxxx pass = xxxxxxxx Host = localhost

Silvester J: have you created the database and user ?

Boyd: Yes Via CPanel

Silvester J: let me check

Boyd: Before we proceed how did you change the magic quotes and is this something I can do myself if needed again rather than bothering you guys?

Silvester J: please try again

Boyd: OK please wait a minute

Boyd: I get the following message

Boyd: We are unable to connect to your database. Please Check your settings and try again.

Boyd: you are welcome to try if you like

Silvester J: ok getting same error but i have checked and the database details and the user permissions are set to correct

Boyd: Ok Here is the reply from open-reality earlier today

Boyd: PIV Support, an employee of Transparent Technologies, replied to Intalling Open Realty Free version - Unable to connect to database, a question about Transparent Technologies. Your host should be able to look at their logs for the exact time you caused this to fail and tell you exactly what is wrong. A typo in the DB user name, password, or a simple lack of privileges will all be logged in their error logs and timestamped for when you caused it to fail. Whatever it is, it's going to be simple, and has to do with the credentials you are using, i.e. one of the following bits of info you entered into the installer: Database Server: Database Name: Database User: Database Password It could be that your host requires something other than "localhost" for the DB server, or as I already mentioned a simple typo or lack of privileges set for the DB user you entered.

Boyd: Can you check the error logs to see if there is a problem?

Silvester J: there is no issues with the database details

Silvester J: ==========================

Silvester J: # mysql -h CORRECT -u CORRECT-p CORRECT selfcate_propertys

Silvester J: Welcome to the MySQL monitor. Commands end with ; or g.

Silvester J: Your MySQL connection id is XXXXX

Silvester J: Server version: 5.1.56-log MySQL Community Server (GPL)

Silvester J: Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Silvester J: This software comes with ABSOLUTELY NO WARRANTY. This is free software,

Silvester J: and you are welcome to modify and redistribute it under the GPL v2 license

Silvester J: Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

Silvester J: mysql>

Silvester J: -====================================

Silvester J: which shows that its connecting fine

Boyd: OK An other suggestions as I know that 1000s of sites run this software?

info: Your chat transcript will be sent to boyd@greyabbey.com at the end of your chat.

Silvester J: you may contact to the provider of the script to check on it

Boyd: Silvester J What are you typing Man!!

Silvester J: There is no issues with the server end or database privileges

Silvester J: you may check it via test database script

Silvester J: http://www.selfcateringnorthernirelan...

Silvester J: this is something with the application you using

Boyd: OK I will get back to the developers why is life so hard all I want to do is make money LOL

Boyd: Thanks for your help great its a pleasure as usual to deal with you guys

Boyd: Bye for Now

Silvester J: You are welcome

Silvester J: You might receive a short Survey, We would request you to give us your valuable feedback as it will help us to go that extra mile to provide you with Quality Service.

Silvester J: Thank you for visiting our live chat service. It was a pleasure serving you. Please feel free to revert in case of any issues or doubts.

Silvester J: Bye

photo
0

Note XXXXX replaces actual usernames etc

photo Employee
1

Your host didn't bother looking at the error logs and connected with tools that are not using PHP & ADODB, so there may be other restrictions in place that prevent OR from connecting to the DB, such as no mySQL abstraction compiled into PHP. It's also notable that at least 100 people successfully install OR every week, and have been for 10 years.

If PHP magic quotes is only turned off for the root folder and not turned off for the *entire site*, that will also cause problems. A lot of budget and/or uninformed hosts think they can just turn this off by dropping a php.ini file into your root folder, but that absolutely will not work. The next version of PHP won't even contain magic quotes support so they should not still running it globally anyway..

All I can suggest here is that you insist they they look at your error logs as I already suggested and also have them verify that your hosting meets *all* of OR's server requirements.Otherwise Transparent Tech offers great compatible hosting at reasonable rates which includes OR Pro edition pre-installed.

photo
0

Hi I have passed your comment on to my Host who confirm that following and ask if you could be kind enough to check the following link

http://www.selfcateringnorthernirelan...

to see if any additional settings are required as they believe currently the server is set correctly

Transcript of our chat follows

Boyd: I have contacted the supplier and this is their response

Boyd: PIV Support, an employee of Transparent Technologies, commented on a reply in Intalling Open Realty (OR) Free version - Unable to connect to database, a question about Transparent Technologies. Your host didn't look at the error logs and connected with tools that are not using PHP & ADODB, so there may be other restrictions in place that prevent OR from connecting to the DB, such as no mySQL abstraction compiled into PHP. It's also notable that at least 100 people successfully install OR every week, and have been for 10 years. If PHP magic quotes is only turned off for the root folder and not turned off for the *entire site*, that will also cause problems. Some hosts just turn it off by dropping a php.ini file into your root folder, but that will not work. The next version of PHP won't contain magic quotes support so it should not be running globally as best practice.. All I can suggest here is that you insist they they look at your error logs as I already suggested and also have them verify that your hosting meets *all* of OR's server requirements. Otherwise Transparent Tech offers great compatible hosting at reasonable rates which includes OR Pro edition pre-installed.

Boyd: The server requirements for open reality version 3 are

Boyd: Open-Realty? v3 requires the following server configuration. o Ability to make outbound connections from your server to HTTP (80) and HTTPS (443) Servers (Ports). o PHP v5.2 or higher o PHP GD Support or Imagemagik o PHP Multibyte String Support o PHP CURL support o PHP OpenSSL support o PHP Zip support o PHP Short Tag support disabled o PHP Magic Quotes set to OFF (in all program folders) o PHP ionCube Loader support o MySQL 5 or higher o Apache mod_rewrite (required for SEO Friendly URLs) o Apache mod_expires (recommended) o Apache mod_headers (recommended)

Boyd: so where do we go from here?

Silvester J: PHP magic quotes - is off for entire site

Silvester J: all the require version is updated on server

Boyd: what do you suggest as I would much prefer to stay with eukhost on this one

Silvester J: please provide this link to http://www.selfcateringnorthernirelan... Intalling Open Realty (OR) team

Silvester J: and ask them if anythiing else need to enable on server

photo Employee
0

You cannot determine 100% if a host meets all of OR's server requirements from looking at phpinfo() output, but you can use that to verify a lot of the requirements. Your host will be the *only* one that knows if their hosting meets OR's list of server requirements, and that is why the list exists.

http://www.open-realty.org/download.html

They still have not done the very first thing I suggested that would bring this to a close, they need to retrieve the specific error from their error logs. If any PHP application tries but cannot access mySQL for whatever reason (it's not connecting) there will be an error in their logs showing the attempt and detailing *exactly* why it is not working, e.g. bad port, bad username or password or etc). Until we know why, all I can suggest is to get a better non-budget hosting account where their support knows how to troubleshoot problems utilizing common services such as PHP and mySQL.

If you are trying to install and use OR with $2.50/month (budget) hosting you will likely never have a satisfactory experience using OR.

photo
0

PHP short tag is required to be turned OFF and phpinfo says it is ON...

photo
0

Hi where can I get some questions relating to hosting by yourselves answered prior to ordering

photo
1

I am a webhost. I'm installing for a client. The mysql error log nor php error log records anything. I have turned on display errors. Cannot connect to database

root@xxxxx.xxxxxx-xxxxxx.com:/home/xxxxxxx/xxxxxxx/public_html# mysql -u xxxxxxxxxx -p -h 192.168.0.2Enter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 143623Server version: 5.1.65-cll MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 20M