MySQL connection errors

11 posts

1. Maushin
   
   Regular
   Joined: Jul '08
   Posts: 44

   hi, I am trying to run a lan server following all the instructions given here but it seems I must be retarded or something as I can't even get Mangos or RealmD to even connect. And thats after going over all the advice give here. Here is what the DBErros says after I run Mangos:

   2008-07-05 00:14:47 SQL: UPDATE characters SET online = 0
   2008-07-05 00:14:47 SQL ERROR: Table 'mangos.characters' doesn't exist
   2008-07-05 00:14:47 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
   2008-07-05 00:14:47 SQL ERROR: Table 'mangos.account' doesn't exist
   2008-07-05 00:14:47 SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
   2008-07-05 00:14:47 SQL ERROR: Table 'mangos.realmlist' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(guid) FROM characters
   2008-07-05 00:14:47 query ERROR: Table 'mangos.characters' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(id) FROM character_pet
   2008-07-05 00:14:47 query ERROR: Table 'mangos.character_pet' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(guid) FROM item_instance
   2008-07-05 00:14:47 query ERROR: Table 'mangos.item_instance' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(id) FROM auctionhouse
   2008-07-05 00:14:47 query ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(id) FROM mail
   2008-07-05 00:14:47 query ERROR: Table 'mangos.mail' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(id) FROM item_text
   2008-07-05 00:14:47 query ERROR: Table 'mangos.item_text' doesn't exist
   2008-07-05 00:14:47 SQL: DELETE FROM character_inventory WHERE item >= '1'
   2008-07-05 00:14:47 SQL ERROR: Table 'mangos.character_inventory' doesn't exist
   2008-07-05 00:14:47 SQL: SELECT MAX(guid) FROM corpse
   2008-07-05 00:14:47 query ERROR: Table 'mangos.corpse' doesn't exist
   2008-07-05 00:14:47 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
   2008-07-05 00:14:47 SQL ERROR: Table 'mangos.mail_items' doesn't exist
   2008-07-05 00:14:47 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
   2008-07-05 00:14:47 SQL ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-05 00:14:47 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
   2008-07-05 00:17:30 SQL: UPDATE characters SET online = 0
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.characters' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(guid) FROM characters
   2008-07-05 00:17:30 query ERROR: Table 'mangos.characters' doesn't exist
   2008-07-05 00:17:30 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.account' doesn't exist
   2008-07-05 00:17:30 SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.realmlist' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(id) FROM character_pet
   2008-07-05 00:17:30 query ERROR: Table 'mangos.character_pet' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(guid) FROM item_instance
   2008-07-05 00:17:30 query ERROR: Table 'mangos.item_instance' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(id) FROM auctionhouse
   2008-07-05 00:17:30 query ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(id) FROM mail
   2008-07-05 00:17:30 query ERROR: Table 'mangos.mail' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(id) FROM item_text
   2008-07-05 00:17:30 query ERROR: Table 'mangos.item_text' doesn't exist
   2008-07-05 00:17:30 SQL: SELECT MAX(guid) FROM corpse
   2008-07-05 00:17:30 query ERROR: Table 'mangos.corpse' doesn't exist
   2008-07-05 00:17:30 SQL: DELETE FROM character_inventory WHERE item >= '1'
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.character_inventory' doesn't exist
   2008-07-05 00:17:30 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.mail_items' doesn't exist
   2008-07-05 00:17:30 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-05 00:17:30 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
   2008-07-05 00:17:30 SQL ERROR: Table 'mangos.guild_bank_item' doesn't exist
   2008-07-05 00:28:38 SQL: UPDATE characters SET online = 0
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.characters' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(guid) FROM characters
   2008-07-05 00:28:38 query ERROR: Table 'mangos.characters' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(id) FROM character_pet
   2008-07-05 00:28:38 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.account' doesn't exist
   2008-07-05 00:28:38 SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.realmlist' doesn't exist
   2008-07-05 00:28:38 query ERROR: Table 'mangos.character_pet' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(guid) FROM item_instance
   2008-07-05 00:28:38 query ERROR: Table 'mangos.item_instance' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(id) FROM auctionhouse
   2008-07-05 00:28:38 query ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(id) FROM mail
   2008-07-05 00:28:38 query ERROR: Table 'mangos.mail' doesn't exist
   2008-07-05 00:28:38 SQL: DELETE FROM character_inventory WHERE item >= '1'
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.character_inventory' doesn't exist
   2008-07-05 00:28:38 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.mail_items' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(id) FROM item_text
   2008-07-05 00:28:38 query ERROR: Table 'mangos.item_text' doesn't exist
   2008-07-05 00:28:38 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-05 00:28:38 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
   2008-07-05 00:28:38 SQL ERROR: Table 'mangos.guild_bank_item' doesn't exist
   2008-07-05 00:28:38 SQL: SELECT MAX(guid) FROM corpse
   2008-07-05 00:28:38 query ERROR: Table 'mangos.corpse' doesn't exist

   And this is what RealmD lists for errors

   2008-07-05 00:17:32 Using configuration file realmd.conf.
   2008-07-05 00:17:32 MaNGOS realm daemon /0.11.0-SVN (Revision 5953) (Win32)
   2008-07-05 00:17:32 <Ctrl-C> to stop.

   2008-07-05 00:17:32 Database: 127.0.0.1;3306;root;password;mangos;realmd
   2008-07-05 00:17:32 MySQL client library: 5.0.56
   2008-07-05 00:17:32 MySQL server ver: 5.0.51a
   2008-07-05 00:17:32 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color <> 3 ORDER BY name
   2008-07-05 00:17:32 ERROR:query ERROR: Table 'mangos.realmlist' doesn't exist
   2008-07-05 00:17:32 ERROR:No valid realms specified.

   If you have any Idea what I am doing wrong can you please help me? And if you can, put it in step by step easy to understand terms cause this stuff makes me feel kind of stupid lol.

   Posted 1 year ago » Permalink

2. Reaper-X
   
   The Reaper
   Joined: Feb '07
   Posts: 483

   based from your error messages, it seems that you haven't imported the sql file into the database yet .. btw could you tell me which version of mangos you're using?

   Posted 1 year ago » Permalink

3. Maushin
   
   Regular
   Joined: Jul '08
   Posts: 44

   I have Mangos version 5953 and am running Xampp. So how would I go about importing said file?

   Posted 1 year ago » Permalink

4. Orphan
   
   Regular
   Joined: May '08
   Posts: 49

   As Reaper has said, it doesn't really look like the mangos databases are in your MySQL.. I don't know what Xampp is, but you need to get a program like Navicat Lite so you can see what databases are in your MySQL. Is your MySQL working correctly? Can you open mysql from command prompt, or from the mysql shortcut in the start menu and login correctly?

   If so, login with your username / password and if typing in "use mangos;" works ( withought the quotation marks ) you should be able to access the mangos database then. If you can't, then simply it means that ManGOS is not properly installed into MySQL.

   If you cannot access it, attempt to install the database again with reaper-x-easy-install or whatever it's called, running the .bat files and it should install the database. If it doesn't, keep your eyes open for errors that appear when installing the database.

   Also when installing ManGOS from the install, just use the default values for databases / passwords etc;
   ie; mangos DB = mangos, charactersDB = characters, ScriptDev2DB = ScriptDev2

   Posted 1 year ago » Permalink

5. Maushin
   
   Regular
   Joined: Jul '08
   Posts: 44

   i did the "use mangos thing and it had no problems" still did not do anything. so i reinstalled database and still get errors including a runtime error when it errors out. so i have no idea what i am doing wrong at all and Xampp is the program that has apache, myscl, php and several other progs in it

   Posted 1 year ago » Permalink

6. Reaper-X
   
   The Reaper
   Joined: Feb '07
   Posts: 483

   based from your description because you're using mysql bundled from XAMPP could you test going into the command prompt and type:

   mysql -uroot -p

   enter password when prompted and then type:

   show databases like 'mangos';

   if you do it correctly you'll get:

   +-------------------+
   | Database (mangos) |
   +-------------------+
   | mangos            |
   +-------------------+
   1 row in set (0.00 sec)

   Posted 1 year ago » Permalink

7. Maushin
   
   Regular
   Joined: Jul '08
   Posts: 44

   ok i see that. but now what? and from my other post you asked what was wrong, and the answer to that is the two problems i listed above. SO what i am going to so is uninstall everything and start from scratch once more ( though this is like the 5th time) as its obvious i am missing a step somewhere. All I want to do is get a server going for a lan setup but i can't even seem to get a normal server going by what i am reading on here lol.

   Posted 1 year ago » Permalink

8. Reaper-X
   
   The Reaper
   Joined: Feb '07
   Posts: 483

   we are going to do it manually by importing the sql files into the database

   first you need to go to where the database sql file located, btw if you're using ReaperMangos5953 you just need to go to where reaper-x-mangos directory located, and i assume you put it in C:\Reaper-X

   1. open command prompt

   2. type:

   cd C:\Reaper-X\Reaper MaNGOS 5953\reaper-x-mangos

   then type:

   mysql -uroot -p -v < "create_structure.sql"
   mysql -uroot -p -v -D realmd < "realmd.sql"
   mysql -uroot -p -v -D characters < "characters.sql"
   mysql -uroot -p -v -D mangos < "reaper-mangos-udb.sql"
   mysql -uroot -p -v -D scriptdev2 < "scriptdev2_structure.sql"
   mysql -uroot -p -v -D mangos < "mangos_full_scripts.sql"
   mysql -uroot -p -v -D mangos < "mangos_additional_req.sql"
   mysql -uroot -p -v -D mangos < "acid1.sql"
   mysql -uroot -p -v -D scriptdev2 < "acid2.sql"

   or if you want to make it so you don't have to type password eachtime the sql file being imported just replace

   -p

   with

   -pmyrootpassword

   Posted 1 year ago » Permalink

9. Maushin
   
   Regular
   Joined: Jul '08
   Posts: 44

   Ok, but before I do that i have uninstalled and have begun reinstalling. Here is how I am doing it. Maybe you can see where I have gobne wrong.

   Step 1: Intsalled MaNGos 5953 to C:\Reaper-X

   Step 2: Installed MySQL server 5.0 to C:\Mysql

   Step 3: Copied Vmap tools to WoW folder then executed Makevmaps_simple.bat

   Step 4: Cut and pasted vmap tools, vmaps and buildings folders back into MaNGos tools\VmapExtractAssembler folder
   Step 5: Copied Map tools to Wow folder then executed extract-map.bat

   Step 6: Cut and pasted map tools and maps folder back into MaNGos tools\MapExtractor folder

   Step 7: Executed Reaper-X batch file. input C:\Mysql\bin as destination then selected option "1" then followed question instructions. Example = what is your world/mangos database name? (most likely "mangos")" and put in mangos, but without the quotes. ( I did this for all of them ). I have no errors after its task completed.

   Step 8: Exited Reaper-X mangos batch file

   Step 9: Edited Mangos.conf in the Reaper-X folder so that it looked like this

   RealmID = 1
   DataDir = "C:\mysql\data"
   LogsDir = ""
   LoginDatabaseInfo = "127.0.0.1;3306;root;password;mangos;realmd"
   WorldDatabaseInfo = "127.0.0.1;3306;root;password;mangos;mangos"
   CharacterDatabaseInfo = "127.0.0.1;3306;root;password;mangos;characters"

   Step 10: Edited Realmd in the Reaper-X folder so that it showed this

   LoginDatabaseInfo = "127.0.0.1;3306;root;107068736;mangos;realmd"
   LogsDir = ""
   MaxPingTime = 30
   RealmServerPort = 3724
   BindIP = "0.0.0.0"
   PidFile = ""
   LogLevel = 0
   LogTime = 0
   LogFile = "Realmd.log"
   LogTimestamp = 0

   Step 11: I then executed Mangos and realmd in the reaper-x folder and get the following errors.

   "MANGOS ERRORS"

   2008-07-06 12:41:17 SQL: UPDATE characters SET online = 0
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.characters' doesn't exist
   2008-07-06 12:41:17 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.account' doesn't exist
   2008-07-06 12:41:17 SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.realmlist' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(guid) FROM characters
   2008-07-06 12:41:17 query ERROR: Table 'mangos.characters' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(id) FROM character_pet
   2008-07-06 12:41:17 query ERROR: Table 'mangos.character_pet' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(guid) FROM item_instance
   2008-07-06 12:41:17 query ERROR: Table 'mangos.item_instance' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(id) FROM auctionhouse
   2008-07-06 12:41:17 query ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(id) FROM mail
   2008-07-06 12:41:17 query ERROR: Table 'mangos.mail' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(id) FROM item_text
   2008-07-06 12:41:17 query ERROR: Table 'mangos.item_text' doesn't exist
   2008-07-06 12:41:17 SQL: SELECT MAX(guid) FROM corpse
   2008-07-06 12:41:17 query ERROR: Table 'mangos.corpse' doesn't exist
   2008-07-06 12:41:17 SQL: DELETE FROM character_inventory WHERE item >= '1'
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.character_inventory' doesn't exist
   2008-07-06 12:41:17 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.mail_items' doesn't exist
   2008-07-06 12:41:17 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.auctionhouse' doesn't exist
   2008-07-06 12:41:17 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
   2008-07-06 12:41:17 SQL ERROR: Table 'mangos.guild_bank_item' doesn't exist

   "REALMD ERRORS"

   2008-07-06 12:41:27 Using configuration file realmd.conf.
   2008-07-06 12:41:27 MaNGOS realm daemon /0.11.0-SVN (Revision 5953) (Win32)
   2008-07-06 12:41:27 <Ctrl-C> to stop.

   2008-07-06 12:41:27 Database: 127.0.0.1;3306;root;107068736;mangos;realmd
   2008-07-06 12:41:27 MySQL client library: 5.0.56
   2008-07-06 12:41:27 MySQL server ver: 5.0.51b-community-nt
   2008-07-06 12:41:27 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color <> 3 ORDER BY name
   2008-07-06 12:41:27 ERROR:query ERROR: Table 'mangos.realmlist' doesn't exist
   2008-07-06 12:41:27 ERROR:No valid realms specified.

   if I have done nothing wrong up to this point i will do what you told me to do in the post

   Posted 1 year ago » Permalink

10. Maushin
    
    Regular
    Joined: Jul '08
    Posts: 44

    ok i have it figured out and will write up a step by step list for others that may have the same problem. The only thing i am working on now is getting realmd to work correctly and am going to do what i have seen suggested on othere posts. hopefully all goes well and I will be playing on my own server tonight.

    Posted 1 year ago » Permalink

11. Remar
    
    Veteran
    Joined: Feb '08
    Posts: 347

    http://forums.reaper-x.com/topic/guide-for-new-install and if you dont want the website just install SQL and Mangos, just skip those steps in the process. But follow the others IN ORDER.
    Because from what I saw in your post, alot of things were wrong, not the least of which
    DataDir = "C:\mysql\data" should definately not read that, that is your mangos install data folder for the maps. And you have to have SQL running when you run the reaper-x.bat, or it wont install the databases and tables.

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.