Error attaching to database during install

[cheffner]

Have a problem during the installation of the vbulletin software version 2.3 with RedHat Linux 8.0 and MySQL during step 3.

Not sure if everything is working correctly or not. I am new to Linux and therefore am a novice.

I have installed the package for the latest MySQL and have completed the config.php file for the installation.

VBulletin admin/install fails at step 3 when trying to find the database which I call VBulletin. Installation manual states that if database file is not found it will be created but I don't think it is creating the database needed for the installation to precede.

This is the error message:

Attempting to attach to database...

Fatal error: Call to undefined function: mysql_connect() in /data/www/admin/db_mysql.php on line 40




Any help would be greatly appreciated.

Thanks,

[Steve Machol]

PHP is not complied with MySQL support. You'll need to recompile PHP with this support.

[cheffner]

PHP is not complied with MySQL support. You'll need to recompile PHP with this support.


Can you give me the instructions necessary to recompile php for the MySQL support?


Thanks,

[Steve Machol]

I've never compiled PHP manually. I suggest you look for the appropriate documentation on their home page:

http://www.php.net/

Note that PHP may be connected to Apache on Redhat servers. You should also check the Redhat home page.

[cheffner]

I've never compiled PHP manually. I suggest you look for the appropriate documentation on their home page:

http://www.php.net/

Note that PHP may be connected to Apache on Redhat servers. You should also check the Redhat home page.


Went to php.net and check documentation and verified php is installed correctly according to instructions. Also tested php according to instructions on the php.net website.

It still looks like MySQL is not running properly or cannot connect to the vbulletin database.

Anybody have any ideas?

Thanks,

[Steve Machol]

Upload the phpinfo.php file from the 'extras' directory of the zip file to your forums directory. Then post the URL here.

[cheffner]

The file has been copied to the /data/www directory as you requested.

Can be accessed at http://208.229.147.59/phpinfo.php

I am not qualified to know what you are looking for but the information is there that you requested.

Again, any help you can offer would be greatly appreciated.

Thanks again.

[Steve Machol]

Have you checked to see if MySQL is running? If so, then you may need to compile PHP with:

--with-mysql

...instead of:

--with-mysql=shared,/usr

[cheffner]

Steve,

As you might remember you updated the account information for me last week for this version of vbulletin that we are trying to run. As I stated, I am a novice when it comes to Linux and therefore I do not know how to verify if mysql is running correctly or not.

Can you please tell me how to verify the mysql installation and if it is running or not?

Thanks,

[Steve Machol]

Type this at the command line and look for 'mysqld':

ps aux

If you don't see it in any of the processes running, then you need to start MySQL. To do this type this at the command line as root:

/etc/rc.d/init.d/mysql start

[cheffner]

Steve,

Check for the mysql application running and it was not running. I am not sure why it is not automatically starting when the linux is rebooting. I did as you suggested and started the mysql and it is now listed in the ps aux output.

I am still receiving the same error that I started with tonight.

Do you have any other suggestions of what the vbulletin install.php script is looking for?

Thanks for your suggestions and help.

[Steve Machol]

Then try this:

...then you may need to compile PHP with:

--with-mysql

...instead of:

--with-mysql=shared,/usr