Lou Sander Posted January 4, 2007 Posted January 4, 2007 I'm a computer technical person, but not very knowledgeable in web hosting matters. I have a phpbb forum on another web site, hosted by another company, that I want to duplicate on my TCH web site HERE. The purpose is to allow a consultant to make changes to the forum, without letting him have access to my other web site. (I can tolerate outsiders, possible spam, etc. here, but not there.) I've copied the Forum directory and subdirectories from the other site to this one, but when I try to access it, I get some error messages having to do with SQL, access, etc. What do I need to do to install my forum on my TCH web site? Quote
TCH-Andy Posted January 4, 2007 Posted January 4, 2007 Have you also copied over the database file ? Or do you want to remotely connect to your existing database ? (I'd suggest a copy if it's for testing purposes) Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 If the database is in the forum folder, I copied it. If not, I didn't. (Sorry, I don't know enough about this stuff even to know where the database resides.) The error message I get when I try to connect to the forum is: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ussranki_phpbb1'@'localhost' (using password: YES) in /home/empefsgf/public_html/forum/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/empefsgf/public_html/forum/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/empefsgf/public_html/forum/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database (ussranki is my username on the other forum) Quote
TCH-Bruce Posted January 4, 2007 Posted January 4, 2007 You will need to take a backup of the current databas on the forum that is running and upload the backup to your web space. You will also need to create a database to use on your testing site. Create a user for the database as well and add it to the database. Then open a ticket with the help desk and ask them to restore the backup file to your newly created database. You will also need to edit the config file for the forum with the new database information. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 You will need to take a backup of the current databas on the forum that is running and upload the backup to your web space. You will also need to create a database to use on your testing site. Create a user for the database as well and add it to the database. I need some help in finding the database to back up. I looked around the other site and didn't find anything that looked like a database, but of course I don't really know what I'm looking for. What should it look like? Should it be in public_html, or elsewhere? Quote
TCH-Thomas Posted January 4, 2007 Posted January 4, 2007 If your other host have cPanel you could see if you have a "backup" section, in there look for "mysql". Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 Got it! I used CPanel to find my database, and it's now on my desktop as phpbb1.gz. What next? Quote
TCH-Thomas Posted January 4, 2007 Posted January 4, 2007 (edited) As Bruce said above: You will need to take a backup of the current databas on the forum that is running and upload the backup to your web space. You will also need to create a database to use on your testing site. Create a user for the database as well and add it to the database. Then open a ticket with the help desk and ask them to restore the backup file to your newly created database. and it should be finished. Edited January 4, 2007 by TCH-Thomas Missed adding a couple of lines first time. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 ...upload the backup to your web space. You will also need to create a database to use on your testing site. Create a user for the database as well and add it to the database. The whole SQL thing is a mystery to me, and I don't know where stuff resides or how to get it there. I don't know how to upload the backup that is now on my desktop as a zipped file. I don't know how to create a database on my testing site. I don't know how to create a user. (Other than that, I'm OK.) Quote
TCH-Thomas Posted January 4, 2007 Posted January 4, 2007 You could upload the file to the public_html with cpanels file manager. Log in to your cpanel at TCH Click the file manager Click upload files Click browse Find the file Click upload Movie tutorial on how to create a MySQL database Then click the Help Desk button on top of this page and ask the techs you uploaded the database backup to your public_html, the files name and that you want them to restore it. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 I've done as you suggested. (Thanks for the link to the movie.) Now I'm waiting for the help desk techs to do whatever they do. How will I know when it's finished? (I assume they'll send me an email or something.) Quote
TCH-Thomas Posted January 4, 2007 Posted January 4, 2007 When you submitted the ticket you were asked for an email address. They will respond to this address. Quote
TCH-Don Posted January 4, 2007 Posted January 4, 2007 Lou, when you submitted the ticket, you should have received an auto responder email about your ticket with a link to view your ticket. Or you can go back into the ticket system and look at your tickets. When the ticket is responded to, you will get another email from the tech that answered your ticket. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 Thanks, guys! The folks over at the CuteSite Builder forum are enthusiastic about TCH, in part because of these forums here. I have to say that there's nothing like it at my other web hosting company, and it makes a BIG differenct to have it. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 The TCH tech says he has done his thing. But I still get the same error message when I try to access the forum on TCH. I'm guessing that the first warning has something to do with a userid and password. I don't have any guesses about warnings 2 & 3. Any suggestions? (I'm thinking maybe I should set up a user ussranki with password YES, and hope to get past the first warning. I don't want to do it until at least one knowledgeable person endorses the idea, though) Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ussranki_phpbb1'@'localhost' (using password: YES) in /home/empefsgf/public_html/forum/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/empefsgf/public_html/forum/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/empefsgf/public_html/forum/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database Quote
TCH-Don Posted January 4, 2007 Posted January 4, 2007 Glad you are happy Lou Let us know if you need more help and your progress. Quote
TCH-Don Posted January 4, 2007 Posted January 4, 2007 As you have a different database name and user you may need to edit a config file that points to the database. I don't use PhpBb but will try to find it. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 Yep. I found a config file with the userid in it. It's got some warnings not to change anything, though, including a password. I think it's time to go over to the phpbb forum and ask how to install this thing from scratch. My problem is that I made some serious modifications after installing it on the other host site. Quote
TCH-Don Posted January 4, 2007 Posted January 4, 2007 Ok I installed phpBB2 Yes you need to edit the config.php file to change the database info - database connect ---- Be sure that in MySql you 1 - created the database 2 - created a user 3 -added the user to the database (go back to MySql and find the Add user select the user and database, and then Add user to database) Then to connect to the database in a script use: host: localhost database: yourCpanelName_databaseName user: yourCpanelName_databaseUser password: mypassword * Note password is just as the password, do not add the CpanelName to it. --------------------------- give that a try. Quote
Lou Sander Posted January 4, 2007 Author Posted January 4, 2007 (edited) Ok I installed phpBB2Yes you need to edit the config.php file to change the database info - database connect ---- Be sure that in MySql you 1 - created the database 2 - created a user 3 -added the user to the database (go back to MySql and find the Add user select the user and database, and then Add user to database) Then to connect to the database in a script use: host: localhost database: yourCpanelName_databaseName user: yourCpanelName_databaseUser password: mypassword * Note password is just as the password, do not add the CpanelName to it. --------------------------- give that a try. I did the MySQL stuff per instructions in posts above. I probably did it correctly. I don't understand the stuff about "Then to connect to the database in a script." I don't know much about scripts, and I'm accustomed to accessing my bb just by going to www.ussrankin.org/forum/ Also, the warnings in the config.php file scare me a bit, as does the long, strange password. EDIT: In the meantime, I've posted a question on the phpbb forum re: how do I duplicate my bb on another host. Edited January 4, 2007 by Lou Sander Quote
TCH-Don Posted January 4, 2007 Posted January 4, 2007 Lou, say your cpanel name is lou and you created a database called forum with a user called me and a password of password edit the config.php file with a text editor or in cpanels filemanager locate the forum folder and click on the file and select edit change the bold parts to your database info <?php // phpBB 2.x auto-generated config file // Do not change anything in this file! $dbms = 'mysql'; $dbhost = 'localhost'; $dbname = 'lou_forum'; $dbuser = 'lou_me'; $dbpasswd = 'password'; $table_prefix = 'phpbb_'; define('PHPBB_INSTALLED', true); ?> Quote
Lou Sander Posted January 5, 2007 Author Posted January 5, 2007 Success! But not FULL success. I can now get to my forum at www.aclacomments.org/forum/, but when I try to log in, I get logged in to the forum on my old site. I'll look for other config-type files to fix, but will also be waiting for more input from you gurus. Quote
TCH-Don Posted January 5, 2007 Posted January 5, 2007 Glad you got it connected. Can't help on the login, not a phpb user until today and I am off to work. But there may be other family members that can help. Quote
TCH-Bruce Posted January 5, 2007 Posted January 5, 2007 My guess is there are links in the database backup that you restored into your new database that will need to be changed to point to where you are testing. Maybe someone on the phpBB forum can tell you what needs modified. I just found this on the phpBB site. I'd start with that. Quote
Lou Sander Posted January 5, 2007 Author Posted January 5, 2007 It's working fine now. The final problem had to do with cookies, and a guy on the phpbb forum gave me the fix. Thanks a million for your help, fellows. What on EARTH would we do without forums??? Now one final thing... I'm trying to get this forum, the TCH one, to automatically log me in when I come here. So far it's not doing it. I've got a check in the box that seems to be the place to set it. Any ideas? Quote
TCH-Bruce Posted January 5, 2007 Posted January 5, 2007 That information is generally stored in a cookie on your machine. Since you deleted the original cookie your test board should be setting a new one but doesn't appear to be. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.