Concerto stopped working and won't start, Ubuntu server 14.04

[mswa...@georgefox.edu]

The server was working fine for about a month and when I came in this morning, it had completely stopped and won't start. I tried rebooting and installing updates but no luck. I'll attach some logs. Server is running in VMware.

/var/log/apache2/error.log:

App 5904 stderr: Attempt to migrate in initializer 01 timed out

App 5904 stdout:

[ 2015-05-27 13:30:54.2938 1323/7f5f91480700 App/Implementation.cpp:287 ]: Could not spawn process for application /usr/share/concerto: An error occured while starting up the preloader.

  Error ID: ab780d7f

  Error details saved to: /tmp/passenger-error-zKcHI6.html

  Message from application: Host 'concerto.ip.address.:)' is not allowed to connect to this MySQL server (Mysql2::Error)

App 5789 stderr: Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "database"=>"concerto", "username"=>"concertouser", "password"=>"password", "host"=>"host", "port"=>3306}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"}

/tmp/passenger-error-zKcHI6.html:

https://drive.google.com/file/d/0B4DXnUg-SK6Wc3JuV1lJUk1WRGs/view?usp=sharing

Any help would be greatly appreciated. This is a production server that is relatively new. Thanks!

[August]

It looks to me like Concerto’s first initializer (which deals with DB population) can’t connect to the MySQL database specified in config/database.yml. I’m assuming you’ve censored the username and password in that output, so make sure they match the credentials in MySQL. You can test this on the command line with mysql -u concertouser -p, which should prompt for the password.

You didn’t mention if you were running the sample VM that we distribute. But if not, it’s worth nothing that on MySQL, users are also granted by host, so ‘concertouser@localhost’ won’t work unless the DB and web server are on the same machine, and you would need a user ‘concertouser@%’ (for any host) or at some static IP address/hostname.

-- 
August

--
You received this message because you are subscribed to the Google Groups "Concerto Digital Signage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to concerto-digital-s...@googlegroups.com.
To post to this group, send email to concerto-dig...@googlegroups.com.
Visit this group at http://groups.google.com/group/concerto-digital-signage.
For more options, visit https://groups.google.com/d/optout.

[mswa...@georgefox.edu]

Thanks August, I logged onto the mysql server and did grant all on concerto.* to 'concertouser'@'ipaddress' identified by 'password';

Do you have any ideas why the permissions stopped working? Concerto seems to be happy after granting permissions again.

[August]

Glad to hear it. I don’t know if you’re referring to the MySQL server on the VM or not, but my best guesses would be that either the DB permissions were removed (perhaps during a package upgrade or uninstallation) or that the IP address changed (if you’re using it in the grant explicitly).

-- 
August

On May 27, 2015 at 4:51:08 PM, mswa...@georgefox.edu (mswa...@georgefox.edu) wrote: