[BlueOnyx:16172] Re: Existing database overwritten by GUI

[Chris Gebhardt - VIRTBIZ Internet]

Hi Michael,
I seem to be having a bit of trouble with MySQL and site creation using 
the API.

On 10/12/2014 12:19 PM, Michael Stauber wrote:
>> Does the new MySQL db creation (and removal) scheme also take effect
>> with the API?
>
> I just published updates that will bring the API back in line with the
> MySQL changes.
>
> On 5106R, 5107R and 5108R that's in the new base-api-*.rpm's that just
> hit the mirrors.
>
> On 5207R and 5208R it's represented by the updated base-alpine-*.rpm's.
>
> I tested it with WHMCS to create, terminate and modify sites and it
> works fine. The resulting MySQL databases and users then use the new
> naming scheme, too.

New 5208R system has current yum (just did yum clean all / yum -y 
update).   Creating a site with MySQL enabled in the 5200 module fails 
(with blank white screen in WHMCS) and the target server 
/var/log/admserv/adm_error gives this:

[Tue Oct 14 12:56:38 2014] [error] [client nn.nn.nn.242] BlueOnyx API: 
Access from 208.77.216.242 to port 81
[Tue Oct 14 12:56:49 2014] [error] [client nn.nn.nn.242] BlueOnyx API: 
Sorry, an error occured while enabling the various services for the Vsite.
[Tue Oct 14 12:56:49 2014] [error] [client nn.nn.nn.242] BlueOnyx API: 
Failed, reporting: BlueOnyx API: Sorry, the Vsite was not created properly.


If I turn off MySQL creation in the WHMCS 5200R module, the site creates 
just fine.

I'm using the WHMCS module version 2.1.

I'll be happy to dig up whatever other info you like, on- or off-list.

-- 
Chris Gebhardt
VIRTBIZ Internet Services
Access, Web Hosting, Colocation, Dedicated
www.virtbiz.com | toll-free (866) 4 VIRTBIZ