PDA

View Full Version : phpmyadmin not found


toux
28th September 2010, 14:21
Hello all!

I have a trouble in other server with ispconfig 3.0.2

Whem I click on Db access on the control panel show "Not found" when I try to access as root typing main Ip of the server /phpmyadmin show not found too.

What can be the problem? Thank you very much!

juan_g
29th September 2010, 01:15
Do you have the line:

Alias /phpmyadmin /usr/share/phpmyadmin

in:

/etc/apache2/conf.d/phpmyadmin.conf
/etc/phpmyadmin/apache.conf

?

Did you follow a tutorial to install ISPConfig? For what Linux distribution: Ubuntu, Debian...?

toux
30th September 2010, 13:01
Hello Juan

Yes I have both published this alias on both files.

I don know what is happened.

/etc/apache2/conf.d/phpmyadmin.conf
/etc/phpmyadmin/apache.conf

I checked but....

I use Debian 5.0 Lenny, yes i follow the steps for install like this tutorial, but for install 3.0.1 and after I update to 3.0.2

Thanl you for your reply ;-)

juan_g
1st October 2010, 00:41
With the alias, and if http://[IP number] or http://example.com works, then http://[IP number]/phpmyadmin or http://example.com/phpmyadmin should work, or also a workaround (http://howtoforge.org/forums/showthread.php?p=239299#post239299) I used on a previous installation.

When the URL works, you can enter it in:

System -> Interface Config -> Sites -> phpMyAdmin URL

and it will work in:

Sites -> Database -> linked icon for each database

tef
1st October 2010, 17:11
Same problem there
i followed the step by step ubuntu 10.04 guide.

/etc/apache2/conf.d/phpmyadmin.conf
this file doesn't exists.

I've created with alias directive (allow etc are not allowed) is it fine?

falko
1st October 2010, 17:38
What are the outputs of updatedb
locate phpmyadmin.conf
and ls -la /etc/apache2/conf.d/?

tef
1st October 2010, 18:11
What are the outputs of updatedb
locate phpmyadmin.conf
and ls -la /etc/apache2/conf.d/?

/etc/apache2/conf.d/phpmyadmin.conf (i've added phpmyadmin in this folder before i don't know why he doesnt exists)
/etc/dbconfig-common/phpmyadmin.conf
/var/lib/dpkg/info/phpmyadmin.conffiles
/var/lib/dpkg/info/phpmyadmin.config
/var/lib/ucf/cache/:etc:dbconfig-common:phpmyadmin.conf


drwxr-xr-x 2 root root 4096 2010-10-01 16:02 .
drwxr-xr-x 7 root root 4096 2010-10-01 12:58 ..
-rw-r--r-- 1 root root 237 2010-08-19 05:22 apache2-doc
-rw-r--r-- 1 root root 269 2010-08-19 07:19 charset
lrwxrwxrwx 1 root root 45 2010-10-01 12:59 javascript-common.conf -> /etc/javascript-common/javascript-common.conf
-rw-r--r-- 1 root root 3296 2010-08-19 07:19 localized-error-pages
-rw-r--r-- 1 root root 161 2010-10-01 15:03 phpmyadmin.conf
-rw-r--r-- 1 root root 1481 2010-08-19 07:19 security

toux
2nd October 2010, 02:40
Hello Falko

Mine is

cdn1:/usr/share/phpmyadmin# locate phpmyadmin.conf
/etc/apache2/conf.d/phpmyadmin.conf
/var/lib/dpkg/info/phpmyadmin.conffiles
/var/lib/dpkg/info/phpmyadmin.config


And

cdn1:/usr/share/phpmyadmin# ls -la /etc/apache2/conf.d/
total 24
drwxr-xr-x 2 root root 4096 2010-10-02 01:28 .
drwxr-xr-x 8 root root 4096 2010-10-01 17:58 ..
-rw-r--r-- 1 root root 237 2009-07-14 22:05 apache2-doc
-rw-r--r-- 1 root root 269 2009-07-14 22:00 charset
lrwxrwxrwx 1 root root 28 2010-07-01 20:54 phpmyadmin.conf -> ../../phpmyadmin/apache.conf
-rw-r--r-- 1 root root 1464 2009-07-14 22:00 security
-rw-r--r-- 1 root root 1253 2009-08-25 17:29 squirrelmail.conf


Thank you!

David

falko
2nd October 2010, 14:48
/etc/apache2/conf.d/phpmyadmin.conf (i've added phpmyadmin in this folder before i don't know why he doesnt exists)How did you create the file? What's in it?

/etc/dbconfig-common/phpmyadmin.conf
What's in this file? Maybe we can use it for the Apache configuration.

falko
2nd October 2010, 14:49
cdn1:/usr/share/phpmyadmin# locate phpmyadmin.conf
/etc/apache2/conf.d/phpmyadmin.conf
What's in /etc/apache2/conf.d/phpmyadmin.conf?

toux
2nd October 2010, 15:14
Hello Falko thank you for your reply

This is the content of the file

# phpMyAdmin default Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
DirectoryIndex index.php
AddHandler fcgid-script .php .php3 .php4 .php5

FCGIWrapper /var/www/php-fcgi-scripts/web5/.php-fcgi-starter .php
Options +ExecCGI Indexes FollowSymLinks
AllowOverride all
Order allow,deny
Allow from all

# Authorize for setup
<Files setup.php>
# For Apache 1.3 and 2.0
<IfModule mod_auth.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
# For Apache 2.2
<IfModule mod_authn_file.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
Require valid-user
</Files>
<IfModule mod_php4.c>
AddType application/x-httpd-php .php
FCGIWrapper /var/www/php-fcgi-scripts/web5/.php-fcgi-starter .php
php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
<IfModule mod_php5.c>
AddType application/x-httpd-php .php
FCGIWrapper /var/www/php-fcgi-scripts/web5/.php-fcgi-starter .php
php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
</Directory>


<IfModule mod_rewrite.c>
<IfModule mod_ssl.c>
<Location /phpmyadmin>
RewriteEngine on

falko
3rd October 2010, 13:58
Can you make a backup of your current phpmyadmin.conf and use this instead?

# phpMyAdmin default Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
Options Indexes FollowSymLinks
DirectoryIndex index.php

# Authorize for setup
<Files setup.php>
# For Apache 1.3 and 2.0
<IfModule mod_auth.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
# For Apache 2.2
<IfModule mod_authn_file.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
Require valid-user
</Files>
<IfModule mod_php4.c>
AddType application/x-httpd-php .php

php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
<IfModule mod_php5.c>
AddType application/x-httpd-php .php

php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</IfModule>
AuthType Basic
AuthName "Members Only"
AuthUserFile /usr/share/phpmyadmin/.htpasswd
<limit GET PUT POST>
require valid-user
</limit>
</Directory>

toux
3rd October 2010, 16:24
Hello Falko

Thank you for your reply.

Now I backup the old file and save the new, I try and nothing, but i change on interface config i write on phpmyadmin url phpmyadmin and try to acces by

https://server-ip:8080/phpmyadmin

And show this:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

EDIT:

I try enter by the control panel selecting the database and:

https://Server-ip:8080/sites/phpmyadmin

and show: Not Found

The requested URL /sites/phpmyadmin was not found on this server.

Thank you

toux
5th October 2010, 04:59
Please any idea to fix it?

I have some scripts without control panel and i must access trought phpmyadmin for manage the sites, and is very important but i have not idea what can be the problem :(

Thank you and greetens!

tef
5th October 2010, 10:26
I think that the falco's configuration is for an url like

http://serverip/phpmyadmin
and not with ispconfig apache port.

my file was only like this:

#
# Web application to manage MySQL
#
Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin


i will try ur suggestione

tef
5th October 2010, 10:36
I've tryed ur suggestion.
which user and password phpmyadmin try to read?

toux
5th October 2010, 14:58
Hi Tef,

thank you for your reply.

I try write this alias but nothing...

Y try with ssl certificacte, ispconfig port, without, all! but only i can see, the server missconfiguration with :8080/phpmyadmin and show a password and user, but not with phpmyadmin index.php.

I write the root data login and after show the internal server error

Thank you!

tef
5th October 2010, 15:42
same to me.
with the falco's script i can't get access

toux
5th October 2010, 16:21
Hi Tef, I found a solution try this:

Go to :/var/www/ispconfig/sites/database_phpmyadmin.php

The last if replace for this code:

if($global_config['phpmyadmin_url'] != '') {
header('Location:'.$global_config['phpmyadmin_url']);
} else {
isset($_SERVER['HTTPS'])? $http = 'https' : $http = 'http';
header('location:/phpmyadmin');
}
exit;
?>

===========================================
After put the original phpconfig.conf on:

/etc/apache2/conf.d/phpmyadmin.conf

If you need the original file please say to me.

and after them restart apache:

/etc/init.d/apache2 restart


For me work, I hope can work for you, if not i see on other forums, that if you try reconfigure phpmyadmin can be solved, but first try this better ;)

Greetens!

tef
6th October 2010, 10:20
Hi, thanks.

This solve https problems or general problem for phpmyadmin?


Yes i need the original.

Now i'm really lost in this modifications.
Why can't i return on default setting? phphmyadmin must run on same port of ispconfig? like myservername:8080/phpmyadmin?

After ispconfig istallation i can't let phpmyadmin works. i solved adding a non existent file to the folder, and then phpmyadmin starts to work on normal path like a normal site. (not ispconfig port)
This was incorrect right?