Trinitycore AKA Funserver and Blizz Repack 3.3.5a + Extras

[Itsabrewing]

If you have a problem just go to tutorials and guides in this section and there are plenty of guides. I have copied one for you, I did not write this props go to Suenc:

Today im going to tell you how to make your PS public through Hamachi.


When you have downloaded and instaled hamachi you need to create
a hamchi group and obtain your hamachi IP.
Write down your hamachi IP.

Connect to your Database with Navicat or a similar program.
Download Navicat

When you are connected to your sql DB open the "realmd" database.Then , on the tables open the "realmlist" table.

You will se se a couple of fields.

The only one you have to care about is "ADRESS".
That is the adress of the server, put your Hamchi IP in the field, and press the save buttom.

Now start your server and change your realmlist.wtf in your wow client folder

Your server is now online and good to go. For people to connect to server, three things are gong to be needed.


A: WoW (your patch Version)
B: Hamachi.
C: And Internet of course.

THEN

1.They have to install hamachi.
2.They CHANGE their realmlist to your hamachi IP.
3.Join your Network.
4.An WoW Acc. of course.

[Selfrot]

Dude - Seriously. I'mma have to create 1 000 000 accounts just to give you the reputation that you're worth for releasing this repack. Awesome work!!!!!!1!!111oneoneeleven

---------- Post added at 06:03 PM ---------- Previous post was at 05:48 PM ----------

Ye, icc is bugged, cant get passed Lady Deathwhisper...

Invincible's Rein doesn't work on ANY Trinity based private servers (As far as I know).
You can get past Lady Deathwhisper, use .go xyz xxx.xxx yyy.yyy zzz.zzz, though I doubt that you can get past Saurfang, since the "portal" doesn't work.
You can download/ make your own boss - loot_tables with Navicat Lite, HeidiSQL or SQLyog, though I strongly suggest that you use Navicat(Same for BT and Sunwell).
Shadowmourne proc can easily be fixed by removing it from the weapon by removing the spellID from the weapons Query in the item_template, and then downloading a new WROKING version of the spell and replacing it with your current, then adding it once more AFTER you've saved that you have removed it.

Hope this helps.
+Rep if it does

Cheers -Selfrot

[Selfrot]

EDIT: problem solved.

This is how I did it, that apperantly NO ONE have told us.

First: You CAN'T put the Trinity folder(s) either 1 or 2 in ANOTHER folder, it HAVE to be in the C:/ Disc, and the C:/ disc ONLY.
Second(Credits to Skadepus) : If you're running Windows 7 - Open your Start Menu, open Control Panel followed by Program and Features - Look for MySQL 5.1 - Uninstall it then re-boot your computer.
Third: Enjoy your working AKA Private Server.
Fourth: +Rep to Selfrot for adding this VITAL INFORMATION.

Cheers, Selfrot

[deklore]

It says it is Virus in it... then i wont download it! But thanks for this, I think it will help other people if it works.. :wave:

[Itsabrewing]

I've been using this for about 3 weeks, I have had no problems, and I use Kaspersky, I have had no virus issues either. Not sure why anyone would think there is a virus in this, mine sometimes detects if download is on a page with various unsecure links. Maybe thats what happened. There was no virus in the file I downloaded and am running.

[stavaren]

the speed rate is ****ed, Im running 100% even without mount, and yes I tried to reinstall the repack.
Any SQL fix or anything would be appritiated.

Otherwise it seems to be a nice repack.

[DocMencer]

Virus=0 (used 2 av's to check). Un-rar'd sucessful. so far so good. I just have to fix the directory issue..

[jt41time]

I have installed everything. Everything seems to run fine. all the server stuff seems to run and sit there looking for stuff then i try to log in on wow and it says, loggin in, handshake,auth, disconect from server. thats it. using admin/ admin. i have changed my realmlist to 127. bla bla bla to my no-ip adress.. says same thing

[nocduk1]

hello im Karl new to the forms
and would just like to say this is the best repack i have found {its absolutely great}and that says it all in one breath

great work guys!!!!!!!!!!!!!!!

i have read many posts but still can not work things out so although this could be a bit cheaky i wondered if you could take the time just to look at this please..;}

please i need help making this public i have changed some ip numbers a little for my security ..;}

now for my help if you dont mind i need a complete noob guild to making this puplic

none himatchi

my setup

i have a pc in the other room with the main route then im linked via a cable from a wirless router giving me the Server IP Address last digit is 2 rather than 1 which is the 1st pc in the other room



MY PORT FORWARD SETUP

#Service Name authserver Start Port 80 End Port 8950

Server IP Address 192.168.1.2
Ports - Custom Services start port and end port as above
Service Type is tcp/udp

Port Triggering Portmap Table
# Enabled

Service Name authserver
Service Type TCP:3306
Inbound Connection TCP/UDP: ports 79..9085
Service User ANY



AND THATS ALL I CAN SET


big question do i turn UPnP on or off????????? thzzz

MY WINDOWS 7 HOST FILE IS SET

# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 wowuk1.dyndns.info
192.168.1.2 wowuk1.dyndns.info (internal ip
192.168.1.1 wowuk1.dyndns.info (router ip
82.47.167.107 wowuk1.dyndns.info (external ip

AND I USE A PROGRAM CALLED NAVICAT TO ENTER THE DATA BASE IN MY DATA BASE I OPEN

auth then open realmlist and heres the setting

name of realm {characteristic of the ancient}then { address 82.47.167.107} {port 8085}

I COULD ALSO PUT MY wowuk1.dyndns.info host the insted but i here this can cause loop problems

NOTHING ELSE TO SET

and heres a print of the world server config from the data base

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world1"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"


i have read several guilds on trinitycore websitE and this is all they say you need to do

SO HERE GOES im on the second pc in the house hold running the server and i have pointed my
world of warcraft game set realmlist wowuk1.dyndns.info {my host}

and i can run the server and log in using set realmlist wowuk1.dyndns.info

{the game plays fine}

{ALL SEEMS FINE}
but ether because i am the host machine there for login in at 127.0.0.1 or its working via wowuk1.dyndns.info

{AS IT SHOULD DO}

but i still can not log in on my other pc so i now dont no if the server is up and running and its blocking my 1st pc due to us been on the same network or is the server still down and its jumping wowuk1.dyndns.info and letting me in at 127.0.0.1

{AS I SAID IM A TOTAL NOOB AT THIS SORT OF THING}

also here is the MySQL window running print out

Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
100925 22:29:55 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition
(GPL)

{ummm i just noticed PORT 3306 do i test this port to see if it is open ???

ok next is

trinitycore1\authserver.exe {this is the game logon part}

TrinityCore Rev: * Release Hash: * (Win32,little-endian) (realm-daemon)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
MySQL client library: 6.0.0
MySQL server ver: 5.0.45-community-nt
Loaded 1 prepared MySQL statements for auth DB.
Added realm "characteristic of the ancient wow".
Added realm "Trinity2 Blizz".
TrinityRealm process priority class set to HIGH

LOOKS FINE WOULD YOU AGREE ?????
so i am now still no closer and more confused lol

i have been trying to do this 4 the last 3days ouch!!!!

{CAN YOU PLEASE PLEASE GET IT RIGHT FOR ME NOOB STYLE

Thank you in advance

Karl

ps heres a link to what i have changed on the realm
http://www.youtube.com/watch?v=y7yIS6UxQDA

[Itsabrewing]

The Server computer should have wow/data/ reamlist set to 127.0.0.1.
All other computers should log in via the dns. (change wow/data/reamlist to whatever the dns says.
Port forward all the necessary ports to the local host (example port 80 forward to 192.168.1.2 (whatever local ip server is)
Ports to Forward: 3724-3727, 80-80, 3306-3306, 8129-8129, 8093-8093, 6112-6112, 6881-6999, 8085-8085, 8050-8050, 9093-9093
Now via Navicat, change your reamlist IP to your dns
If you can login via one computer, then the problem probably lie's with the reamlist in the data folder saying the wrong thing, all except the server should point to dns

[rakuta]

Ok one question on connecting with heidi SQL or navicat... whats the username and password... normally its root, root unless thats just arcemu?
Ive had this same problem with 4 or 5 different repacks, they dont put the user and pass information in the post... so? what is it?

[Willzy]

EDIT: problem solved.

This is how I did it, that apperantly NO ONE have told us.

First: You CAN'T put the Trinity folder(s) either 1 or 2 in ANOTHER folder, it HAVE to be in the C:/ Disc, and the C:/ disc ONLY.
Second(Credits to Skadepus) : If you're running Windows 7 - Open your Start Menu, open Control Panel followed by Program and Features - Look for MySQL 5.1 - Uninstall it then re-boot your computer.
Third: Enjoy your working AKA Private Server.
Fourth: +Rep to Selfrot for adding this VITAL INFORMATION.

Cheers, Selfrot

Do NOT ask for rep.......

[Jackhamme]

this repack is AMAZING!!!, everything works, its so brilliant only one problem

i can't get this into a public server for me and my mates by hamachi. When i put all of the my ip into where the 127.0.0.1's are placed the world command box just closes straight away, same with all of the other applications that get the server running, any ideas on how to get this to work? :/

says this: ERROR: Could not connect to MySQL database at 5.109.22.247: Host 'Lewis-PC' is not allowed to connect to this MySQL server

[amras199090]

Hey thanks for sharing this is great stuff !!

I managed to set up the server, however when I login I get prompted to choose a realm the first one is "Trinity1 GM" which appears as disactivated therefore i cant pick that one, and then theres another realm "Trinity2 Blizz" when i click on the second one I almost inmediatly get pronpted again to pick a realm.

Any ideas on how to solve this!!

Thanks

[Jackhamme]

Some one please help me i really need help :/