[MANGOS]Set up your Mangos Server 2.0.8 TBC with EasyPHP

I have everything working good with other people connecting to my wow server but i cant get remote connections to the web portal please help.

is there a possibility to upload this in a cpanelx server

1)I cant connect to my server

2) and eror with php site

MySQL said: http://127.0.0.1/phpmyadmin/themes/o...img/b_help.png
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

What I need to do?

Alright I have my private server set up exactly how it states in the directions, and I can't get past the realm list. I already checked to see if the default world port matches already. I installed it on a fresh install of Windows XP PRO SP2. Any ideas?
[IMG]file:///C:/DOCUME%7E1/Owner/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG]

Quote:

---

Originally Posted by nos770

you must first go to whatismyip.com. there is your wan ip. after you fowarded the following ports: 3443,3306,8085, set your realmlist to your wan ip. run your realmd and your mangos and people can connect to your server outside your own network.

---

Where is that ports?
What I need to do?

i got those messages please help, all is rigthtly configured, also the 3306 port is open, i can create accounts, but when i try to enter to the server status i got those messages, please help!!

SQL Error: at C:\wamp\www\wow\components\server\server.realmstatus.php line 58

Array
(
[code] => 0
[message] =>
[query] => mysql_connect()
[context] => C:\wamp\www\wow\components\server\server.realmstatus.php line 58
)

SQL Error: at C:\wamp\www\wow\components\server\server.realmstatus.php line 60

Array
(
[code] => 0
[message] =>
[query] => SET NAMES CP1251
[context] => C:\wamp\www\wow\components\server\server.realmstatus.php line 60
)

SQL Error: at C:\wamp\www\wow\components\server\server.realmstatus.php line 62

Array
(
[code] => 0
[message] =>
[query] => SELECT count(*) FROM `character` WHERE online=1
[context] => C:\wamp\www\wow\components\server\server.realmstatus.php line 62

hey
my server work properly and every could log in and everything. But then when i came home from a friend no one could log in to it :S the ports was still opened so thats not the problem. Does anyone know what the problem is? please help me!

ok i got everything working everyone can join and all but ppl not on the host computer cannot see chat....wat is going on here

Hi. my server is working, but i can

Quote:

---

Originally Posted by Dunkmydonuts

ok, im on step 7, where is the realmlist.wtf file located? its not in the Mangos folder i made... should it be???

---

If no one already answer'd this :sq_yellow
Its in your World of Warcraft folder :winky:



Now for my question :poster_ss How much of Outland is spawn'd with this? :Jumpy:
:drinks_dr

Quote:

---

Originally Posted by deatheagle

ok i got everything working everyone can join and all but ppl not on the host computer cannot see chat....wat is going on here

---

This is cos' you need the right patch :eek:
(Does the commands like .money 99999 not give you money and .speed 10 make you stand still?:eek6: )
If you've got teh right patch's I got no idea whats going on...But that what happens to me..
Then I got the correct patch's and it worked fine :poster_ss

(Sorry for double post :sq_yellow )

Ok so I think Im doing everything right however when I run mangosd.exe this is the error I am getting

Loading Game Object Templates...
SQL: SELECT MAX(`entry`) FROM `gameobject_template`
query ERROR: Table 'realmd.gameobject_template' doesn't exist
Error loading `gameobject_template` table (not exist?)

Anyone know why this is happening and how I can fix it?

Ok wow I got it all set up and working great work here however how do you get other player to connect to this server. I was playing around with this but I am at a lost. With my second computer I can see the server on the realm selection and when you select it all it dose is reload the realm list O and the server shows up in yellow.

All my ports are open to the server using DMZ on the router and firewall is off.

How can I fix this Please help

Quote:

---

Ok so I think Im doing everything right however when I run mangosd.exe this is the error I am getting

Loading Game Object Templates...
SQL: SELECT MAX(`entry`) FROM `gameobject_template`
query ERROR: Table 'realmd.gameobject_template' doesn't exist
Error loading `gameobject_template` table (not exist?)

---

I had the same problem what I did is Drop Data Base and make a new one and named it mangos then restore from SQL Dump.

[quote=jtwoj1;2379855]Ok wow I got it all set up and working great work here however how do you get other player to connect to this server. I was playing around with this but I am at a lost. With my second computer I can see the server on the realm selection and when you select it all it dose is reload the realm list O and the server shows up in yellow.

All my ports are open to the server using DMZ on the router and firewall is off.

How can I fix this Please help

i get the same error trying to extract sql_newtables
Query:
/* */
/* UNKNOWN LOCATION */
/* WORLD BOSS */
UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

Error occured at:2007-10-10 15:38:57
Line no.:7
Error Code: 1046 - No database selected

Query:
/* */
/* UNKNOWN LOCATION */
/* WORLD BOSS */
UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

Error occured at:2007-10-10 15:48:20
Line no.:7
Error Code: 1146 - Table 'db.creature_template' doesn't exist

Query:
/* */
/* UNKNOWN LOCATION */
/* WORLD BOSS */
UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

Error occured at:2007-10-10 15:48:28
Line no.:7
Error Code: 1146 - Table 'db.creature_template' doesn't exist

Query:
/* THIS FILE CONTAINS ADDITIONAL SQL REQUIRED FOR SCRIPTS TO WORK PROPERLY */
/* CAN BE INCLUDED IN ANY DATABASE IF SCRIPTDEV SUPPORT IS WANTED BY DEFAULT */
/* It's recommended to run this SQL after any regular database update */
/* */
/* AREATRIGGER_TEMPLATE */
/* */
/* */
/* CREATURE_TEMPLATE */
/* */
/* UPDATE `creature_template` SET `faction` = 0, `npcflag` = 0 WHERE `entry`= xxxxx ; */
/* Lothos Riftwaker */
UPDATE `creature_template` SET `npcflag`= 3 WHERE `entry` = 14387

Error occured at:2007-10-10 15:48:31
Line no.:17
Error Code: 1146 - Table 'db.creature_template' doesn't exist

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:11:11
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:11:33
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:12:24
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-10-16 13:12:35
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:13:04
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:30:49
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:31:26
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-16 13:35:59
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

what should i do ? sorry for the size of error...

Quote:

---

Originally Posted by pawnyou

i get this same thing i think u might have somthing wrong with ur update 22.sql file so could u please post a fixed version of it or somthing would be great and im using 2.0.12 if that makes and differnts to the file

---

i have the same thing you have too... what to do to fix it ?. someone please help sorry for doubble posting

Help plz,

I use Gm command's but thy dont do anything
I use .GMon than GmCommand's they do nothing
I have GMlevel 6 in SQL so that isnt it

Can you help me.

And where can i find a list with gm commands(.commands isnt working)

Can't use the search

. Open your browser and go to http://127.0.0.1/phpmyadmin

that doesnt work for me it says

The page cannot be displayed

The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.Please try the following:

• <LI id=instructionsText1>Click the [IMG]res://shdoclc.dll/refresh.gif[/IMG] Refresh button, or try again later.
  <LI id=instructionsText2>If you typed the page address in the Address bar, make sure that it is spelled correctly.
  <LI id=instructionsText3>To check your connection settings, click the Tools menu, and then click Internet Options. On the Connections tab, click Settings. The settings should match those provided by your local area network (LAN) administrator or Internet service provider (ISP). <LI id=list4>See if your Internet connection settings are being detected. You can set Microsoft Windows to examine your network and automatically discover network connection settings (if your network administrator has enabled this setting).
  1. <LI id=instructionText6>Click the Tools menu, and then click Internet Options. <LI id=instructionText7>On the Connections tab, click LAN Settings.
  2. Select Automatically detect settings, and then click OK.
  <LI id=instructionsText5>Some sites require 128-bit connection security. Click the Help menu and then click About Internet Explorer to determine what strength security you have installed. <LI id=instructionsText4>If you are trying to reach a secure site, make sure your Security settings can support it. Click the Tools menu, and then click Internet Options. On the Advanced tab, scroll to the Security section and check settings for SSL 2.0, SSL 3.0, TLS 1.0, PCT 1.0.
• Click the [IMG]res://shdoclc.dll/back.gif[/IMG] Back button to try another link.

Cannot find server or DNS Error
Internet Explorer


What should i Do ?

I got an problem with the execute of sql_newtables.sql

can someone tel me whats wrong??

Quote:

---

Originally Posted by danny112

I got an problem with the execute of sql_newtables.sql

can someone tel me whats wrong??

---

I have the same problem it tells me

Quote:

---

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-19 11:37:44
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-19 11:37:53
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE site_regkeys ADD `used` tinyint(1) DEFAULT '0'

Error occured at:2007-10-19 11:38:18
Line no.:1
Error Code: 1146 - Table 'realmd.site_regkeys' doesn't exist

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-19 11:41:05
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-10-19 11:50:11
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

---

but what I need to do now??

it is a f*ckt up problem!!

on part 8 step step 7... why wont it work? and i cant connect to the link for http://127.0.0.1/phpmyadmin it realy sucks. How can i solve the problem?

eh... every time i try to log onto SQLyog it comes up a message contains:
Error No. 1130
Host "localhost" is not allowed to connect to this MySQL server.
what do i do?

Can any one tell me plz how to rollback the patch I got the news one, everything works fine but the GM commands I get a massage that says “SESSION: received unhandled opcide unknown (0x038C)” this massage is in my MaNGOS

Thank you