February 2007 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] MYSQLI_CLIENT_SSL
by Marc Delisle 01 Mar '07

01 Mar '07

Hi, I wonder if $cfg['Servers'][$i]['ssl'] = true; being true by default will not cause us some problems. https://sourceforge.net/forum/forum.php?thread_id=1683182&forum_id=72909 http://ca.php.net/mysqli MYSQLI_CLIENT_SSL Use SSL (encrypted protocol). This option should not be set by application programs; it is set internally in the MySQL client library. =========== "should not be set by application programs": this is us, no? :) They don't mention this warning for MYSQL_CLIENT_SSL. Marc

3 4

[Phpmyadmin-devel] phpMyAdmin 2.10.0.1 is released
by Marc Delisle 28 Feb '07

28 Feb '07

Hi, This version contains just one change from 2.10.0: a default value of false for $cfg['Servers'][$i]['ssl']. The default value of true is problematic on some servers. Details on http://www.phpmyadmin.net Marc Delisle, for the team

1 0

[Phpmyadmin-devel] phpMyAdmin 2.10.0 is released
by Marc Delisle 27 Feb '07

27 Feb '07

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.10.0 http://www.phpmyadmin.net phpMyAdmin 2.10.0 - February 27, 2007 ===================================== A PHP application to administrate MySQL over the Web ---------------------------------------------------- Announcement ------------ The phpMyAdmin Project announces the immediate availability of phpMyAdmin 2.10.0. 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. Improvements: * Designer: new graphical relation manager * Improved speed on servers with thousands of databases/tables * Vertical field editor (optional) * Option to avoid counting rows for views * Calendar on search page * DOS-style end-of-lines in setup-generated files Detailed list of changes is usually available under http://www.phpmyadmin.net/ChangeLog.txt but at present time, please refer to the ChangeLog in the distribution kit for the most up to date information. 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 ----------- (from http://www.phpmyadmin.net/documentation) 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: * easily browse through databases and tables * create, copy, rename, alter and drop databases * create, copy, rename, alter and drop tables * do table maintenance * add, edit and drop fields * execute any SQL-statement, even multiple queries * create, alter and drop indexes * load text files into tables * create (*) and read dumps of tables or databases * export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats * administer multiple servers * manage MySQL users and privileges * check server settings and runtime information with configuration hints * check referential integrity in MyISAM tables * 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 * transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link * support InnoDB tables and foreign keys (see FAQ 3.6) * support mysqli, the improved MySQL extension (see FAQ 1.17) * communicate in 50 different languages (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zlib) and/or Bzip2 support (--with-bz2). Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2007 Marc Delisle <Marc.Delisle_at_cegepsherbrooke.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> Sebastian Mendel <cybot_tm_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 Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Marc Delisle / 2007-02-27

1 0

[Phpmyadmin-devel] add LIMIT once? ... or
by Sebastian Mendel 27 Feb '07

27 Feb '07

Hi, if you browse a table, (or any other SELECT ...?) PMA always adds the LIMIT but why is this done at least twice? first it is done in sql.php but the function PMA_displayMessager() is called without the added LIMIT and now this function adds the LIMIT again! what was the reason not doing this once and give PMA_displayMessage() the query with the already added LIMIT? -- Sebastian Mendel www.sebastianmendel.de

2 3

[Phpmyadmin-devel] ready for 2.10.0 ?
by Marc Delisle 25 Feb '07

25 Feb '07

Hi, I would be ready, I'm just waiting for the shell server to recover from its failure (if we want phpmyadmin.net to reflect the newly released version). Marc

2 2

[Phpmyadmin-devel] changelog strcutre
by Sebastian Mendel 22 Feb '07

22 Feb '07

Hi, how about changing our changelog structure? are you all happy with current structure? some suggestion: - date only once per day - prefix type if change: bugfix, change, new - add module info, f.e. sqlparser, config, themes, import, ... release info in trunk changelog do says nothing - if we not also include info in later chnages if it was backported to any other branch do we really need to list all changed files? i think this comes from long ago when no versioning system was used!? f.e.: 2006-07-13 User - USer - BUGFIX: #123456 - bug report title - BUGFIX: some notices User2 - USer2 + NEW: [themes] new feature in themes / CHANGED: [gui] changed all layout table into fieldsets 2006-07-12 User - User * SECURITY: #123458 - blah blah [QA_2_10, QA_2_9] 2006-07-11 User - User > BRANCH: create branch QA_2_10 -- Sebastian Mendel www.sebastianmendel.de

3 16

[Phpmyadmin-devel] 'connect' in sql?
by Sebastian Mendel 22 Feb '07

22 Feb '07

Hi, in common.lib.php::PMA_mysqlDie() // if the config password is wrong, or the MySQL server does not // respond, do not show the query that would reveal the // username/password if (!empty($the_query) && !strstr($the_query, 'connect')) { ??? what is 'connect' for??? in 'ancient times' ... was it neccessary to use a sql command to connect ??? -- Sebastian Mendel www.sebastianmendel.de

3 2

[Phpmyadmin-devel] phpDocuemntor documentation gneration (michal)
by Sebastian Mendel 22 Feb '07

22 Feb '07

Hi, michal, could you please try: https://sourceforge.net/tracker/?func=detail&atid=111194&aid=1658708&group_… ? -- Sebastian Mendel www.sebastianmendel.de

2 2

[Phpmyadmin-devel] generic $strOptions
by Marc Delisle 19 Feb '07

19 Feb '07

Hi, while merging a patch in trunk for YAML export, I added a generic $strOptions. I think we could use it for all export options in the Legend, and remove a bunch of messages like $strCSVOptions $strHTMLWordOptions $strXMLOptions $strSQLOptions Marc

2 3

[Phpmyadmin-devel] recent fix for white page and field uploads
by Marc Delisle 16 Feb '07

16 Feb '07

Hi, revision 9989 (in trunk) contains a fix (with a hardcoded limit) for a problem I have: when uploading a 700 Kio file into a BLOB, I get a white page. I think we had a limit on the number of queries displayed but not on the size of them. Tell me what you think of this, as I would like to backport to QA_2_10. Marc

2 6