Jump to content
The Uniform Server Community

phpMyAdmin Fails under US3.5


twp
 Share

Recommended Posts

I'm unable to run phpMyAdmin in a NEWLY INSTALLED COPY of Uniform

Server 3.5 (Apollo) under Win XP. No other changes to the installed

code, no website yet in the www folder and no user data.

 

I get an "access denied" error through Firefox and a message window

that says the following

---------

Welcome to phpMyAdmin 2.10.2

Error

MySQL said: ?

#2003 - Can't connect to MySQL server on 'localhost' (10061)

---------

 

From reading messages on the US message forum, I have tried the

following:

 

1) Fresh install from latest download of US3.5 zip file and/or the

.exe file.

 

2) Checked for previous versions of Uniform Server and for

MySQL/Apache. I found a copy of mysqld-opt.exe running a process (

found with Win XP taskmanager). I ended this process.

 

3) I ran the Stop.bat file from all three versions of Uniform Server

(I have them all on my laptop). NOTE: the mysqld-opt.exe process IS

NOT removed or ended by the Stop batch files...

 

4) From a cold boot of Windows, A fresh installation of US3.5 from the

zip file, Running Server_Start.bat to start US3.5, I found the

following processes running (Win XP Taskmanager reports):

------

Apache.exe (one instance, about 3508+Kb)

Apache.exe (second instance, about 700kb)

mysqld-opt.exe (one instance,1.144kb)

uniserv.exe (one instance, 28kb)

------

 

5) I DID NOT change the default usernames/passwords for anything. All

are set to root.

 

6) I've installed THREE different websites, one of which uses a MySQL

database (it fails to open since it needs username/passwords and I

cannot edit it's database with phpMyAdmin...), This site works under

US3.3 and US3.2a. The OTHER two sites work correctly (no database

needed), under US3.5.

 

7) I've checked for php cookies, found none, but I did run the

Stop.bat file and closed the Firefox tabs (and ended Firefox also).

According to suggestions on the board, this should have removed php's

cookie that may cause this problem... It doesn't fix the phpMyAdmin

failure.

 

8) I've installed virtual hosts (which work under US3.3 and US3.2a).

 

The Windows Hosts file contains these additional lines:

--------

127.0.0.1 localhost #localhost:80

127.0.0.1 www.twpdev.com #TWP Marketing Development Center

127.0.0.1 www.gadgetsforgold.com #GadgetsForGold.com

127.0.0.1 www.twpmarketing.com #TWP Marketing.com

127.0.0.1 www.stopbrite.com #Stopbrite.com (dead)

--------

These virtual hosts are correctly reported on the US3.5 Admin Virtual

Hosts page.

 

These same Virtual Hosts are declared in the Apache httpd.conf file as

follows:

------

NameVirtualHost *

<VirtualHost *>

ServerName localhost:80

DocumentRoot /www

</VirtualHost>

##########VIRTUAL HOST SETUP##########

# TWP Marketing Development Directory

<VirtualHost *>

ServerName www.twpdev.com

DocumentRoot /www/twpdev

</VirtualHost>

 

##########VIRTUAL HOST SETUP##########

# www.GadgetsfForGold.com

<VirtualHost *>

ServerName www.gadgetsforgold.com

DocumentRoot /www/gfg

</VirtualHost>

 

##########VIRTUAL HOST SETUP##########

# www.twpmarketing.com

<VirtualHost *>

ServerName www.twpmarketing.com

DocumentRoot /www/twp

</VirtualHost>

 

##########VIRTUAL HOST SETUP##########

# www.stopbrite.com

<VirtualHost *>

ServerName www.stopbrite.com

DocumentRoot /www/sb

</VirtualHost>

------

 

I'm open to suggestions about what may be causing this problem.

Link to comment
Share on other sites

I found 7 instances of this DLL on my hardrive.

 

All are in the usr\local\php folder of an installation of Uniform Server(3.2a, 3.3 or 3.5) or in the zipped master copy.

 

NO copies of this DLL are found the Windows SYSTEM or SYSTEM32 folders...

 

I've copied all my US installations to a USB drive and deleted all of it from my harddrive. I'll re-install US3.5 fresh and see if it makes any difference...

 

Update: The cleanout and reinstall did not solve the problem. The same error is posted (see top of my first message). Any other suggestions about what could cause it?

Thanks

Link to comment
Share on other sites

Do you use 3Ds MaX?

 

and you said you can see mysqld-opt.exe in the Task Manager? no errors where given at startup?

 

No, I don't use 3Ds MaX. This runs on a Dell Latitude CP with neomagic's video processor.

 

There are no errors on startup, BUT, I must start with nothing else running or php scripts will timeout (30 seconds limit in php.ini). It only times-out if I have something else running, forcing too much disk swapping to cache. I solved this problem earlier by changing the script limit to 300 seconds in php.ini. NOTE: I did not change the script timeout limit on the new install of US3.5...

Link to comment
Share on other sites

hmm.. ok.. lets try this.. start the server with Server_Start.bat

 

Go to Task Manager and kill mysqld-opt.exe if you see it.

 

Start MySQL again from the Admin Panel... Do you get an error?

Link to comment
Share on other sites

Sorry for the delay in replying. Your suggestion (quoted below) worked, I am running under US3.5 now.

Apparently an earlier version of MySQL was starting by default an was not being removed by the stop.bat file from Version 3.5. I have removed earlier versions of US from my system and the problem does not reoccur.

Thanks for your help Olajide!

 

hmm.. ok.. lets try this.. start the server with Server_Start.bat

 

Go to Task Manager and kill mysqld-opt.exe if you see it.

 

Start MySQL again from the Admin Panel... Do you get an error?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...