ArchLinux and phpmyadmin

veranyon · 2009-12-25 12:31:16

phpmyadmin is one that have troubles everything. opensuse, ubuntu etc..

No matter how many times I did not install this package - it did not work. Either the 404 error or Access denied - and always offered some crutches to it.

I put this package six months ago on one of the machines with archlinux and hadn't problems. Just put everything right and everything. And again - error 404.

People. What has changed and what to do, if it's not a secret.

Thanks

kermana · 2009-12-25 19:44:43

Hi,

Even tough I am no expert, I think you should check a couple of things:

first make sure you include the httpd-phpmyadmin.conf in httpd.conf with
Include conf/extra/httpd-phpmyadmin.conf

Second, check httpd-phpmyadmin.conf and see what the alias looks like, it should have something like Alias /phpmyadmin/ "/usr/share/webapps/phpMyAdmin/". As in this example, I have to the type the "phpmyadmin" in lowercase (in firefox) to get there or I get a 404 error just like yours.

Also, if I remember correctly I had to go to /usr/share/webapps/phpMyAdmin and modify .htaccess file. DId you check the wiki for phpmyadmin by the way? if not http://wiki.archlinux.org/index.php/PhpMyAdmin seems like its quite complete.

Edit: just saw your other post, as the Alias section shows, your phpMyAdmin should be in /usr/share/webapps/phpMyAdmin. Also, as far as I know locate command does not show the newly created files. You have to do a "updatedb" before you use locate to update the file database and phpMyAdmin files should show up then.

Edit 2: Also just remembered that you have to modify php.ini too check the wiki.

Last edited by kermana (2009-12-25 20:31:11)

veranyon · 2009-12-26 00:32:27

Hi
It's strange. I don't oppose but I rembmer that I din't change that manipulation. about http://wiki.archlinux.org/index.php/PhpMyAdmin

Thanks. All're ok and It's working.

mar77i · 2009-12-26 19:56:18

Hi

Well, nope. I'll double check what I have done to proof that my problem isn't coming from negligence here...
My problem, more precisely, is that I don't get access to /usr/share/webapps/phpMyAdmin/index.php through http://localhost/phpmyadmin/index.php- The 403 error persists despite the following measures:

* I've tested the directory rights, which are recusively +x for everyone up to the root dir (looked that with ls -ld /; ls -ld /usr; ls -ld /usr/share etc.).
* Applying chmod 777 on the file didn't help (undid that after testing it). I expect owner/group == root:root to be okay, we'll be looking at phpmyadmin config files later.
* My setup includes apache, php5, some php5-* modules, mod_fcgid from AUR (php5 and mysql are working, a Drupal is running on http://localhost/*)
* I have set up phpmyadmin from community; following the Wiki based on which I have checked the following pointers:

- The directory phpmyadmin exists in the httpd configuration only
- The 403 error proves that the /etc/httpd/conf/extra/httpd-phpmyadmin.conf[1] file is included in httpd.conf (the file is provided at the end of this post)
- No old installation is present, the 403-ing Alias, as provided in [1], is not visible from apache's directory index
  + without it the error is 404 - Object not found.
- Removed /usr/share/webapps/phpMyAdmin/phpmyadmin/.htaccess
- Removed the trailing slash, so the 403 error comes for [url]http://localhost/phpmyadmin[/url], too
- added the paths to open_basedir, as it's no longer necessary according to [url]http://wiki.archlinux.org/index.php/LAMP#PHP[/url]
- ...softlink doesn't make sense if

Despite all efforts, I get an "Access forbidden" message from the httpd server. Normally, I solve stuff like that in no time at all, today I seem to be too dumb for it.

Files:
[1]: /etc/httpd/conf/extra/httpd-phpmyadmin.conf

#
# Provide access to phpmyadmin
#
Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin/"
<Directory "/usr/share/webapps/phpMyAdmin">
AllowOverride All
Options FollowSymlinks
Order allow,deny
Allow from all
</Directory>

Last edited by mar77i (2009-12-26 22:22:14)

kermana · 2009-12-26 20:23:19

can you also try with /phpmyadmin/index.php. I might be very off but if index.php is not set as directory index and you try to access with directory name you might get a 403 (if apache is set to not allow directory listing). I remember I had some troubles installing it too. Its usually some small thing we miss. It can get really annoying

Last edited by kermana (2009-12-26 20:25:51)

mar77i · 2009-12-26 20:45:22

Oh I thought I made that clear with "php5 and mysql are working from wiki". Since I haven't posted my http.conf, you weren't able to check that, but the Wiki had mentioned that, too. Yeah, I've been playing around with that already before mod_rewrite was running, and it's not the issue.

Last edited by mar77i (2009-12-26 20:46:02)

kermana · 2009-12-27 00:01:45

opps my bad sorry all out of ideas ... do you see anything useful in the apache logs ?

Edit: and on a side note, I believe LAMP wiki page may be outdated. It says "Instead, add your document root as follows (this is the default):" that used to be ok since phpmyadmin was installed in /srv/http/ in older versions ... since it has moved to /usr/share/webapps/ I am pretty sure we need to add the webapps folder into php.ini. I changed my open_basedir back to default and my installation broke, changed back and everything was back to normal. We might need some clarification on this.

Last edited by kermana (2009-12-27 00:33:08)

Arch Linux

#1 2009-12-25 12:31:16

ArchLinux and phpmyadmin

#2 2009-12-25 19:44:43

Re: ArchLinux and phpmyadmin

#3 2009-12-26 00:32:27

Re: ArchLinux and phpmyadmin

#4 2009-12-26 19:56:18

Re: ArchLinux and phpmyadmin

#5 2009-12-26 20:23:19

Re: ArchLinux and phpmyadmin

#6 2009-12-26 20:45:22

Re: ArchLinux and phpmyadmin

#7 2009-12-27 00:01:45

Re: ArchLinux and phpmyadmin

Board footer