XP/Mysql Problems

Anon

Hey all. Just upgraded to XP pro on my laptop (which is my development machine.) Anyway, I started get 'page cannot be displayed' in phpmyadmin and on some of the sites I was developing at the time when trying to access mysql. So, I uninstalled everything and re-installed. Same problem. It doesnt happen on any of my other machines. I am assuming that everything is compatible with xp. Here are my verion #'s. I hope someone can help me out with this. Spending $200 on xp pro will really tick me off if I cant even develop on it.

Windows XP Pro
Mysql 3.23.47 (Using mysqld-nt.exe)
Php 4.1.1
Apache 1.3.23
Perl 5.6.1.631(Activestate)

Anon

what does the apache error log say?

Anon

Nothing. The error log has no errors regarding this problem.

zalath

Funny, that. I use a WinXP PRO / Apache 1.3.22, PHP 4.1.1, and mySQL 3.23.47 (mysqld-nt) whis is essentially the same configuration. How do you access your local site (that is, what do you type to the address bar), and what does IE say when you try to access it?

Anon

Well, sometimes it works and sometimes it doesnt. It appears to only happen when database access is part of the equation. For example, phpMyAdmin will bring some stuff up but sometimes when you try to view table information it will just say 'page cannot be displayed' and other times it just keeps trying to load and reload the page until it finally errors off with a 'page cannot be displayed'.

zalath

Hmm. Bizarre. Are you running PHP as a module or CGI? I'm having trouble running it as a module (read: I can't get it to actually execute the scripts), but as CGI it works fine. Also, as I've informed two others already, there's a chance (although you probably know this already) that connecting to the database with a simple mysql_connect(); with no arguments might have some effect - it did on my system.
Your problem appears to be different though.

Sorry I can't be of any more assistance... :/

Anon

Php code executes without a hitch on the system. It has something to do with apache and/or mysql with XP. I have seen the problem elsewhere on this board, but I dont if anyone has any answers yet or not.

Anon

Anyone else have any ideas?

Anon

I've the same problem on XP/Apache but when i'm not working in localhost. I can't see my page on other hosts.
I can't use XP/Apache.. I've tried everything, the same config on a W2K works fine.
My advice, turn on W2K or Linux

Best regards.

zalath

I'm baffled - My configuration differs only on the apache version number - which is 1.3.22 instead of the 1.3.23 . Must be a major change.

Also, I got the PHP working as a module as well (which was a problem before). The only weird thing is that when I load phpinfo() from phpMyAdmin, the page keeps blinking on and off uncontrollably.

...weird... keep trying. I know it can be done.

-L-

Anon

Hmm. I will try downgrading to the previous version of apache. I have tried the 2.0 beta of apache with no avail.

Going to win2k or linux is not an option for this development machine. Its not like I am in a standstill. I can still develop on other machines here using 2k or linux, etc. BUT, I paid $200 bucks for xp to go on my laptop and I need it to work. You know what I mean?

Anyway...lets see what I can do.

Anon

"Microsoft made a new OS and society says I must integrate into my life or suffer consequences, regardless of problems or better solutions available"

do you realize what you are saying?

Anon

I am so tired of explaining my upgrade, but I guess I must. I upgraded because my job required it. I write windows software. I do php/mysql development on the side.

I did not upgrade because microsoft told me to. I upgraded because my boss told me to. Now, do you want to pay my salary? Because I would gladly NOT use xp.

Anon

And now...regarding the real problem at hand:

I downgraded to apache 1.3.22 and the problem persists. Very strange, folks. This doesnt seem to be a problem all across the board...that is what makes it strange. This person has it, this one doesnt.

Lauri, are your versions of mysql and php matching my versions?

zalath

Yes. To the detail.
Say, do you have an internet connection configured on your laptop?

-L-

Anon

What do you mean? I have a network at home and at work. All I do is plug in. No dial-ups. And no internet connection sharing.

zalath

What I mean is do you have an active internet connection while you're testing your system. After I had configured my server it worked fine, but when I got an ADSL line, every time I tried to access http://localhost/ it gave me an error. Now, if I refer to the server as http://127.0.0.1/ (the ip equivalent of localhost), it gives me the same error (page cannot etc.). What I noticed, however, is that the address on the address bar changed to http://localhost/ all by itself - the browser did a lookup from the DNS. Now, the DNS doesn't see <i>my</i> localhost, but it probably sees itself as localhost so it can successfully resolve the ip, but there's no access to the DNS. So I tried to type the 127.0.0.1 on the address bar again, and - voilà.

I have a sneaking suspicion this won't solve your problem, but anything is better than not trying at all, right 😉

-L-

Anon

Nope. That didnt help, but it was worth a shot. 😛

I have found others with a similar problem and I guess it has been reported to apache. I just wish I knew what the problem is, because really I have no clue whether or not its apache or php or mysql. All I know is that it has something to do with xp.

ranam

This is absolutely killing me!! I have spend the last 6 hours trying to figure out why my scripts wont connect to MySQL. I upgraded to WinXP pro. Installed the old apache, php and mysql I was using. Everything worked but simple PHP WONT connect to mysql. I have tried editing every tiny configuration file and setting. PHP simply wont connect and read from the DB. Neither will it give any error that it can't connect. It will return a blank as if now row was there. Accessing from the dos prompt works fine. So I upgraded all my installations Apache 1.3.23, PHP 4.1.1 and MySQL 3.23.47-nt. Still no change. This is absoletely outrageous! I can't work!! And any long page keeps refreshing until I get the error page. I could not connect to the DB using PHP in any way (all of which ofcourse worked before and works on the hosting server)! Even phpMyAdmin won't work. But THE MOST funny thing is that when I downloaded the latest version of phpMyAdmin (phpMyAdmin 2.2.3) it connect to the DB without problem! I am using the same method to connect to the DB as they are:

$db = mysql_connect($SESS_DBHOST, $SESS_DBUSER,$SESS_DBPASS) or die("Could not connect");

but mine won't work! I also tried only
$db = mysql_connect();
and any other combination. It just won't work!

Lauri Kotilainen-> you can't connect to localhost probably because ur using proxy. Go to Internet options->connection->Lan setting and select "Bypass proxy server for local address". That should work.

zalath

I suspect it's not the proxy, but rather the DNS that resolves the 127.0.0.1 to localhost (which is correct, actually).

The $db = mysql_connect($SESS_DBHOST, $SESS_DBUSER,$SESS_DBPASS) or die("Could not connect"); would only work if you had defined the same session variables as phpMyAdmin presumably does, but with your username and password. Of course I'm assuming that's <b>exactly</b> how your code goes. Now, suppose you had defined a user named 'admin' in the MySQL server with the password 'pass', you would naturally call the function: $db = mysql_connect('localhost','admin','pass') rather than use the session variables which you may or may not have defined.

I'll copy-paste you the exact code which connects me to the mysql database on my winxp:

$link = mysql_connect("localhost", "put your username here", "don't forget the password");
if (! $link ) die ("Could not connect: ".mysql_errno()." ".mysql_error());
if (mysql_select_db("database_name" ,$link) == false)
{
die ("Didn't find database");
}