NYCPHP Meetup

[P. Fawcett]

tx.

to confirm - so i can have both a mod & standalone cgi (thou i don't
know why i'd want both but the programmers don't seem to know their
environment so i'm just thinking of covering all bases till i get a
handle on it.)

i found that php 4.2.2 if mysql not specified in config, then it's auto
built in

so i've got php working but mysql won't do anything from within the
server including basic #myqladmin version or variable info, returns
w/error: 

"MySQL said: 
Host '204.nnn.nnn.nn' is not allowed to connect to this MySQL server"

& docs point to 'make sure mysqld running- it is, & /tmp/msql-4socket
exists -it does, so something else w/access prblm so i have to find
mysql talk & maybe they'll know something

Analysis & Solutions wrote:
> 
> Hey P:
> 
> On Wed, Oct 09, 2002 at 11:35:40AM -0400, P. Fawcett wrote:
> >
> > 1)  if i have php, mysql & perl installed on the sys, do i have to
> > include them in the other configs. ie configuring php --with-mysql?
> 
> Yes.  That gives PHP the ability to talk to MySQL.  It makes PHP be
> compiled with the MySQL functions.
> 
> > configuring apache --with-perl
> 
> This enables the apache/perl module.  It speeds things up.  Either way,
> you can still call Perl scripts as standalone CGIs.
> 
> > am i right mod's, ie mod_php is just a lighter version of php
> > & not necessary if i have php 4.2.2 installed?
> 
> Similarly, mod_php installs the apache/perl module, which speeds up
> execution.  If you install PHP separately, you can then also execute PHP
> scripts in CGI mode.
> 
> In both cases, CGI mode would have the script execute as the owner of the
> script while the module versions execute as the Apache process.
> 
> > but mysql would fail after config on: mysqladmin -u root -password
> > "new-passwd"
> > err: mysqladmin: connect to server at 'localhost'failed error: 'can't
> > connect to local mysql server thru socket '/tmp/mysql.sock'(2).  check
> > that mysqld is running & that socket exists.  well it wasn't & it didn't
> 
> I run MySQL on Windows NT, so am not completely familliar with installing
> it on linux, but I believe you need to install MySQL as normal.  Then
> start the daemon by issuing a "mysqld" command.
> 
> > so i reconfig mysql with simplier 3.23.52 rpm, which would run thru the
> > config ok, create the socket, start the daemon, but would populates
> > files all over the sys and not create /usr/local/mysql dir, so without
> > php config --with-mysql (no path) php would fail syntax in the
> > hpptd.conf:
> > LoadModule php4_module libexec/libphp4.so - "cannot load
> > /usr/local/apache/libexec/libphp4.so into server:libmysqlclient.so".
> 
> Find where the files are created and set your my.conf and/or other
> configuration files/commands appropriately.
> 
> --Dan
> 
> --
>                PHP classes that make web design easier
>         SQL Solution  |   Layout Solution   |  Form Solution
>     sqlsolution.info  | layoutsolution.info |  formsolution.info
>  T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
>  4015 7 Av #4AJ, Brooklyn NY     v: 718-854-0335     f: 718-854-0409
> 
> --- Unsubscribe at http://nyphp.org/list ---