SMF Version: SMF 1.1 RC2
Hello,
I would like to move my forum database to a separate server, but leave the files on the existing one. How is this possible? I tried entering in the IP for the MySQL Server in repair_settings.php but it keeps saying: Some settings are not being shown because the MySQL connection information is incorrect.
Make sure that all the MySQL server information is correct and that the server that you're moving things to accepts external connections.
What exactly is the "MySQL server" field? It's usually localhost, so I'm assuming it will be the IP address of the new server? I haven't found any examples anywhere of people using anything other than localhost so I'm not sure...
Also, how can I verify that the second server accepts external connections?
You'll have to ask the people running the server if you can contact it from the webserver. They can also provide you with the information you need to enter to connect.
Actually, I'm running the server. :P Well, not literally but it's a Virtual Private Server and I'm actually the one who installed mysql on it. I would greatly appreciate it if anyone can tell me where to find the server connection settings, as I already know the login, password and database.
Thanks! :)
Oh and to answer your question, I can access it via that server's phpMyAdmin, as well as its Webmin web interface.
If it is listening on an outside interface, you should be able to use the IP or a DNS name as the mysql server in the SMF settings. Just make sure you grant access to the username you are using and check password is fine.
The username and password I verified quite a lot, but it's the IP i'm not sure of. So how would I enter it, just numerically like: 127.0.0.1 or with the URI: http://127.0.0.1/
(and yes, I know that's not a real ip address, it's just an example :P)
Thanks
Just numerically.
And it is a real IP address.
;; QUESTION SECTION:
;1.0.0.127.in-addr.arpa. IN PTR
;; ANSWER SECTION:
1.0.0.127.in-addr.arpa. 86400 IN PTR localhost.
;; AUTHORITY SECTION:
0.0.127.in-addr.arpa. 86400 IN NS localhost.
Yes, I know it's localhost, but I guess you didn't get the joke or the irony. :-\ This whole thread is because I've only seen SMF work on "localhost" and no other IP. :P
EDIT: Grammar. ;D
Numeric doesn't work:
LainaaSome settings are not being shown because the MySQL connection information is incorrect.
Odd. Are you using some weird private IP? Are you using a public IP? Also, try assigning a DNS name and using that.
Lainaus käyttäjältä: Yonkey - elokuu 09, 2006, 08:40:06 IP
Yes, I know it's localhost, but I guess you didn't get the joke or the irony. :-\ This whole thread is because I've only see SMF work on "localhost" and no other IP. :P
I like killing jokes with logic. It is fun.
Lainaus käyttäjältä: Motoko-chan - elokuu 09, 2006, 08:49:39 IP
Odd. Are you using some weird private IP? Are you using a public IP? Also, try assigning a DNS name and using that.
I doubt it's private considering you can access it via the web: http://69.12.216.149/
How would I assign a DNS name to it? ???
Ok, I assigned a DNS name to it: http://www.silverliningthegame.com/ but SMF still can't read it. :'(
Does anyone else have a suggestion? ???
That name (and the IP) takes me to the apache placeholder page. Are your forums somewhere else off the root?
Ok I actually found the problem. I had to grant mysql privileges to the other host trying to access the database. :)
Haha. I've gotten bit by that before too. Easy thing to overlook.
Yeah... I actually should have just made a test connection script to begin with. The SQL error was pretty self-explanatory (compared to the vague one in repair_settings.php). :P Oh well. :)