--=-qBOVXp9t/aHlCU3fAweg Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Have you looked in your php.ini file for "mysql". PHP loads a Dynamic Extension for mysql. Mine's at line 242. On Sat, 2003-02-08 at 11:34, mazdaracer wrote: > This was the original beginning when I tried the postnuke install via=20 > the install.php script per postnuke instructions. >=20 > Fatal error: Call to undefined function: mysql_pconnect() in=20 > /var/www/html/postnuke/html/install/newinstall.php on line 36 >=20 > Then I started to run from the command line mysql commands. That's when=20 > I discovered I had some user id problems looking at the main mysql DB. I=20 > was able to get in w/o a password. That finally got resolved, so I went=20 > back to the postnuke install. >=20 > Still getting the same error, so I "up2date php-mysql" (RH8) and it=20 > updated a bunch of stuff. Running phpinfo(), while showing what is in=20 > the dbx section as below, does not show a mysql section. And I still=20 > have the error as shown above. >=20 > Via the command line I'm able to get into the mysql and test DB's and=20 > poke around, so I know mysql is up. php seems to work, but not the DB=20 > connection. >=20 > Beleive it or not, on a previous (Mandrake) installation, I had similar=20 > problems that did get resolved by uninstalling and re-installing php and=20 > mysql, but I don't remember doing apache with that too because webmin=20 > showed php support for the apache module. >=20 > And now when I use webmin to check out the mysql svr, I get a password=20 > prompt as I expect. >=20 > I do apologize to the list for all this! I've been searching the net=20 > like crazy to find others' fixes. >=20 > pete >=20 >=20 > Craig White wrote: > > I have to say that it is difficult to help you when I after many posts, > > I still don't understand what the problem is. > >=20 > > I have to believe that removing & reinstalling apache & php will have > > nothing whatsoever to do with your problem. > >=20 > > when you run the phpinfo test that was suggested...do you get this in > > the dbx section? > >=20 > > dbx > > dbx support enabled > > dbx version 1.0.0 > > supported databases MySQL > > ODBC > > PostgreSQL > > Microsoft SQL Server > > FrontBase > > Oracle 8 (not really) > > Sybase-CT > >=20 > > Craig > >=20 > > On Sat, 2003-02-08 at 10:43, mazdaracer wrote: > >=20 > >>Let's step back a moment. > >>Initially the discovery came when trying to install postnuke and gettin= g=20 > >>the "connect" not defined problem. > >> > >>Wrote a quick test script for phpinfo. (point to 63.231.43.237/test.php= ) > >>No MySQL section per Mr. Young. > >> > >>I then did "up2date php-mysql" and it updated a bunch of stuff. > >> > >>I restarted httpd and mysql. > >> > >>Ran test.php and still no mysql section. > >> > >>And all this after the login issues, which seem to be ok now. > >> > >>I must be missing a step (at least!). Been looking thru "PHP and MySQL=20 > >>Web Development" by Sams for some guidance but it's not much at this st= age. > >> > >>My next inclination is to remove all the php and mysql packages, stop=20 > >>httpd and re-install them from up2date. (RH8 btw) > >>pete > >> > >> > >>Craig White wrote: > >> > >>>Just out of curiousity > >>>What command are your running and what did you expect that you're not > >>>getting? > >>> > >>>Craig > >>> > >>>On Fri, 2003-02-07 at 16:21, mazdaracer wrote: > >>> > >>> > >>>>Getting there! Now I have this installed: > >>>>[pete@rotor installed]$ rpm -qa | grep -i php > >>>>asp2php-0.76.2-3 > >>>>php-odbc-4.2.2-8.0.5 > >>>>php-4.2.2-8.0.5 > >>>>php-mysql-4.2.2-8.0.5 > >>>>php-manual-4.2.2-8.0.5 > >>>>php-imap-4.2.2-8.0.5 > >>>>php-devel-4.2.2-8.0.5 > >>>>php-ldap-4.2.2-8.0.5 > >>>>php-snmp-4.2.2-8.0.5 > >>>>asp2php-gtk-0.76.2-3 > >>>>php-pgsql-4.2.2-8.0.5 > >>>>[pete@rotor installed]$ > >>>> > >>>>I've restarted httpd. Looks like I need to do something else yet to g= et=20 > >>>>php - mysql to talk. phpinfo still doesn't come up with any mysql dat= a. > >>>>pete > >>>> > >>>> > >>>> > >>>> > >>>>mazdaracer wrote: > >>>> > >>>> > >>>>>I thought I had things figured out from the last msg from George. Bu= t=20 > >>>>>when I got back on this morning, I see I can get into the mysql DB=20 > >>>>>without a password as a regular user (me, pete). Also, in webmin, I = can=20 > >>>>>easily see everything too. The password for the DB is different from= my=20 > >>>>>regular root password, but still no prompting. Here's the output fro= m=20 > >>>>>this morning: > >>>>> > >>>>>[pete@rotor pete]$ mysqlshow > >>>>>+-----------+ > >>>>>| Databases | > >>>>>+-----------+ > >>>>>| Phoenix | > >>>>>| mysql | > >>>>>| test | > >>>>>+-----------+ > >>>>>[pete@rotor pete]$ mysql > >>>>>Welcome to the MySQL monitor. Commands end with ; or \g. > >>>>>Your MySQL connection id is 22 to server version: 3.23.55 > >>>>> > >>>>>Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > >>>>> > >>>>>mysql> use Phoenix > >>>>>Database changed > >>>>>mysql> show tables; > >>>>>Empty set (0.00 sec) > >>>>> > >>>>>mysql> use mysql > >>>>>Reading table information for completion of table and column names > >>>>>You can turn off this feature to get a quicker startup with -A > >>>>> > >>>>>Database changed > >>>>>mysql> show tables; > >>>>>+-----------------+ > >>>>>| Tables_in_mysql | > >>>>>+-----------------+ > >>>>>| columns_priv | > >>>>>| db | > >>>>>| func | > >>>>>| host | > >>>>>| tables_priv | > >>>>>| user | > >>>>>+-----------------+ > >>>>>6 rows in set (0.00 sec) > >>>>> > >>>>>mysql> select User,Host,Password from user; > >>>>>+------+--------------------------+------------------+ > >>>>>| User | Host | Password | > >>>>>+------+--------------------------+------------------+ > >>>>>| root | localhost | 77f55a9e14442c8f | > >>>>>| root | rotor.byerlyelectric.com | 77f55a9e14442c8f | > >>>>>+------+--------------------------+------------------+ > >>>>>2 rows in set (0.01 sec) > >>>>> > >>>>>mysql> > >>>>> > >>>>> > >>>>>With only root in the DB I would think I'd be prompted each and ever= y time. > >>>>> > >>>>>pete > >>>> > >>--------------------------------------------------- > >>PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > >>To subscribe, unsubscribe, or to change you mail settings: > >>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > >=20 > >=20 > >=20 > > --------------------------------------------------- > > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > > To subscribe, unsubscribe, or to change you mail settings: > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > >=20 >=20 >=20 > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change you mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --=20 Bryce C CoBryce Communications --=-qBOVXp9t/aHlCU3fAweg Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA+RU/H/wbq/C6yyPcRAitmAJ0Yc0C/sWGFN2YnhP9HZA/zd8yOhgCdEGIj CCtm7s5R32pO90piEBOJ+nE= =8N1/ -----END PGP SIGNATURE----- --=-qBOVXp9t/aHlCU3fAweg--