more MySQL issues
Bryce C
plug-discuss@lists.plug.phoenix.az.us
08 Feb 2003 11:43:20 -0700
--=-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 <Plug@BryceCo.Net>
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--