I am trying to setup and restore a PHPLD directory database. I created a site, created the database (and user), but when I click on the little db icon to the right of the database - the rollover says "http://examplesite.com/:8088/sites/database_phpmyadmin.php?id=2"- I get the Firefox default Server not found Firefox can't find the server at server1.example.com. BTW, My port is set to 8088 to stop conflicts with my router, and in this case I am logging in as a customer by going to examplesite.com:8088, if that matters Thanks for any insight
Please set the correct URL to your phpmyadmin installation in ispconfig under system > interface config. The URL is normally something like: http://123.123.123.123/phpmyadmin without a port and use the IP and not the server URL.
Do I use an internal or external ip? Neither seems to work. When I change the ip in interface config, log out, log back in as customer, the icon (left of the wrench) rollover still shows the external ip and port (http://68.113.x.x:8088/sites/database_phpmyadmin.php?id=6) no matter which Ip I entered into the interface config. And clicking gives a timeout or server not found error. Do I need to restart the system after entering the changes (throwback to Windows). Am I attempting to get to PHPMyAdmin incorrectly? I have deleted and recreated the db each time I changed the ip address. ** new info: Even though the rollover shows the URL above, when I have the internal IP in interface config, the bottom of the browser bar says "connecting to 192.168.1...." before timing out. Thanks
More info Still having issues with this. I may have a little more info. I checked my /etc/hosts files and see this: 127.0.0.1 localhost.localdomain localhost 127.0.1.1 server1.example.com server1 Shouldn't that second line have something else? 192.168.1.x or something? Thanks
The URL looks wrong to me - should be http://examplesite.com:8088/sites/database_phpmyadmin.php?id=2 instead of http://examplesite.com/:8088/sites/database_phpmyadmin.php?id=2. You can try that.
My mistake Falko, You are correct on the url. That was a typo on my part. I will try altering the hosts file.
Still no luck Any other ideas? I'm stumped. But then that's not hard. Can you tell me where to look to investigate the problem? A PhpMyAdmin config file somewhere? I looked in /etc/dbconfig-common/phpmyadmin.conf and can't see anything that might help Thanks
Maybe an idea When I looked in /etc/dbconfig-common/phpmyadmin.conf it has dbc_user='phpmyadmin' But in /usr/local/ispconfig/server/lib/mysql_clientdb.conf it shows a clientbd_user = 'root' Could this be the issue? Thanks
Ubuntu 9.04 Ubuntu 9.04 and ISPConfig3 The Perfect Server - Ubuntu 9.04 [ISPConfig 3] http://www.howtoforge.com/perfect-server-ubuntu-9.04-ispconfig-3
Any ideas? I haven't heard a response in a while. I really don't want to start over if I can help it. Thanks.
Reinstall PhpMyadmin? Do you think a reinstall of PHPMyadmin might fix things? Or make more problems? I think this is a PHPMyadmin issue alone.
Another possible clue When I go to http://123.123.123.123/phpmyadmin (external ip address) I get a 404 error. When I go to just: http://123.123.123.123/ I get the home page of a website, actually the only website, that I set up through ISPConfig. Should it not be some sort of default ISPconfig page on the ip?
Perhaps one more clue Sorry for the multiple posts. I restarted Apache and got this: [warn] NameVirtualHost 192.168.1.26:443 has no VirtualHosts
Have I stumped the experts? I don't know whether to be proud or ashamed. I really don't want to start from scratch if I can help it. I can't understand how I could have screwed this up seeing as how I copied and pasted the majority of it. Here may be one more clue. I walked through the setup (http://www.howtoforge.com/perfect-server-ubuntu-9.04-ispconfig-3-p4) visually and came across the line on page 4 where it says to run netstat -tap | grep mysql The results are supposed to look like this: tcp 0 0 *:mysql *:* LISTEN 8474/mysqld Mine looks similar except for the last segment: tcp 0 0 *:mysql *:* LISTEN - Does that spark any ideas? I really do appreciate the time you guys put in here.