Re: [cobalt-users] MySQL, PHP, and Apache

[Malcolm McLeary <mmcleary@xxxxxxx>]

Hi Guys,

on 12/2/03 1:42 AM, BSmith@xxxxxxxxxxx wrote:

> Chances is that it is configured in as a static library. (.SO), so you will
> need to look at your PHP.INI file, and see if you see
> 
> ;Extensions
> 
> extension=mysql.so
> 
> If there is a ";" semi colon, remove it, then.
> 
> /etc/rc.d/init.d/httpd restart
> 
> That works on a RaQ, I don't touch Qubes, but it should be the same.

That was a good start ... my simple test page now works and returns;

Resource id #1 

> Also, you will want to look further down in your "PHPINFO()" for something
> that looks like this:
> 
> mysql
> MySQL Support enabled
> Active Persistent Links  0
> Active Links  0  
> Client API version  3.23.54
> MYSQL_MODULE_TYPE  external
> MYSQL_SOCKET  /var/lib/mysql/mysql.sock
> MYSQL_INCLUDE  -I/usr/include/mysql
> MYSQL_LIBS  -L/usr/lib -lmysqlclient
> 
> If you do NOT have it, it won't work.

Further I now find included in phpinfo() the following;

mysql
MySQL Support    enabled
Active Persistent Links    0
Active Links    0
Client API version    3.23.32
MYSQL_MODULE_TYPE    builtin
MYSQL_SOCKET    /var/lib/mysql/mysql.sock
MYSQL_INCLUDE     
MYSQL_LIBS

Is the last two items being empty a serious issue?

on 12/2/03 3:15 AM, Bruce Timberlake wrote:

> I believe the line
> 
> ;extension=mysql.so
> 
> in /etc/httpd/php.ini needs the leading ';' removed (and then reload
> httpd) to actually enable the MySQL functionality.  Go figure why it
> wasn't done from the beginning...
>
> While you're in there, you might want to uncomment the PostgreSQL and
> IMAP options too... :)

That is a question I'm sure will never be answered.  Apache, PHP, and MySQL
are listed as "features" of the Qube3 but obviously PHP support for MySQL
(and PostgreSQL and IMAP for that matter) is not enabled.  If owners are
only supposed to use the GUI for management and then simply upload "data"
how on earth is one supposed to use these listed features if they are
disabled?

What is it they say at M$ ... "its doesn't have to work, it just has to
sell, and having lots of features listed on the box sells a product".

I'm not really complaining ... I'm making progress.  ;-)

My next challenge is to work out MySQL security so I can actually
create/modify tables within my database.

Cheers,  Malcolm