Greetings,

I'm new to October CMS and this is my first post. I have setup two local apps on my machine. I'm using PostgreSQL 9.3 for my RDBMS and Ubuntu 14.04. I have two databases with the same user. After I setup one October app, I successfully accessed the backend admin system. I then setup another October app, successfully accessed the backend system for that one, then all of a sudden I get a database missing error when I go back and try to access the backend for the 1st app. I'm not sure what the issue is here.

Last updated 7 years ago

I solved my own issue as it appears I didn't have any other choice since after 24 views I couldn't get a single suggestion.

I just needed to tell PostgreSQL to allow for multiple connections from any local IP address and port. Maybe this answer could help someone in the future.

bigbanks8022270 said: I just needed to tell PostgreSQL to allow for multiple connections from any local IP address and port. Maybe this answer could help someone in the future.

Have any resources on how exactly to do this? I just updated my virtual server which had numerous OctoberCMS installs on it and every site is now giving me the "Database Missing" error.

I'm assuming this is a fairly new setting? I am using MySQL but I get the sense that we have a similar thing going on here.

Thank you so much!

Whelp, after trying a fresh install I am now seeing where the errors are coming from I suppose:

Will report back!

For anyone who is stuck with the same problem as me, I had to do the following and now we are all good to go!

Install missing extensions

• sudo apt-get install php7.0-curl
• sudo apt-get install php7.0-mbstring
• sudo apt-get install php7.0-gd
• sudo apt-get install php-mysql
• sudo apt-get install php7.0-mysql
• sudo service nginx restart

Edit php.ini located at /etc/php/7.0/fpm/php.ini

• uncomment the line : ;extension=php_pdo_mysql.dll

Edit php.ini located at /etc/php/7.0/cli/php.ini

• uncomment the line : ;extension=php_pdo_mysql.dll

This thread helped me solve it: https://stackoverflow.com/questions/2852748/pdoexception-could-not-find-driver/44360511#44360511

P.S. Remember to save a snapshot of your VPS image before you go updating/cleaning packages and such. You can really mess some things up like I did (; hopefully this post helps save someone else!

Last updated 6 years ago

@abass Sorry for the late reply to this! Yes I think you have your apps all using the same localhost database connection. In order to prevent the database missing error you have to tell your MySQL setup to allow multiple connections on localhost. This is going to be in a MySQL config file somewhere on your system. I use PostgreSQL so the config line to do this may be different. My line was something like:

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host     all   all   0.0.0.0/0   md5

Then it worked. Hope this helps!

bigbanks8022270 said:

Yes I think you have your apps all using the same localhost database connection. In order to prevent the database missing error you have to tell your MySQL setup to allow multiple connections on localhost.

@bigbanks8022270 - Thanks for the follow-up! It was not this for me - I posted my solution in the reply above yours. That being said, it is good to have your solution in this thread so there is a living archive of all the possible solutions. Hopefully this helps others who run into a similar problem! Cheers!