Jump to content
xisto Community
Sign in to follow this  
gippal

Help Me Config Drupal Url Database!

Recommended Posts

I tried Install drupal In my hosting service but I'm totally stuck and have not a clue what I did wrong

 

first, drupal worked properly when used in localhost

 

 

sites/default/setting.php

 

$db_url='mysql://myusername:mypassword@localhost/mydatabase';

 

 

 

Than I change it to my host;

 

sites/default/setting

 

$db_url='mysql://myusername:mypassword@db5.mysites.com/mydatabase';

 

but when I tried to open, It shows Internal server error

 

what have I done wrong?????

can you tell me the right setting????

please help me!!!

 

 

 

regards,

gippal

Share this post


Link to post
Share on other sites

Do you have a database on that other server ?And the server with the database have to support requests from the outside.Its easy to have the hosting and the database on the same server, then you have no problems.

Share this post


Link to post
Share on other sites

Sure I have a username and a database in that server....but the location on my database is different with my domain and subdomain.

for example my subdomain is http://forums.xisto.com/no_longer_exists/
but my database located in db5.finalFantasy.com

in my host, it automaticvally host database in separated location
is drupal can't open mysql database that has separated location????




regards,

gippal

Share this post


Link to post
Share on other sites

Never tried it before on a other location.I'm running drupal on a local server (lampp), and the database and the webserver are on the same computer.Note: You have to make a database and (database)user on the server before you can start.Then you have to make the tables with the SQL provided with the instalation.With my configuration it worked in a few minutes.I'll try to move the database to another computer in my (small) LAN and I'll see what happens.

Share this post


Link to post
Share on other sites

I have tested the following and it works :

Webserver (in local lan using XAMPP).
Database (on free server http://forums.xisto.com/no_longer_exists/)

The line in the drupal config becomes :

$db_url = 'mysql://[i]login[/i]:[i]password[/i]@http://forums.xisto.com/no_longer_exists/;;

Note the Italic has to be filled in with your specs.
The number :3306 is port on the server that's listening for database access.
(you need to specify this when it's not the default port).

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.