phpmyadmin 2.80 available

[empoweri]

http://www.phpmyadmin.net/home_page/downloads.php?relnotes=0

I haven't tried it yet.

Knowing their program I would wait a few releases before upgrading. ;-)

[Chrysalis]

this is needed upgrade if you use php 5.1.x

[floris]

You can't just drop in the 2.7.0 config.inc.php and continue working as if nothing happened... i'm not sure yet what changes are required in that file to make 2.8.0 work again.

Error "Access denied" directly after opening the phpmyadmin page.

Floris

[Oddis]

I had the same experience, so I tried the free upgrade part in JTbox and everything work okay

JTbox (http://www.directadmin.com/forum/showthread.php?threadid=9046&highlight=JTbox)

[Chrysalis]

2.8.0 no longer has a dist config file it assumes defaults unless you insert config changes. So the phpmyadmin upgrade script many have been using will no longer work.

[floris]

Yea, that's it. I was using that upgrade script i found on this forum. By the way: the upgrade script that DA delivers does work (doh!)

Floris

[empoweri]

Like I said.. Wait until they make it stable :-)

[markus]

Hi!

I have upgraded to PMA 2.8.0.1 (yes, there is such a thing released) as usual, but the part related to the custom config... in regards to that, instead of modifying the file I just created a file named config.inc.php in the PMA root directory, with the following contents:


<?php

/* Servers configuration */
$i = 0;

/* Server localhost (http) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = true;
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';

/* End of servers configuration */

$cfg['PmaNoRelation_DisableWarning'] = true;
?>

No problems so far. ;)

[Chrysalis]

Originally posted by empoweri
Like I said.. Wait until they make it stable :-)

this isnt a beta or RC it is a actual release. But has no security fixes over the latest 2.7 so isnt an essential upgrade if you use php 4.x.

[hehachris]

look, this is how my pma looks like starting from 2.7
i should downgrade to 2.6.4-pl4

[Chrysalis]

or you could fix the config, your mysql also out of date dude.

[empoweri]

Originally posted by Chrysalis
this isnt a beta or RC it is a actual release. But has no security fixes over the latest 2.7 so isnt an essential upgrade if you use php 4.x.

Yes just because it's 'released' doesn't mean it's stable and/or secure.

[jjma]

Originally posted by hehachris
look, this is how my pma looks like starting from 2.7
i should downgrade to 2.6.4-pl4

I have the same problem and have used the config.inc.php submitted from markus but still no style on the phpmyadmin?

Jon

[jw00dy]

Your PMA probably looks that way because you are using it over an SSL connection. I have the same problem, but if I use a non-ssl connection it shows with the tables etc, as it should.

I'm not sure how to fix it either, but I'm sure it relates to the SSL connection since it works fine over non-ssl :confused:

[jjma]

But ssl is the default setup for DA so has something changed since the introdction of 2.7. Can someone help with this using a ssl connection?

Jon

[jjma]

Anyone?

Jon

[Chrysalis]

jjma have you read the changelog yet?

[jjma]

Yes and posted that I have tried the config.inc.php file. Somehow with a bit of noodling I have managed to get it up and running so thanks all the same.

Jon

[jw00dy]

Can you share what you did to get it working with SSL?

[jjma]

I spoke to early. I was looking at a cached session and when I opened phpmyadmin again it's back to the unstyled shape. ::mad:

Jon

[markus]

This is what I did.

#
# Set the version of PMA we're about to install
#
VERSION=2.8.0

#
# Goto the documents root of the server
#
cd /var/www/html

#
# Download PMA from sf.net (use mirror of choice)
#
wget http://internap.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-${VERSION}.tar.gz

#
# Untar into phpMyAdmin-${VERSION}
#
tar xzf phpMyAdmin-${VERSION}.tar.gz
rm -f phpMyAdmin-${VERSION}.tar.gz

#
# Create custom config (see previous post)
#
vi phpMyAdmin-${VERSION}/config.inc.php

#
# Adjust file/dir permissions and ownership
#
find phpMyAdmin-$VERSION -type f -exec chmod 640 {} \;
find phpMyAdmin-$VERSION -type d -exec chmod 750 {} \;
chown -R apache:apache phpMyAdmin-$VERSION

#
# Redo the phpMyAdmin link
#
rm -f phpMyAdmin
ln -s phpMyAdmin-$VERSION phpMyAdmin

# cleanup
unset VERSION


Then, open the browser and clear all cookies related to the domain where PMA is installed. Remeber to do this between tries, in case something goes wrong with the installation.

Finally, point the browser to:
https://www.example.com/phpMyAdmin

[markus]

Originally posted by jjma
I spoke to early. I was looking at a cached session and when I opened phpmyadmin again it's back to the unstyled shape. ::mad:

Jon

Maybe a browser cache issue? Have you tried reloading PM with Ctrl+F5, or clearing the cache, closing the browser and opening it again?

[markus]

Here's a tip to use a "dynamic textarea resizer" with phpMyAdmin.

http://forums.phpmix.org/viewtopic.php?t=1064

[jjma]

Originally posted by markus
Maybe a browser cache issue? Have you tried reloading PM with Ctrl+F5, or clearing the cache, closing the browser and opening it again?

Nope it is not a cache issue. I still get the broken stylesheet. Tried the mod_gzip fix by adding

mod_gzip_item_exclude file \.css.php$

to mod_gzip so that IE ignores the stylesheet.

Strange as non ssl works.

Jon

[jjma]

As a follow up to this it appears that the css fails only when logged in via ssl.

Jon

[nobaloney]

Do you have code in both public_html and in private_html? If so you have to make any changes in both directories.

Jeff

[jw00dy]

the files are located in /var/www/html/phpmyadmin so their isn't a pub and priv dir's like their is under user dirs.

[Chrysalis]

I think I can confirm this problem, although I have just been putting up with it.

[jjma]

Originally posted by jlasman
Do you have code in both public_html and in private_html? If so you have to make any changes in both directories.

Jeff

The default install for da is /var/www/html/phpmyadmin which can be both.

I can also confirm that friefox 1.5 has no issues with stylesheets showing properly over ssl connections.

Jon

[nobaloney]

I didn't think of that. :eek: .

Jeff

[Aspegic]

It may be a good idea to rename phpMyAdmin into something else.

In the past few month I've seen many scans like this in my logfiles:


24.26.20.41 - - [26/Mar/2006:10:01:51 +0200] "GET /phpmyadmin/main.php HTTP/1.0" 401 2463 "-" "-"
24.26.20.41 - - [26/Mar/2006:10:01:56 +0200] "GET /PMA/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:00 +0200] "GET /mysql/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:04 +0200] "GET /admin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:08 +0200] "GET /db/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:12 +0200] "GET /dbadmin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:16 +0200] "GET /web/phpMyAdmin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:20 +0200] "GET /admin/pma/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:25 +0200] "GET /admin/phpmyadmin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:30 +0200] "GET /admin/mysql/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:34 +0200] "GET /phpmyadmin2/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:40 +0200] "GET /mysqladmin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:44 +0200] "GET /mysql-admin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:48 +0200] "GET /main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:52 +0200] "GET /phpMyAdmin-2.5.6/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:02:56 +0200] "GET /phpMyAdmin-2.5.4/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:00 +0200] "GET /phpMyAdmin-2.5.1/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:04 +0200] "GET /phpMyAdmin-2.2.3/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:08 +0200] "GET /phpMyAdmin-2.2.6/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:13 +0200] "GET /myadmin/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:18 +0200] "GET /phpMyAdmin-2.6.0/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:22 +0200] "GET /phpMyAdmin-2.6.0-pl1/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:28 +0200] "GET /phpMyAdmin-2.6.3-pl1/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:33 +0200] "GET /phpMyAdmin-2.6.3/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:38 +0200] "GET /phpMyAdmin-2.6.3-rc1/main.php HTTP/1.0" 404 - "-" "-"
24.26.20.41 - - [26/Mar/2006:10:03:43 +0200] "GET /phpMyAdmin-2.6.2-rc1/main.php HTTP/1.0" 404 - "-" "-"

Aparently hackers are actively searching for phpMyAdmin versions which have known vulnerabilites.

Even if you update phpMyAdmin regularly there is always the possibility that a hacker will exploit a vulnerability before you had a chance to upgrade. To make it a bit harder for the hacker to find phpMyAdmin on your server you may want to rename it into something else.

To do this, rename the install folder of phpMyAdmin in /var/www/html into something they won't guess easily. Then delete the phpMyAdmin symbolic link in /var/www/html and create a new one with a different name (pointing to the renamed install folder).

To make sure that phpMyAdmin is still accessible from the DA controlpanel you'll have to modify the file db.html in the "user/db" folder of each skin (for example the file db.html for the 'default' skin is located in /usr/local/directadmin/data/skins/default/user/db). For the 'enhanced' skin you'll also have to edit: user/show_domain.html
Note: if you upgrade DirectAdmin these files will be overwritten with the default one so you'll probably want to make a copy of the skin under a different name and assign that skin to your users).

The last thing you need to do is edit httpd.conf (in /etc/httpd/conf) and modify the phpMyAdmin aliases to reflect the new name you've chosen.

[Maniak]

It's for sure a bug from IE.

Add to your gzip module:
mod_gzip_item_exclude file .php$

This goes in the way of the post of jjma.

[jjma]

This work around still doesn't work in https mode. It also negates all your php files from using mod_gzip which should be considered if you have alot of busy forums on your server, php sites, etc.

Jon

[ovsoft]

i upgraded to pma 2.8 but now it has very big charachters... how can I fix?

[dennisc]

cd /var/www/html/phpMyAdmin
perl -pi -e 's/body\ {/body\ {\n\ \ \ \ font-size:\ 80%;/g' themes/original/css/theme_left.css.php
perl -pi -e 's/body\ {/body\ {\n\ \ \ \ font-size:\ 80%;/g' themes/original/css/theme_right.css.php

[jjma]

Anyone have the latest version working with internet explorer v 6 in https mode without the stylesheet breaking?

Jon

[@how@]

Originally posted by jjma
Anyone have the latest version working with internet explorer v 6 in https mode without the stylesheet breaking?

Jon

yes work fine phpMyAdmin - 2.8.0.3
tested with explorer v 6
:)

[jw00dy]

Originally posted by jjma
Anyone have the latest version working with internet explorer v 6 in https mode without the stylesheet breaking?

Jon
If you are on the latest version of DirectAdmin just run /usr/local/directadmin/scripts/phpMyAdmin.sh

I upgraded with it to version 2.8.0.3 and the CSS style sheet is working well via ssh.

[jjma]

Thanks for the tip. Now have a working phpmyadmin in ie6 over https.

Jon

[Chrysalis]

not sure what that script does but I tried it out of coriousity on my test fbsd box and the previous working phpmyadmin now gives this in error log :)

[Tue May 16 01:03:36 2006] [error] PHP Warning: main(./libraries/common.lib.php): failed to open stream: Permission denied in /var/www/html/phpMyAdmin-2.8.0.3/index.php on line 36
[Tue May 16 01:03:36 2006] [error] PHP Fatal error: main(): Failed opening required './libraries/common.lib.php' (include_path='.:/usr/local/lib/php') in /var/www/html/phpMyAdmin-2.8.0.3/index.php on line 36
[Tue May 16 01:03:41 2006] [error] PHP Warning: main(./libraries/common.lib.php): failed to open stream: Permission denied in /var/www/html/phpMyAdmin-2.8.0.3/index.php on line 36
[Tue May 16 01:03:41 2006] [error] PHP Fatal error: main(): Failed opening required './libraries/common.lib.php' (include_path='.:/usr/local/lib/php') in /var/www/html/phpMyAdmin-2.8.0.3/index.php on line 36
[Tue May 16 01:03:48 2006] [error] PHP Warning: main(./libraries/common.lib.php): failed to open stream: Permission denied in /var/www/html/phpMyAdmin-2.8.0.3/index.php on line 36
[Tue May 16 01:03:48 2006] [error] PHP Fatal error: main(): Failed opening required './libraries/common.lib.php' (include_path='.:/usr/local/lib/php') in /var/www/html/phpMyAdmin-2.8.0.3/index.php on line 36

I chowned the phpmyadmin dir to apache:apache and it then worked fine.

In the script is the following lines.

chown -f -R root ${PMADIR};
if [ "$OS" = "FreeBSD" ]; then
chgrp -f -R wheel ${PMADIR};
else
chgrp -f -R root ${PMADIR};
fi
chmod -f 755 ${PMADIR};

The subdirs under /var/www/html/phpmyadmin are not world readable by default at least on my server and so without the owner or group set to apache I can see why the error occured.

[Oddis]

phpMyAdmin v 2.8.1 released.
Bug fixes + fix for a new vulnerability:
XSRF vulnerabilities

[jw00dy]

Thanks for the notification.

[sullise]

To fix the CSS issues....

in /phpMyAdmin/lang/english-iso-8859-1.inc.php add:

PHP]$font_size = '10pt';[/PHP]

and replace the $right_font_family with the same fonts as $left_font_family if you wish.

Next, in /phpMyAdmin/themes/original/css/theme_right_css.php, add to the body class:


font-size: <?php echo $GLOBALS['font_size']; ?>;

Then right after the body class, add:


table, tr, th, td {
font-size: <?php echo $GLOBALS['font_size']; ?>;
font-family: <?php echo $GLOBALS['right_font_family']; ?>;
}



Optionally, change the .value class to :



.value {
font-family: verdana, arial, helvetica, geneva, sans-serif;
}

This should make it more appealing and simular to the 2.7.0-pl2 version.

[Freak]

Hi,
im not a real linux guy...
im using phpMyAdmin - 2.8.2.4 with MySQL - 4.1.12-standard

on a directadmin Server Version 1.32.2 with Fedora 4

i want to upgrade all software on the server... including mysql and phpmyadmin.

ok starting with PMA...

what are the risks for updating from 2.8.2.4 to 'the newwest stable'
and how do i do that ?

[smtalk]

No risk :) And you can downgrade phpMyAdmin anytime if you want.

[Freak]

so im not gonna loos any data.. or some thing...

and HOW do i upgrade?
have any tutorial?

[smtalk]

Read CustomBuild FAQ.

[Freak]

Read CustomBuild FAQ. = http://www.directadmin.com/forum/showthread.php?t=19221