Sorry , i don't understand what you mean :

i installed php with a NetBSD package:
# cd /usr/pkgsrc/www/ap-php
# ls -l
drwxr-xr-x  2 root  wheel  512 Mar  2 19:08 CVS
-rw-r--r--  1 root  wheel  368 Nov  4  2004 DESCR
-rw-r--r--  1 root  wheel  821 Mar 30  2005 MESSAGE
-rw-r--r--  1 root  wheel  909 Feb  5 23:11 Makefile
-rw-r--r--  1 root  wheel  108 Nov  4  2004 PLIST
# make install clean

and i have no idea where to remove --without-mysql and where to add the ./configure...

[EMAIL PROTECTED] a écrit :
remove --without-mysql:

You need to explicitly enable mysql like this:

./configure
--with-apxs2=/usr/local/apache-2.2.0/bin/apxs'
--prefix=/usr/local/php-5.1.2'
--with-mysql=shared,/downloads/mysql/bin/mysql-standard-5.0.18-linux-i686'
--with-mysqli=shared,/downloads/mysql/bin/mysql-standard-5.0.18-linux-i686/bin/mysql_config'
--with-mysql-sock=/var/lib/mysql/mysql.sock'
--with-mhash'
--enable-shared=yes'
--enable-all=shared'

and anything else you want to compile php with.

Alter the paths to suite your environment.

Keith


In theory, theory and practice are the same;
in practice they are not.

To unsubscribe from this list, please see detailed instructions already posted at:

http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2

On Wed, 22 Mar 2006, Jahislove wrote:

To: php-install@lists.php.net
From: Jahislove <[EMAIL PROTECTED]>
Subject: [PHP-INSTALL] can't access mysql from a php script

hello all ,

i am under NetBSD 3.0
and i have installed apache/php/mysql as described on this wiki
http://wiki.onetbsd.org/index.php/How_to_install_a_LAMP_Server

/usr/pkgsrc/www/apache2
/usr/pkgsrc/databases/mysql5-server
/usr/pkgsrc/www/ap-php      (Installing the PHP Module for Apache)

apache work fine
php work fine
mysql work fine

but it seem that i can't access database from a php script

this little script (test.php) return only "test1" and not "test2" without any error

<?php
$host = "localhost";
$login = "compteur";
$password = "xxxxxx";
$database = "compteur";
$table = "nb_connect";

echo "test1";

$db = mysql_connect($host, $login, $password)
or die("Impossible de se connecter : ".mysql_error());

echo "test2";

mysql_select_db($database,$db);

mysql_query("INSERT INTO $table VALUES('','blabla','30')")
or die("error : ".mysql_error());

$update = mysql_insert_id();
mysql_close($db);
?>


a phpinfo() return :
Configure Command        './configure' '--without-mysql' '--without-iconv'
'--disable-posix' '--with-config-file-path=/usr/pkg/etc'
'--with-exec-dir=/usr/pkg/libexec/php4' '--with-regex=system'
'--enable-memory-limit' '--enable-track-vars' '--enable-ipv6'
'--with-openssl=/usr' '--with-apxs2=/usr/pkg/sbin/apxs'
'--prefix=/usr/pkg' '--host=mipsel--netbsd' '--mandir=/usr/pkg/man'

any idea of the problem?
is it possible that the problem  come from '--without-mysql'  ?
and so how can i install that?

Reply via email to