Check the permissions of the database directory
(possibly /var/lib/mysql) and the permissions of the
files themselves. Check also as what user is mysqld
running.

ET

--- Jahislove <jahislove@wanadoo.fr> wrote:

> 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"
> 
> <?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);
> ?>
> 
> 
> any idea of the problem?
> is it possible that the ap-php isn't working and i
> must install a 
> php-mysql module?
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com