[FGS] Problem Connection to MySQL

[Guillaume Dallaire]

Hi,


On Thu, 2006-06-01 at 06:03 +0100, Mazlan Man wrote:
> Hi,
> 
> I've just installed the fgs-mapserver base package 
> fgs-mapserver_phpmapscript_4.8.2-1.2-linux-i386.bin 
> and also installed the php_mysql-module 4.4.2
> 
> Then I did fgs stop and fgs start
> 
> I've restarted apache.
> 
> after phpinfo i get this...it seems my newly installed
> module was not loaded
> 
> Configure Command 	 './configure'
> '--with-regex=system'
> '--with-freetype-dir=/home/users/gdallaire/fgs-dev/built/freetype'
> '--with-dbase'
> '--prefix=/home/users/gdallaire/fgs-dev/built/php'
> '--with-mysql=shared,/home/users/gdallaire/fgs-dev/built/mysql-standard-4.1.14-pc-linux-gnu-i686'
> ...etc...
> 
> so when run my php script to connect mysql i get this
> 
> Call to undefined function: mysql_connect() in
> /home/mazlan/fgs/www/htdocs/testbed/Connections/TestBed.php
> on line 9
> 
> 
> Then I found a "SOLUTION" that require us to add this
> into php.ini and restart fgs (fgs stop fgs start)
> 
> extension=mysql.so
> 
> but the problem remain the same ....found that the
> newly added line suddenly missing...it seems that
> apache regenerate the php.ini
> 

You should modify the php.ini.template file.

There are some comments about this in the header of the php.ini file,
but it's easy to not see it. The installer could give some warning about
that (when you install the mysql module). Added in the TODO list.


Guillaume

-- 
________________________________________________
 Guillaume DALLAIRE      gdallaire at mapgears.com
      Mapgears              www.mapgears.com
________________________________________________