php and mysql

lives4him06

i had an apache server, mysql, and php all set up and configured nicley on my linux box.

i recently reinstalled php.

since then all sessions are messed up.. they are never recognized to exist. and everytime i go to create a new table in the database (via either php or mysql itself) an error comes up saying

could not create 'table name'.frm

whats going on?

Norman_Graham

I know this is a stupid question, but you did configure PHP with mysql support when you re-installed it?

Norm

lives4him06

i might of missed that. I didnt remember doing it the first time. I need to configure php with mysql as well as gd2 (graphics library). Whats the syntax to do both of those?

Norman_Graham

The best method is to do ./configure --help and check the list of options. They can vary depending on the PHP version. However, it's usually just --with-mysql, but you might need to specify the path to your MySQL installation, i.e. --with-mysql=/path/to/my/mysql/installation

HTH

Norm

tsinka

Hi,

the error message

could not create 'table name'.frm

is a hint that php has mysql support at all because that error message rather comes from the MySQL database. Please check the directory permissions of the MySQL database directory (something like /path/to/mysql/var or /var/lib/mysql). Make sure that the MySQL user has write permissions on that directory.

Regarding the sessions:

Make sure that the session.save_path configuration variable in php.ini points to a valid and writable directory and that the session settings are the same as with the previous PHP installation. Did you replace php.ini with a new one ?

Thomas