PhpMyAdmin server not found

Discussion in 'Installation/Configuration' started by jopa123, Oct 14, 2010.

  1. jopa123

    jopa123 New Member

    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
     
    Last edited: Oct 14, 2010
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. jopa123

    jopa123 New Member

    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
     
    Last edited: Oct 14, 2010
  4. jopa123

    jopa123 New Member

    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
     
  5. falko

    falko Super Moderator Howtoforge Staff

    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.
     
  6. jopa123

    jopa123 New Member

    My mistake

    Falko,

    You are correct on the url. That was a typo on my part. I will try altering the hosts file.
     
  7. jopa123

    jopa123 New Member

    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
     
    Last edited: Oct 23, 2010
  8. jopa123

    jopa123 New Member

    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
     
    Last edited: Oct 23, 2010
  9. falko

    falko Super Moderator Howtoforge Staff

    Which distribution do you use? Which guide (URL) did you use to set up the system?
     
  10. jopa123

    jopa123 New Member

  11. jopa123

    jopa123 New Member

    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.
     
  12. falko

    falko Super Moderator Howtoforge Staff

    Well, I'm running out of ideas... :(
     
  13. jopa123

    jopa123 New Member

    Reinstall PhpMyadmin?

    Do you think a reinstall of PHPMyadmin might fix things? Or make more problems?

    I think this is a PHPMyadmin issue alone.
     
  14. jopa123

    jopa123 New Member

    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?
     
  15. jopa123

    jopa123 New Member

    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
     
  16. jopa123

    jopa123 New Member

    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.
     

Share This Page