1
tjmichner
can not connect to datase
  • 2006/7/7 22:38

  • tjmichner

  • Just popping in

  • Posts: 45

  • Since: 2006/6/22


I am trying to install xoops. I know the name of MySQL database and the password. I have tried to enter the host server name as the same i enter in an ftp program and I have tried the IP address of the server and I have tried leaving it "localhost".

The database username is the same that I use to access my site.

The path and URL have been verified.

Each time I then get to the final screen it says "could not connect to the database check to see if the database is configured correctly"

Does anyone know what I might try?

Thank you!

2
Bender
Re: can not connect to datase
  • 2006/7/7 22:46

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


Without knowing much about your hosting its difficult to say. Some hints however:

1. Did you create the database yourself or was it created by your hoster?

2. Can you access that database with phpmyadmin or whatever tool your hoster supplies in combination with the user/pw you think is the correct one?

3. Upload this to your website and call the file in the browser then after you changed server, user and pw accordingly to see if it can connect to the db.

$link mysql_connect('mysql''mysql_user''mysql_password');
if (!
$link) {
die(
'No connection possible: ' mysql_error());
}
printf("MySQL server version: %sn"mysql_get_server_info());
?>


(Name it testdb.php or something)
What does the errorcode say if there is any?

4. What does your hosters faq say how the sql server should be named? Some use "mysql" for the servername.
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

3
aamjad2001
Re: can not connect to datase
  • 2006/7/7 22:51

  • aamjad2001

  • Just popping in

  • Posts: 64

  • Since: 2006/6/20


some time a simple task solves this problem

the simple task is to recreate the MySQL user and give it access permissions to the database.

4
tjmichner
Re: can not connect to datase
  • 2006/7/7 23:11

  • tjmichner

  • Just popping in

  • Posts: 45

  • Since: 2006/6/22


I created a new user and gave that user permission to the sql database. I did this using the e-Soft InstaRak control panel.

The database was apparently a default database created when I was given sql permissions.

My host company said to try the IP address of the host which I tried to no avail.

I don't know have phpmyadmin I only have the control panel. I don't know anything about the php code....do I paste that into a blank page in FrontPage and upload it? do i need the ' ' around the user and password?

Thank you I'm sorry to be so unintelligible I didn't realize how entailed a XOOPS site installation is.

5
tjmichner
Re: can not connect to datase
  • 2006/7/7 23:34

  • tjmichner

  • Just popping in

  • Posts: 45

  • Since: 2006/6/22


ok the php test page says "unknown server host" ugh

6
tjmichner
Re: can not connect to datase
  • 2006/7/7 23:37

  • tjmichner

  • Just popping in

  • Posts: 45

  • Since: 2006/6/22


i changed the php test page server host to the IP address and I got this error

Parse error: parse error in /var/sites/rmmarketing.biz/web/testdb.php on line 2

7
Bender
Re: can not connect to datase
  • 2006/7/7 23:43

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


So its definately the servername that we need to fix first.

Does it work if you put the ip there?
(and yes you need to keep the ' ' chars around the values)

So for an example:

If:

Hostname/IP is: 54.54.54.54
DB User is: name1
DB Password is: pass1

The file needs to look like this:

$link mysql_connect('54.54.54.54''name1''pass1');
if (!
$link) {
die(
'No connection possible: ' mysql_error());
}
printf("MySQL server version: %sn"mysql_get_server_info());
?>


You can create it with a simple texteditor. No need for that MS Frontpage ***censored***.


If we don´t get to the name of your MySQL server you could just give that file to your hoster and ask them to make it work for you. Should be easy for them. (You could also point them to this thread)
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

8
tjmichner
Re: can not connect to datase
  • 2006/7/8 0:41

  • tjmichner

  • Just popping in

  • Posts: 45

  • Since: 2006/6/22


now the error that i get says

No connection possible: Host 'dns1' is not allowed to connect to this MySQL server

I really appreciate your help with this. I would contact my host but they are of course closed till Monday now and I was hoping that I could work on this site over the weekend. I don't understand this error message.

9
tjmichner
Re: can not connect to datase
  • 2006/7/8 0:49

  • tjmichner

  • Just popping in

  • Posts: 45

  • Since: 2006/6/22


i added the :XXXX number at the end that i use from the browser https://xx.xxx.xx.xx.:xxxx

and now the page attempts to open but it can't and it just sits there trying to open the page for a long time...does that mean it is closer?

Login

Who's Online

181 user(s) are online (100 user(s) are browsing Support Forums)


Members: 0


Guests: 181


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits