Help Me Config Drupal Url Database!

gippal

Sep 15 2006, 10:29 AM

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

kdr_98

Sep 15 2006, 05:15 PM

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.

gippal

Sep 16 2006, 12:17 PM

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://gippal.finalFantasy.com
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

kdr_98

Sep 17 2006, 06:51 AM

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.

kdr_98

Sep 17 2006, 06:18 PM

I have tested the following and it works :

Webserver (in local lan using XAMPP).
Database (on free server http://www.freesql.org)

The line in the drupal config becomes :

CODE

$db_url = 'mysql://[i]login[/i]:[i]password[/i]@www.freesql.org:3306/[i]databasename[/i]';

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).

Similar Topics

Keywords : config drupal url database

Want To Purchase A New Computer - what do you think about the config. ? (9)
I Need A Database Generator - Or something like that... (2)
Ehrm the title and description don't describe it that good. I am making a info site for a
MMORPG-game, and want to make a monsters list. On the first column, I have the levels On the second,
the monster name etc Clicking on the name or level or whatever, it will show more info (preferably
a new page, but a dropdown menu or something like that is okay too) Well, I don't know how to
describe it, I hope you understand what I need anyway... /tongue.gif' border='0'
style='vertical-align:middle' alt='tongue.gif' /> Preferably a generator (they're more easy to...

How Do I Delete Info From Mysql Database Through My Cpanle? - - help (1)

I want to delete some info in a MySql database. Can I do that through my cPanle? if not, I need to
know even through command prompt. Thanks\ nickmealey ...

Internet Connection Script/applicatio/config - (8)

hi guys does any one of you know a VB sctipt that connects to the net with given info in the
winXP environment i im sick of click connecting every time i turn on my pc though i thought that i
do know "stuff" bout XP but i failed to find this option in the settings and administration tools
take care...

Looking for config, drupal, url, database

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE