September 2009 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Replication support & code style
by Herman van Rink 16 Oct '09

16 Oct '09

Hi, These last few days I have been playing with the code for replication and the related synchronization code. I regret not having had the time this summer to test this earlier.... But the impression I get is that the code has only been tested in a limited scenario. Some of the following points could be considered "nice to have's", but I wanted to at least note them. At every step I run into problems: 1) The added replication user missed the privileges to even query for the master info (REPLICATION CLIENT) 2) Synchronisation is only made possible directly after setting the master info. But for this the replication user requires even more privileges. So there should be some way to use different credentials for this. 3) When syncing it fails me either with : Fatal error: Allowed memory size of x bytes exhausted or Backtrace from warning 'Invalid argument supplied for foreach()' at svn_root/trunk/phpMyAdmin/libraries/server_synchronize.lib.php 641: The memory problem occured when the database to sync was larger then the php's memory_limit. But increasing this to N*10 was still not enough :(. 4) There should be a way to change the Binlog_Do_DB and Binlog_Ignore_DB. Although this requires manual editing the my.cnf why not reuse the initial form to make this clear? 5) There should be a way to set Replicate_Do_DB on the slave. We could reuse some code from the master config generator for this. 6) Why not include a small list of slaves for a configured master? SHOW SLAVE HOSTS; should provide this data 7) The code style and HTML validity are standards are not met. Indentation, newlines ( I saw a dos2unix was needed by Michal), overall structure in harmony with the style guidelines Could we add this to the list of 'things to check' on future GSOC's? In conclusion, I would like to ask the GSOC students to look over the svn diffs from the last few days which relate to the new code. If you are willing to help in fixing similar problems then that's great, but at least try to learn from them. -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions

3 5

[Phpmyadmin-devel] Fosdem 2010
by Herman van Rink 15 Sep '09

15 Sep '09

Hi, Like every year I plan to attend FOSDEM in Brussels on 6 and 7 February 2010 (http://fosdem.org) Anyone else from the pma community? -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions

3 6

[Phpmyadmin-devel] phpMyAdmin 3.2.2 is released
by Marc Delisle 13 Sep '09

13 Sep '09

Welcome to phpMyAdmin 3.2.2, a bugfix-only version. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team ---- http://infomarc.info

1 0

[Phpmyadmin-devel] phpMyAdmin 3.2.2-rc1 is released
by Marc Delisle 05 Sep '09

05 Sep '09

Welcome to the first release candidate for phpMyAdmin 3.2.2, a bugfix-only version. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team --- http://infomarc.info

1 0

[Phpmyadmin-devel] handling of arbitrary binary data
by Marc Delisle 01 Sep '09

01 Sep '09

Hi, At some places in phpMyAdmin we output binary data and I was told that this might be violating UTF-8. I'm looking for ideas about a function that would trim illegal characters. I know that in some places we use bin2hex() but I would not like this approach in this case. Thanks, -- Marc Delisle http://infomarc.info

1 0