|
Next: Slack Live distro
|
| Author |
Message |
External

Since: Sep 12, 2003 Posts: 4
|
(Msg. 1) Posted: Fri Sep 12, 2003 2:43 am
Post subject: PHP/MySQL problems Archived from groups: alt>os>linux>slackware (more info?)
|
|
|
Hi all, perhaps someone can help me?
I'm running an out-the-box install of Slackware 9, a complete install. I
decided today to upgrade the 3.23 version of MySQL to 4.0 or 4.1 from
slackware-current.
To do this, I used pkgtool to remove the old MySQL.. And installpkg to
install the new one.. I had problems with this (It complained that GLIBC was
missing or something along those lines), so I also installed this.
So, the names of the files I installed from slackware-current are:
glibc-solibs-2.3.2-i486-1.tgz
glibc-zoneinfo-2.3.2-noarch-1.tgz
mysql-4.0.14-i486-1.tgz
Now when I reboot.. I have Apache/PHP running (I can do a "phpinfo();" in
PHP and view it via Apache on a web browser to confirm this), and I have
MySQL running (I can connect fine using "mysql -u root -p" and run queries
fine).
However, PHP and MySQL don't appear to be talking to each other. I can
write PHP code and it'll come out at the other end if you like, but as soon
as I enter a line of PHP that has anything to do with MySQL, I just get
blank pages returned to the browser. I've tried turning on error_reporting,
but still all I get are blank pages.
/var/lib/mysql/<hostname>.err file shows date/time: InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.14' socket: '/var/run/mysql/mysql.sock' port: 3306
.....which I think is all correct, so I'm sure MySQL is definitely running
okay.
This is the first time I've had a go at installing any software (I'm not
100% sure what I've done above to install it is correct), all I've used is
an out-the-box installation of it, so I'm now a bit stuck with what to do.
Before I tried upgrading, everything was fine, so I'm not sure if I've
overwritten a config file somewhere I shouldn't have or what.
Anyone help with this, or give me a nudge in the right direction?
Cheers,
Steve.
PS. If me including any log files would help, please advise which ones! |
|
| Back to top |
|
 |  |
External

Since: Aug 15, 2003 Posts: 15
|
(Msg. 2) Posted: Fri Sep 12, 2003 11:25 am
Post subject: Re: PHP/MySQL problems [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In article <3f612a2a$0$261$cc9e4d1f@news.dial.pipex.com>, It's Me wrote:
> However, PHP and MySQL don't appear to be talking to each other. I can
> write PHP code and it'll come out at the other end if you like, but as soon
> as I enter a line of PHP that has anything to do with MySQL, I just get
> blank pages returned to the browser. I've tried turning on error_reporting,
> but still all I get are blank pages.
What is problaly bitting you in the ass is a new "feature" of the PHP
configuration file.
Nowadays you will have to excplicitly enable mysql support.
In the file /etc/apache/php.ini there is a section like:
; Load the MySQL module by default.
; Comment this out if you don't use MySQL.
extension=mysql.so
(I edited the comment a bit to cope with line breaks)
This entry is problaly commented out or not even there.
- --
You will be Told about it Tomorrow. Go Home and Prepare Thyself.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/YZEKdLi+tUDFQJcRAjAlAKCHywwAtfVpwDoVjUcljYg8GY2WzACcCYd2
BgBDTahlnhBPkoobRjpQCSY=
=N2ZK
-----END PGP SIGNATURE----- |
|
| Back to top |
|
 |  |
External

Since: Sep 12, 2003 Posts: 4
|
(Msg. 3) Posted: Fri Sep 12, 2003 12:33 pm
Post subject: Re: PHP/MySQL problems [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Bilbo wrote:
>>
>> However, PHP and MySQL don't appear to be talking to each other. I
>> can write PHP code and it'll come out at the other end if you like,
>> but as soon as I enter a line of PHP that has anything to do with
>> MySQL, I just get blank pages returned to the browser. I've tried
>> turning on error_reporting, but still all I get are blank pages.
>
> What is problaly bitting you in the ass is a new "feature" of the PHP
> configuration file. Nowadays you will have to excplicitly enable
> mysql support.
>
> In the file /etc/apache/php.ini there is a section like:
>
> ; Load the MySQL module by default.
> ; Comment this out if you don't use MySQL.
> extension=mysql.so
Hi Bilbo,
Thanks for the reply.. I've checked my php.ini and that section is indeed
there, so I'm not sure what to do now. Any other ideas?
I'm not sure this file would've been amended anyway, it's only MySQL I've
reinstalled, not PHP.. So I suspect if it's a configuration issue, it'll be
in one of the MySQL config files. But I can't see where!
Cheers,
Steve. |
|
| Back to top |
|
 |  |
External

Since: Sep 12, 2003 Posts: 4
|
(Msg. 4) Posted: Fri Sep 12, 2003 11:37 pm
Post subject: Re: PHP/MySQL problems [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
It's Me wrote:
> Hi all, perhaps someone can help me?
>
> I'm running an out-the-box install of Slackware 9, a complete
> install. I decided today to upgrade the 3.23 version of MySQL to 4.0
> or 4.1 from slackware-current.
>
> To do this, I used pkgtool to remove the old MySQL.. And installpkg to
> install the new one.. I had problems with this (It complained that
> GLIBC was missing or something along those lines), so I also
> installed this.
>
> So, the names of the files I installed from slackware-current are:
> glibc-solibs-2.3.2-i486-1.tgz
> glibc-zoneinfo-2.3.2-noarch-1.tgz
> mysql-4.0.14-i486-1.tgz
>
> Now when I reboot.. I have Apache/PHP running (I can do a
> "phpinfo();" in PHP and view it via Apache on a web browser to
> confirm this), and I have MySQL running (I can connect fine using
> "mysql -u root -p" and run queries fine).
>
> However, PHP and MySQL don't appear to be talking to each other. I
> can write PHP code and it'll come out at the other end if you like,
> but as soon as I enter a line of PHP that has anything to do with
> MySQL, I just get blank pages returned to the browser. I've tried
> turning on error_reporting, but still all I get are blank pages.
>
> /var/lib/mysql/<hostname>.err file shows date/time: InnoDB: Started
> /usr/libexec/mysqld: ready for connections.
> Version: '4.0.14' socket: '/var/run/mysql/mysql.sock' port: 3306
>
> ....which I think is all correct, so I'm sure MySQL is definitely
> running okay.
>
> This is the first time I've had a go at installing any software (I'm
> not 100% sure what I've done above to install it is correct), all
> I've used is an out-the-box installation of it, so I'm now a bit
> stuck with what to do.
>
> Before I tried upgrading, everything was fine, so I'm not sure if I've
> overwritten a config file somewhere I shouldn't have or what.
In case anyone has a similar problem to this later, I got around this issue
by upgrading my version of Apache as well.
Steve. |
|
| Back to top |
|
 |  |
External

Since: Sep 13, 2003 Posts: 3
|
(Msg. 5) Posted: Sat Sep 13, 2003 2:00 am
Post subject: Re: PHP/MySQL problems [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
On Fri, 12 Sep 2003 02:43:09 +0100, It's Me wrote:
> Hi all, perhaps someone can help me?
>
> I'm running an out-the-box install of Slackware 9, a complete install. I
> decided today to upgrade the 3.23 version of MySQL to 4.0 or 4.1 from
> slackware-current.
>
<snip>
> Now when I reboot.. I have Apache/PHP running (I can do a "phpinfo();" in
> PHP and view it via Apache on a web browser to confirm this), and I have
> MySQL running (I can connect fine using "mysql -u root -p" and run queries
> fine).
>
> However, PHP and MySQL don't appear to be talking to each other. I can
> write PHP code and it'll come out at the other end if you like, but as soon
> as I enter a line of PHP that has anything to do with MySQL, I just get
> blank pages returned to the browser. I've tried turning on error_reporting,
> but still all I get are blank pages.
>
> /var/lib/mysql/<hostname>.err file shows date/time: InnoDB: Started
> /usr/libexec/mysqld: ready for connections.
> Version: '4.0.14' socket: '/var/run/mysql/mysql.sock' port: 3306
>
I may me wrong, but you probably need to rebuild PHP, seeing as the
version shipped is built against version 3.x.x of MySQL.
--
Chuck Hughes
webmaster DeleteThis @DRINKCOKEsugargrove.lib.il.us
http://www.sugargrove.lib.il.us/
I get a warm feeling when I wet myself. |
|
| Back to top |
|
 |  |
External

Since: Sep 12, 2003 Posts: 4
|
(Msg. 6) Posted: Sat Sep 13, 2003 9:32 am
Post subject: Re: PHP/MySQL problems [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Chuck wrote:
> On Fri, 12 Sep 2003 02:43:09 +0100, It's Me wrote:
>
>> Hi all, perhaps someone can help me?
>>
>> I'm running an out-the-box install of Slackware 9, a complete
>> install. I decided today to upgrade the 3.23 version of MySQL to
>> 4.0 or 4.1 from slackware-current.
>>
> <snip>
>> Now when I reboot.. I have Apache/PHP running (I can do a
>> "phpinfo();" in PHP and view it via Apache on a web browser to
>> confirm this), and I have MySQL running (I can connect fine using
>> "mysql -u root -p" and run queries fine).
>>
>> However, PHP and MySQL don't appear to be talking to each other. I
>> can write PHP code and it'll come out at the other end if you like,
>> but as soon as I enter a line of PHP that has anything to do with
>> MySQL, I just get blank pages returned to the browser. I've tried
>> turning on error_reporting, but still all I get are blank pages.
>>
>> /var/lib/mysql/<hostname>.err file shows date/time: InnoDB: Started
>> /usr/libexec/mysqld: ready for connections.
>> Version: '4.0.14' socket: '/var/run/mysql/mysql.sock' port: 3306
>>
> I may me wrong, but you probably need to rebuild PHP, seeing as the
> version shipped is built against version 3.x.x of MySQL.
Hi Chuck,
I did upgrade PHP, but still had the same problem.. The solution appears to
have been to upgrade Apache too.. So altogether I've reinstalled MySQL, PHP
then Apache. All now seems okay (Apart from having to make a couple of
slight changes to config files).. For some reason "apachectl startssl"
doesn't want to work any more so I've changed my rc.httpd script to
"httpd -DSSL".
Steve. |
|
| Back to top |
|
 |  |
External

Since: Sep 13, 2003 Posts: 3
|
(Msg. 7) Posted: Sat Sep 13, 2003 9:32 am
Post subject: Re: PHP/MySQL problems [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
On Sat, 13 Sep 2003 09:32:56 +0100, It's Me wrote:
> Chuck wrote:
<snip>
>> I may me wrong, but you probably need to rebuild PHP, seeing as the
>> version shipped is built against version 3.x.x of MySQL.
Well, at least I wasn't completely wrong.
> Hi Chuck,
>
> I did upgrade PHP, but still had the same problem.. The solution appears to
> have been to upgrade Apache too.. So altogether I've reinstalled MySQL, PHP
> then Apache. All now seems okay (Apart from having to make a couple of
> slight changes to config files).. For some reason "apachectl startssl"
> doesn't want to work any more so I've changed my rc.httpd script to
> "httpd -DSSL".
>
> Steve.
Glad you got it working.
--
Chuck Hughes
webmaster.TakeThisOut@DRINKCOKEsugargrove.lib.il.us
http://www.sugargrove.lib.il.us/
I get a warm feeling when I wet myself. |
|
| Back to top |
|
 |  |
External

Since: Sep 14, 2003 Posts: 1
|
(Msg. 8) Posted: Sun Sep 14, 2003 10:45 am
Post subject: DOSEMU [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
Does anyone have this working?
Mine gives one error line 496 parse error.
The file isn't that long!
GA! |
|
| Back to top |
|
 |  |
External

Since: Aug 15, 2003 Posts: 124
|
(Msg. 9) Posted: Sun Sep 14, 2003 10:45 am
Post subject: Re: DOSEMU [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
In article <pFX8b.9936$8N5.87988410@news-text.cableinet.net>,
Guy Abandon. wrote:
> Does anyone have this working?
Yes.
> Mine gives one error line 496 parse error.
>
> The file isn't that long!
Which file? Dosemu uses several configuration files.
--
/dev/rob0 - preferred_email=i$((28*28+2  )@softhome.net
or put "not-spam" or "/dev/rob0" in Subject header to reply |
|
| Back to top |
|
 |  |
External

Since: Sep 14, 2003 Posts: 11
|
(Msg. 10) Posted: Sun Sep 14, 2003 8:03 pm
Post subject: Re: DOSEMU [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
In article <pFX8b.9936$8N5.87988410@news-text.cableinet.net>, Guy Abandon. wrote:
> Does anyone have this working?
> Mine gives one error line 496 parse error.
> The file isn't that long!
If I remember correctly. (I got it working and never took
notes on how.) did you make sure that globle.conf is in
/var/lib/dosemu and /etc/dosemu/global.conf, I think that I had to
copy it to /var/lib/dosemu to get it working
--
A tagline from Comp.os.Linux.Advocacy:
(I keep hearing RTFM, but I'm not sure where TFM is).
From the Desk of the Sysop of:
Planet Maca's Opus, a Free open BBS system.
Telephone 860-738-7176 300-33.6kbps
Telnet://pinkrose.rivernet.cc. Open 24/7!
The New Cnews maintainer
B'ichela |
|
| Back to top |
|
 |  |
| Related Topics: | MySQL 5.0 vs. 4.1? - Hi, I just have to install a PHP frontend to a database app, which "requires MySQL 4.0 or 4.1". The machine is running Slack 11.0 with MySQL 5.0 on it, and I wonder if this version is backwards-compatible, or if I have to rebuild an older vers...
Postfix and mysql - Anyone here knows how to check whether a postfix 2.x has mysql support build in or not? I'm desperately trying to setup a backup mailserver with mysql for the first time and I have a bug. I am getting to the point where I think that mysql support isn't....
php + apache, broken w/o mysql? - I have apache working. I have php installed. I do not have mysql installed. I uncommented the appropriate lines in /etc/apache/httpd.conf. I verified the contents of /etc/apache/mod_php.conf. Restart apache. Browser still asks me if I would like....
connection refused on mysql from java - I'm having problems connecting from a java program to a mysql database. I am able to connect to the mysql server locally with kmysqladmin. This is a partial stack trace: java.net.SocketException: java.net.ConnectException: Connection refused at....
Path Environment Variable & MySQL startup on boot - I am current setting up MySQL and would like to confirm what I am doing before executing any commands. I have the following two tasks left to complete: 1) Add MySQL to the PATH environment variable. The installation manual states this is done with the.... |
|
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|