- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Message freeze and 2.9.0 roadmap
by Marc Delisle 09 Aug '06

09 Aug '06

Hi, I sent the list of changes to the translators list. I suggest to release 2.9.0-beta1 in one or two weeks. I plan to open QA_2_9 but I would prefer if we first reach a decision about: - auto-numbering in Documentation.html Marc

3 3

[Phpmyadmin-devel] about getting the db list
by Sebastian Mendel 08 Aug '06

08 Aug '06

from the code and the documentation i collected this information about how and what phpMyAdmin tries to get the db list: - first it tries SHOW DATABASE for the current user - if this fails it tries it with controluser and checks against privilege tables but the documentation says only that the controlusers requires access to various `mysql`-tables - not that he also requires SHOW DATABASES privileges - without this a user with global select privileges will not see any database - or wildcards cannot expanded to real db names - if this both fails the dblist stays empty - phpMyAdmin drops all db's not in cfg[only_db] - phpMyAdmin drops db's in cfg[hide_db] - phpMyAdmin tries every db with USE DATABASE (for specific MySQL version) Questions: "Note: starting with phpMyAdmin 2.6.1, this section is only applicable if your MySQL server is older than 4.1.2, or is running with --skip-show-database." Why "is older than 4.1.2"? thinks i want to change: - if SHOW DATABASE fails try INFORMATION_SCHEMA - merge PMA_safe_db_list(), PMA_availableDatabases(), PMA_DBI_get_dblist() into a single function - if the dblist is still empty check `mysql` and `INFORMATION_SCHEMA` with USE DATABASE and add them to the list please correct me if i missed something and feel free to comment -- Sebastian Mendel www.sebastianmendel.de

4 8

[Phpmyadmin-devel] Public Reportback on OSCON
by Robin H. Johnson 04 Aug '06

04 Aug '06

Hi everybody, So a reportback on OSCON 2006. This is the publicly consumable part, as with my MySQL UC report. The trip down was a pain - this is worthy of mention because none of us are American. The US INS (immigration/customs) guy that I had to speak to had absolutely no understand of open source software, or that we could give something away. He asked if I had some proof that I was associated with phpMyAdmin as a business (he kept referring to it as such, no matter how many times I pointed out we were closest to a community organization) - so I showed him one of my phpMyAdmin business cards, and the 11x17 posters I had Do not be tempted to lie to these guys, they use infra-red cameras trained on faces to try and detect it. This still did not help his understanding of phpMyAdmin and open source, and he opened his drawer and got out his dreaded orange rejection pad (by which they deny you entry into the USA) - I had to rack my brains and make very fast analogies at this point - and eventually I succeeded, but it is NOT an experience I would like to repeat again. A number of the other folk at the conference admitted to having similar troubles while crossing various borders. The rest of the journey down to Portland was uneventful - I had time for a brief bite of lunch in Seattle once the bus stopped, and before the Amtrak train left (I'll take the European rail system, even that of Italy over Amtrak anyday however). On reaching Portland, I was grabbing a cab to where I was staying, which turned out to be interesting in itself - the cab driver was Eritrean, and could not understand my South African accent whatsoever, to the point where I had to write down the address. Originally, I was going to be staying with a fellow Gentoo developer, but about a week ahead of time, he had roommate issues, and wasn't able to offer me a place. A few other Open Source leads didn't help either. So, in the same vein as MySQL UC 2006, I used CouchSurfing.com, and ended up on a fold-out futon bed, 1.5 miles from the convention centre. My host said she could loan me a spare bicycle, so I brought my helmet and other gear down. She asked that I keep her identity to myself, for various reasons. CouchSurfing as a concept works out reasonably well. You get a couch or better to stay on, and generally just try to lend a helping hand while you are there (I helped in the kitchen, read a bedtime story to my host's daughter and her friend, tuned up the bicycles, and a few more things). The Wednesday morning cycle to the convention centre was ok - I had previously made a brief study of Google Maps, and was told by my host that the convention centre had two very large spires that were good landmarks to orient by within the NE district of Portland. The ride was a bit interesting, the route I picked based on Google Maps turned out to go via some of the slummiest parts of town, which felt marginally unsafe at 8.15am. Got to the convention centre, signed in, rigged up the 11x17 posters in the booth (as visible in the photo that Marc linked to, which was taken by the ZDNet photographer, early on Thursday morning, right after the doors opened for non-exhibitors), and said Hi to the other dot-org booths around my area - a bunch of the same people that were at MySQL UC - Apache, WITI, FSF. Fired up the CVS HEAD demo on my fiance's laptop, and waited for the first crowd to come in. As a general summary, while exhibit hall passes were free for OSCON - it was much subjectively quieter than MySQL UC - most of those that did come in exhibit hall passes were just there to scoop freebies - and did not interact with any booth without freebies. At the breaks between sessions, there was a good deal more activity in the exhibit hall - due to the refreshments and snacks. For folks approaching the phpMyAdmin booth I had a number of folk complaining of not getting it working, but after some targeted debugging questions, the source of their troubles were Apache/PHP, not phpMyAdmin in any form. I had a number of UI designers make interesting comments about the PMA design - such as the cookie login message (from a Databases professor at Stanford) that I brought up for Marc's message freeze request. Some of these I see we are already working on (like the present thread for tracking server/database etc in a cookie). Some more of them I intend to dig out my UI design textbooks and examine more closely to see if there are logical ways that we can improve them. There were no comments about the lack of bleeding edge functionality - even those that I specifically asked about a stored procedure editor admitted they did not have a need for one. There was one notable functionality request, and it's got some low-hanging fruit we can consider - an explicit tab-separated value (TSV) export format - in the same vein as our CSV export. The second part of the request was considerably more complication - and that was IMPORT functionality for CSV/CSV-Excel/TSV/XML data. I went for lunch Wednesday with teh Gentoo developers, courtesy of E-Trade - who are apparently very large Gentoo users - discussions had about application packaging were very in-depth. The afternoon was similar to the morning, just hanging in the booth, and speaking to interested conference attendees. There were a lot of full conference attendees that just breezed by the booth shouting out things like 'Great software!', 'We use it everyday!', and similar slogans of support. Starting at 15h30, the free beer came out. Nothing as elaborate as the party at LinuxTag last year, but still very good quality micro-brewery german-style beers (which Portland is famous for), incl. a nice triple Bock, and an Altbier similar to that which Alexander had going last year at LinuxTag for us. The exhibit hall for Wednesday wrapped up at 5pm, and everybody (incl. exhibitors) was kicked out so the caterers could set up the IBM-sponsored reception. The 6pm reception was reasonble - good appetizers, and a lot more beer and wine. From there, some of the Gentoo developers and myself went to two of the open-bar parties that were taking place in nearby hotels - the first was slow, and badly attended, with a Jewish kleizmer (sp?) [with a story attached linked to Metallica], and more beer, but no food. The second party was a lot more active, held by O'Reilly - their hotel suite was shoulder-to-shoulder people. I engaged in some interesting conversations with Google employees, before calling it a night around 11pm, so I could cycle back while still marginally sober (and able to stay upright on the bicycle). Thursday morning saw me figure out a different cycleroute to the convention centre - one that turned out to be safer from people and traffic (there are cycling lanes painted on the road, but DON'T cycle in them with the traffic unless you have a deathwish, they do NOT like cyclists). Rigged up the laptop demo again, the ZDNet guy came by and grabbed the photo of the booth with me busy setting up the laptop demo. Thursday seemed much quieter. I had an interesting discussion with a group of high-school youth that were developing a MySQL-based library book tracking system for their school, and helped out with their database design. I arranged for 50 blank CACert CAP forms and also did CACert assurances at the booth during Thursday, as I found that I was not going to be able to attend the keysigning event Thursday night. Ate the conference boxed lunch at lunchtime, it wasn't noteworthy in any way. Come the 5pm teardown time, I grabbed my stuff, and departed. I was informed of a few more parties, but I turned them down due to my pending early departure on Friday morning. Stopped at a bookstore on the way back. I had a light dinner out with my host, cooked up my famed near-diabetic-inducing chocolate sauce which was then served over ice cream and strawberries. Grabbed some sleep before the morning and leaving to catch the public bus to the train station at 7am. The return journey was much better, baring the initial 1 hour delay due to a train derailment south of Portland. The private report portion will be a followup email to the usual location. -- Robin Hugh Johnson E-Mail : robbat2(a)users.sourceforge.net GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85

3 4

[Phpmyadmin-devel] AUTO_INCREMENT next value and MySQL 5.0.23+
by Marc Delisle 04 Aug '06

04 Aug '06

Hi, starting with MySQL 5.0.23, SHOW CREATE TABLE includes the AUTO_INCREMENT next value, just after the ENGINE clause. We had a "Add AUTO_INCREMENT value" option in table operations and db operations. So I suggest: - for 5.0.23+, the "Add AUTO_INCREMENT value" checkbox be removed from table operations and db operations dialogs. The same functionality is now being provided automatically in the CREATE TABLE statement - for 5.0.22-, I would also prefer to remove these checkboxes For all MySQL versions, I guess that during a copy, the majority of users want to copy also the AUTO_INCREMENT value. If it's not the case, they can always go to the copied table on Operations and change the value in "Table options". If we still want to provide this checkbox, well for 5.0.23+ we would have to examine the statement and remove the AUTO_INCREMENT clause. Marc

3 10

[Phpmyadmin-devel] ohloh.net about phpMyAdmin
by Sebastian Mendel 04 Aug '06

04 Aug '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 hi, somehow slow - but very interesting: http://ohloh.net/opensource/software/phpmyadmin - -- Sebastian Mendel www.sebastianmendel.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (MingW32) iD8DBQFEvhaYX/0lClpZDr4RAjZkAJ9PNvAEHVi2RjwIlf0+B0HecH4LTwCeLM2S xD5bWUO1nVyrhKuSI95tE9k= =Z5Cy -----END PGP SIGNATURE-----

4 11

[Phpmyadmin-devel] phpMyAdmin booth as OSCON
by Marc Delisle 03 Aug '06

03 Aug '06

http://www.flickr.com/photos/calevans/201270101/in/set-72157594210410472/

1 0

[Phpmyadmin-devel] 2.9.0 message freeze?
by Marc Delisle 03 Aug '06

03 Aug '06

Hi, I would like some feedback about a message freeze for 2.9.0 because I'm preparing the batch. Marc

3 8

[Phpmyadmin-devel] PMA_safe_db_list()
by Sebastian Mendel 03 Aug '06

03 Aug '06

Hi, PMA_safe_db_list() first tries to use SHOW DATABASES if it fails it tries mysql.db and inside this code there is a query with SHOW DATABASES again ... why? did i missed something there? -- Sebastian Mendel www.sebastianmendel.de

3 10

[Phpmyadmin-devel] phpMyAdmin 2.8.2.1 is released
by Marc Delisle 03 Aug '06

03 Aug '06

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.8.2.1 http://www.phpmyadmin.net phpMyAdmin 2.8.2.1 - August 2nd, 2006 ===================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of phpMyAdmin 2.8.2.1. No new features appear in this version -- it's a bugfix only release. Development of new features is happening in the 2.9 series. 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. New fixes in 2.8.2.1 -------------------- * darkblue_orange theme not readable * setup script: protect against PHP code input from user * blank page after Edit in IE6 via IIS * reload default configuration if config.inc.php is removed 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 ----------- (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-2006 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 the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Marc Delisle/ 2006-08-02

5 10

[Phpmyadmin-devel] isset($cfg[...]) not needed anymore
by Sebastian Mendel 02 Aug '06

02 Aug '06

Hi, as we have the config.default.php there is no need to always check with isset() for a specific config variable, isn't it? -- Sebastian Mendel www.sebastianmendel.de

3 2