Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Issues connecting to database during install.

Asked Modified Viewed 1,150 times
D
DarekG
D
DarekG 10
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
asked
Newbie

Hi All,

I used PHP fusion for my first ever website back in 2007 and decided to circle back and see if the project was still alive. I'm glad to see that PHP fusion is thriving! Anyways...

I'm running into an issue with my installation when attempting to connect to my MySQL database. Unfortunately with my current web host (1and1) the databases are hosted on different servers which complicates things, I don't connect to "localhost" but rather a different server address that they provide me.

Tested the SQL server connection with other tools, and another PHP CMS and am able to install/use those things without issue with the exact same credentials, server address, port, database name, users, etc, you name it!

MySQL 5.7 & PHP 7.3

My running theory is that it does not like the server address because it has a dash in it. The address I enter is as follows (exact address changed for privacy):

servernameherexyz.hosting-data.io


Now the interesting thing is when I hit the "Save and Proceed" button, it refreshes the page, gives me the "Cannot connect to database." generic error, and it actually re-writes the server address with an underscore in the database hostname field like so:

servernameherexyz.hosting_data.io


I'm beginning to think this is a glitch with the PHP Fusion installer rather than my server/host as other PHP applications have been working flawlessly up until this point. Has anyone else run into this?

Thanks in advance!
Edited by DarekG on 12-02-2020 19:24,
0 replies

3 posts

R
Anonymous User
R
Anonymous User 367
  • Veteran Member, joined since
  • Contributed 939 posts on the community forums.
  • Started 2 threads in the forums
  • Answered 20 questions
answered
Veteran Member

D
DarekG
D
DarekG 10
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
answered
Newbie



Thanks - That did the trick!

I'm wondering if this could have adverse effects elsewhere? I have now successfully installed PHP fusion and its default infusions but am unable to see the Forum, Gallery, etc under the content menu. Think this change might be related?

EDIT: For whatever reason manually defusing and refusing seems to have fixed my last issue.
Edited by DarekG on 13-02-2020 00:23,
0 replies
R
Anonymous User
R
Anonymous User 367
  • Veteran Member, joined since
  • Contributed 939 posts on the community forums.
  • Started 2 threads in the forums
  • Answered 20 questions
answered
Veteran Member

I fixed your problem with the DB host. Nothing else was affected.
0 replies

Category Forum

Installation Issues- 9

Labels

None yet

Statistics

  • Views 0 views
  • Posts 3 posts
  • Votes 0 votes
  • Topic users 2 members

2 participants

R
R
Anonymous User 367
  • Veteran Member, joined since
  • Contributed 939 posts on the community forums.
  • Started 2 threads in the forums
  • Answered 20 questions
D
D
DarekG 10
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet