- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Config import proposal
by Michal Čihař 08 Sep '05

08 Sep '05

Hi all current state when default values are written at two places (config.inc.php and libraries/config_import.lib.php) makes easy to make one of them different. And then we copy config file to config.default.php when releasing tarballs. So on each release configuration in placed on three places, in CVS "just" on two. This could be IMO handled better way. I can currently see two possibilities, one quite easy to implement: 1. Manage just config.default.php in CVS. 2. User has to create config.inc.php. 3. Include config.inc.php. 4. Call fix up function, that will add missing values to configration based on config.default.php. Function could look something like this (just to show how it could look like, I even haven't tested whether this code actually works): function fixup_array(&$src, &$dst) { foreach($src as $key => $val) { if (!isset($dst($key)){ $dst[$key] = $val; } elseif (is_array($val)) { fixup_array($src[$key], $dst[$key]); } } } function fixup() { include './config.default.php'; fixup_array($cfg, $GLOBALS['cfg']); } Second possible solution would be do to this fixup only when that configuration options is actually needed. This would mean no direct reading of $cfg, but using some function instead, that will deal with default values. This definitely needs more modification to all code. Comments? -- Michal Čihař | http://cihar.com

2 3

[Phpmyadmin-devel] phpMyAdmin 2.6.4-rc1 is released
by Marc Delisle 28 Aug '05

28 Aug '05

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.4-rc1 http://www.phpmyadmin.net phpMyAdmin 2.6.4-rc1 - August 28th, 2005 ======================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the first release candidate for phpMyAdmin 2.6.4. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular Web GUI for MySQL and is downloaded between 6,000 and 14,000 times a day, according to SourceForge.net. Highlights ---------- Improvements: * Foreign-key dropdowns can be more customized * Export: configurable filename templates * Display column comments while editing data * Transformations: new hexadecimal mode * HTTP auth: support FastCGI * Themes: can now have different theme per server * OLD_PASSWORD in the list of functions * Better messages when checking numerical input * Allow adding DROP TABLE when copying databases * Better support of information_schema * Various interface CSS improvements * Tree subgroups in left panel database selector * Documentation: links and anchors to every FAQ item * Table comments move to page header * Export: configurable default charset * Removed warning about PmaAbsoluteUri not set Fixes: * Database search in MySQL 5.0.x on fields without a charset * Invalid "normal" cursor style * Browsing state when deleting multiple rows * Support bigger queries in print view, insert row, export results * Unsaved changes to relations were lost when changing display field * Exporting under IE 6 (Windows XP SP2) * Better catching of parse errors in config file * XSS on the cookie-based login panel * Show all while browsing foreign values * Escaping of special characters in ENUM or SET * XSS on table creation page * Using mysqli extension with MySQL 4.0.x * "empty result set" message was sometimes not returned * Incorrect message "You should define a primary key" * Abide cfg['Lang'] settings even if using MySQL > 4.1.x Detailed list of changes is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- Please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin handles the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create, copy, rename and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 50 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller..com> Copyright (C) 2001-2005 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge..net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Marc Delisle/ 2005-08-28

1 0

[Phpmyadmin-devel] plans for 2.6.4
by Marc Delisle 23 Aug '05

23 Aug '05

Hi, I plan to open the QA_2_6_4 branch and release 2.6.4-rc1 on 2005-08-28. Marc

2 2

[Phpmyadmin-devel] encryption of config file
by Vishal Sharma 13 Aug '05

13 Aug '05

hello ppl, i am wondering abut is there any way i can encrypt my phpmyadmin config file so that no body can get the username/passwd of the databse. the thing i want is the config file must be encrypted and decrypt only at application level ie it must decrypt only on execution (at applicatin level) and once the session will be finished it must encrypt again. so what you guys think of this ......any suggestions ..? vishal -- Bringing Freedom....Deploying GNU/LINUX....

2 1

[Phpmyadmin-devel] PEAR Packaged phpMyAdmin
by Clay Loveless 11 Aug '05

11 Aug '05

Hello, pMA devs! : ) I'm working on a project that leverages PEAR 1.4.0's robust packaging system that aims to bring PHP application distribution to the level of ease that is available to users of Debian Linux's apt-get system. To that end, I have prepared a phpMyAdmin PEAR installable package that I would like your feedback on. In order to make phpMyAdmin PEAR 1.4.0 compatible, there were only two modifications to the phpMyAdmin traditional distribution. 1. When installed, config.inc.php becomes config.inc.php.dist, so that future package upgrades do not overwrite existing configuration. 2. A slight version numbering change, as PEAR only supports letters, numbers and dots in versions. So, 2.6.3-pl1 became 2.6.3pl1 in this example. To install the PEARified package, follow these steps: 1. Get PEAR installed If you're already got PEAR running on your machine, we'll work with that. If you don't, or if you want to use a localized PEAR installation, just follow these instructions: http://pear.php.net/manual/en/installation.php 2. Upgrade to PEAR 1.4.0a12 To upgrade to the alpha version of PEAR that supports channels, run these commands. $ pear config-set preferred_state alpha $ pear upgrade -o PEAR 3. Set up the Pearified.com channel With PEAR 1.4.0a12, run this command: $ pear channel-discover pearified.com 4. Install the Role_Web package. This package is what makes the installation of a web front-end application easy with PEAR 1.4.0. Note that there is a post-install script to run ... So do these things: $ pear install pearified/Role_Web $ pear run-scripts pearified/Role_Web 5. Install the phpMyAdmin package The installer will put the installation in a directory of '/pma' inside of whatever directory you specified after installing the Role_Web package. This package isn't released yet, so it will install a little bit differently for the time being: $ pear install http://pearified.com/testing/DB_phpMyAdmin-2.6.3pl1.tgz Once released, this package would be installed like this: $ pear install pearified/DB_phpMyAdmin But, that won't work right now. That's it! Once those steps are completed, copy config.inc.php.dist to config.inc.php, configure as needed, and you'll be up and running. A future enhancement to this package is a post-install script that steps users through the process of setting up config.inc.php. I am eager for your feedback! Please let me know if any of you have trouble installing the package. If you're interested, I would like to discuss maintaining this package going forward so that we may open up a new convenient installation option for phpMyAdmin. I am willing to maintain that package, or I would also be happy to help out the phpMyAdmin development team in taking over the maintenance of the PEAR package. Thanks for your time! Regards, Clay -- Killersoft.com

4 3

[Phpmyadmin-devel] Mail Delivery (failure phpmyadmin-devel@lists.sourceforge.net)
by michal＠cihar.com 03 Aug '05

03 Aug '05

1 0

[Phpmyadmin-devel] server_privileges and special characters in table name
by Marc Delisle 27 Jul '05

27 Jul '05

Hi, First under MySQL 4.1.13 I create a table with a special character in its name (for example école). Then I have problems assigning privileges on a table level, with PMA. This is because SELECT Table_name from tables_priv returns a weird character instead of "é". Note however that SHOW GRANTS displays this character correctly. I was thinking of doing some conversion in server_privileges.php, but before, I tried the same test under MySQL 5.0.9 and there is no problem! Could someone confirm/comment my tests? Marc

1 0

[Phpmyadmin-devel] templates documentation and troubles
by Alessandro De Zorzi 26 Jul '05

26 Jul '05

Hi all, I'm working to create my first template with pla, I create with successfully a creation/new_my_template.php file now I try to create the related xml file but the "Proceed >>" button don't appears clickable, could be a my js problem? I try to create template for VirtualAdmin objectClass this is the schema http://www.phamm.org/docs/phamm.schema I'm looking for documentation about "howto create template for pla" is this available? Another one, is xml template the good way to use templates? Can consider the php template obsoleted? I need to create an multiple-entry with a template (my VirtualDomain need a postmaster account inside), is this possible? Is possible to use hidden values with xml templates? Thanks in advance. Alessandro De Zorzi

1 0

[Phpmyadmin-devel] Edit/insert mode
by Marc Delisle 21 Jul '05

21 Jul '05

Hi, I like the new dropdowns on this page, but I suggest replacing "and" by "then", which would give, for example: Insert as a new row then Go back to previous page Opinions? Marc

2 2

[Phpmyadmin-devel] Error reporting in config file
by Michal Čihař 12 Jul '05

12 Jul '05

Hi all since PHP 4.3.5 interpreter stops on parse error. With our current code this leads to empty page when user makes such error in configuration. This is pretty confusing, see bugreport [1]. Possible solutions, that come to my mind: - do not reset error reporting - user will get directly error message - eval config file content, parse errors inside eval are not thet fatal, so we can hide errors in that time and handle error simmilar way how we did it before 1. https://sourceforge.net/tracker/?func=detail&atid=377408&aid=1223319&group_… -- Michal Čihař | http://cihar.com

2 5