Login and Admin panel not showing.

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Did complete install of Mangosweb Enhanced
2.Chose username and pass for admin during install.
3.I login as administrator

What is the expected output? What do you see instead?
login should work and admin panel should show.

It appears that acct login fails and admin panel never shows. The admin acct is 
being added to the DB correctly. Also DB functions are going through because 
acct creation works for members.

What revision of the product are you using? In what browser?
Rev. 45 3.3.3a Chrome/IE/Firefox

What version are you using? MangosWeb or TrinityWeb?

Mangosweb 

Please provide any additional information below.

This is a fresh build of the 3.3.5 release directly from getmangos. I know the 
rev is newer however I cannot see the update being the problem.

Any ideas community ?

Original issue reported on code.google.com by neot...@gmail.com on 6 Jul 2010 at 3:42

[GoogleCodeExporter]

did you have the same admin account setup already via mangos server before you 
installed mangosweb? if so that could be your issue..., try setting up an admin 
account with a different username and password and see if you have an issue 
still logging in. It even tells you in one of the install steps that if the 
account exists already mangosweb will not include the new password..., for some 
reason this also causes issues with old password. if creating you try 
reinstalling with a new admin username and pass and it still doesn't work then 
you could try this:

As I am assuming by the date of the post that this was for Mangosweb v1 release

Well you could try this to get the old admin account back..., at least to get 
logged back in:

Well you could try this to get the old admin account back..., at least to get 
logged back in.

Run this query for admin user "well" with pass "malibu123":
Code:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `account`
--

--
-- Dumping data for table `account`
--

REPLACE INTO `account` (`id`, `username`, `sha_pass_hash`, `gmlevel`, 
`sessionkey`, `v`, `s`, `email`, `joindate`, `last_ip`, `failed_logins`, 
`locked`, `last_login`, `active_realm_id`, `expansion`, `mutetime`, `locale`) 
VALUES
(9, 'well', '2192c6aabbdfec2314cd90f18109da69600cc1bd', 3, NULL, NULL, NULL, 
NULL, '2010-03-14 16:40:58', '127.0.0.1', 0, 0, '2010-03-14 16:43:31', 0, 0, 0, 
0);

Then run this query for "well" extend:

Code:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `account`
--

--
-- Dumping data for table `account_extend`
--

REPLACE INTO `account_extend` (`account_id`, `character_id`, `character_name`, 
`g_id`, `avatar`, `gender`, `homepage`, `icq`, `location`, `signature`, 
`hideemail`, `hideprofile`, `theme`, `forum_posts`, `registration_ip`, 
`activation_code`, `msn`, `secretq1`, `secreta1`, `secretq2`, `secreta2`, 
`vip`, `donator`) VALUES
(9, 8, 'Well', 4, NULL, 0, NULL, NULL, NULL, NULL, 1, 0, 0, 4, '0.0.0.0', NULL, 
NULL, '0', '0', '0', '0', 0, 0);

that restores an admin account so you can log in and modify what accounts you 
currently are having issues with

~good luck 

Original comment by deathwatchgaming on 29 Jul 2010 at 6:34

[GoogleCodeExporter]

thank you.. i solve the same problem...

Original comment by gaf03s...@gmail.com on 12 Oct 2010 at 12:01

[GoogleCodeExporter]

hi.!!! i have the same problem with ¨MangosWeb Enhanced v2, Rev. 10, No HG 
Files¨ for 3.3.3A but this query dont work with this version.

any can help me ??

Original comment by gaf03s...@gmail.com on 16 Oct 2010 at 1:16