kodstationen

Can someone please guide me in the right direction here. A client of mine tries to connect to my server as a replication slave. The connection has worked before. I can't give much more information about my clients setup other than that he is using MAMP on a notebook. And as I've said; The connection has worked in the past (a couple of months ago). The error log: Någon som kan hjälpa mig med följande error-log: 090415 22:43:12 [ERROR] Slave I/O thread: error connecting to master 'repl@server0.kodstationen.se:9999': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 61' errno: 2013 retry-time: 60 retries: 86400 090415 22:44:21 [Note] Slave I/O thread killed while connecting to master 090415 22:44:21 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000019', position 526096132 090415 22:44:21 [Note] Error reading relay log event: slave SQL thread was killed 090415 22:44:29 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000019' at position 526096132, relay log '/Applications/MAMP/tmp/mysql/mysql-relay-bin.000001' position: 98

I'm sorry about not updating this post since I figured out that it was an trigger that caused the error.The trigger was defined (by the dump) by another user. Adding the user to the slave solved the problem. And I'm sorry that I didn't read the guidlines for the board... :-\

Ok, so I passed the exam last friday. I thought it was a bit tougher than the mock exams acctually. I don't know how well I did, just that I passed and that I definitely didn't get everything right. IMHO, if you took the test totaly unprepared and passed, then an "easy" test like this is perfect to show that you're skilled. But when you prepare for it, especially by using the mock exams, the test isn't such a good measure for your skill level. I think the php community should set up a hardcore php certification. As I see it it should be set up as follows: - Use the different fields that is covered in the zend exam - Use really difficult questions that is some how real world related (something you can't say about the zend exam's questions) - Have an offline version of php.net at your disposal as only help - Have 24 hours to complete the test - Let it be free of charge (or as close to free as is possible) the first time you try it. And let it be real expensive to take it a second time (to finance the cost to get a second/third/forth set of questions for the test) - Have an 90-100% pass grade. - If you pass ONE area (of the fields that are covered) you are "hardcore php certified". So you get a diploma that sates that you are a "hardcore php5 (or php6) certified engineer" and at closer inspection (in the fine print, or in the yellow pages (following zends standard)) it list which fields you are certified in. I really would like to be involved in something like this and I think it is the only way to go to convince people that you're truly top of the crop. If I look at my own skills today I should not be able to pass the test as I vision it.

I agree with you completely. But when you live and operate in a country where each and every kid is hacking php and there is a total of 11 certified engineers that paper could mean business...

Can't you just output the tables as a comma-separated list and import it as a csv file into Excell? Something like: header("Content-Type: text/csv"); header("Content-Disposition: attachment; filename=\"test.csv\""); header('Vary: User-Agent'); header("Cache-Control: cache, must-revalidate"); header('Pragma: public'); $r = mysql_query("select * from table"); while ($row = mysql_fetch_array($r)) { echo '"'.implode('","',$row).'"\n"; } (for the purpse of simplicity I don't care about good coding practices here...)

Just tried a mock exam for Zends PHP Certification. One thing that struck me as odd was that I passed the over all test but faild some categories in the test. Will the true certification exam behave the same way? Can I pass the exam even though I faild the questions about Arrays or Database programming?

Hi! I'm new to this board, but not new to php or mysql. I have a client that runs a slave database from my master mysql database. However, after a crash on the slave we dumped the master db and my client restored his db from the dump. He started the replication again from my instructions but gets the following error where checking show slave status: "Error 'Access denied; you need the SUPER privilege for this operation' on query." The query is an INSERT statement Isn't this done by the replication user? That user only have replication privileges... Anyont know how to get it right? /Bobo - web developer for Kodstationen AB, Sweden