Fixing my MySQL/PhpMyadmin

Discussion in 'Installation/Configuration' started by jeeva, Feb 8, 2010.

  1. jeeva

    jeeva New Member

    Hi

    Currently running Fedora 11. Initially I used my dedicated server only for a SeedBox (with MySQL, Lighttpd:81, Torrentflux, php, etc, PsyBNC, Eggdrop) but recently I installed ISPconfig 3 (from the HowToForge guide Fedora + ISPConfig 3.0.1.6) above all of these.

    The control panel etc is working, http://domain.com:8080/ (everything default settings), but when I create a database and try to access it via the webgui shortcut link from ISPConfig > Sites > Database:

    http://domain.com/sites/database_phpmyadmin.php?id=3

    it forwards to http://domain.com/phpmyadmin

    Code:
    Forbidden
    
    You don't have permission to access /phpmyadmin on this server.
    
    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
    Apache/2.2.13 (Fedora) Server at
    When I manual type a different database number [where 3 was, now 1] (which doesn't exist)
    http://domain.com/sites/database_phpmyadmin.php?id=1

    Code:
    No DB-Server found!
    if that is any clue.

    I'm unable to login into my torrentflux control panel, so from what I gather my SQL settings changed somewhere if someone can please help me out and trying to get to fix it without having to reinstall my box.
     
  2. till

    till Super Moderator

    Please post the exact error message from the apache error log.
     
  3. jeeva

    jeeva New Member

    /var/log/httpd/error-log

    Code:
    [Sun Feb 07 03:30:16 2010] [notice] Digest: generating secret for digest authentication ...
    [Sun Feb 07 03:30:16 2010] [notice] Digest: done
    [Sun Feb 07 03:30:17 2010] [notice] Apache/2.2.13 (Unix) DAV/2 PHP/5.2.12 mod_scgi/1.13 configured -- resuming normal operations
    [Sun Feb 07 15:14:54 2010] [error] [client 222.186.25.125] File does not exist: /usr/local/ispconfig/interface/web/R.asp
    [Sun Feb 07 15:18:16 2010] [error] [client 222.186.25.125] File does not exist: /usr/local/ispconfig/interface/web/R.asp
    [Mon Feb 08 02:06:02 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:06:26 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:06:43 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:06:48 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:06:51 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:07:05 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:07:08 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:07:11 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:07:13 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:07:15 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:07:25 2010] [error] [client 196.209.195.87] PHP Notice:  Undefined variable: wb in /usr/local/ispconfig/interface/lib/app.inc$
    [Mon Feb 08 02:08:18 2010] [error] [client 196.209.195.87] client denied by server configuration: /usr/share/phpMyAdmin
    [Mon Feb 08 02:08:19 2010] [error] [client 196.209.195.87] File does not exist: /usr/local/ispconfig/interface/web/favicon.ico
    [Mon Feb 08 02:08:19 2010] [error] [client 196.209.195.87] File does not exist: /usr/local/ispconfig/interface/web/favicon.ico
    [Mon Feb 08 02:08:22 2010] [error] [client 196.209.195.87] File does not exist: /usr/local/ispconfig/interface/web/favicon.ico
    [Mon Feb 08 02:16:38 2010] [notice] caught SIGTERM, shutting down
    [Mon Feb 08 02:16:42 2010] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
    [Mon Feb 08 02:16:42 2010] [notice] Digest: generating secret for digest authentication ...
    [Mon Feb 08 02:16:42 2010] [notice] Digest: done
    [Mon Feb 08 02:16:42 2010] [notice] Apache/2.2.13 (Unix) DAV/2 PHP/5.2.12 mod_scgi/1.13 configured -- resuming normal operations
    [Mon Feb 08 02:17:33 2010] [error] [client 196.209.195.87] client denied by server configuration: /usr/share/phpMyAdmin
    [Mon Feb 08 02:19:06 2010] [notice] caught SIGTERM, shutting down
    [Mon Feb 08 02:19:07 2010] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
    [Mon Feb 08 02:19:07 2010] [notice] Digest: generating secret for digest authentication ...
    [Mon Feb 08 02:19:07 2010] [notice] Digest: done
    [Mon Feb 08 02:19:07 2010] [notice] Apache/2.2.13 (Unix) DAV/2 PHP/5.2.12 mod_scgi/1.13 configured -- resuming normal operations
    
     
  4. digital-cipher

    digital-cipher New Member

  5. jeeva

    jeeva New Member

  6. till

    till Super Moderator

    Add the lines:

    <Directory /usr/share/phpMyAdmin>
    Order allow,deny
    Allow from all
    </Directory>

    at the end of the file 000-ispconfig.conf file in the sites-anabled folder of your apache configuration and then restart apache.
     
  7. jeeva

    jeeva New Member

    Thanks for the help, last part worked. Forgot about the case sensitivity.
     

Share This Page