AC Web Ultimate Repack for 2.3.0 Tutorial! With Pictures For Newbies

[Skozzan]

Skozzan do u know how to fix my problem? or can u upload your .confg files?

Check the "logonserver.conf" and scroll down to the lines:

# Host Directive
#
#    This is the address that the realmlist will listen on.
#    To listen on all addresses, set it to 0.0.0.0
#    Default: 127.0.0.1 (localhost)
#
#    Note: ISHost is the interserver communication listener.
#
<Listen Host = "127.0.0.1"
        ISHost = "127.0.0.1"
        RealmListPort = "3724"
        ServerPort = "8093">

Change the ISHost to 127.0.0.1 not "localhost"

[Desus]

Skozzan are u just ignoring my calls 4 help or dont u know how 2 fix it?. can u upload your .confg files?

[trigun345]

yeah. im having the same problems. except the authentication doesnt fail. it just keeps timing out. this has been annoying me for the past week. cant you post a quick fix for it? my .Conf files are exactly as how they should be. im wondering whats the deal.

[Xeneth]

MySQLyog is used to view Sql files, It's the basis of many programs released by the makers of MySql, There are alternatives

Google

HeidiSql (<< my prefered)

Navicat (sp?)

I use a combination of MySql and Heidi

[Kolbein]

My server worked fine yesterday, but when I started Ascent now
this error shows up;

[karal007]

Hey Genius This Is Not Ac-webs Repack And You Must Post There Website Anyway Its N The Copyrigt

[trigun345]

still no one posts a reply.. im beginning to doubt the level of other peoples reading skills.


my authentication times out when i run ascent.
thats it.
quick fix?
it cant be that difficult.

[Skozzan]

Hey Genius This Is Not Ac-webs Repack And You Must Post There Website Anyway Its N The Copyrigt

Hey dipshit! It would be easier if you read the other replies! I've been saying alot that I didn't know there was an inbuilt MySQL database and that.. So I just fixed it as I usally fix a server.. So this is my way of making a server.. And you can compare this ac-web pack to the one you download from AC Web that it's the same files and all that! And I can't change the tutorial now! When so many ppl have been using this.. It would screw up for them alot!

And I've posted their website!

[Tinky]

I don't get how to open the ports.

greatful for help

[Skozzan]

I don't get how to open the ports.

greatful for help

Just look for your router brand and model on:

PortForward.com - Free Help Setting up Your Router or Firewall

Then there will be for the game: World of Warcraft.. and that port is 3724. And after that.. Do the same thing but with the other ports, after that just restart the router and it should work..

[Kolbein]

Skozzan, Do you thing you can fix my problem?

[serzxs]

hi, i have one big problem.. when i try to execute ascent_world, error log jumps out.. it says:

Query:
CREATE TABLE `banned_names` (
`name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-04 16:39:45
Line no.:71
Error Code: 1050 - Table 'banned_names' already existsQuery:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:40:00
Line no.:27
Error Code: 1050 - Table 'ai_agents' already existsQuery:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:41:12
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:43:59
Line no.:27
Error Code: 1050 - Table 'ai_agents' already existsQuery:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:44:45
Line no.:27
Error Code: 1050 - Table 'ai_agents' already existsQuery:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:45:12
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:45:30
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-04 16:49:50
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists





can u pls tell me how to debug this?

[Skozzan]

hi, i have one big problem.. when i try to execute ascent_world, error log jumps out..

Then you got some other mysql database thats using the 3306 port.. If you can figure out whats blocking it.. uninstall that program or what it is and then try again.. I had the same problem once.. Or you got some phpbb forum thats using mysql databases.. I dunno

[Jacob7]

MAn SQLlog sucks use Navicat its very very very better. And gives a wider easier variety of stuff. I have done your guide .

ITS AMAZING + Rep man alot of it. This guide is so easy my lil bro in his sleep could do it. Lol and he is 4 its nice but change it from SQL log to Navicat the more noobs who read from this post will be able to use navicat easier. TY alot man. ^_^

[Jacob7]

And sorry to post here again but you fixed my problems i was having with teh other guidies my MYSQL connected instantly and all it finally works if i get it live but i run off a wireless net gear router if you could help me on that.