How to fix phpmyadmin error: “Connection for controluser as defined in your configuration failed”

January 3rd, 2011 by rvdavid 9 comments »

“Connection for controluser as defined in your configuration failed” It’s one of those small, annoying messages that appear out of the way on your screen, but still catches your eye once in a while especially when you’re deep in thought about how to building a multi-join query in the SQL tab of phpmyadmin.

Well, it annoyed me today so much that I finally decided to do something about it and finally take a look. I opened up the PHPMyAdmin config file located at /etc/phpmyadmin/config-db.php  on Ubuntu Maverick Meerkat. There’s a default username and password in $dbuser and $dbpass variables.

Now my knee jerk reaction to this would have been “no problem I’ll just change that to my root username and password.” which will work by the way, but I decided against it since the control user for PHPMyAdmin did not really need to have access to all the other databases in my local cluster.

» Read more: How to fix phpmyadmin error: “Connection for controluser as defined in your configuration failed”

ContentPane in dojo not loading scripts? This is how you fix it.

December 16th, 2010 by rvdavid 8 comments »

I was planning on writing my first enquiry on how to do something in dojo, but just before I pressed the submit button, I thought I’d look into one more thing and as the saying goes – “it’s always in the last place you look” (probably because you stop looking after you find whatever it is you’re looking for).

So the problem I had was that I wanted to load a datagrid inside a contentPane in a pet project my newbie friends and I are using to sharpen our Zend Framework skillz.

I’ve been idle (and will continue to be for the rest of the year) so all my tickets are pretty much at a stand still. This included a ticket which reports that a remote datagrid does not load properly in chromium / google chrome, but loads fine in Firefox. But seeing as I have a few hours to kill from being idle (development wise, but actively looking after family) , I thought I’d do an idle search into why this was happening. Dojo could not possibly have a bug, there must be some magic attribute that needed to be set which would make it all better.

So I started my search. Looking for things like “ContentPane not loading datagrid in tabContainer dojo” through to “javascript events not firing in contentPane dojo dijit” for those of you who look for answers to advanced questions when it comes to the dojo toolkit, you know how teeth-gnashingly frustratting it is to look for answers.

A couple of them mentioned “executeScript” attribute, but that was from ages ago, so I tried it a couple of times to no avail in dojo 1.5 then gave up looking for answers that use executeScript attribute.

» Read more: ContentPane in dojo not loading scripts? This is how you fix it.

Happy Holidays everyone — Winding down to hiatus mode.

December 10th, 2010 by rvdavid 2 comments »

Well, as fast as my wheels were turning for the past few weeks, I’ve decided to slow down for the holiday season and spend some time with the family.

To me, there is nothing better than _quality_ time with family – big emphasis on “quality” because when I’m in work mode, I’m always half thinking about work even when I’m sitting on the couch watching TV.

For me, now is the time to not think about work and spend time with, and think about what I’m really working for. This is also a good time to reflect on my goals for next year.

» Read more: Happy Holidays everyone — Winding down to hiatus mode.

Analysis Paralysis: In a quest for perfection, I manage to achieve nothing

December 4th, 2010 by rvdavid 3 comments »

This was supposed to be a live coding note, but it just turned into something else. No ground breaking news, no new concept which will make you go “hmmm”, just a guy kicking himself – you can safely ignore this frustrated post if you aren’t in the mood to read about how much an idiot I think I am :P

It’s been a mixture of Tunnel Vision, NIH Syndrom and Analysis paralysis that had me living in a haze of trying to implement DataMappers ala Zend Quickstart Guide on and off, for the past 4 weeks.

I even wrote the Unit Tests and everything for this project I’ve taken part in called “customember”: a sample project to help a few newbies I know (and to a certain extent myself) skill up through practical experience rather than going into a real world project and doing the floundering around when the gun is really loaded.

» Read more: Analysis Paralysis: In a quest for perfection, I manage to achieve nothing

Unit testing with Live Databases and/or How do I use Mock Objects?

November 30th, 2010 by rvdavid 9 comments »

This is another live coding note. I’ve found my rhythm with TDD and currently bashing away at some unit tests for the Models and Service layers for a project I’m working on.

In tonights post, I’m going to write about how I get around with Unit Testing live databases.

Unit Testing with Live Databases

For my unit tests, I’m currently working with a live test database since I don’t fully understand the “power” of mock objects. If you have any links out there that’s worth noting, please be a friend and “link me”. I’m not going to pretend that I know everything and anything about Web Development. I know a lot, but the one thing that I do know is that I don’t know everything.

Mock Objects. WTF are you?

One thing which is mostly a mystery to me is the concept and practical application of Mock Objects in Unit testing. I’ve read several articles on Mock objects, but some of them delve into how to create Mock Objects rather than practical usage for mock objects in a live development setting. What problem exactly are mock objects trying to solve?

I get that it replaces other objects that the current class your testing will collaborate with, but I’m guessing that this is due to not having a setup like I currently have where I have the extra application code which easily gives me access to the db resource so that I can just as easily do this within my unit test as it would with mock objects… maybe? I’m confused.

» Read more: Unit testing with Live Databases and/or How do I use Mock Objects?