October 2005 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Catching up with you
by Alexander M. Turek 20 Nov '05

20 Nov '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi guys, As you have noticed, I have been busy for some while. Because of this, I've hardly followed the discussions on the mailing lists and now I'm trying to catch up with the development, again. Could you guys give me a little update? ;-) Just some things I noticed while testing HEAD: 1) The interface scaling is partly broken, as far as I can see. With the default theme, all the text is displayed way too large - except for the optgroups in the database selection. With the darkblue / organge theme, it looks better, but there are still some places, where table captions are displayed too large. I noticed, that you've worked on some XHTML-related stuff, so I guess this is still under contruction? I could provide screen shots, if you want me to. 2) On server_status.php, I noticed that you have devided the variables into groups and added small descriptions. Well, at least for the different storage engines, I started doing the same on server_engines.php. For some variables, we now have even redundant descriptions in our lang files. :-/ Regarding the fact, that server_status.php has become quite large, I'd suggest to move the stuff that is related to a specific storage engine to server_engines.php and libraries/engines. 3) I have worked on a code splitup of server_privileges.php in order to implement the new MySQL 5 privileges, including the new privilege level and removing all "SELECT ... FROM mysql" queries on MySQL 5. I had to stop because of some bugs in MySQL 5, that have been fixed meanwhile. Is anyone working on the privilege system right now? Otherwise, I'd resume my work and try to merge it with the changes you have made during the time I've been inactive. Regards, AMT -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDVoCH8c/ssWf/SMcRAnF6AKCsNljPChPV69LOIsStc/+1nT1BcwCfRuYo MQ772WyWvaSDadcrR5fQfDM= =v8Xd -----END PGP SIGNATURE-----

5 32

[Phpmyadmin-devel] MySQL 5 strict
by Sebastian Mendel 09 Nov '05

09 Nov '05

Hi, please can anybody heavily test with MySQL 5 in strict mode, as there are many errors with current PMA! http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#id2968483 Sebastian

4 9

[Phpmyadmin-devel] Is <base href="..." /> needed?
by Michal Čihař 30 Oct '05

30 Oct '05

Hi all is there any reason why we need to explicitly define this? -- Michal Čihař | http://cihar.com

3 4

[Phpmyadmin-devel] Re: [Phpmyadmin-cvs] CVS: phpMyAdmin favicon.ico,NONE,2.1 ChangeLog,2.1496,2.1497 index.php,2.17,2.18
by Marc Delisle 29 Oct '05

29 Oct '05

Sebastian Mendel a écrit : > Update of /cvsroot/phpmyadmin/phpMyAdmin > In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26339 > > Modified Files: > ChangeLog index.php > Added Files: > favicon.ico > Log Message: > added favicon.ico > > --- NEW FILE: favicon.ico --- Hi Sebastian, This favicon was suggested in April. Marc

2 1

[Phpmyadmin-devel] New demos
by Michal Čihař 29 Oct '05

29 Oct '05

Hi all I just set up new demo server. It's hosted on free vserver service provided by pipni.cz, so there is no guarantee at all, however for demo puproses it is good enough :-). The demo runs on MySQL 5 (right now in strict mode), provides both stable version and current CVS HEAD. I didn't yet play with configuration so both use defaults. You can mess there with privileges, they are restored to default set every 10 minutes, each night databases are emptied. Demo listing on our web has been updated, all demos are run at <http://pma.cihar.com>. -- Michal Čihař | http://cihar.com

2 2

[Phpmyadmin-devel] server_privileges.php no longer respects the chosen initial
by Marc Delisle 29 Oct '05

29 Oct '05

Hi, I would like to merge https://sourceforge.net/tracker/index.php?func=detail&aid=1341647&group_id=… Marc

2 1

[Phpmyadmin-devel] true number of rows for tables
by Marc Delisle 26 Oct '05

26 Oct '05

Hi, Here is a recent change in db_details_structure.php, line 351: <td class="value"><?php echo PMA_formatNumber( $display_rows ); ?></td> I think we should not use PMA_formatNumber(), because we lose the exact count of rows when it's available (for example, MyISAM). Marc

3 4

[Phpmyadmin-devel] CREATE USER
by Marc Delisle 26 Oct '05

26 Oct '05

Hi Sebastian & list, ------- Update of /cvsroot/phpmyadmin/phpMyAdmin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8321 Modified Files: ChangeLog server_privileges.php Log Message: MySQL 5 requires CREATE USER before GRANT ----------- I am using MySQL 5.0.13 and was always able to create a user with a GRANT command. Marc

2 1

[Phpmyadmin-devel] 2.7.0 schedule
by Marc Delisle 24 Oct '05

24 Oct '05

Hi, We are supposed to freeze new messages today, and send a message to the translators. I suggest to freeze the features today also, so: 2005-10-23: feature freeze, opening of QA_2_7_0 branch, intensive testing period 2005-11-06: 2.7.0-beta1 Does the team agree? Marc

2 2

[Phpmyadmin-devel] tooltip pollutes event handler
by Sebastian Mendel 24 Oct '05

24 Oct '05

Hi, as i tried to replace the mark and hover javascript code with one changing the class und added globaly as event handler i recognized in opera and IE that applying another class is very slow in phpMyAdmin i figured out that the tooltip.js captures too much events possible we can switch to use overLib https://sourceforge.net/projects/overlib/ -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

2 1

[Phpmyadmin-devel] phpMyAdmin 2.6.4-pl3 and security alert
by Marc Delisle 22 Oct '05

22 Oct '05

Hi, phpMyAdmin 2.6.4-pl3 was released today, to fix security problems. Security alert: http://www.phpmyadmin.net/home_page/security.php?issue=PMASA-2005-5 Download details: http://www.phpmyadmin.net Marc Delisle, for the team

1 0

[Phpmyadmin-devel] mysql(i)_real_escape_string()
by Sebastian Mendel 21 Oct '05

21 Oct '05

Hi, how does phpMyAdmin normaly escapes string inserted in sql querys? or why is there no function like PMA_DBI_escapeString() ? -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

2 1

[Phpmyadmin-devel] broken exporting from db panel
by Marc Delisle 21 Oct '05

21 Oct '05

Hi, this breaks Export (from db panel) http://cvs.sourceforge.net/viewcvs.py/phpmyadmin/phpMyAdmin/db_details_db_i… because in db_details_export.php, we are using $tables[$i]. Marc

2 2

[Phpmyadmin-devel] query window and Run SQL queries
by Marc Delisle 19 Oct '05

19 Oct '05

Hi, Thanks Sebastian for the resync of the query window when switching db in the left panel. Now, in the query window, the Run SQL query/queries on database ____ enables to click on the db name itself, but the result is displayed in the query window; IMO it should go in the right panel. Marc

2 5

[Phpmyadmin-devel] losing login credentials under MySQL 5.0.13
by Marc Delisle 19 Oct '05

19 Oct '05

Hi, in current HEAD, after a cookie-login with a super-user, I choose a db from the left frame and boom, I'm back to login panel. No bug under MySQL 4.1.x. Someone can confirm? This would motivate me to look for this nasty bug :) Marc

3 7

[Phpmyadmin-devel] pma_history and table&db
by Michal Čihař 18 Oct '05

18 Oct '05

Hi all in all our tables we use db_name and table_name, however in history there is just db and table. This causes problem when somebody exports it without backticks (support #1326579 [1]). Do you think we should switch pma_history to db_name and table_name? It would mean including backward compatibility code to work with both situations. 1.https://sourceforge.net/tracker/index.php?func=detail&aid=1326579&group_i… -- Michal Čihař | http://cihar.com

2 2

[Phpmyadmin-devel] QueryFrame -> QueryWindow
by Sebastian Mendel 17 Oct '05

17 Oct '05

Hi, i would like to replace $cfg QueryFrame und QueryFrameJS by QueryWindow - allways display SQL icon in left frame QueryWindow = true - always opens the QueryWindow (from left frame and from 'edit sql' in sql tab) QueryWindow = false or not js capable browser - always opens sql tab QueryWindow = 'left' or 'onlyleft' or ? - from query icon in left frame opens QueryWindow - from 'edit sql' in sql tab open query in sql tab with last default beeing default -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

3 4

[Phpmyadmin-devel] phpMyAdmin meets OpenUsability
by Michal Čihař 16 Oct '05

16 Oct '05

Hi all inspired by todays workshop on OpenWeekend [1], I decided to register our project on OpenUsability [2], so that we can receive feedback from usability experts, if our project will be interesting for some of them. I expect I can handle feedback from there myself and forward important stuff to our trackers or mailing lists, however if you want to participate, feel free to join project [3] there (registration required). 1. http://openweekend.cz/index.php?lang=1 2. http://www.openusability.org 3. http://www.openusability.org/projects/phpmyadmin/ -- Michal Čihař | http://cihar.com

2 2

[Phpmyadmin-devel] Team members?
by Michal Čihař 15 Oct '05

15 Oct '05

Hi all it looks like development team has been cut down to Marc, me, our new member Sebastian and sometimes Gavin gives some comments. Any information about rest? Maybe it's time to clean up list of developers on sourceforge? FYI last commits (this is information I can easily acquire and doesn't tell much) for selected users: rabus 2005-06-24 mkheck 2005-03-08 robbat2 2005-07-11 swix 2005-06-12 BTW: Is anybody taking care on themes tracker right now? -- Michal Čihař | http://cihar.com

3 3

[Phpmyadmin-devel] Re: Icons
by Marc Delisle 15 Oct '05

15 Oct '05

Hi Michael, glad to read you'll be back on the project! Those ideas are exciting, but I think that they should go in 2.7.1. Right now we should be busy stabilizing for 2.7.0-beta1 scheduled on 2005-11-06. Message freeze will occur on 2005-10-23. If we open QA_2_7_0 right now, I'm afraid we will have much duplicate work to do for bug fixing (there are show-stoppers right now in the bug tracker), so I would like to open it only on 2005-10-30. Then you (and others) could start playing on HEAD. Unless someone objects and finds that adjusting themes (the current way) for 2.7.0 is too complex. Marc Michael Keck a écrit : > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi Members, > > I like this Icons to ;) > Are the Icons free? Can we use them without any limitations? > And are there all by PMA needed Icons available? > > Next week I'm back again from my holidays and my job for the big project > is done, so I will find more time to work on the pma project. > > I've making some tests with template files to work with separate layout > files, application files and xml-configs. > > So it would become easier to work with themes, languages and styles. > And of course I'm thinking we can make a brand for 'PMA-Lite'? > > Next week I will start to build the template based PMA on the latest > CVS-Snapshot. Should we make a new testing plattform for these? > > Regards > Michael Keck > > > - --- Original Message --- > Mail from: Sebastian Mendel > Date: 14.10.2005 10:29 > >>Michal Čihař wrote: >> >> >>>Hi >>> >>>On Thu 13. 10. 2005 12:11, Sebastian Mendel wrote: >>> >>> >>>>possible we can switch to the Tango-Icons >>>> >>>>http://tango-project.org/Tango_Icon_Gallery >>> >>> >>>I looked at those when the project has been announced, however there >>>is too few icons we can use right now. >> >> >>yes, of course, when they are available ... ;-) >> >> >> >>>Anyway I'd prefer new theme for those over replacing icons in one of >>>existing. >> >> >>i don't think so, i would prefer this types of icon in the default >>theme, one good reason: we could make use of the svg images (wether by >>detection or by a configuration switch) making it more easy to make PMA >>more WAI conform >> >>btw. i don't like this Microsoft Access style icons much ... >> >>and this icons are designed by GUI specialists - i think they know what >>they are doing and why. >> >>if we implement this icons (whenever) we could rename the current theme >>to 'classic'

1 0

[Phpmyadmin-devel] $strShowStatusThreads_cachedDescr
by Marc Delisle 14 Oct '05

14 Oct '05

This message looks weird to me: $strShowStatusThreads_cachedDescr = 'The number of threads in the thread cache. The cache hit rate can be calculated as threads_created/Connections. If this value is red you should raise your thread_cache_size.'; Seems to me that the second part is an explanation for Threads_cache_hitrate_% Marc

3 2

[Phpmyadmin-devel] current HEAD, MySQL 4.0.x and mysqli
by Marc Delisle 14 Oct '05

14 Oct '05

Hi, can someone reproduce this? HEAD no longer works correctly with MySQL 4.0.x, with mysqli extension. Many symptoms occur, for example: structure only shows the first 7 fields of a table; insert no longer works, etc. Looks like the output of SHOW FIELDS, when fetched in a loop by PMA_DBI_fetch_assoc(), stops after reading the 7th row. Same server works well with QA_2_6_4 + mysqli extension. Works well with HEAD + mysql extension. I know that mysqli is targeted to MySQL 4.1.x+, but... Marc

3 4

[Phpmyadmin-devel] generall about devel mailings
by Sebastian Mendel 13 Oct '05

13 Oct '05

Hi, i would prefer if ALL messages related to development, whether they are addressed to specific developers or not, would come through this list at least for me: - no messages can get lost in spam filter - i notice problems not affecting my code but i can have also an eye on this (f.e.) the new import system - i didn't noticed any of the problems Marc reported to Michal (he mentioned in a mail before) - i have all pma-dev related mails in one folder - and for the archive stuff ... -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

2 2

[Phpmyadmin-devel] Import switched
by Michal Čihař 13 Oct '05

13 Oct '05

Hi all I just switched all SQL splitting to new import system. I'd like to especially thank to Marc for testing it and giving me nice feedback. I tried to test all possible code paths, but there still might me minor problems, so please test it and send me feedback (bug tracking is preferred as you probably won't be the only one facing problems). -- Michal Čihař | http://cihar.com

3 3

[Phpmyadmin-devel] Icons
by Sebastian Mendel 13 Oct '05

13 Oct '05

Hi, possible we can switch to the Tango-Icons http://tango-project.org/Tango_Icon_Gallery -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

2 2

[Phpmyadmin-devel] Registration / Installationstatisitics
by Sebastian Mendel 13 Oct '05

13 Oct '05

Hi, how about add an 'Registration' in main.php which leads to local registration form this form could collect, of course after explaining and asking for permission: - number of servers/databases/tables handled with this installation - currently installed versions of PHP, PMA, MySQL - used extension mysql, mysqli - changed configuration (different from default) - used theme - registration information (email, name, company, ... ) - hash of installation path (as unique id for installation) - hash of server connection string (as unique id for servers) - a free textfield for additional comments this can be stored local, or at least a hash over all, to recognize changes and update registration and of course in the phpMyAdmin project database so we can - make most used settings to default - send security alerts on specific versions - statistics on used versions - and much more ... -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

4 7

[Phpmyadmin-devel] Import rewite
by Michal Čihař 13 Oct '05

13 Oct '05

Hi all I finally managed to make new import in some state, I'm ready to publish it a bit. It's available in patch tracker [1]. As you can read in patch tracker, basic goals of this rewrite are: - plugin based import system - LOAD DATA independent CSV loading - time/memory limit workarounds - default configuration of import stored in config Current state is not yet complete. Plugin architecture is there, it should correctly deal with php time/memory limits. However design is probably not final and there are still some things need to be fixed (charset support, finalizing CSV plugin, etc.). If you have time, you're welcome to provide this some testing. Thanks! 1. https://sourceforge.net/tracker/index.php?func=detail&aid=1288933&group_id=… -- Michal Čihař | http://cihar.com

3 5

[Phpmyadmin-devel] release schedule for 2.7.0 ?
by Sebastian Mendel 13 Oct '05

13 Oct '05

hi, is there any release schedule for 1.7.0? -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

3 5

[Phpmyadmin-devel] using md5(table_name) for identifying a table in PMA_showMessage()
by Sebastian Mendel 11 Oct '05

11 Oct '05

Hi, PMA_showMessage() in common.lib.php uses md5() for generating the table-id, why md5() why not cleartext? and second: why only the table-name? the table is not unique if you have more than one db ... i would change this, if no one complaints. -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

2 1

[Phpmyadmin-devel] XHTML compliance patch, PLS TEST!
by Sebastian Mendel 11 Oct '05

11 Oct '05

Hi, i've done a little rewriting of all this qerywindow javascript stuff, coming with this is * XHTML comlinace at least in index.php and left.php * more semantic XHTML * moved all styling into css * url param support for index.php (index.php?db=mysql) * less JavaScript * better support for non JS Browsers * ... https://sourceforge.net/tracker/index.php?func=detail&aid=1312571&group_id=… -- Sebastian Mendel www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet

4 14

[Phpmyadmin-devel] phpMyAdmin 2.6.4-pl2 and security alert
by Marc Delisle 11 Oct '05

11 Oct '05

Hi, phpMyAdmin 2.6.4-pl2 was released today, to fix a security problem. Security alert: http://www.phpmyadmin.net/home_page/security.php?issue=PMASA-2005-4 Download details: http://www.phpmyadmin.net Marc Delisle, for the team

1 0

[Phpmyadmin-devel] use of session_name()
by Marc Delisle 11 Oct '05

11 Oct '05

Hi, we have a problem on our (new) demo on sf.net, because of the call to session_name('phpMyAdmin') in libraries/session.inc.php. This is not supported on sf.net. Do we really need this in the code? Or can we detect in advance this problem? Marc

2 2

[Phpmyadmin-devel] Unused messages
by Michal Čihař 08 Oct '05

08 Oct '05

Hi all it's time to cleanup translations ;-). Following messages seems not to be used anywhere in our code. Any objections to remove them? strBinaryLogCache strBookmarkOptions strCarriage strEngineDisabled strIfYouWish strInsertBookmarkTitle strInsertTextfiles strInstructions strLineFeed strLoadExplanation strLoadMethod strMoreStatusVars strMustSelectFile strNeedPrimaryKey strNoQuery strOftenQuotation strOptionalControls strOptionally strPHP strPos strPrivDescAlterDb strReplace strRoutines strSearchOption strSearchOption strSearchOption strSearchOption strTheContents strTheContent strTheTerminator -- Michal Čihař | http://cihar.com

2 3

[Phpmyadmin-devel] MySQL 5.0.13 'view' becomes 'VIEW'
by Sebastian Mendel 05 Oct '05

05 Oct '05

SHOW FULL TABLES now returns 'VIEW' instead of 'view' should phpMyAdmin recognice both? or cause 'view' was only used in BETA drop support for 'view' and now only support 'VIEW' (beside this that at the moment PMA only supports 'view' and reports an error on MySQL 5.0.13) -- Sebastian Mendel www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet

3 6

Re: [Phpmyadmin-devel] XHTML compliance patch, PLS TEST!
by Sebastian Mendel 04 Oct '05

04 Oct '05

Garvin Hicking wrote: > Hi! > >>> https://sourceforge.net/tracker/index.php?func=detail&aid=1312571&group_id=… >>> 067&atid=377410 >>> >> i would like to commit this into CVS, if no one is against. >> >> Marc? Michal? > > I think this portion: > > +foreach( $_GET as $key => $val ) { > + if ( ! in_array( $key, $drops ) ) { > + $url_querys[] = $key . '=' . $val; > + } > > allows for XSS attacks to index.php which outputs remote input HTML/JS code. uuh, sorry fixed this with $url_querys[] = urlencode( $key ) . '=' . urlencode( $val ); > Added to that, it seems your patch kills the $cfg['LeftFrameTableSeparator'] > functionality of nested table groups in non-light mode. It seems you removed all > the PMA_nestedSet() functionality without proper replacement of its content? did you tried? or took you just a look at the code? $cfg['LeftFrameTableSeparator'] is respected and should be properly displayed - if not pls give me an example of your settings, what you expect and what you got thnx -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

3 8

[Phpmyadmin-devel] Re: PMA server_privileges.php
by Sebastian Mendel 03 Oct '05

03 Oct '05

Marc Delisle schrieb: > Hi guys, > > I am currently working on adding MySQL 5 privileges to > server_privileges.php, > so please do not commit anything on this script for a few days. > > Thanks, did you finished? what about `mysql`.`db`.`Execute_priv`? `mysql`.`user`.`ssl_*` and `x509_*` and `max_user_connections` -- Sebastian Mendel www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet

2 2

[Phpmyadmin-devel] Translators list
by Michal Čihař 03 Oct '05

03 Oct '05

Hi as I'm constantly being spammed by those messages "I'm idiot and don't read anything" from translators.html, I'd like to see some better solution for this. First problem comes from people not understanding English, so they just write bellow our message Czech request for translation. This could be solved either by translating message for each language in html file or converting to php and using similar translation system as in rest of phpMyAdmin. However the majority of messages are just plain copies of our one. I have no idea why people are so stupid and I actually do not see way how to make sending feedback possible, but more restrictively saying that there should really written something. Anyway I thing we need to localise these messages, this should lower a bit this spam rate. Comments? -- Michal Čihař | http://cihar.com

2 2

[Phpmyadmin-devel] MySQL 5.0.13 'view' becomes 'VIEW'
by Sebastian Mendel 02 Oct '05

02 Oct '05

SHOW FULL TABLES now returns 'VIEW' instead of 'view' should phpMyAdmin recognice both? or cause 'view' was only used in BETA drop support for 'view' and now only support 'VIEW' (beside this that at the moment PMA only supports 'view' and reports an error on MySQL 5.0.13) -- Sebastian Mendel www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet

1 0