Help Request getting server live or LAN active

4 posts

1. Symbolic
   
   New Member
   Joined: Dec '08
   Posts: 2

   Greetings,

   I am sorry to be a pain in the butt, but I literally don't know where else to turn! I keep striking out on the same problem over and over again. I am trying to get my server live (hehe as is everyone) I have had a Arcemu 2.4.3 repack running smoothly on LAN, but I recently decided to update to 3.0.3. This is a link to the repack I used, just for clarifications sake, http://www.ac-web.org/forum/releases...56-9061-a.html

   And the problem I keep encountering is this;
   "Could not connect to MySQL database at symnet.servegame.org: Access denied for user 'ascent'@'symnet.servegame.org' (using password: YES)

   Cannot connect to database.

   No matter how i have this set, i encounter this error. I leave as default, localhost, and still get denied, I have not changed any setting except host details, as required.

   I even tried logging into the database and granting all kinds of user permissions. To no avail.

   I am currently using a dynamic IP address, with a program called DynDNS Updater for IP updates. This seems to of unaffected the results, as they are similar if not identicle.

   I would suffice just to be able to LAN this again, as my brother and I, and both keen to check things out.

   I eagerly await a response, If you should see me worthy.

   Regards,

   -Sym

   Posted 11 months ago » Permalink

2. Samories
   
   Regular
   Joined: Jul '08
   Posts: 91

   are you running the mangos server on the same machine as the mysql server?

   Posted 11 months ago » Permalink

3. Symbolic
   
   New Member
   Joined: Dec '08
   Posts: 2

   yea, all is being run from the same machine.

   Posted 11 months ago » Permalink

4. zulin
   
   New Member
   Joined: Dec '08
   Posts: 1

   Hi everybody!

   What I would (re)do is to set the permissions manually:

   Login to mysqld using the command line tool and "mysql" as the working db:
   > mysql -u root -p mysql

   check that the DBs exist
   >show databases;
   you should see at least
   >mysql
   >test
   >mangos
   >realmd
   >characters

   If the mangos DBs are missing, create them:
   > create database mangos;
   > create database realmd;
   > create database characters;

   Then set the permissions:
   >grant all on realmd.* to mangususer@localhost identified by 'mangosuserpassword';
   >grant all on mangos.* to mangosuser@localhost;
   >grant all on characters.* to mangosuser@localhost;

   (Assuming you use user=mangosuser and password=mangosuserpassword, the db names can change too)

   Inspect the mangos.conf and realm.conf to set to the exact same stings, e.g.:
   >LoginDatabaseInfo = "127.0.0.1;3306;mangosuser;mangosuserpassword;realmd"
   >WorldDatabaseInfo = "127.0.0.1;3306;mangosuser;mangosuserpassword;mangos"
   >CharacterDatabaseInfo = "127.0.0.1;3306;mangosuser;mangosuserpassword;characters"

   Check your firewall, that it allows MaNGOS to connect to MySQLd!

   And if you then still cannot connect to mangos, post the exact error message, plz.

   Posted 11 months ago » Permalink

RSS feed for this topic

Reply

You must log in to post.