| Re: new problem - will not start |
Thu, 21 March 2002 00:26 |
|
|
I have no clue who creates the morph files you are seeing, try running lsof command and grepping for what program is using those files...
I'll modify the register globals form to work with it is submitted with a return and consider a better position for the "Set" button.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 21:49 |
|
|
Oh, way over there to the right. I had not seen that before! Could you move it down to a line by itself so it would be on the left?
I found out one reason why I ran out of space. In the /var/lib/mysql directory there is a morph.log file that is 55MB. Can that be deleted or at least be reduced in size? There are also some files with names like morph-bin.009 that are fairly large.
Thanks again for all of your help. I really appreciate it.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 21:33 |
|
|
You see no update(Set) button?
There should be a "Set" button at the bottom right corner of the page, you may need to scroll a little to see it because admglobal is a rathe long form.
If the button is not there, then that is your problem, to solve it simply replace your admglobals.php with the admglobals.php from the one stored inside the forum_install/install_data/docs/adm/ directory (the forum sources you've downloaded).
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 21:29 |
|
|
I have already upgraded to 1.2.3 so that is not the problem.
One thing that has puzzled me before is that the global settings manager does not have an update button. I made a change to the 'reason for disabling' message. I then went to the message editor and then back to the global settings and I got back the original vaues not what I had changed them to. How does one save the settings?
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 21:09 |
|
|
Hmm... try changing some other setting using the admin control panel, see if it saves the value...
If it does not, consider upgrading to later FUDforum version...
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 21:07 |
|
|
|
The files in the include directory all are owned by apache. The 'copies' in the html directories all are shown as symlinks.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 21:03 |
|
|
Maybe it did not have permissions to write to the file?
Another reason could be that the 2 symlinks to the GLOBALS.php inside forum's web root & adm/ dir got changed to files. So, they don't reflect the data inside the GLOBALS.php stored inside the include/ directory.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:45 |
|
|
ok, the forum consistency check now runs ok. No error messages. It then says the forum is currently disabled and that I should go toe the Global settings manager to re-enable it. I tried that. Changed the picklist from no to yes and then clicked return to forum but I still receive the message saying :
Undergoing Upgrades
Administrators can login here
I then noticed that the time stamp on the GLOBALS.php file in the include directory had not changed. I then change the N to Y to enable it using vi. I was then able to access the forum. So far it looks like the various messages are there! Time for a big backup.
Why would the admin control panel not be able to change the GLOBALS.php file?
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:22 |
|
|
| fjrohlf wrote on Wed, 20 March 2002 8:19 PM |
No, I just stopped the deamon I did not stop using mysqladmin also. Should I try to kill all of those processes?
|
Uhm did you use the "kill" command?
You ALWAYS should stop mysql using the mysqladmin script, otherwise you risk corrupting the databases.
use the command like this:
mysqladmin -uroot -pROOT_PASS shutdown
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:19 |
|
|
|
No, I just stopped the deamon I did not stop using mysqladmin also. Should I try to kill all of those processes?
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:16 |
|
|
Heh...
Before you start mysql, did you shut it down using mysqladmin?
You cannot start another Mysql if the old one is still running!
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:16 |
|
|
Myabe it is creating to mysql.sock file somewhere else?
Your tmp directory is usually where mysql stores them in.
If you cannot locate the file, change the forum's MYSQL_SERVER to localhost or 127.0.0.1
|
|
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:12 |
|
|
| fjrohlf wrote on Wed, 20 March 2002 8:10 PM |
I tried /etc/init.d/mysql start
and I get the following:
Starting mysqld daemon with databases from /var/lib/mysql
020320 20:19:40 mysqld ended
If I then type mysql I get the following:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
|
I think your mysql fails to start...
after you run your start script, do a "ps aux" and see if you can spot mysql running....
|
|
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:10 |
|
|
I tried /etc/init.d/mysql start
and I get the following:
Starting mysqld daemon with databases from /var/lib/mysql
020320 20:19:40 mysqld ended
If I then type mysql I get the following:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
|
|
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 20:06 |
|
|
|
Strange. Now the /var/lib/mysql/mysql.sock has vanished. How does one create a new one? I see I have one in my backup directory. Can it be copied?
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 19:54 |
|
|
try that...
You probably want to overwrite the entire directory cause each table has 3 files, replacing just 1 file won't fix the problem, cause the data in all 3 files per table needs to match.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 19:52 |
|
|
|
ok, it did something. Problem still is that the fud_thread_view.MYD file is missing. Perhaps there is nothing to lose in copying it from my backup.
|
|
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 19:14 |
|
|
|
I found a file called mysqlcheck in the usr/bin directory. I ran it with the --all-databases option and it said all were ok except: forumdata.fud_index and forumdata.fud_msg are corrupt and the file forumdata.fud_thread_view.MYD cannot be found. I noticed that there was a repair options -a and -r. Should I try them?
|
|
|
|
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 18:02 |
|
|
| fjrohlf wrote on Wed, 20 March 2002 5:22 PM |
I ran the update. Final result was a screen with the following message:
Locking the database for checking
Query Failed: LOCK TABLES fud_thread WRITE, fud_thread_view WRITE, fud_forum WRITE, fud_cat WRITE, fud_msg WRITE, fud_mod WRITE, fud_users WRITE, fud_users AS fud_users_2 WRITE, fud_read WRITE, fud_poll WRITE, fud_poll_opt WRITE, fud_poll_opt_track WRITE, fud_smiley WRITE, fud_thread_notify WRITE, fud_forum_notify WRITE, fud_attach WRITE, fud_msg_report WRITE, fud_thread_rate_track WRITE, fud_level WRITE, fud_custom_tags WRITE, fud_user_ignore READ, fud_buddy WRITE, fud_pmsg WRITE, fud_ext_block WRITE
Reason: Can't find file: 'fud_thread_view.MYD' (errno: 2)
From: /var/www/html/forum/adm/consist.php
Server Version: 3.23.48-log
Now the forum seems disabled. Get the message "Undergoing upgrades".
|
Oh boy, you running out of space seems to have screwed up MySQL. Mysql query failed because mysql couldn't find "fud_thread_view.MYD" file. You'll need to run mysql integrity checker & fixer 1st.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 17:22 |
|
|
I ran the update. Final result was a screen with the following message:
Locking the database for checking
Query Failed: LOCK TABLES fud_thread WRITE, fud_thread_view WRITE, fud_forum WRITE, fud_cat WRITE, fud_msg WRITE, fud_mod WRITE, fud_users WRITE, fud_users AS fud_users_2 WRITE, fud_read WRITE, fud_poll WRITE, fud_poll_opt WRITE, fud_poll_opt_track WRITE, fud_smiley WRITE, fud_thread_notify WRITE, fud_forum_notify WRITE, fud_attach WRITE, fud_msg_report WRITE, fud_thread_rate_track WRITE, fud_level WRITE, fud_custom_tags WRITE, fud_user_ignore READ, fud_buddy WRITE, fud_pmsg WRITE, fud_ext_block WRITE
Reason: Can't find file: 'fud_thread_view.MYD' (errno: 2)
From: /var/www/html/forum/adm/consist.php
Server Version: 3.23.48-log
Now the forum seems disabled. Get the message "Undergoing upgrades".
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 16:39 |
|
|
|
Yeah, that would be a good idea, running a consistency checker would also fix most problem other then the GLOBALS.php problem, which I believe you've already fixed.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 16:37 |
|
|
|
I think I found the root of the problem - the /var partition was full. I have created some free space but still get the same error. Some files must have been corrupted. What is the best strategy? Is the update to 1.2.3 likely to fix anything?
|
|
|
|
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 15:55 |
|
|
If fixed the $MYSQL_SERVER setting and now I get the following error when I access the forum:
Query Failed: SELECT count(*) FROM fud_msg LEFT JOIN fud_thread ON fud_msg.thread_id=fud_thread.id LEFT JOIN fud_forum ON fud_thread.forum_id=fud_forum.id LEFT JOIN fud_mod ON fud_forum.id=fud_mod.forum_id AND fud_mod.user_id=1 WHERE fud_msg.approved='N' AND fud_forum.moderated='Y'
Reason: Can't open file: 'fud_msg.MYD'. (errno: 145)
From: /var/www/html/forum/index.php
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 15:44 |
|
|
Verify your MYSQL settings inside the GLOBALS.php file.
if you are using the socket, make sure you MYSQL_SERVER line reads:
:/var/mysql.sock and NOT /var/mysql.sock
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 15:43 |
|
|
I found that the GLOBALS.php file in the forumdata/include directory had just 0 bytes! I have no idea how that happened. I have not done anything with the forum for several days. Fortunately, I had a pretty recent backup copy of that file so I copied it over. Different error now. It says:
Warning: Can't connect to local MySQL server through socket '/var/lib/mysql.sock' (2) in /var/www/forumdata/include/db.inc on line 26
The mysql.sock file is there. This sounded familiar so I tried a previous suggestion about typing
mysql -S/var/mysql.sock -uuserid -ppassword
and I recieved the same error message.
|
|
| Re: new problem - will not start |
Wed, 20 March 2002 12:37 |
|
|
Verify the validity of you GLOBALS.php file and the symlinks to it.
This problem occurs because GLOBALS.php or the symlinks to it were corrupted.
Which version of the forum are you running?
|
|
| new problem - will not start |
Wed, 20 March 2002 12:25 |
|
|
I just checked my forum today and received the following message:
Fatal error: Call to undefined function: fud_use() in /var/www/html/forum/index.php on line 22
What should I do now?
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home