MySQL connect error when copying custom fields

[dspaan]

Hi all,

I have a ViCibox two server cluster which has been running fine and still is. I just created a new list and tried to copy custom fields from an old list to the new one and i get this:

MySQL connect ERROR:

The rest of the screen is blank and the fields are not copied.

The particular thing about this cluster is that it used to be a single server install before this and i moved it over from another host.
This is a ViCibox 3.1.15 install
VERSION: 2.8-426a
BUILD: 140214-1643

I tried checking various logs but the only thing i could find is this in /var/mail/root:

DBI connect('asterisk:localhost:3306','custom',...) failed: Access denied for user 'custom'@'localhost' (using password: YES) at$
Couldn't connect to database: Access denied for user 'custom'@'localhost' (using password: YES) at /usr/share/astguiclient/ADMIN$

DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/astguiclient/AST_conf_update.pl line 364.
executing: SELECT extension,conf_exten from conferences where server_ip='xx.xx.xx.xx' and extension is NOT NULL and extension !=$

But these errors were not generated at the time of copying the custom fields.

I did

mysql -u custom -p

and noticed i could not login with the password custom1234 that was specified in astguiclient.conf so i changed it to blank in astguiclient.conf (which works). But this did not resolve my problem.

[striker]

change it to cron and 1234
or create new user in mysql as custom with pass custom1234

[dspaan]

Thanks Striker, changing it to cron/1234 worked.

[dspaan]

Update, creating new users custom@% and custom@localhost seemed to be the final fix, otherwise you would still get custom field errors because the cron user i made earlier did not have the proper permissions (create and alter).