[BlueOnyx:08627] Re: MySQL

[Michael Stauber]

Hi Martyn,

> Crumbs, I've been subscribed to this list since 6th Jan 2009 - and
> this is the first time I've managed to get 'The Management' to allow
> me to migrate from Blue Quartz to Blue Onyx!

Oh oh. But better late than never. :o)

> Anyway, just installed BlueOnyx-5107R-SL-6.1-20110913 in one of
> our Dell Poweredge 1425s and I'd have to say (and so sorry to
> Hisao) it looks very good indeed.

Thank you!
 
> However, the downside is going to be that I've a reasonably steep
> learning curve to go through, and the first is that although enabled
> in Server Management > Netword Services, MySQLstatus is
> saying:
> 
> "MySQL connection cannot be established. Check settings."

Yeah, with MySQL it's like this:

There are some parts of our GUI that need to know your MySQL "root" password. 
It needs to know it in order to automatically create MySQL users and MySQL 
database for Vsites. This is of course optional.

Likewise, our built in phpMyAdmin will login users automatically into 
phpMyAdmin with the right username and password suiteable to their privilege 
levels. Provided the GUI "knows" the MySQL "root" password.

I guess you already changed your MySQL "root" password through means other 
than the GUI. Which is fine. But now you need to go to "Network Services" / 
"MySQL" and on the first of the three tabs you see there, it asks for your 
current MySQL"root" password. The 2nd tab lets you change the password, by the 
way, while the third tab allows you to perform a MySQL dump.

Once you have entered the current MySQL "root" password (twice) in the first 
tab, the MySQL status will change and it will tell you that the GUI can now 
connect to MySQL.
 
> So, this is mt first of many "I'm not really a clueless newbie,
> honest" queries - there will be many more to come, I assure you.

Sure, bring them on. :-)
 
> BTW - Michael Stauber, did you ever release MyDNS as a
> package for BO/BQ?

Yes and no. I have a MyDNS PKG for BlueQuartz and I'm actually still using 
MyDNS myself. Never got around to market it off my site, or to build a 
BlueOnyx version of it. There was just too little demand to make it 
worthwhile.

But as I have to move my MyDNS from BQ to BX soon when I retire my last two BQ 
boxes), I'll build a BlueOnyx PKG for it, too. Even if I'll be the only one 
using it. ;o)

-- 
With best regards

Michael Stauber