FUDforum: FUDforum Installation Issues » After Forum Database import, all Forum accounts locked

Home » FUDforum » FUDforum Installation Issues » After Forum Database import, all Forum accounts locked

Show: Today's Messages :: Polls :: Message Navigator

After Forum Database import, all Forum accounts locked [message #20164]

Wed, 29 September 2004 23:02

piner

Messages: 8
Registered: September 2004

Karma: 0

Junior Member

I built a 2.6.6 version test FUDForum on a Solaris system and loaded it with some existing mail archives (mbox) files and everything worked fine. However, when I did a forum dump and then loaded the forum onto a production FUDForum, all the accounts were locked out on both the test forum and the new production forum. I can't get in as admin or root the either of the forums. Where do I turn from here? Please help!!!

Thanks!

Dan

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20189 is a reply to message #20164]

Thu, 30 September 2004 22:48

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Login to mysql and tell me what is the output of the following query (change fu26_ to whatever your sql prefix is).

SELECT users_opt, id FROM fud26_users LIMIT 5;

FUDforum Core Developer

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20264 is a reply to message #20164]

Tue, 05 October 2004 18:40

piner

Messages: 8
Registered: September 2004

Karma: 0

Junior Member

Ilia,

Test System:

I ran the command on the FUDForum testserver:

SELECT users_opt, id FROM fud26_users LIMIT 5;

This is the output:

+-----------+----+
| users_opt | id |
+-----------+----+
| 6585269 | 1 |
| 5405687 | 2 |
| 4357044 | 69 |
| 4357044 | 49 |
| 4357044 | 63 |
+-----------+----+
5 rows in set (0.00 sec)

My database name is fudbase.

Production system:

I also ran the command on the FUDForum production server:

SELECT users_opt, id FROM fud26_users LIMIT 5;

This is the output:

+-----------+----+
| users_opt | id |
+-----------+----+
| 6585269 | 1 |
| 5405687 | 2 |
| 4357044 | 69 |
| 4357044 | 49 |
| 4357044 | 63 |
+-----------+----+
5 rows in set (0.00 sec)

The testserver system is a Sun Blade 150 running Solaris 2.8. The production system is a Sun V100 running Solaris 2.8. I had everything working fine on the test system when I wanted to test the forum dump and import tools. I simply made a dump of the forum, copied it over to production server, and then ran the import tool on FUDForum on the production server. This worked fine and imported all the forums and posts from the test server to the production server, but then proceeded to lock me out of FUDForum on both the test and production systems. I really appreciate your help on this. I'm really stuck.

Thanks!

Dan

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20265 is a reply to message #20264]

Tue, 05 October 2004 18:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The first thing you should try is to clear out the sessions table.

If this still does not work, open the GLOBALS.php inside the include/ directory and make sure that cookie domain & path settings are correct.

If you do need to adjust them login via http://url.to.your.forum/adm/

and then rebuild the theme.

FUDforum Core Developer

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20269 is a reply to message #20265]

Tue, 05 October 2004 20:35

piner

Messages: 8
Registered: September 2004

Karma: 0

Junior Member

Thanks again,

I have gone into the mysql database on the testserver and cleared out the sessions by doing the following:

mysql>DELETE FROM fud26_ses;

Then I ran to verify it is empty:

mysql>SELECT * FROM fud26_ses;

This cleared out the fud26_ses table in the fudbase database.

The other suggestions you made I believe require me to have admin access to the FUDForum and I am locked out of all FUDForum accounts including the admin account. I can modify the /opt/xampp/FUDForum/include/GLOBALS.php file from the UNIX command prompt with vi editor, however I'm not sure how to rebuild the themes without having access to the admin control panel. Still struggling. Thanks again.

Dan

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20271 is a reply to message #20269]

Tue, 05 October 2004 20:47

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

If you modify the globals file, the changes should allow you to access admin control panel via http://your.forum/adm/

FUDforum Core Developer

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20292 is a reply to message #20271]

Wed, 06 October 2004 20:09

piner

Messages: 8
Registered: September 2004

Karma: 0

Junior Member

Still can't get into the FUDforum as "admin". Therefore I have ran some additional tests and have come to a conclusion.

Tests ran:

On System A

1.Created a whole new Apache, mysql environment.

2.Assigned the mysql root account a password.

3.Created a new database called "fudbase"

4.Installed a new FUDforum environment.

5.Logged into the new FUDforum and created some test categories and corresponding forums.

6.I then did a FUDForum dump that created a file "FUDforum_06_10_2004_11_43.fud"

7.I saved this FUDForum dump file.
----------------------------------------------------------------

On System B

1.Created a whole new Apache, mysql environment.

2.Assigned the mysql root account a password.

3.Created a new database called "fudbase"

4.Installed a new FUDforum environment.

5.Using the Administrator Tool I then imported the file
"FUDforum_06_10_2004_11_43.fud".

6.After the import completed I was prompted by FUDforum to run a forum consistency check. I clicked on the link to run this and I was given a login window at myhost/adm location. I then tried to login and I was now again locked out of the newly created FUDForum.

Additional test:

1.On system A I manually removed the categories and forums.

2.Imported the dump that I just created with this FUDForum and the import went just fine. I could log into the same FUDForum.

Conclusion:

If you use a FUDForum on a system to create a FUDForum dump and then try to import that dump to another system running FUDForum, all the accounts will now be locked.

However, if you create the FUDForum dump on a system and then import back into that system, things will work fine.

The reason I want to do this is so I can have the ability to take a dump of the forum from a production server and recreate the entire environment on another system in an emergency.

Please let me know if any of these conclusions are wrong. In addition, is there anything else besides the dump file that I would need to transfer over from a given system running FUDForum to another system also running FUDForum that I wished to import to?

Thanks!

Dan

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20295 is a reply to message #20292]

Wed, 06 October 2004 20:49

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Did you try logging in using the source forum's admin account or the destination one? You should use the source forum's account, as all the destination's forum data is cleared on import.

FUDforum Core Developer

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20297 is a reply to message #20295]

Wed, 06 October 2004 21:54

piner

Messages: 8
Registered: September 2004

Karma: 0

Junior Member

Yes, I did try to use the source forums' root account and password and it still will not let me into the target forum. It is my understanding that the import process replaces the target forums' database accounts with the source forums' accounts. I was wondering if maybe the FUDforum dump tool locks the databases prior to creating the dump file, but the import tool does not unlock them. Just a thought. Still working on this. Thanks again for your assistance.

Smile

Dan

Report message to a moderator

Re: After Forum Database import, all Forum accounts locked [message #20298 is a reply to message #20297]

Wed, 06 October 2004 22:50

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Nope, if that had happened, 1st the lock would be released on script termination. Secondly if somehow the lock was left, mysql's 'show processlist' would show you a process holding a lock.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	1146: Table 'dbname_fudforum.fud26_pmsg' doesn't exist
Next Topic:	Can't access GLOBALS.php after moving forum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 15 23:24:07 GMT 2024

Total time taken to generate the page: 0.02382 seconds