Developers

developers@phpmyadmin.net

7004 discussions

[Phpmyadmin-devel] config.inc.php generator: a suggestion
by Olivier Mueller 15 Jan '05

15 Jan '05

Hello, I've tested a few things today, here is a little something to (re-)open the discussion :) I think it would be nice if PMA would have a simple configuration generator, like in many other projects: What about something simple like that? : http://www.phpmyadmin.net/swix_pma/setup/ Scoll to the end of the page to find the [generate] button. It's based on the orginal Documentation.html, with some special "cfgen" tags, which are simply parsed by the setup/index.php script. (look at the .html source of the original http://www.phpmyadmin.net/swix_pma/Documentation.html ) source: http://www.phpmyadmin.net/swix_pma/setup/index.phps and http://www.phpmyadmin.net/swix_pma/setup/generate.phps The generate.php script needs a special version of the config.inc.php files (with lines like: "$cfg['blowfish_secret'] = '%%blowfish_secret%%'; ") Do you think something like that would be good? Is that the right way? Feedback welcome :) regards & have a nice week-end, Olivier -- _______________________________________________________ Olivier Müller - PGP key ID: 0x0E84D2EA - Switzerland E-Mail: http://omx.ch/mail/ - AIM/iChat: swix3k

2 2

[Phpmyadmin-devel] QA_2_6_1 branch
by Marc Delisle 10 Jan '05

10 Jan '05

Hi, I have created the QA_2_6_1 branch, from which 2.6.1 will be released someday (depending on the feedback about 2.6.1-rc2). Please commit only bug fixes in this branch (and commit them also in HEAD). Development can resume in HEAD. Marc

1 0

[Phpmyadmin-devel] phpMyAdmin 2.6.1-rc2 is released
by Marc Delisle 09 Jan '05

09 Jan '05

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.1-rc2 http://www.phpmyadmin.net phpMyAdmin 2.6.1-rc2 - January 9th, 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 second release candidate of phpMyAdmin 2.6.1. Almost four months have passed since 2.6.0, although three patch releases were made to take care of several security alerts we received. In 2.6.1 there are two more security fixes. As a consequence of one of these fixes, if you want to use MIME-based external transformations you have to use a PHP version of 4.3.0 or later. A big speed improvement for users of the "cookie" authentication type is included starting from 2.6.1-rc1, but you must be running on a Web server with the mcrypt PHP module. Another improvement worth mentionning, which relates to a new feature offered on MySQL 4.1.2+: on multi-user installations, the control user no longer needs to have any rights to the "mysql" db. It is now only used to access the linked-tables infrastructure (pmadb). Please note that it is not recommended to run this testing release on production environments. 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 GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Upgrade note: * Using external transformations now requires PHP > 4.3.0 Improvements: * Big speed improvement (if using auth_type = 'cookie') by using the mcrypt library (if available on your system) * Improved wording when adding fields * (mysqli) support for compressed protocol and CLIENT_LOCAL_FILES * Clickable active server in left panel * Improved ANSI mode in various scripts * Hints added (light bulb) * Database copying * New Database Operations tab: note that many db operations have been moved here, including the PDF schema generation dialog * Optional simple blocking of root login * Binary log display * Index creating on multiple fields * Improved displaying of messages below tabs * Handle MySQL "duplicate entry" error * User list: top index for user initials * Support for OLD_PASSWORD() function * Under MySQL 4.1.2+, we no longer need the control user to have rights over the "mysql" db * New checks for common index problems * Upload: show filename of uploaded file * Improved page selector when browsing foreign table values * Improved handling of InnoDB constraints * Speed up display for left panel with PMA infrastructure is used * New message "no activity..." * Support of keywords NAMES and VIEW * Can now edit next entry (based on the next numeric primary key) * New warnings related to the use of mbstring * Improved navigation in calendar * Export: selectable SQL compatibility * PDF schema: added support for output in UTF-8 Fixes: * Security fix against some crafted data allowing arbitrary program execution (if PHP safe mode is off and external transformations are activated) * Security fix against a possible attack on read_dump.php (if PHP safe mode is off) * Incorrect appending of LIMIT to queries * Export: insufficient space to save * Export: convert end of line chars we get from MySQL * Wrong double column sort (with JOIN) * Export: (mysqli) some fields wrongly exported as BINARY * Illegal mix of collations for converted strings * Wrong tabbing from value to value * Allow work on temporary tables * UNIX_TIMESTAMP and optional parameter * Export: improved zip headers * 0 as field name caused problems * Incorrect handling when no default server defined * Export: Use just for SQL exports * Comments and multi-table selects * Security: deactivate the list of programs for external transformations * Incorrect handling of OFFSET * Better displaying of table-specific privileges for a db containing an escaped character * Since 2.6.0-pl3, connecting on a non-standard HTTP port did not work * Do not catch Alt and Shift keys * Do not duplicate constraints when exporting multiple databases * Illegal length for LONGTEXT * Moving/copying a table: problem with constraints copying * Reloading frame on multiple queries * Collations on non-text fields * Use standardized MIME type for gzip/bzip2 * Problem with field names like 000 * Timestamps problem under MySQL 4.1.x * Support Option key for field moving in Safari * Error when adding a FLOAT field under MySQL 4.1.x Detailed list of changes since version 2.2.0 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 ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, 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 is intended to handle 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 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 47 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 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-01-09

1 0

[Phpmyadmin-devel] 2.6.1 release plan
by Marc Delisle 04 Jan '05

04 Jan '05

Hi devs, I suggest this Sunday (Jan 9) for 2.6.1. Marc

3 6

[Phpmyadmin-devel] PDF output in utf-8
by Michal Čihař 30 Dec '04

30 Dec '04

Hi all I just committed support for creating PDF also in utf-8. It was needed to slightly modify FPDF to make this work, but it seems to work okay as far as I can test. Please verify if it didn't break anything and keep in mind for future FPDF updates that we have slightly modified version. -- Michal Čihař | http://cihar.com

2 10

[Phpmyadmin-devel] Security alerts url on homepage
by Michal Čihař 16 Dec '04

16 Dec '04

Hi does anybody see same as me on our homepage - urls for security alerts are much wider than column for news and are not wrapped? Any volunteer to fix it? :-) -- Michal Čihař | http://cihar.com

2 3

[Phpmyadmin-devel] phpMyAdmin 2.6.1-rc1 is released
by Marc Delisle 12 Dec '04

12 Dec '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.1-rc1 http://www.phpmyadmin.net phpMyAdmin 2.6.1-rc1 - December 12th, 2004 ========================================== 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 of phpMyAdmin 2.6.1. Almost three months have passed since 2.6.0, although three patch releases were made to take care of several security alerts we received. In 2.6.1 there are two more security fixes (and the official alert will be published in a few days). As a consequence of one of these fixes, if you want to use MIME-based external transformations you have to use a PHP version of 4.3.0 or later. A big speed improvement for users of the "cookie" authentication type is included in 2.6.1-rc1, but you must be running on a Web server with the mcrypt PHP module. Another improvement worth mentionning, which relates to a new feature offered on MySQL 4.1.2+: on multi-user installations, the control user no longer needs to have any rights to the "mysql" db. It is now only used to access the linked-tables infrastructure (pmadb). Please note that it is not recommended to run this testing release on production environments. 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 GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Upgrade note: * Using external transformations now requires PHP > 4.3.0 Improvements: * Big speed improvement (if using auth_type = 'cookie') by using the mcrypt library (if available on your system) * Improved wording when adding fields * (mysqli) support for compressed protocol and CLIENT_LOCAL_FILES * Clickable active server in left panel * Improved ANSI mode in various scripts * Hints added (light bulb) * Database copying * New Database Operations tab * Optional simple blocking of root login * Binary log display * Index creating on multiple fields * Improved displaying of messages below tabs * Handle MySQL "duplicate entry" error * User list: top index for user initials * Support for OLD_PASSWORD() function * Under MySQL 4.1.2+, we no longer need the control user to have rights over the "mysql" db * New checks for common index problems * Upload: show filename of uploaded file * Improved page selector when browsing foreign table values * Improved handling of InnoDB constraints * Speed up display for left panel with PMA infrastructure is used * New message "no activity..." Fixes: * Security fix against some crafted data allowing arbitrary program execution (if PHP safe mode is off and external transformations are activated) * Security fix against a possible attack on read_dump.php (if PHP safe mode is off) * Incorrect appending of LIMIT to queries * Export: insufficient space to save * Export: convert end of line chars we get from MySQL * Wrong double column sort (with JOIN) * Export: (mysqli) some fields wrongly exported as BINARY * Illegal mix of collations for converted strings * Wrong tabbing from value to value * Allow work on temporary tables * UNIX_TIMESTAMP and optional parameter * Export: improved zip headers * 0 as field name caused problems * Incorrect handling when no default server defined * Export: Use just for SQL exports * Comments and multi-table selects * Security: deactivate the list of programs for external transformations * Incorrect handling of OFFSET * Better displaying of table-specific privileges for a db containing an escaped character * Since 2.6.0-pl3, connecting on a non-standard HTTP port did not work Detailed list of changes since version 2.2.0 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 ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, 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 is intended to handle 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 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 47 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 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/ 2004-12-12

1 0

[Phpmyadmin-devel] export compatibility
by Marc Delisle 08 Dec '04

08 Dec '04

Hi, Would it be a good idea to add a checkbox "pre-MySQL 4.1-style export" on the SQL export sub-page, so users can read the dump on MySQL 4.0.x? I submit this idea but did not have time to check all the implications about the data. Marc

2 3

[Phpmyadmin-devel] speed improvement in auth_type cookie!
by Marc Delisle 24 Nov '04

24 Nov '04

Hi, after some profiling (thanks to Garvin for the hint about xdebug), I found that using a blowfish encryption coded in php was taking about 70-80% of the execution time every time we encrypt or decrypt. And since we have the security feature of adding the current time to username and password cookie (which makes a stolen cookie useless after LoginCookieValidity seconds), we encrypt and decrypt on each click! Thanks to Michal for the suggestion of using mcrypt. It's now used instead of blowfish.php (if available), producing dramatic speed improvements. I will add in the doc a strong suggestion to use this library. Meanwhile, please test :) Marc

3 5

[Phpmyadmin-devel] 2.6.0-pl3 and non-standard http port
by Marc Delisle 23 Nov '04

23 Nov '04

Hi, I just fixed http://sourceforge.net/tracker/index.php?func=detail&aid=1070197&group_id=2… the impact of the bug is that 2.6.0-pl3 is non-working on non-standard http ports. I don't feel like releasing -pl4 for this... but we could schedule 2.6.1-rc1 quickly... Comments? Marc

2 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers