We've put together a RPM to install phpMyAdmin2.3.3pl1 on Ensim 3.1.x (3.1.1.31 et al).

Installation is simply a matter of updating the RPM. The download (and instructions) are at:

http://messages.cheetachat.com/viewtopic.php?t=2505

Sounds painless

Thanks for another great howto

rpm works like a charm, i tested it for gpan on a few boxes before this thread post and i love it.

great job with the RPM's gpan, keep them coming

Laugh we both posted about the same thing literally at the same time but please read what i wrote. Have you tested the adding and removing of privilages when using this version? http://forum.rackshack.net/showthread.php?...&threadid=15304

Iv tryed to recreat this problem in the rpm install for phpMyAdmin that gpan provides and was unable to do so.

Not with gpan's rpm!

The link above is for mysql update, not the phpmyadmin rpm. was that the wrong link?

Fixed.

Thanks gpan! works and looks cool as well Also, the link on your forum needs to be fixed

from:
http://www.colours.us/phpMyAdmin-2.3.3pl1-...-1.1ct.i386.rpm

to:

http://www.colours.us/phpMyAdmin-2.3.3pl1-...-1.1ct.i386.rpm

Thanks again - Mike

thanks again worked easy as can be.

Worked ok. No probs at all.

Thanks for the RPM files.

Worked great! Thanks again.

this version looks so much better!

to install an rpm is this the correct command?

rpm <*filename*>

Cajun

Nevermind. Found it....

rpm -Uvh <*filename*>.rpm

Cajun

Thank you very much gpan. Works like a charm!

SPECS:
Ensim 3.11.41 Apache updates
RH7.2
P4 1.7Ghz

it worked like a charm but I got this message.

warning: /var/www/html/phpMyAdmin-2.2.0/config.inc.php saved as /var/www/html/phpMyAdmin-2.2.0/config.inc.php.rpmsave

is that bad? how bad is that? OH MY GAWD! it's bad isn't it?

please tell me it's not that bad and doesn't matter.

Tone

Thats not bad at all ... basically it told you it backed up your existing file to .rpmsave so you can use it to go back to your original configuration if there is any problems ...

Wow - these are fun... lets see, whats next

Thanks cpan!

Wow! You are da man!

Why dont you open a paypal account for donations? I am sure many people would like to compensate you.

Thanks Ed.. and thank you gpan for all these great rpms.

Tone

WOW! What a HUGE difference that made...

great job... now - is there still no way to be able to allow user multiple DBs?

Tone

Thanks for this one.
Maybee I'm blind, but how do I reach this from the web??

Thanks for answering dumb questions!

Happy New Year.

After installing:

http://ipaddress/MyAdmin/ will display the new one (same as original ensim)

Thanks for quick answer!

I tought of this but it was not working for me.
As I noticed now there seems to be another prob with my server cause it doesn't answer anymore

Last what I saw was about 10 to 15 tomcat 4 / Java Processes runing with 200MB each (according to webmin).

Now it's dead

Hiya, I sent you mail

I installed the phpMyAdmin 2.3.3.pl1 using this How-to, and everything was working great!

Yesterday, I went to create a database, and the phpMyAdmin login shows up, but when I click Login all I get is a blank page! I set the $cfg['OBGzip'] = FALSE; as stated in the Documentation.html file, and it didn't help.

I'd like to get this working again ASAP!

Have you changed your hostname since?. If you have, edit the index.php page in /var/www/html/MyAdmin/ to reflect the correct IP. You may need to do this for indexsite.php also

I'm looking in the index.php right now, and not seeing anywhere where it has a set value for my IP or Hostname ?

Seems that the line extension=mysql.so was somehow removed from my php.ini.
I backup all files like that that I edit (Soas to make an easy restore), in comparing them, I noticed that line wasn't in the latest php.ini, so I copied and pasted it into the new one.

Logged into phpMyAdmin multiple times now with no problem!

Hi,

I just upgraded my 3.1.0 box to 3.1.3-4,
so I'm wondering of there's any risk in upgrading phpmyadmin
on the box.

I notice this how to is for 3.1.x esp 3.1.1-31
Does it work on ensim 3.1.3-4 ?

Works the same on 3.1.3x

I couldn't login with the cookie login, although thats probably me, i prefer the http auth box.

To make it use the http auth box do the following

pico -w /var/www/html/MyAdmin/config.inc.php

press ctrl+w type auth_type and press enter

You will brought to a line like this:

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?

Change it to

$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?


Thanks,
James Mitchell

Awesome rpm! Thanks, gpan!

Any way to allow for secure (https) login?

I believe you could just change the redirect in index.php and indexsite.php to use https rather than http

I got the following error when opening the root db:




Also, is there someway to modify the default left frame size so that it opens about 60 pixels wider? The dropdown menu is hidden "slightly" - I know I can drag the frame wider ... but some of my clients are apt to be confused.

Thanks in advance ...

Some will, some wont ... oknext

Interestingly, I just upgraded the MYSQL phpMyAdmin utility using this rpm. But I can no longer access it via the GUI.

I get this error:

Forbidden
You don't have permission to access /MyAdmin/index.php on this server.

I had access before the upgrade.

Any idea?

Thanks.

Did you restart apache after installing it?

Yes, I did. I restarted apache and even rebooted at some point.

I just checked in my /var/www/html directory and I have the impression that the upgrade may not have happened correctly.

I have two MyAdmin folders in there:

The old one: phpMyAdmin-2.2.0 (permissions drwxr-sr-x 2 apache apache)

The new one: phpMyAdmin-2.3.3pl1 (permissions drwx------ 6 root root )

Then, there is a symlink: MyAdmin -> /var/www/html/phpMyAdmin-2.3.3pl1. (Permissions lrwxrwxrwx 1 apache apache)

I assume that there is both an upgrade issue and a permissions issue.

So, what should I do here?

Thanks.

OK. I suppose it was a permissions issue.

For some reason, the permissions were not allocated correctly. I tried looking at the setup in a different server, so now it seems accessible.


An important question: How come the link to phpMyAdmin is not using SSL in Ensim? I want to be able to get in there in SSL environment, but the link does not support this. How can I change this link so it can use SSL?

Thanks.

Ensim didn't set it up to use SSL; you could probably just access it via https://ip/MyAdmin/ though

I just installed the rpm, and now phpMyAdmin access is no longer secure. Accessing at...

https://IPAddress/MyAdmin

does not work. Any further clicks redirect back to non-SSL pages.

Any thoughts?
Skadar

I upgraded to the rpm, restarted apache, and it was working fine. Now however I log in and just get a blank page. One interesting thing is when I goto the login page the username is already filled in for me. Should I try switching to http authentication?

I'm new with Ensim, so bear with me. On a fresh Ensim 3.1.3 install I installed this new phpMyAdmin rpm.

I set up a site: mysite.com
with user: Bubba
A mySQL database is automatically created: mysite_com

Bubba goes to administer the database:
http://IPAddress/MyAdmin

He logs in with: Bubba : password
(Bubba@mysite.com does not work)

Upon entering phpMyAdmin, Bubba sees the "create database" field pre-filled with "mysite?com". Bubba does not have the right to create a new database, but if he clicks the Create Database button, a new database "mysite?com" is created.

Bubbs experiments and enters "mysite!com" as a new database. He is able to create it.

Plus, whenever Bubba clicks a link, it blows away the left hand frame.

What's going on here? Is this normal behaviour?
Skadar

Well my problem went away ... maybe the box needed a nap.

--------------------------------------------------------------------------------
I got the following error when opening the root db:

Database mysql running on localhost
PMA Database ... not OK
--------------------------------------------------------------------------------

I started with phpMyAdmin v2.2.0 and MySQL v3.23.41. I used gpan's update rpm for phpMyAdmin to v2.3.3pl1 and all went well. However, in phpMyAdmin I started getting the following error message with every installed database:

-----------------------------------------------
Database mysql running on localhost
PMA Database ... not OK
-----------------------------------------------

It turns out that this reflects db/tables relational features that were not active. To enable them and get rid of this error, I did the following:

USE THIS HELP AT YOUR OWN RISK. I DO NOT GUARANTEE FUNCTIONALITY OR COMPATIBILITY.

In phpMyAdmin create the following database: phpmyadmin and all related tables as follows:

(1) Login as root to phpMyAdmin

(2) Create a new database called phpmyadmin

CREATE DATABASE phpmyadmin;

Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):

GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';

Do not give any other user rights on this database.

(3) To allow the usage of the bookmark queries functionality, create a table following this scheme:

CREATE TABLE `PMA_bookmark` (
id int(11) DEFAULT '0' NOT NULL auto_increment,
dbase varchar(255) NOT NULL,
user varchar(255) NOT NULL,
label varchar(255) NOT NULL,
query text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='Bookmarks';

(4) Create a special 'relation' table, which field is a key in another table (a foreign key). phpMyAdmin currently uses this to (a) make clickable, when you browse the master table, the data values that point to the foreign table; (b) display in an optional tooltip the "display field" when browsing the master table, if you move the mouse to a column containing a foreign key (use also the 'table_info' table); © display links on the table properties page, to check referential integrity (display missing foreign keys) for each described key; (d) in query-by-example, create automatic joins; (e) enable you to get a PDF schema of your database (also uses the table_coords table). The keys can be numeric or character. Create the table following this scheme:

CREATE TABLE `PMA_relation` (
`master_db` varchar(64) NOT NULL default '',
`master_table` varchar(64) NOT NULL default '',
`master_field` varchar(64) NOT NULL default '',
`foreign_db` varchar(64) NOT NULL default '',
`foreign_table` varchar(64) NOT NULL default '',
`foreign_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`master_db`, `master_table`, `master_field`),
KEY foreign_field (foreign_db, foreign_table)
) TYPE=MyISAM COMMENT='Relation table';

Now as normal user open phpMyAdmin and for each one of your tables where you want to use this feature, click "Structure/Relation view/" and choose foreign fields.


(5) Create a special 'table_info' table, which field is to be displayed as a tooltip when moving the cursor over the corresponding key. This configuration variable will hold the name of this special table. Create this table following this scheme:

CREATE TABLE `PMA_table_info` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`display_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`db_name`, `table_name`)
) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';

For each table where you want to use this feature, click "Structure/Relation view/Choose field to display" to choose the field.

(6) phpMyAdmin can create PDF pages showing the relations between your tables. To do this it needs two tables "pdf_pages" (storing information about the available pdf pages) and "table_coords" (storing coordinates where each table will be placed on a PDF schema output). You must be using the "relation" feature and have a table of PDF pages to create PDF output. Create two tables for this functionality following this scheme:

CREATE TABLE `PMA_table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`, `table_name`, `pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';

CREATE TABLE `PMA_pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) NOT NULL default '',
PRIMARY KEY (page_nr),
KEY (db_name)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA';

(7) To store comments to describe each column for each table which will then be shown on the "printview", create a table following this scheme:

CREATE TABLE `PMA_column_comments` (
id int(5) unsigned NOT NULL auto_increment,
db_name varchar(64) NOT NULL default '',
table_name varchar(64) NOT NULL default '',
column_name varchar(64) NOT NULL default '',
comment varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY db_name (db_name, table_name, column_name)
) TYPE=MyISAM COMMENT='Comments for Columns';

( Now you must update the phpMyAdmin configuration file as follows:

Login as root

cd /var/www/html/phpMyAdmin-2.3.3pl1 (or wherever your phpMyAdmin 2.3.3pl1 folder is located)

You must populate the $cfg['Servers'][$i] variables with the names of the tables created above as follows:

pico –w config.inc.php

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
// - leave blank for no support
$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark'; // Bookmark table - leave blank for no bookmark support
$cfg['Servers'][$i]['relation'] = 'PMA_relation'; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
$cfg['Servers'][$i]['table_info'] = 'PMA_table_info'; // table to describe the display fields
// - leave blank for no display fields support
$cfg['Servers'][$i]['table_coords'] = 'PMA_table_coords'; // table to describe the tables position for the PDF
// schema - leave blank for no PDF schema support
$cfg['Servers'][$i]['pdf_pages'] = 'PMA_pdf_pages'; // table to describe pages of relationpdf
// - leave blank if you don't want to use this
$cfg['Servers'][$i]['column_comments'] // table to store columncomments
= 'PMA_column_comments'; // - leave blank if you don't want to use this


Now you must restart the server and reload MySQL.

I hope this helps.

Sory guys I am new to this. I just got a server and it has2.2.0 on it and would like to upgrade phpmyadmin.

My problem is i dont even know what a rpm is let alone how to install one. I know that this will take some time for me to understand.

If anyone could help me with this update I would be very thankful..

Basically

ssh into the server; su to root

then

rpm -Uvh (link to rpm file)

You can private message me if you need help also

Ok I did the update but when i try to login it does not let me like its wrong password or something so i went and tried changing password I wait... then get a blank white page so im assuming password may have got changed but nope =( so I look at mysql and its offline so restarted and back online so i try again to login and no go again =0 any ideas?

Have you set your hostname on the box?...

Also, m ake sure safe mode isn't on in php

Yeah hostname is set whats command to check if safe mode is on or not if it is how u disable command?