DB Connection Problem
-
Hello,
I have finally gotten to step 6 in the installation process and need help.
https://www.ideaspacevr.org/documentation/1.1#installing-ideaspace
I have verified that database name, username, and password and am using the database "localhost" and the table prefix "isvr_" as detailed in the directions. When I click submit I get the error:
"Cannot connect to the database. Please verify your database settings and try again."
Anyone know if there is a setting that I missed somewhere that would cause this or if the localhost and iscr_ should be something else? I do not have a static IP address at the moment. I really appreciate any assistance!!!!
Heather
-
@drhstone The issue is most likely related to "localhost". How do you connect to your MySQL database? Are you sure that your database is available as localhost? Some hosting provider give their users specific domain names for accessing the database (eg. mysql.yourdomain.com).
-
@WeddingDJ
Thank you for your quick response. I am hosting the db and the website on a server that is on my network. How would I look up how to access the db?
-
@drhstone if you can log in to your mysql server from the command line like this: mysql -u root -p then it should be ok
-
@drhstone So you got to step 6, so I can the close the issue on github?
-
This post is deleted!
-
@WeddingDJ
Also if you send me your address you will get some swag! I am presenting at Mozz Fest next weekend and am under a crunch to get this up and running. I know how amazing it will Be!
-
@WeddingDJ
I can do that and it says welcome to MySQL monitor... but I still cannot get past the connect to database page for step 6.
-
@drhstone Did you create a database in MySQL? For the MySQL user name: did you run the following statement in MySQL (granting user access to your database)? grant all privileges on YOUR_DB_NAME.* to 'YOUR_USERNAME'@'localhost';
-
Got it working. Thank you!
-
@WeddingDJ Hi, I am facing the same issue with step 6, I am able to see the Ideaspace working in the web browser but when given the DB credentials, it says Database connection error. I have granted all privileges on the DB but still facing the same issue. Am i missing something important here which is stopping the Ideaspace web application from connecting to my DB?
P.S.: I am using MYSQL as the DB.
Would appreciate a response
thanks
-
@am507u Is your database accessible through 'localhost'? Some providers offer their databases only via a domain name, eg. mysql.your-domain.com
-
@WeddingDJ thanks for your response. Yes it is accessible through localhost.
-
@am507u You could take a look at storage/logs/laravel.log if there are any errors.
