php apps not connecting with mysql

rasat · 2003-01-01 06:57:04

I am not getting php applications using mysql, connected to mysql server. Apache, phpMyAdmin (mysql management) and phpSysInfo all work fine. PostNuke connected to mysql, which run fine on other distros, don't connect. Following error appears:
Fatal error: Call to undefined function: mysql_connect() in /home/httpd/html/ami-proto/pnadodb/adodb-mysql.inc.php on line 105

Local address: http://localhost/ami-proto/index.php.
File config.php is:
$pnconfig['dbtype'] = 'mysql';
$pnconfig['dbhost'] = 'localhost';
$pnconfig['dbuname'] = 'root';
$pnconfig['dbpass'] = '';
$pnconfig['dbname'] = 'amidb';
$pnconfig['system'] = '0';
$pnconfig['prefix'] = 'nuke';
$pnconfig['encoded'] = '0';
I am not using password (when running on my own machine).

Arielext · 2003-01-01 15:56:12

rebuild php with mysql support

rasat · 2003-01-02 01:07:34

Arielext wrote:

rebuild php with mysql support

How do you do it with Arch Linux? I already did Apache with php (read thread: http://bbs.archlinux.org/viewtopic.php?t=253) and works fine.

How do you test if php is running with mysql? PhpSysInfo only shows the Apache-php relation.

rasat · 2003-01-02 05:18:38

rasat wrote:

Arielext wrote:
rebuild php with mysql support
How do you do it with Arch Linux?

I found the solution. To run php with mysql, untag "extension=msql.so" in /usr/etc/php.ini. For more information, please read:
http://bbs.archlinux.org/viewtopic.php?t=253

rasat · 2003-01-02 05:49:10

Sorry, I made a typing error. The extension is:
extension=mysql.so (not 'msgl.so')

rasat · 2003-01-05 07:15:32

I came across another reason why PostNuke and other php-mysql apps may not run with mysql, is due to version mysql-3.23.54. If installed with mysgl-3.23.51 or earlier version, it will not run. You must upgrade the database. Most php apps, like PostNuke, PHPnuke, phpMoney and phpBB, have an easy upgrade system.

PS. To install an older mysql version will not work on Arch Linux 0.4.

jlvsimoes · 2003-01-30 01:00:32

i got some trouble to runing this i did uncoment the mysql.so
( question do i did it rigth ? if you chek this out you will see whi i ask
rooty.dhis.org/index.php )
im a complete newbie runing apache php mysql so any help is welcome
on index.php
cannot load MySQL extension,
please check PHP Configuration. ( but i did uncoment mysql.so )
on admin.php
Warning: main(home/httpd/html/includes/sql_layer.php) [function.main]: failed to create stream: No such file or directory in /home/httpd/html/mainfile.php on line 48

Fatal error: main() [function.main]: Failed opening required 'home/httpd/html/includes/sql_layer.php' (include_path='.:/php/includes') in /home/httpd/html/mainfile.php on line 48
( ????? )
on routty.dhis.org/teste.php ( teste is the name in my native language for test )
it looks good

apeiro · 2003-01-30 02:51:30

Did you restart apache?

jlvsimoes · 2003-01-30 11:26:30

shure thing

jlvsimoes · 2004-03-23 01:12:46

this tread is old but there is something bad about php to make stuff work i must rebuid php and remove this --with-mysql=shared,/usr from the pkgbuild and yes stuff work then

Xentac · 2004-03-23 03:04:28

You have to enable mysql in /etc/php.ini (extension=mysql.so). It's not built in because some people may not want to use mysql with php (maybe they're using postgres...).

jlvsimoes · 2004-03-26 00:28:19

i did forget about it and thaks

shadowhand · 2005-10-21 07:10:07

I'm gonna revive a dead horse here (magic ain't it? ) and say that this info NEEDS TO BE SOMEWHERE when php is installed. I just spent the last 20 minutes freaking out because php was saying that "mysql_connect" was an "undefined function".

Arch Linux

#1 2003-01-01 06:57:04

php apps not connecting with mysql

#2 2003-01-01 15:56:12

Re: php apps not connecting with mysql

#3 2003-01-02 01:07:34

Re: php apps not connecting with mysql

#4 2003-01-02 05:18:38

Re: php apps not connecting with mysql

#5 2003-01-02 05:49:10

Re: php apps not connecting with mysql

#6 2003-01-05 07:15:32

Re: php apps not connecting with mysql

#7 2003-01-30 01:00:32

Re: php apps not connecting with mysql

#8 2003-01-30 02:51:30

Re: php apps not connecting with mysql

#9 2003-01-30 11:26:30

Re: php apps not connecting with mysql

#10 2004-03-23 01:12:46

Re: php apps not connecting with mysql

#11 2004-03-23 03:04:28

Re: php apps not connecting with mysql

#12 2004-03-26 00:28:19

Re: php apps not connecting with mysql

#13 2005-10-21 07:10:07

Re: php apps not connecting with mysql

Board footer