<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<div>Never mind - answered my own question.</div>
<div>
<br /></div>
<div>I put in some BS names for database, user, password and SAVED. Then put back in the correct values and SAVED again. And it worked. The site is not configured for the right database and user.</div>
<div>
<br /></div>
<div>It might still be nice to know how to browse & change the CCED database. But this is a work-around for problems working with the GUI for databases.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>Chuck
<br /></div>
<font size="2">
<br />
<br /><b>---------- Original Message
-----------</b>
<br />
From: "Chuck Tetlow" <chuck@tetlow.net>
<br />
To: "BlueOnyx Mail List" <blueonyx@blueonyx.it>
<br />
Sent: Tue, 14 May 2019 22:11:52 -0500
<br />
Subject: [BlueOnyx:22900] MySQL database management
<br />
<br />> Hi
everyone,
<br />>
<br />> I'm almost done restoring a previously failed server. With
Michael's help - I finally got all sites restored, and only have a WordPress
problem left resulting fro a small problem with
databases.
<br />>
<br />> In the old server, before it was exported/backed up - sites
were configured with the database/user/password for a MySQL database (used for
WordPress or Joomla). But after the cmuImport restore - the
database/user/password is gone and the "MariaDBUser and database"
checkbox is not checked any
more.
<br />>
<br />> OK, not a big problem - just put the database, user, and
password info back in and SAVE, right? Nope! The BlueOnyx GUI complains
"That MariaDB user already exists". And "That MariaDB Database
already
exists".
<br />>
<br />> I've tried deleting the database and user from the command
line, and then again with MySQLAdmin (of course, reloading the MySQL service
afterward). But the GUI keeps complaining the user and database
exists.
<br />>
<br />> The only reason I can think of that the GUI would still be
complaining about a database that isn't there any more is the CCED database.
I'm assuming it also stores info about a site's
database/user/password.
<br />>
<br />> Does anyone know if CCED also stores the database and user
info in the CCED database? In that case, I need to figure out how to remove
those CCED database entries - so I can put them back for that site and then
restore the database from
backup.
<br />>
<br />> Maybe I should just tell the GUI to put in a dummy
database/user/password - to clear those fields to something else in the CCED
database. I'll try that. But if anyone knows if CCED stores those values,
and how to modify them in the CCED database - please let me
know.
<br />>
<br />> Thanks
experts!
<br />>
<br />>
Chuck
<br /><b>------- End of Original Message
-------</b>
<br />
</font>
</BODY>
</HTML>