|
Re: Moving whole website to a different server [message #40471 is a reply to message #40455] |
Fri, 07 March 2008 18:03 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
I seem to be having another problem in moving the forum from one site to another. Can you tell me what is going on and what to do about it? Can it have anything to do with having mysql as the database name on the old site, but rpimysql as the databasename on the new site?
On the old site, I went to the administrative control panel and dumped a backup of the active forum. I left the box checked so the output would be compressed.
I downloaded the dump file to my desktop, then uploaded it on the new site and put it in the same folder where I got it.
On the new site, I went to the control panel and selected "Import Data" and a small green gauge came on the bottom of the screen. It speedily got to about 50% but then hung there. I did it twice. One of the times I went home and left it overnite. In the morning, I had a browser error. In looking at the forum, The home page was updated with counts, etc., but on all of the forums there are no messages. Even though several of the forums show multiple "pages" of messages, they all say there are no messages in this forum. The apache log shows:
[Fri Mar 07 21:39:27 2008] [error] [client 66.249.67.54] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb(at)rpinet(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
The last two errors in the forum sql error file were:
[Fri Mar 7 22:15:00 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTY8YnIgLz4KL3V zci9sb2NhbC9hcGFjaGUyL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjM0MjxiciAvPgovdXNyL2 xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS90aGVtZS9kZWZhdWx0L2luZGV4LnBocDo5OTxic iAvPgovdXNyL2xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS9pbmRleC5waHA6MTE0NTxiciAv PgopIDEwNjQ6IFlvdSBoYXZlIGFuIGVycm9yIGluIHlvdXIgU1FMIHN5bnRheDsgY2hlY2sgdGh lIG1hbnVhbCB0aGF0IGNvcnJlc3BvbmRzIHRvIHlvdXIgTXlTUUwgc2VydmVyIHZlcnNpb24gZm 9yIHRoZSByaWdodCBzeW50YXggdG8gdXNlIG5lYXIgJycgYXQgbGluZSAxPGJyIC8+ClF1ZXJ5O iBVUERBVEUgZnVkMjYxX3NlcyBTRVQgc3lzX2lkPSc4MWNmOTZkZDhhMzZhNjBlNDNkMGYwZDVi ZWZmOGY3ZicsIGZvcnVtX2lkPTAsIHRpbWVfc2VjPTEyMDQ5MjgxMDAsIGFjdGlvbj0nQnJvd3N pbmcgdGhlICZsdDthIGhyZWY9XCZxdW90O2luZGV4LnBocD90PWluZGV4XCZxdW90OyZndDtmb3 J1bSBsaXN0Jmx0Oy9hJmd0OycsIHJldHVybnRvPScnIFdIRVJFIGlkPTxiciAvPgpTZXJ2ZXIgV mVyc2lvbjogNS4wLjQ1PGJyIC8+CltSZWZlcnJpbmcgUGFnZV0gaHR0cDovLzE5OC4xMDYuMjku NS88YnIgLz4K
[Fri Mar 7 22:23:41 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTY8YnIgLz4KL3V zci9sb2NhbC9hcGFjaGUyL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjM2ODxiciAvPgovdXNyL2 xvY2FsL2ZvcnVtZGF0YS9pbmNsdWRlL3RoZW1lL2RlZmF1bHQvZXJyLmluYzo2MzxiciAvPgovd XNyL2xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS90aGVtZS9kZWZhdWx0L3JlcG9ydC5waHA6 MTI4PGJyIC8+Ci91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTQ 1PGJyIC8+CikgMTA2NDogWW91IGhhdmUgYW4gZXJyb3IgaW4geW91ciBTUUwgc3ludGF4OyBjaG VjayB0aGUgbWFudWFsIHRoYXQgY29ycmVzcG9uZHMgdG8geW91ciBNeVNRTCBzZXJ2ZXIgdmVyc 2lvbiBmb3IgdGhlIHJpZ2h0IHN5bnRheCB0byB1c2UgbmVhciAnJyBhdCBsaW5lIDE8YnIgLz4K UXVlcnk6IFVQREFURSBmdWQyNjFfc2VzIFNFVCBkYXRhPSdzOjEyNzpcJnF1b3Q7Jmx0O2ZpZWx kc2V0Jmd0OyZsdDtsZWdlbmQmZ3Q7RVJST1I6IFlvdSBhcmUgbm90IGxvZ2dlZC1pbiZsdDsvbG VnZW5kJmd0O1RvIGFjY2VzcyB0aGlzIHBhZ2UgeW91IG11c3QgYmUgYSBtZW1iZXIgb2YgdGhpc yBmb3J1bS4mbHQ7L2ZpZWxkc2V0Jmd0OyZsdDticiAvJmd0O1wmcXVvdDs7JywgcmV0dXJudG89 J3Q9cmVwb3J0JmFtcDttc2dfaWQ9MTc5NDUmYW1wO3JpZD0wJmFtcDtTPTYxMzRjZjBlNzQ0MzI yZGYxN2EyMWFmMTNiNmVhNmRhJyBXSEVSRSBpZD08YnIgLz4KU2VydmVyIFZlcnNpb246IDUuMC 40NTxiciAvPgpbUmVmZXJyaW5nIFBhZ2VdIHVua25vd248YnIgLz4K
The last line in the forum access log is:
[Fri Mar 7 22:32:23 GMT 2008] W0Vycm9yXSBJbnZhbGlkIElucHV0PGJyIC8+W01lc3NhZ2UgU2VudCB0byBVc2VyXSBZb3UgaGF 2ZSBmb2xsb3dlZCBhbiBpbnZhbGlkIGxpbmsuIFBsZWFzZSBub3RpZnkgdGhlIDxhIGhyZWY9Im 1haWx0bzp3amJAcnBpbmV0LmNvbSI+d2VibWFzdGVyPC9hPiBob3cgeW91IGdvdCBoZXJlLjxic iAvPltVc2VyIElQXSA2Ni4yNDkuNjcuNTQ8YnIgLz5bUmVxdWVzdGVkIFVSTF0gaHR0cDovL3Jw aXZwcy5zZWN1cmVzaXRlcy5uZXQvd2ZvcnVtL2luZGV4LnBocD90PXRyZWUmdGg9MzEwNiZyaWQ 9MCZTPWE5NDhkZTU5MDk0NjUyOWE2Y2NiZDkwMzRiZWY1YzBiPGJyIC8+
[Updated on: Fri, 07 March 2008 18:07] Report message to a moderator
|
|
|
|
|
|
Re: Moving whole website to a different server [message #40503 is a reply to message #40497] |
Tue, 11 March 2008 14:33 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
Thank you.
when I first looked at it, the fud261_ses table contained over 2000 "entries". After deleting the entries once, the import hung again. Looking at that table again, it had over 300 entries, so I deleted them again and imported again.
There was no change in the operation after doing this. The import still essentially halts at about half way, and afterwards there are no messages in any of the forums.
However, I seem to have bolluxed things up, somehow, because now when I get the adm login screen it does not recognize my admin username/password. Also, it appears I may have interrupted the rebuilding of a theme, because the control panel (before I got excluded from viewing it) contained a long list of warnings, on through all the various languages, of which the first few were:
WARNING: couldn't create '/usr/local/forumdata//include/GLOBALS_HELP'
WARNING: couldn't create '/usr/local/forumdata//include/adm.inc'
WARNING: couldn't create '/usr/local/forumdata//include/cat.inc'
WARNING: couldn't create '/usr/local/forumdata//include/core.inc'
WARNING: couldn't create '/usr/local/forumdata//include/customtags.inc'
WARNING: couldn't create '/usr/local/forumdata//include/email_filter.inc'
WARNING: couldn't create '/usr/local/forumdata//include/email_msg_format.inc'
WARNING: couldn't create '/usr/local/forumdata//include/ext.inc'
WARNING: couldn't create '/usr/local/forumdata//include/forum_adm.inc'
WARNING: couldn't create '/usr/local/forumdata//include/glob.inc'
WARNING: couldn't create '/usr/local/forumdata//include/groups_adm.inc'
WARNING: couldn't create '/usr/local/forumdata//include/ipfilter.inc'
WARNING: couldn't create '/usr/local/forumdata//include/login_filter.inc'
The forumdata/errors/sql_errors file contained:
[Tue Mar 11 17:42:04 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 17:44:38 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 17:44:50 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 17:45:00 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 18:02:40 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
[Tue Mar 11 18:05:44 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZ
Finally, the apache log contained several of the following messages (along with a lot of warnings and notices):
[Tue Mar 11 17:42:04 2008] [error] [client 66.249.73.18] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb(at)rpinet(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
[Tue Mar 11 17:45:00 2008] [error] [client 66.249.73.18] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb(at)rpinet(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
I do not understand these latter message at all.
It looks like the only thing I can do is repeat moving the forum from the beginning. using all the info in this thread as a guide. Is that my best course?
|
|
|
|
|
|
|
|
Re: Moving whole website to a different server [message #40538 is a reply to message #40536] |
Mon, 17 March 2008 19:48 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
Thanks for the reply.
Yes, I am using the same login from the original install.
I tried a second and third userid, after testing out the passwords on the "old" installation, and upon putting the same info into the login panel, I generated this message on the login screen above the login box in red letters:
Only administrators with proper access credentials can login via this control panel
The above message stays on the screen if I use another non-administrator id, but when I go back to the administrator id, theh red message disappears. It seems to know that it is an administrator, but won't complete the login.
Somehow, I don't think the system is correctly getting access to all of the table data. I say this because I have manually selected the first hundred or so records from my fud261_users table, and my administrator login is the second one in the table (after Anonymous Coward whose password is 1). The table appears to be in good order, with the password field reading a consistent number of gibberish characters for all the entries.
Another possible clue: a Google "bot" is repeatedly generating "Fatal Error" messages (along with some Notice messages) in the log file that say:
[Mon Mar 17 23:34:41 2008] [error] [client 66.249.73.71] PHP Notice: Only variable references should be returned by reference in /home/rpivps/www/rpinet.com/wforum/index.php on line 214
[Mon Mar 17 23:34:41 2008] [error] [client 66.249.73.71] PHP Notice: Only variable references should be returned by reference in /home/rpivps/www/rpinet.com/wforum/index.php on line 214
[Mon Mar 17 23:34:41 2008] [error] [client 66.249.73.71] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/rpivps/www/rpinet.com/wforum/theme/default/index.php' (include_path='.:') in /home/rpivps/www/rpinet.com/wforum/index.php on line 1145
Can I override the password in the table somehow?
Or is there still some lurking permissions issue blocking access?
[Updated on: Tue, 18 March 2008 13:54] Report message to a moderator
|
|
|
|
Re: Moving whole website to a different server [message #40552 is a reply to message #40549] |
Tue, 18 March 2008 16:17 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
Users_opt field value for administrator is 5405687
But now my situation has changed slightly. I found a messages file in /usr/local/forumdata/thm/default/tmpl which had only 600 permissions. After changing it to 666, my administrator screen did finally show up!
However, I don't think the theme rebuild worked because it generated the following message:
Missing Message entry custom_avatar_queue inside i18n/english/msg
Plus, the forum home page won't display.
I found a msg file at /usr/local/forumdata/thm/default/i18n/english, and I tried peeking at it with vi. It does appear to have a line in it which has the string - custom_avatar_queue followed by some space and then Custom Avatar Queue. Can you tell me what is going on? And what to do?
[Updated on: Tue, 18 March 2008 21:14] Report message to a moderator
|
|
|
Re: Moving whole website to a different server [message #40557 is a reply to message #40552] |
Wed, 19 March 2008 15:15 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
I think I may be learning a little.
I looked further into the status of files on the web root path, and I found out that the msg file above was 600. Upon changing it to 666 the message changed to say it couldn't write to actions.php. That led me on further permissions hunts, and I changed the default directory from 700 to 775, and so on with pdf.php, and rdf.php (644 --> 664). Somehow, I must have gotten confused and neglected to look at these permissions. The last few diagnostic messages were actually helpful, whereas the earlier ones seemed misleading!
Now, everything seems to work properly. Once again, thank you for the encouragement and assistance!
Should I be concerned to tighten some of the permissions back up?
[Updated on: Wed, 19 March 2008 15:30] Report message to a moderator
|
|
|
|
|
|
Re: Moving whole website to a different server [message #40603 is a reply to message #40600] |
Mon, 24 March 2008 16:46 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
I have a sense that some of this trouble may be due to moving the site domain name. Anyway, yes, I edited the GLOBALS.php file and changed the $WWW_ROOT value to reflect the original (now re-oriented) domain name, and I checked the other values, which were correct in the GLOBALS.php file. So, I went in to the control panel and rebuilt the theme.
It may not have rebuilt, because I noticed in the control panel itself, the $WWW_ROOT_DISK path was not the value in the GLOBALS.php file. In fact, somehow, it was the value that was where the forum was found on the OLD SERVER. I changed the value to be correct. After a couple more rebuild attempts, I noticed the "set" button below Globals on the control panel. So, I again pasted the correct value in the $WWW_ROOT_DISK field, clicked on "set" and rebuilt the theme again. This time, it left the correct path showing on the control panel.
However, the icons and smileys are still not showing up on the post form. It sure does feel like a path error, but where to look?
|
|
|
|
Re: Moving whole website to a different server [message #40617 is a reply to message #40605] |
Fri, 28 March 2008 15:22 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
Well, I have checked and rechecked the GLOBALS.php file and the symlinks, which both say:
lrwxr-xr-x 1 rpivps www 40 Mar 15 01:07 GLOBALS.php -> /usr/local/forumdata/include/GLOBALS.php
I CD'd to the respective folders and edited the GLOBALS.php file and in both cases found the content identical to the actual GLOBALS.php file at the above path.
I notice that clicking on one of the little placeholder icons generates an error (displayed in the footer or status bar), as does each of the placeholders for smileys, and as does the show all smileys link.
Except for participants not being able to insert these icons and smileys, the site seems to be running strong, including the accurate display of at least one smiley with sunglasses (which has been there for a long time) on my forum home page.
I hope you can give me a tip or two. I can't imagine the site working so well with a basic GLOBALS.php error, and yet, some sort of path error seems to make sense. Is there a chance that yet another permission issue may be involved? I did change all the file ownership to my userid. Thanks!
|
|
|
|
Re: Moving whole website to a different server [message #40628 is a reply to message #40626] |
Sun, 30 March 2008 15:38 |
WilliamBurns
Messages: 123 Registered: March 2004 Location: San Jose, CA
Karma: 0
|
Senior Member |
add to buddy list ignore all messages by this user
|
|
I have rebuilt the theme using the theme manager many times now, and the result seems the same every time: no icons/smileys.
But... I just got it! With some guesswork help from my ISP tech support. The clue came with a whole slew of messages like this:
[Mon Mar 31 16:28:18 2008] [error] [client 198.65.168.24] (13)Permission
denied: file permissions deny server access:
rpinet.com/wforum/images/smiley_icons/icon_redface.gif,
referer:
http://www.rpinet.com/wforum/index.php?t=post&reply_to=22742&rid=47 8&S=49d82ee55f564e6d1c9f46cd8d9e178e
I went into this directory:
rpinet.com/wforum/images/smiley_icons
All the image files were at 600 permission. I ran this command chmod 755 *
Then, I went into this directory:
rpinet.com/wforum/images/message_icons
All the image files were at 600 permission. I ran this command chmod 755 *
The icons and smileys now show up like they are supposed to.
How the permissions suddenly got set so restricted remains a mystery to me, but the board is up and running. Thanks again for all your help.
[Updated on: Mon, 31 March 2008 12:58] Report message to a moderator
|
|
|
|