• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 654
  • Last Modified:

Apache/Zend PHP Server/MySQL connection problems -- Which application holds the solution?

I'm setting up a dyanmic web development environment using GoLive, the Zend Studio (IDE and PHP Server), and Navicat.  I've already installed Apache 2.0.58, PHP/5.1.2, MySQL 5.0.2.   The problem is my applications aren't talking to each other and I don't understand the interrelationships enough to fix it!

-------------------Navicat/MySQL--------------------------

I'm having a bit of trouble managing my connections and users.  I've created an additional user so I won't have to login through 'root'.  My goal is to have one master admin user that can access all the connections and privilages without exposing the root but I can't seem to make this happen.  At this point I've got two Users, 'root' and 'admin', and admin has has access to only two of four items (schema and something else; don't remember which - away from my desk at the moment)
--------------------------------------------------------------
Do I need one connection per user?  One connection for all users?  Do I need increase the number of 'connections' or 'users possible' in Apache, or can it all be done in MySQL/Navicat?


---------------------Zend/MySQL---------------------------

I'm trying to establish a connection between Zend and a blank database.  In the SQL Connection screen I'm prompted to add a 'server Alias' but I don't remember ever setting up one.  Besides that issue, I'm using the same username and password that exist as part of my MySQL database connection.  I know the password is and I'm using the username for the 'root' DB connection, so the I believe the problem must be in the Alias setting.  
---------------------------------------------------------------
Is the 'Alias' setting controlled through Apache, the Zend Studio PHP Server, or somewhere in MySQL?  Whichever is correct, how to I set it up properly?


---------------------------------------------------------------


I'm under the gun on this one.  I need to have a working Dev Environment so I can complete an assignment that is already late.  Therefore, I'm giving an answer to this question the maximum value.  Help!
0
JaeWebb
Asked:
JaeWebb
  • 5
  • 3
  • 2
1 Solution
 
gheistCommented:
Do you run any particular operating system?
0
 
JaeWebbAuthor Commented:
My OS: Windows XP Media Addition
0
 
gheistCommented:
Builtin firewall cripples localhost connections on MS Desktop systems.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
JaeWebbAuthor Commented:
I've used this system to connect to a MySQL database before.  The difference is that previously my connection was built with Dreamweaver instead of Zend.  Another difference is I've uninstalled and reinstalled both MySQL and Apache; I don't know if that matters, but my set up worked before then and now it doesn't.

Does anyone else have any suggestions?
0
 
JaeWebbAuthor Commented:
I can't believe there is no one here that has a clue on what's going wrong with my set-up.  Is there no "Expert" on this subject available?  Did I post in the wrong section?  What's wrong here?!

I hate to sound snippy about it but I joined this site as a premium member specifically to get help with this issue (and another issue posted in Apache).  It has been a few days since I signed up already.  If I can't get this issue fixed here, and quickly, then I'm wasting my time.  There is no reason for me to be a paid member here otherwise.

Hopefully one of the folks in charge can clue me in on whether my expectations here are too high.  Is there something I should be doing to make my posts on this site more popular?  Is it worth it to stick it out when you are late getting a response or when a solution isn't immediately available?  Should I just chalk this up as lost time and try some other help-site?  

I'm dying here.
0
 
kamermansCommented:
Using Zend PHP Server + MySQL + GoLive + Niavicat (whatever that is) on XP is certainly not a common task - I peronally use WAMP Server (http://www.wampserver.com/en/).  This software package is made for Windows XP and includes PHP 5.1.3 + PECL, MySQL 5.0.21, phpMyAdmin, Apache 2.0.55, SQLitemanager.  This package has very little configuration and installed the major services as Windows services and provides a nice tray icon to monitor/manage them from.  This isn't fixing your problem but I thought you might be interested.
0
 
kamermansCommented:
Ok - Navicat is a glorified query browser for MySQL - got it.  Are you able to connect to the MySQL server with Navicat under the username 'root'?  It wasn't clear to me in your post.

As far as the connections question is concerned, you cannot have one user that can access all the connections per say.  Each connection should be connecting you to a different MySQL Server.  I just installed it and tested it to determine this.  In your case it sounds like you want only one connection - localhost.  Then you need to connect as 'root' to setup the users on that connection - what you're really doing is  setting up users on that server.  You can give the users priviledges relative to the database on that server, the client's IP, specific tables, or even columns on a table.

Check out this file: http://support.navicat.com/index.php?_a=downloads&_m=get&_i=54 (navicat user management help file)

I will look into Zend PHP Server now - let me know if you still need help with Navicat.
0
 
kamermansCommented:
I've been looking into your Zend question but I'm not sure what you mean.  You mentioned Apache a couple time - I'm assuming you use that as your webserver.  Before you try to use Zend to speed up you PHP and get better reports, you should try to get the standard Apache-PHP module and PHP-MySQL module working - these are what make everything work in the backend.  Are you familiar with the phpinfo.php file? and if so can you post your output for us?  This will tell us if PHP knows how to talk to MySQL.  It is important to note that you can develop everything in the Zend IDE without having the Zend ?Server? installed.

Can you be more specific about which Zend product you're having trouble making a connection to MySQL in?  (ie. the IDE aka Studio, Platform, Core, etc...).

I need to get some sleep but I will check this post tomorrow!
0
 
JaeWebbAuthor Commented:
Thank you for stopping by.  I have hope again!

After trying XAMPP with Eclipse and failing to get all the result I wanted, I thought it would be best to avoide pre-configured packages.  I've had so much trouble this way that I'm willing to try anything.  I will probably end up uninstalling Apache and MySQL and reinstalling them as a WAMP configuration now that I"ve had a chance to check it out.

You left quite a bit of information for me that I need to review more closely before commenting.  I've got to go to work now but I will respond after I get back to my night job (this stuff) at about 5pm PST.  I'll try and work this issue out before moving to WAMP.
0
 
JaeWebbAuthor Commented:
Thanks for your help, kamermans.  You've already earned the points on this one.

I uninstalled all that other stuff in favor of a new WAMP installation.  I already purchased Zend Studio 5.1.0 Professional (w/out Zend Studio Server) so I still have it available.  I'm getting rid of Navicat since most of it's functionality is already present in the forementioned applications.

Now that I'm using phpMyAdmin I have figured out the relationship between all the WAPM applications and Zend.  Your comment about getting the "standard Apache-PHP module and PHP-MySQL module working" drove the point home for me.  Connection between them hasn't been verified yet but I'm sure it won't be a problem.  

Thanks for the solution.

0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now