Logging In

[riki64]

I cant log into my server. When I put my name and password in, it just gives me the wrong info message. So I can't log in.

I can't find the answer this one. So i'm sure its something I missed on my part. I checked in navicat and sure enough, my info is there (i.e. admin pw:1234) but when entering it, it says its wrong. I'm not sure WHAT id its looking for.

Any suggestions I can try? Any and ALL that help, will get +Rep



ps:
I noticed when trying to find a solution to my prob - people have been asking about the mailbox_insert_queue error:

Try the following: (worked for me)

--
-- Table structure for table `mailbox_insert_queue`
--

DROP TABLE IF EXISTS `mailbox_insert_queue`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `mailbox_insert_queue` (
  `sender_guid` int(30) NOT NULL,
  `receiver_guid` int(30) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `body` varchar(500) NOT NULL,
  `stationary` int(30) NOT NULL,
  `money` int(30) NOT NULL,
  `item_id` int(30) NOT NULL,
  `item_stack` int(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `mailbox_insert_queue`
--

LOCK TABLES `mailbox_insert_queue` WRITE;
/*!40000 ALTER TABLE `mailbox_insert_queue` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailbox_insert_queue` ENABLE KEYS */;
UNLOCK TABLES;

[Sonic Waffle]

Are you even connecting to you're server or the blizz servers? >.<
Sorry to ask, but some people forget to change their realmlist...

[doublehex]

1) make sure you have your server online
2) check configs
3) check realmlist
not sure what else off the top of my head

EDIT: dang lol too slow XD

[~ViVo~]

OMG i was going to ask about that.. +Rep

[riki64]

Are you even connecting to you're server or the blizz servers? >.<
Sorry to ask, but some people forget to change their realmlist...

Np I understand (I had and older one up for almost a year) the only thing i did different on this one is that i used MYSQL v5 instead of the ones that come with the AC Ultimate Repack. So I wonder if its picking up the info from somewhere else.

Thanks

[riki64]

1) make sure you have your server online
2) check configs
3) check realmlist
not sure what else off the top of my head

EDIT: dang lol too slow XD

thats ok, i'll still give ya a rep lol

The configs match my old server. What exactly should I be looking for IN those configs?

[doublehex]

well if you just read what the configs say and you follow them correctly then they should be fine, keep the defaults if you want it for a server on your comp only(not public)

[riki64]

well if you just read what the configs say and you follow them correctly then they should be fine, keep the defaults if you want it for a server on your comp only(not public)

Well they load up fine with no errors (cept for the mail box one, and now there is a "muted" issues but i can take are of that one). The only reason I started from scratch was that I compiled the new one 4.0 and it works great. but now just can't log on.

I think what I'll try is uninstall the MYSQL v5(that is the only thing that I did different) AND move the AC ultimate repack's mysql directory and run it that way and see what happens.

I'll keep you guys informed...

cheers

[~ViVo~]

riki Since you did that.. ill rep you if you can figure out how to fix my new error.
Ascentworld.Disenchantingloot' Doesn't exist :/

[riki64]

riki Since you did that.. ill rep you if you can figure out how to fix my new error.
Ascentworld.Disenchantingloot' Doesn't exist :/

hmmm
I love a challange... lemme see what I can come up with :-)

[Sonic Waffle]

Ascentworld.Disenchantingloot' Doesn't exist :/

You need to install that table to the DB, as ascent cannot find it! :P

[doublehex]

get it from ncdbs svn:

DROP TABLE IF EXISTS `disenchantingloot`;
CREATE TABLE `disenchantingloot` (
`index` int(11) NOT NULL auto_increment,
`entryid` int(11) unsigned NOT NULL default '0',
`itemid` int(11) unsigned NOT NULL default '25',
`percentchance` float NOT NULL default '0',
`heroicpercentchance` float default '0',
`mincount` int(30) default '1',
`maxcount` int(30) default '1',
`ffa_loot` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`index`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=utf8*/;

[riki64]

dang your fast :P

[doublehex]

yes i am

[riki64]

Ok. Here is what I did for this goofy error.
I have all these files separate if anyone needs them.

1. Uninstalled MySQL (v5)
2. in my root dir I made a sub dir /server
3. copy the mysql dir from my ac ultimate repack (or set it up yourself)
4. now run the mysql program from this dir
5. go to your NCDB and run the TOOL.BAT
6. Navigate Navicat to \ascentsrc\branches\3_8_stable\sql and update the character structure and logon structure
7. Open accounts and add your name
8. Run.

Now it works and I can log on.
So now it begs the question if i can log on with NAVICAT and the lognserver/ascent-world loads fine, why could I not log on with MySQL installed, but I can with the above procedure.

anyways.. no biggy. Now I have to see whats up with some old bugs and see if they are fixed with this new compile

Thanx - You guys are great!