So, I've been using LogBlock with a remote database on my web host for about two weeks now. I wanted to switch and use a local database which is hosted on the same server. I have MySQL installed, and the database called 'logblock' created with the user 'logblock' having full access the the database. I have PhpMyAdmin installed to make sure it's all correct. But when I change the config, and start the server, the '/lb' commands don't work. This happens when it can't connect to the mysql database :\. Here is my config for MySQL: Code: mysql: port: 3306 host: localhost password: ******** user: logblock database: logblock I made the pass **** on purpose.
Did you "bind" the user to database? And what OS is are you running it on? If it is Vista or Windows, then replace localhost with 127.0.0.1
I am using 'Ubuntu 10.04, 64-bit'. Also, I added the user 'logblock' to the database 'logblock', and it still did not work.
You are sure the localhost redirect work (again you can just replace it with 127.0.0.1)? Also when you bound the user and database, did you give the user permissions to query the database?
I am paying for a hosting service for my server. I followed their instructions on how to create a mysql database using phpmyadmin and installed logblock. It connects to the database fine but whenever I use the /lb rollback and /lb block commands, my server restarts. Any ideas on what could be causing this?
Why not? Im not trying to be a smartass, im just trying to figure out why this thread is old and if I can help with it. EDIT by Moderator: merged posts, please use the edit button instead of double posting.