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

Connecting to the MySQL Server [fixed]
https://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=2166
Page 1 of 1

Author:  Montanascott [ Wed Feb 21, 2007 4:00 am ]
Post subject:  Connecting to the MySQL Server [fixed]

I'm going through the install process and everything seems to go fine until I get to the Setup Database part. The page shows Connecting to the MySQL Server... . I thought that it may just take a while, so I let it sit for an hour. It still says Connecting to the MySQL Server... . I'm getting no errors. Any ideas?

Author:  harner [ Mon Feb 26, 2007 11:20 pm ]
Post subject: 

Do you have the correct values in the include_config.php file?

Author:  mikeyrb [ Mon Feb 26, 2007 11:24 pm ]
Post subject: 

It may be an error in the setup script, I'm not entirely sure. Please download this version of setup.php:
[quote]http://open-audit.svn.sourceforge.net/viewvc/*checkout*/open-audit/trunk/setup.php?revision=690

There were some bug fixes and actually I believe the installer that got released was buggy! Hope the new script works for you.

Author:  AMueller [ Wed Feb 28, 2007 6:39 am ]
Post subject: 

I'm seeing the same issue. I tried the new setup.php with no luck...

Author:  mikeyrb [ Wed Feb 28, 2007 7:37 am ]
Post subject: 

What version of MySQL/PHP and also is it on localhost?

Author:  AMueller [ Wed Feb 28, 2007 11:32 pm ]
Post subject: 

MySQL version 5.0.27-community-nt. It's loaded in the c:\prog files\mysql\mysql server 5.0\ directory, however I have all necessary directories in my PATH. (ie. bin, etc)

PHP is 5.2.0.0 and it is off the root (C:\php)

P.S. MontanaScott sorry to take over your post, hopefully the same resolution fixes us both!!

Author:  Mark [ Thu Mar 01, 2007 12:01 am ]
Post subject: 

OK, create a .php file in your web directory, and inside it, put the following:
[code]<?php
phpinfo();
?>[/code]
Next, call that page in your web browser. Do you see a section with a "mysql" heading ? If not, then your php isn't talking to your mysql....

Author:  AMueller [ Thu Mar 01, 2007 12:43 am ]
Post subject: 

You nailed it! No MySQL section, the two are not on speaking terms...

Author:  A_Hull [ Fri Mar 02, 2007 8:46 pm ]
Post subject: 

Look for the following in your php.ini file.. (you may have more than one PHP.INI file if you have installed PHP and Apache as separate packages, so if this line looks OK, look for another PHP.INI file).

[code]
;extension=php_mysql.dll
[/code]

if it has a ; in front of the line, then remove it.

ALSO beware the line ;extension=php_mssql.dll is for Microsoft SQL so check carefully.... mysql not mssql


[code]
extension=php_mysql.dll
[/code]

and restart the web server (apache or iis)
(If you are running Linux, the line will be slightly different)

BTW this sort of problem is the reason I moved to using XAMPP, it typically sets up all of this stuff for you. http://www.apachefriends.org/en/xampp.html

Author:  qc_metal [ Sat Mar 03, 2007 12:08 am ]
Post subject: 

I noticed when I ran the installation for PHP, there was an option to select the MySQL components (got around this issue nicely!).

Author:  A_Hull [ Sat Mar 03, 2007 1:56 am ]
Post subject: 

[quote="qc_metal"]I noticed when I ran the installation for PHP, there was an option to select the MySQL components (got around this issue nicely!).

I take it that means the issue is fixed (I will mark it fixed). If not let me know.
Hope you enjoy using Open Audit. Let us know how you get on.
:lol:

Author:  qc_metal [ Sat Mar 03, 2007 3:37 am ]
Post subject: 

Whoops - I guess I hopped into this conversation saying that the PHP installation for Windows gives you an option to select MySQL add-ins during install...just trying to be helpful. I don't know if the issue is fixed for AMueller...

Author:  AMueller [ Mon Mar 05, 2007 2:01 am ]
Post subject: 

Thanks for all the input. I'm actually away from my computer until Tuesday but will try the php.ini fix then.

Thanks all for your help!

Author:  AMueller [ Wed Mar 07, 2007 1:07 am ]
Post subject: 

That was it!!! I uncommented that line and I got by that piece. Thanks for your guys help and patience!

:D

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