PDA

View Full Version : Changed my domain name and now my site wont show


movingknowhow
08-06-2006, 05:22 AM
I guess it something to do with the definitions
when i log to my DB i get this ODBC(what is ODBC? I didn’t have that before the domain change)

My DB looks like this
MySQL Database
List Of Databases Hosted On localhost

Database Manager

Details of movingknowhow_com Database


User List
User Name
User Role
escuser- Full Access
kritan- Full Access
moving- Database Administrator


ODBC List
User Name Host
escuser movingknowhow.com
kritan movingknowhow.com
moving movingknowhow.com

BTW how do i backup? which filed i neeed to backup?
want to save it weekly on CD:wink:

redeye
08-06-2006, 07:07 AM
I guess it something to do with the definitions
when i log to my DB i get this ODBC(what is ODBC? I didn’t have that before the domain change)



GOOGLE says:
(pronounced as separate letters) Short for Open DataBase Connectivity, a standard (http://www.webopedia.com/TERM/O/standard.html) database (http://www.webopedia.com/TERM/O/database.html) access (http://www.webopedia.com/TERM/O/access.html) method developed by the SQL (http://www.webopedia.com/TERM/O/ODBC.html#) Access (http://www.webopedia.com/TERM/O/ODBC.html#) group in 1992. The goal of ODBC (http://www.webopedia.com/TERM/O/ODBC.html#) is to make it possible to access any data (http://www.webopedia.com/TERM/O/data.html) from any application (http://www.webopedia.com/TERM/O/application.html), regardless of which database management system (DBMS) (http://www.webopedia.com/TERM/O/database_management_system_DBMS.html) is handling the data (http://www.webopedia.com/TERM/O/ODBC.html#). ODBC manages this by inserting a middle layer, called a database (http://www.webopedia.com/TERM/O/ODBC.html#) driver (http://www.webopedia.com/TERM/O/driver.html), between an application and the DBMS. The purpose of this layer is to translate the application's data queries (http://www.webopedia.com/TERM/O/query.html) into commands (http://www.webopedia.com/TERM/O/command.html) that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them. Since version 2.0, the standard supports (http://www.webopedia.com/TERM/O/support.html) SAG SQL (http://www.webopedia.com/TERM/O/SQL.html).

movingknowhow
08-06-2006, 08:15 AM
Red I tried to post what you wrote on ODBC into my PHP code
Still the site won't show
here is my new domain
www.moversneeds.com

and i get this

Warning: mysql_connect(): Unknown MySQL Server Host 'www.movingknowhow.com' (2) in /home/moving/moversneeds-www/classes/DirDb.php on line 35
Could not connect: Unknown MySQL Server Host 'www.movingknowhow.com' (2)Could not connect: Unknown MySQL Server Host 'www.movingknowhow.com' (2)

Vincent Wright
08-06-2006, 08:26 AM
First of all, your new domain is www.moversneeds.com and you try to connect to www.movingknowhow.com (at least this is what error says).

Second, instead of using domain name try to use "localhost". You can change it manually in includes/config.inc.php. Find the piece of code below


$gDirConfig['dbhost'] = 'your_actual_domain_name_here';


And type in 'localhost'.

movingknowhow
08-06-2006, 08:42 AM
now i get
Warning: mysql_connect(): Access denied for user: 'escuser@localhost' (Using password: YES) in /home/moving/moversneeds-www/classes/DirDb.php on line 35
Could not connect: Access denied for user: 'escuser@localhost' (Using password: YES)Could not connect: Access denied for user: 'escuser@localhost' (Using password: YES)

the problem started when i changed my domain name form movingknowhow to moversneeds
BTW I changed my DB and login password after I switch to another domain
I tried instead of loaclhost put moverneeds and the site showed but with no graphics

Vincent Wright
08-06-2006, 08:44 AM
Now make sure user escuser exists in the database and make sure password stored in config.inc.php is valid.

movingknowhow
08-06-2006, 08:51 AM
escuser exists in the database
where is the password line in config.inc.php

Vincent Wright
08-06-2006, 09:00 AM
This is what db config looks like in config.inc.php (in my copy it starts on line #22)


$gDirConfig['dbhost'] = 'your_db_host';
$gDirConfig['dbuser'] = 'your_db_user';
$gDirConfig['dbpwd'] = 'your_db_password';
$gDirConfig['dbname'] = 'your_db_name';


You have to change $gDirConfig['dbpwd'] setting.

movingknowhow
08-06-2006, 05:31 PM
Thanks Vincent for the remarkable and outstanding patience and support

Vincent Wright
08-06-2006, 06:07 PM
You are welcome!