November 2004 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] MySQL 4.1 and column comments
by Alexander M. Turek 28 Jan '05

28 Jan '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi list, There's a small change that I'd like to see in 2.6.1, but I don't have the time to implement it. MySQL 4.1 supports adding comments on column level. Afaik, phpMyAdmin only supports its own column comments, but not MySQL's native ones. On top of that, I think that column comments don't fit into the relation overview. I'd rather move the interface to the table structure editor. This should be the preferred way to perform this operation. Comments? Regards, AMT -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) iD8DBQFBqfNM8c/ssWf/SMcRAnKnAJ49xllPYAspKmjU3GCJUI1ei2jf1gCeLX0D BcOZFpe7X0TR8VNAvpPF6RM= =eH72 -----END PGP SIGNATURE-----

5 9

[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

[Phpmyadmin-devel] utf-8 truncating and mbsting
by Michal Čihař 23 Nov '04

23 Nov '04

Hi if in utf-8 mode, we try to use mbstring functions for work with strings, to work correctly with multibyte chars. However we do not suggest adding mbstring anywhere, so it leads to bug reports like 1063149 [1]. The question is how to warn users about this. Warning on main page if mbstring is not found and using multibyte charset or just notice in documentation or something else? 1. https://sourceforge.net/tracker/index.php?func=detail&aid=1063149&group_id=… -- Michal Čihař | http://cihar.com

2 1

[Phpmyadmin-devel] speed optimization
by Marc Delisle 19 Nov '04

19 Nov '04

Hi, Since we received a message on the users list about this, I made some comparisons between 2.6.0-pl2 and 2.5.4. I am quite surprised to see 2.5.4 being 3-4 times quicker in routine operations like cookie login, changing db, going into Structure page for a table, etc. Removing all the js setTimeout does not improve the situation much. (Those could be eventualy made conditional to the Safari browser.) So I am hunting to find what happened.... Stay tuned (or help me :) My goal is to restore 2.5.4 speed for 2.6.1 ! Marc

2 6

[Phpmyadmin-devel] phpMyAdmin 2.6.0-pl3 and security alert
by Marc Delisle 18 Nov '04

18 Nov '04

Hi, Patch level 3 of phpMyAdmin 2.6.0 has been released, fixing some XSS vulnerabilities. Our PMASA-2004-3 security announcement gives more details and further references. The announcement and downloads details are available at http://www.phpmyadmin.net Marc Delisle, for the team

1 0

[Phpmyadmin-devel] Input Transformation System
by Garvin Hicking 18 Nov '04

18 Nov '04

Hi All! (Kyle, I CC'ed you to draw your attention here) While digging through our SF.Net request tracker, I spotted a rather nice feature request: https://sourceforge.net/tracker/?func=detail&atid=377411&aid=1061133&group_… Basically it's about allowing users to hook into our editing/insertion system, just like the Transformation system now does for displaying data. I do think this is a very worthful addition for PHP-Developers working with PMA. The implementation is quite straight-forward and should be implementable with enough time (but without any serious problems) - I outlined my imaginations in the feature tracker. My time currently is quite limited, so if Kyle can take on the job, that would be perfect. If he doesn't have time I still would love to see this feature implemented, and I'd try to work on it in Januar/February, where I should have more time. The only thing I'm a bit afraid of is that this needs a change of our PMA DB structure, and how to best upgrade tables. Anyways, that can be dealt with later. ;) Regards, Garvin. -- ++ Garvin Hicking | Web-Entwickler [PHP] | www.supergarv.de | ICQ 21392242 ++ Developer of | www.phpMyAdmin.net | www.s9y.org ++ Make me happy | http://wishes.garv.info

4 3

[Phpmyadmin-devel] phpmyadmin ported to XUL?
by Matt Alexander 15 Nov '04

15 Nov '04

Is there any interest in porting phpmyadmin to XUL? Any estimates on how difficult this would be? Thanks, ~M -- Get Firefox! http://www.mozilla.org/products/firefox/

2 1

[Phpmyadmin-devel] WG: MySQL ConCom 2004
by MK Keck 02 Nov '04

02 Nov '04

Should I do something like this ... ? Regards Michael > -----Ursprüngliche Nachricht----- > Von: Georg Richter [mailto:georg@mysql.com] > Gesendet: Montag, 1. November 2004 12:58 > An: garvinhicking(a)users.sourceforge.net; lem9(a)users.sourceforge.net; > mkkeck(a)users.sourceforge.net; nijel(a)users.sourceforge.net; > rabus(a)users.sourceforge.net > Betreff: MySQL ConCom 2004 > > > Hi all, > > hopefully some of you will be awake... :) > > We need the phpMyAdmin logo for the conference brochure and booth sign > within the next 3 hours :( If possible in eps format. > > Thanks! > > /Georg > -- > Georg Richter, Senior Software Developer > MySQL AB, www.mysql.com > > See you at MySQL ComCon Europe November 8-10! > www.mysqlcomconeurope.com > > >

3 4

[Phpmyadmin-devel] main.php and control user
by Marc Delisle 01 Nov '04

01 Nov '04

Hi, I just merged a change in main.php. Please test it: under MySQL 4.1.2+ the control user no longer needs any privilege on the mysql db. If everything is fine, I will change the doc. Thanks, Marc

1 0