Open-AudIT
https://www.open-audit.org/phpBB3/

Database error after install
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6564
Page 1 of 1

Author:  AlanHoiland [ Wed Nov 23, 2016 7:27 am ]
Post subject:  Database error after install

Hello,

After installing OA, and trying to open community, I get this error:
A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: C:\xampplite\open-audit\code_igniter\system\database\DB_driver.php

Line Number: 124

Author:  jpa [ Wed Nov 23, 2016 8:13 am ]
Post subject:  Re: Database error after install

Check that the MySQL service is running. The Windows [url=https://community.opmantek.com/display/OA/Windows+-+Installing]install[/url] of OpenAudit should work without further configuration.

Author:  AlanHoiland [ Wed Nov 23, 2016 9:07 am ]
Post subject:  Re: Database error after install

Yes, It is running. And port 80 is open for Apache. I'm a little flumoxed - I'ver install OA several times on different PCs without a problem.

Author:  jpa [ Wed Nov 23, 2016 9:24 am ]
Post subject:  Re: Database error after install

You could use another SQL query tool to check that MySQL is working. Database settings are in "C:\xampplite\open-audit\code_igniter\application\config\database.php". See if the server, username and password as defined there work.

Or even [code]mysql -Dopenaudit -uopenaudit -popenauditpassword[/code]Does that connect?

Remove and reinstall?

Author:  AlanHoiland [ Fri Nov 25, 2016 5:50 am ]
Post subject:  Re: Database error after install

So, I uninstalled 12.8.1 and installed 12.4. OA works fine. Installed 12.8.1 and after the install I get the database error. Tried to start MySQL from the command line - no go even though the service was running. Did some Googling and found a suggestion to add localhost to the hosts file. MySQL is now working as is OA. Weird. I don't recall having to do this on my other installs.

Author:  Mark [ Mon Dec 05, 2016 11:05 am ]
Post subject:  Re: Database error after install

I recently encountered this in development. For some reason connecting to localhost no longer worked. I changed the configuration in database.php to use 127.0.0.1 and it's fine. This is now the default shipping config. What a PITA.

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/