"Can't install database." error on ubuntu 14.04 cloud server

asked May 22, 2017 by rsthomas (320 points)
Running rstmailinglists.com/seotoaster/install

Error message:  SQLSTATE[42000] [1044] Access denied for user 'mailing'@'%' to database 'toaster'

I am using Sentora as a web hosting application (similar to cPanel/WHM), and have successfully installed SeoToaster on one domain (rsthost.com/seotoaster).  The error occurred while trying to install SeoToaster on a second domain.

Installing Sentora automatically does everything described on https://www.seotoaster.com/seotoaster-ubuntu-vps-installation.html down to the Download SeoToaster section.  I then did:
[user]$ sudo cd /opt && wget https://www.seotoaster.com/downloads/seotoaster.v2.5.0.zip
[user]$ sudo unzip seotoaster.v2.5.0.zip -d seotoaster
[user]$ sudo mv seotoaster /var/www/html/seotoaster

Set user permissions
[user]$ sudo chown www-data:www-data -R /var/www/html/seotoaster/

Location of each installation:
/var/sentora/hostdata/rsthost/public_html/seotoaster -- the one that works.
... so there shouldn't be a conflict.

I had previously set up the database username and password account within Sentora, so that wouldn't be the problem.

Do you suppose there is something going on within SeoToaster that is not allowing two installations to run on the same server in the Sentora environment?  I hope not!!

Might there be some system "master" cache folder somewhere, besides the cache for each installation, that needs to be cleared?

2 Answers

answered May 23, 2017 by Pavel.g (4,600 points)
Hello Rsthomas.

A seotoaster can install multiple copies on a single server without problems.
In your case, most likely you specify the user for the database where his do not have the rights to the database toaster.
Please check

Regards, Pavel.
answered May 23, 2017 by rsthomas (320 points)
Finally got it!  The database name requires the complete name -- both the username and database name combined (mailing_toaster) -- in order to work.  I must have stumbled upon this format during the first installation, but forgot it for the second.

If I remember cPanel correctly, the database name is created automatically.  Sentora doesn't have all of cPanel's bells and whistles -- but overall it works pretty well, and it's free.