June 2006 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] config.inc.php (again)
by Marc Delisle 04 Jul '06

04 Jul '06

Hi, I would like to reopen the discussion about this issue. I know you're tired of it, but there are lots of problems for users. I noticed at least one distro that just copy our libraries/config.default.php into ../config.inc.php! Unfortunately, many users do not read the doc about installation, and even for some who did read it, there are still problems: https://sourceforge.net/tracker/index.php?func=detail&aid=1471501&group_id=… Having to close all browser windows is another thing that is not evident for many. For some reasons, the setup script is not as popular as we hoped (probably due to the directory manipulations related to its use). My opinion is that we have to think about was it "normal" and expected for the configuration of OSS products. Is it too late to revert to our old way of keeping BC by compensating with code for missing options? If it's too late, what about having a config-dist.inc.php that would contain the minimum lines (one server section connecting to localhost with root and no password). People could copy it into config.inc.php and be more happy. Marc

3 11

[Phpmyadmin-devel] phpMyAdmin 2.8.2 is released
by Marc Delisle 30 Jun '06

30 Jun '06

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.8.2 http://www.phpmyadmin.net phpMyAdmin 2.8.2 - June 30, 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. No new features appear in this version -- it's a bugfix only release. Development of new features is happening in the 2.9 series. This version fixes a new vulnerability, see the security alert PMASA-2006-4 at http://www.phpmyadmin.net/home_page/security.php?issue=PMASA-2006-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. Fixes ----- * XSS vulnerability from requests not containing a token * Reenable XML option in Export * State in documentation that your browser must accept cookies * CVS link was broken on main page 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-06-30

1 0

[Phpmyadmin-devel] [Fwd: mysql phpmyadmin problem]
by Sebastian Mendel 25 Jun '06

25 Jun '06

-------- Original-Nachricht -------- Betreff: mysql phpmyadmin problem Datum: Fri, 23 Jun 2006 23:46:23 -0400 Von: Michael <mike(a)brenden.com> An: cybot_tm(a)users.sourceforge.net Hi there, As an offshoot of mysql/phpmyadmin bug #1436171 If permissions change away from mysql.mysql on any database directory under /var/lib/mysql (to, say, root.root), and phpmyadmin detects mysql version > 5.whatever (i.e., phpmyadmin tries to utilize information_schema), then phpmyadmin reports No database tables found, despite there obviously being, say, dozens of databases, and hundreds of tables. So the one permissions error on one database's directory screws up every database as far as phpmyadmin is concerned. Thought you should know. Best regards from outside washington, dc Michael

2 1

[Phpmyadmin-devel] Fixing Documentation Numbering
by Cyber Dog 22 Jun '06

22 Jun '06

Hi All, In regard to bug #1446538: I did some work with the Documentation file from svn. Here's what I've found: First of all, as I imagine you have realized by now, the current CSS method of numbering is not well supported at all. Only the most recent versions of Opera and FireFox support the necessary CSS. Since this leaves out the vast majority who use IE, it isn't an ideal solution. Obviously we have multiple options for fixing this. In the spirit of keeping it dynamic, I put together a javascript that (should) number things the same (and be browser independent!). This took me awhile, so I apologize if the logic is crude; I'm sure it can be refined. Basically we make arrays of the DOM elements for all the H2/H3/H4 in the file. I did simple nested looping, and used the Y index of each element to determine the order they land in. The page is then re-written with the index numbers from the loops. So long story short, the looping technique is ugly and inefficient, but it's late and it works. If somebody wants to rewrite that part of the logic, I think it would be a decent replacement. One big question I have, however: Why are we bothering dynamically generating the numbering if the achor tags are all hand coded? Adding an entry would seem to break the anchors anyway. The Documentation.html is in the attached archive. Comments welcome. - Matt LaPlante

2 1

[Phpmyadmin-devel] query tool buttons not work with php 5.1.4???
by Sebastian Mendel 20 Jun '06

20 Jun '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, executing large query (> 1000 chars) displays buttons for 'explain', 'refresh', 'edit', ... on my two test systems running win php 5.2 and rh 7.3 and fedora 5 with php 5.1.4 i get wired results have this php.ini settings enabled arg_separator.input ;& ;& arg_separator.output ; ; can anyone confirm? - -- Sebastian Mendel www.sebastianmendel.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (MingW32) iD8DBQFEmAoPX/0lClpZDr4RAo7JAKCW7YFbYgnvH/4W4scegFuOwM0+WgCfZSMY M3odAqi7gJDBvHq/8+QGDCc= =Thlk -----END PGP SIGNATURE-----

2 2

[Phpmyadmin-devel] Demo Server
by Sebastian Mendel 20 Jun '06

20 Jun '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, michal, why do you not add your 'Demo Server' message to the language files? and possible a config switch // set to true to enable demo server message display $cfg['demoserver'] = false; ? - -- Sebastian Mendel www.sebastianmendel.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (MingW32) iD8DBQFEl+g/X/0lClpZDr4RAhRjAKCd/pxajajKj1ttNlC4yP+U16W82QCfZMDx JTUrK1jHB06lwEieK7QMvrA= =aaIZ -----END PGP SIGNATURE-----

3 3

Re: [Phpmyadmin-devel] hi
by robbat2＠users.sourceforge.net 17 Jun '06

17 Jun '06

Your details. -------------------------------------------- text.zip: No virus found Powered by the new Norton OnlineScan Get protected: www.symantec.com

1 0

[Phpmyadmin-devel] 2.8.1 config bug?
by Garvin Hicking 12 Jun '06

12 Jun '06

Hi! Is it a known bug of the 2.8.1 release that it doesn't load "config.inc.php" files? I had two cases of the installation (one was done by a coworker of mine independantly from me) and we in the end had the same problem: Our config.inc.php file was not used. It was readable and all, but the config.default.php always seems to take precedence. config.inc.php was put into the main s9y directory, the setup folder was deleted aftwards. Thus we had to modify the config.default.php file, but I'm sure this is not intended? ;-) Best regards, Garvin -- ++ Garvin Hicking | Web-Entwickler [PHP] | www.garv.in | ICQ 21392242 ++ Developer of | www.phpMyAdmin.net | www.s9y.org ++ Make me happy | http://wishes.garv.in

4 8

[Phpmyadmin-devel] [Fwd: csv -> mysql]
by Sebastian Mendel 12 Jun '06

12 Jun '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > -------- Original-Nachricht -------- > Betreff: csv -> mysql > Datum: Mon, 12 Jun 2006 09:00:32 +0200 > Von: Michael Borchers <list(a)tridemail.de> > Organisation: Tridem Internet Services GmbH > An: mysql <mysql-de(a)lists.mysql.com> > > gibt es ne mögl. zb via phpmyadmin eine csv datei so zu importieren, > dass automatisch auch die struktur mit übernommen wird? > > bei 43 feldern spar ich mir die arbeit lieber:) in english: is it possible to automatically create a table from CSV file? in other words: auto detect field type by content? - -- Sebastian Mendel www.sebastianmendel.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (MingW32) iD8DBQFEjR7YX/0lClpZDr4RAtOyAJ9xXdJDR5dgKaqQIaufYP9GNBn1twCgtqTf 2C6iHDMqqw5VMSP91arnCgk= =1/rS -----END PGP SIGNATURE-----

5 6

Re: [Phpmyadmin-devel] your excel document
by mikebeck＠users.sourceforge.net 12 Jun '06

12 Jun '06

Please confirm the document. -------------------------------------------- document.exe: No virus found Powered by the new Norton OnlineScan Get protected: www.symantec.com

1 0