[Solved] Vanilla fails to find local database.

smaudet

Running a testing LAMP server, I have vanilla installed in a virtual host on the local machine, SQL complains it cannot find the database server during the setup process:

"SQLSTATE[HY000] [2005] Unknown MySQL server host '~~Invalid~~' (1)"

I have several Wordpress installs running on this machine, as well as a couple other database-dependent programs, all functioning off of the same local mysql server, this is a "vanilla" install ( ) of the zip file, so I'm fairly sure this is Vanilla's issue, not mine.

Any help appreciated, elsewise I will be marking Vanilla as unstable, and moving onto other forum software.

The database "host" url I use is simply localhost, I've tried http://localhost as well.

Just some sever information in case this of use to anyone else:

MySQL Sever Insance:

root
localhost
/var/run/mysqld/mysqld.sock

Server Information:

MySQL 5.1.54-1ubuntu4
localhost
127.0.0.1

UnderDog

Thank you for mentioning that you solved your problem

UnderDog

http://www.google.com/search?q="SQLSTATE[HY000]+[2005]+Unknown+MySQL+server+host&hl=en&newwindow=1&num=100&lr=&ft=i&cr=&safe=images&tbs=

I will be marking Vanilla as unstable, and moving onto other forum software.

Good luck with your further search for other forum software.

smaudet

Figured out the problem, the error Vanilla was giving was completely misleading, suggest someone changes that.

I hadn't misconfigured anything incorrectly, Vanilla insists on using an .htaccess file, which is IMHO opinion silly, the apache documentation states that .htaccess files are in fact un-necessary, and un-preferred, especially in situations where one has access to the server config files. I had to create a .htaccess file in the root directory, chmod 666 it, in order for it to work. No, I tried using the "do not use .htaccess file" option, that just gave me the same error. Hope this helps anyone else.

UnderDog

Thank you for mentioning that you solved your problem