EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::News (https://www.eqemulator.org/forums/forumdisplay.php?f=594)
-   -   Windows Server Repack (EQEmu Akka's PEQ Repack) (https://www.eqemulator.org/forums/showthread.php?t=38836)

luchiann12 03-30-2015 12:32 PM

akka's repack
 
hi akkas im a newb sorry. I have downloaded your repack and did the steps in the instructions but I still don't understand how to get this working all I see are 4 command boxes blacked out and still don't understand how to run the game can I get some help in a full run down if it's no trouble. thanks

Massy2k1 03-30-2015 02:13 PM

Quote:

Originally Posted by luchiann12 (Post 239063)
hi akkas im a newb sorry. I have downloaded your repack and did the steps in the instructions but I still don't understand how to get this working all I see are 4 command boxes blacked out and still don't understand how to run the game can I get some help in a full run down if it's no trouble. thanks

I think your all set, those 4 blank command boxes are suppose to appear I believe and they don't start logging information until you head on into your server which should be in the server list when you log into Everquest ;)

Also I'm still trying to work out how to access the variables table which I think is what I need to limit the expansions on my server. Any help would be great, thanks guys.

luchiann12 03-30-2015 05:53 PM

akkas
 
[QUOTE]
Quote:

Quote:

Originally Posted by Massy2k1 (Post 239065)
I think your all set, those 4 blank command boxes are suppose to appear I believe and they don't start logging information until you head on into your server which should be in the server list when you log into Everquest ;)

Also I'm still trying to work out how to access the variables table which I think is what I need to limit the expansions on my server. Any help would be great, thanks guys.[/QUOT






ok but im new is there something I need to do to the game client to access the server list to log in also I havnt set a password or user to the game yet and that's were im lost.

Uleat 03-30-2015 06:19 PM

http://wiki.eqemulator.org/p?Play_Gu...etting_Started

luchiann12 03-30-2015 07:55 PM

[[/QUOTE]


thanks helped but when I log into the game there are no server list nor does it accept my user name and password would not receiving the sms verification code do this?
Actually I got it working I had the wrong login info put in oops.

Massy2k1 03-31-2015 03:11 PM

So I think I've worked out that I need to use HeidiSQL which comes with the download to access the variables database although I cant seem to get it working.

When opening up HeidiSQL my settings are

Network Type - MySQL (TCP/IP)
Hostname/IP - 127.0.0.1
User - root
Password - I've left this blank since I haven't created a password
Port - 3306

And I get the error message

SQL Error (1045) in statement #0: Access denied for user 'root'@'127.0.0.1' (using password:NO)

Not sure what I'm doing wrong, I've tried this with my server running and with it not running.

YouTube videos have suggested using the passwords, root or ascent. I don't have a password configured I don't think but tried them anyway with no luck.

Akkadius 03-31-2015 03:41 PM

Quote:

Originally Posted by Massy2k1 (Post 239090)
So I think I've worked out that I need to use HeidiSQL which comes with the download to access the variables database although I cant seem to get it working.

When opening up HeidiSQL my settings are

Network Type - MySQL (TCP/IP)
Hostname/IP - 127.0.0.1
User - root
Password - I've left this blank since I haven't created a password
Port - 3306

And I get the error message

SQL Error (1045) in statement #0: Access denied for user 'root'@'127.0.0.1' (using password:NO)

Not sure what I'm doing wrong, I've tried this with my server running and with it not running.

YouTube videos have suggested using the passwords, root or ascent. I don't have a password configured I don't think but tried them anyway with no luck.

The same information you are looking to use to connect to the database through the database browser (HiediSQL) is available in the server folder under eqemu_config.xml

Massy2k1 03-31-2015 04:14 PM

Yup I took a look and all the information seems the same as what's already in HeidiSQL

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>
host>127.0.0.1</host>
port>3306</port>
username>root</username>
password></password>
db>peq</db>

All the information seems to match.

<img src="https://www.imageupload.co.uk/images/2015/03/31/EQError.png" border="0">

luchiann12 03-31-2015 06:30 PM

Akka I got the server working I wound up just using a server that was already on the list rather than my own thanks. there is just one thing wrong I cant seem to access internet explorer to go on sites when im not playing I turn the server off and I still can not use internet explorer is there something I can do to fix this issue? thanks

luchiann12 04-02-2015 12:54 AM

Quote:

Originally Posted by Massy2k1 (Post 239093)
Yup I took a look and all the information seems the same as what's already in HeidiSQL

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>
host>127.0.0.1</host>
port>3306</port>
username>root</username>
password></password>
db>peq</db>

All the information seems to match.

<img src="https://www.imageupload.co.uk/images/2015/03/31/EQError.png" border="0">

the password will look similar if not the same Zn*VqhP=Le2h?>324** you have to put all the =*> as well

Massy2k1 04-02-2015 02:14 AM

<img src="https://www.imageupload.co.uk/images/2015/04/02/EQError.png" border="0">

I tried typing the whole thing I highlighted with a red border but still get the same error. I tried different variations of this also like leaving out the arrows & then tried leaving just these arrows. Not sure what I'm doing wrong.

Soz, me = dumb

Aanein 04-09-2015 06:31 AM

Anything in that section is commented out. <!-- and --> are the opening and closing tags. What you want to be looking at is further down; Zn*VqhP=Le2h?>324** is what you want to enter.

Exo 04-09-2015 07:15 PM

Just wanted to say thanks for this repack : -)

Pdizzle 04-11-2015 11:14 PM

I managed to get the server running and successfully updated it. However, I can't figure out how to update the PEQ database tables. Can someone please explain how to do this? I can't seem to locate the .sql files to even make an attempt at editing the tables.

On another note...

Thanks a TON for providing this to the community Akka!

Pdizzle 04-12-2015 11:30 AM

Quote:

Originally Posted by Pdizzle (Post 239292)
I managed to get the server running and successfully updated it. However, I can't figure out how to update the PEQ database tables. Can someone please explain how to do this? I can't seem to locate the .sql files to even make an attempt at editing the tables.

On another note...

Thanks a TON for providing this to the community Akka!

Ok, I figured out how to get access to the database. For others who may not know, you have fire up HeidiSQL and enter the password provided in the eqemu_config file. I'm guessing the database is stored outside of my pc since I can't seem to locate the sql files? Now, it's time to figure out what I can do with the database...

Stabones 04-18-2015 02:36 AM

I searched through the thread but couldn't find much about my problem. I hope I didn't miss an answer somewhere.

Your repack mentions it can support the RoF client. When I try to connect to my server with RoF it hangs. I can connect with UF. Am I missing a port forward somewhere?

Thanks a lot!
Mike

markusdabrave 04-18-2015 02:56 AM

What are you forwarding now?

And does your eqhosts.txt have port 5999 instead of 5998?

markusdabrave 04-18-2015 03:16 AM

Quote:

Originally Posted by Pdizzle (Post 239303)
Ok, I figured out how to get access to the database. For others who may not know, you have fire up HeidiSQL and enter the password provided in the eqemu_config file. I'm guessing the database is stored outside of my pc since I can't seem to locate the sql files? Now, it's time to figure out what I can do with the database...

Save yourself a lot of headaches and use Akka's EoC. It's amazing and makes life a lot easier :)

Akkadius 04-18-2015 05:14 AM

Quote:

Originally Posted by markusdabrave (Post 239391)
Save yourself a lot of headaches and use Akka's EoC. It's amazing and makes life a lot easier :)

A+

/10char

sculler 04-18-2015 10:02 AM

Akka,

What is the proper way to uninstall the repack so it doesn't keep trying to reinstall itself?

Thanks

Akkadius 04-18-2015 01:39 PM

Quote:

Originally Posted by sculler (Post 239393)
Akka,

What is the proper way to uninstall the repack so it doesn't keep trying to reinstall itself?

Thanks

You can uninstall in add/remove programs.

sculler 04-18-2015 07:14 PM

I feel like an idiot. I looked in there a couple of times and completely missed it.

Much appreciated.

Stabones 04-18-2015 11:10 PM

Quote:

Originally Posted by markusdabrave (Post 239390)
What are you forwarding now?

And does your eqhosts.txt have port 5999 instead of 5998?

To clarify, I can get to server select on my RoF client. It is using 5999.

Otherwise, I am forwarding 9000 and 7000 - 7100.

I can log onto other servers with RoF.

Let me know if you have any other ideas.

Mike

markusdabrave 04-18-2015 11:21 PM

Let's take it to IRC. I'll be happy to help troubleshoot.

http://www.eqemulator.org/forums/showthread.php?t=29292

Uleat 04-18-2015 11:55 PM

Hopefully, markus can assist..I don't recall seeing much of your problem/setup.


I know Akkadius keeps the repack current..so, an actual issue there is least plausible.

Make sure that your server folder has the rof/rof2.conf files.

Double-check that your RoF client is either the 'Dec 10 2012 17:35:44' or 'May 10 2013 23:30:08' build (verifiable in the client's log file.)

If you downloaded the recent steam client and it is not the 'May 10' version, please post back (someone recently mention something about
a check-box for newer content..though, I have not verified this.)

Stabones 04-19-2015 09:36 AM

Quote:

Originally Posted by Uleat (Post 239411)
Hopefully, markus can assist..I don't recall seeing much of your problem/setup.


I know Akkadius keeps the repack current..so, an actual issue there is least plausible.

Make sure that your server folder has the rof/rof2.conf files.

Double-check that your RoF client is either the 'Dec 10 2012 17:35:44' or 'May 10 2013 23:30:08' build (verifiable in the client's log file.)

If you downloaded the recent steam client and it is not the 'May 10' version, please post back (someone recently mention something about
a check-box for newer content..though, I have not verified this.)

I checked my client and it's May 10 so we are good there.

I did notice that I don't seem to have a rof/rof2.conf file. Maybe Akka's Repack doesn't support RoF?

Many thanks to everyone's help so far.

Stabones 04-19-2015 02:51 PM

Quote:

Originally Posted by Stabones (Post 239415)
I checked my client and it's May 10 so we are good there.

I did notice that I don't seem to have a rof/rof2.conf file. Maybe Akka's Repack doesn't support RoF?

Many thanks to everyone's help so far.

EDIT: Thought it had been fixed, but RoF still not connecting.

Uleat 04-19-2015 09:39 PM

I'll be the first to admit that I don't know much about Akkadius's repack...

If you didn't find either *.conf file, then it may not be setup by default to run RoF+ clients..someone else will have to verify that.


As far as whether those *.conf files are registered in the repack, check this file in your local repository:
https://github.com/EQEmu/Server/blob...es/patches.cpp

Both functions need to have the StructStrategy method calls for the client that you are attempting to use.

If they are not present, you should be able to add them, recompile and then copy over the new binary files to the
repack's server directory.

As this now makes your content 'custom,' I don't know how updates to the repack are handled and you may need to ask
some more questions.


IF they are present in your local copy, then there are still some other issues that need to be addressed..but, we need to
first determine if those methods are being called.

Stabones 04-19-2015 09:46 PM

markusdabrave tried Titanium, UF, and RoF. Titanium and UF worked. RoF did not.

Maybe I'll just need to compile myself.

markusdabrave 04-19-2015 09:57 PM

We haven't successfully resolved Stabones issue but we did make some progress. Looks like a router reboot fixed some stuff but not all. Currently

- Titanium Client works
- UF Client works
- ROF Client hangs after server selection.

DBG Log Below:
Code:

[Sun Apr 19 20:36:11 2015]00031:Initializing client variables.
[Sun Apr 19 20:36:11 2015]00032:Parsing INI file .\VoiceChat.ini
[Sun Apr 19 20:36:11 2015]00033:INI file .\VoiceChat.ini loaded.
[Sun Apr 19 20:36:11 2015]00034:Loading spell effects.
[Sun Apr 19 20:36:11 2015]00035:Initializing display structures.
[Sun Apr 19 20:36:12 2015]00036:Sound Manager loaded 3245 filenames from soundassets.txt.
[Sun Apr 19 20:36:12 2015]00037:Voice Manager loaded 12 macros from VoiceData.txt.
[Sun Apr 19 20:36:12 2015]00038:Parsing INI file .\defaults.ini
[Sun Apr 19 20:36:12 2015]00039:INI file .\defaults.ini loaded.
[Sun Apr 19 20:36:12 2015]00040:Memory mode defaulted to Balanced
[Sun Apr 19 20:36:12 2015]00041:Networking: using port [59293].
[Sun Apr 19 20:36:12 2015]00042:Networking: Connection Established [1]
[Sun Apr 19 20:36:12 2015]00043:WorldAuthenticate: Initiating Login.

Prior to reboot, I was being dropped back to the login after:
Code:

00639:*** WorldAuthenticate.  Error connecting to <IP Address>:9000 [client:DisconnectReasonConnectFail,server:DisconnectReasonNone]
Confirmed Expansions is set to 16383 in Variables table.

At this point I'm stumped. Any suggestions?

Edit: Maybe a dumb question and probably should have been asked earlier - but did you do the below update?
http://www.eqemulator.org/forums/showthread.php?t=39317

Stabones 04-19-2015 10:40 PM

Alright so I manually downloaded and added patch_RoF2.conf.

I can log in now but of course I ran Akka's update script and it screwed up my server(not a big deal since I haven't made any progress on it).

From what I can see, patch_RoF2.conf was not included in Akka's initial install nor the most recent update.

When I try to run the latest update, which is found here(http://www.eqemulator.org/forums/showthread.php?t=39317), I get an error about mysql's mysqldump not being found, which makes sense because Akka's uses MariaDB. What I don't understand is why his update would try and call MySql when he doesn't use with his distro.


Code:

        Enter numbered option and press enter...

> 1
Performing database backup....
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.


Akkadius 04-19-2015 10:43 PM

It calls MySQL in the script to interact with the database.

You need to make sure that your operating system has it set in the system path.

I've made instructions for this before:

http://www.eqemulator.org/forums/sho...4&postcount=13

markusdabrave 04-19-2015 11:42 PM

I learned the hard way - read the entire thread ;)

Stabones 04-20-2015 12:30 AM

Quote:

Originally Posted by Akkadius (Post 239427)
It calls MySQL in the script to interact with the database.

You need to make sure that your operating system has it set in the system path.

I've made instructions for this before:

http://www.eqemulator.org/forums/sho...4&postcount=13

Thank you. I am sorry I didn't see that. I have been doing a lot of reading to find answers to different problems and eventually you stop reading entire threads.

Hopefully that can make its way into a Wiki somewhere if it hasn't already!

Thanks again Akk!

SoltanHeatwave 04-22-2015 08:56 PM

Also make sure the C:\program files\mariadb 10.0\bin precedes the C:\program files\mariadb 10.0\ statement. Otherwise the search will stop in the C:\program files\mariadb 10.0\ folder and will not search the \bin folder. At that point it will error out. Old DOS trick and problem. The repack installs both path statements, but it doesn't install the \bin statement first. Well, it didn't in my installation.

Akkadius 04-22-2015 08:58 PM

Quote:

Originally Posted by markusdabrave (Post 239430)
I learned the hard way - read the entire thread ;)

It's the only major thing not in the repack.

It's a hell of a lot better than the alternative, doing it all from scratch having no clue what you're doing.

Even if you do know what you're doing, people get hung up on many stupid things.

The repack is definitely a massive time saver.

I really don't feel like spending 10 hours going through and getting everything just weeded out just right and tested on several platforms to change one small thing to build another repack.

SoltanHeatwave 04-22-2015 09:09 PM

I think the Repack is great. Vsab brought the variable solution to me.

I was just letting everyone know that if they do have this problem to check the path statement to make sure the \bin precedes the other mariadb path statement. You shouldn't have to change it not even implying that you should.

I just wanted anyone who is running into this problem and don't have any xp in the old dos path environment to know what to look for.

The correction is a simple one.

Just add \bin to the first mariadb path statement and delete it from the other one.

Takes longer to find it in the path than to correct it.

Qwan 05-01-2015 02:33 PM

Fresh Install - No servers listed
 
Hello...

I have a fresh install using Titanium client. I can launch the server just fine, get the four console windows as expected. When I try running the client, I can't see any servers and login fails. Anyone have a clue as to what may be the problem?

karekiz03 05-02-2015 10:20 AM

I got it up and running, but when I restarted the installer tried to re-install on bootup. Anyway to kill the installer from launching on restart?

Running Windows 7 64-bit

*Edit: Fixed it, was problem with corrupted registry on startup. Used Fixit to fix the registry.

MillerT 05-24-2015 08:51 PM

What do i need to fix?
 
[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[World Server] Starting HTTP world service...
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\Program Files\MariaDB 10.0\bin/mysql
================================================== ==========
Binary Database Version: (9077)
Local Database Version: ()

Retrieving latest database manifest...
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/db_upda
te_manifest.txt)
o Saved: (db_update/db_update_manifest.txt)
You have missing database updates, type 1 or 2 to backup your database before ru
nning them as recommended...

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Check and stage pending REQUIRED Database updates
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
8) Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 3
Reading manifest...

ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_02_logsys_packet_logs_with_dump.sql)
o Saved: (db_update/2015_02_02_logsys_packet_logs_with_dump.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_01_logsys_packet_logs.sql)
o Saved: (db_update/2015_02_01_logsys_packet_logs.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_28_quest_debug_log_category.sql)
o Saved: (db_update/2015_01_28_quest_debug_log_category.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_25_logsys_Mercenaries_category.sql)
o Saved: (db_update/2015_01_25_logsys_Mercenaries_category.sql)

ERROR 1932 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist in engine
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_19_raid_group_mentor.sql)
o Saved: (db_update/2014_10_19_raid_group_mentor.sql)

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Run pending REQUIRED updates... (5)
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
8) Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 3
Running Update: 9054 - 2014_10_19_raid_group_mentor.sql
ERROR 1932 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist in engine
ERROR 1932 (42S02) at line 2: Table 'peq.raid_leaders' doesn't exist in engine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9069 - 2015_01_25_logsys_Mercenaries_category.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9070 - 2015_01_28_quest_debug_log_category.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9074 - 2015_02_01_logsys_packet_logs.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 2: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 3: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Running Update: 9075 - 2015_02_02_logsys_packet_logs_with_dump.sql
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 2: Table 'peq.logsys_categories' doesn't exist in eng
ine
ERROR 1932 (42S02) at line 1: Table 'peq.db_version' doesn't exist in engine
Reading manifest...

ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_02_logsys_packet_logs_with_dump.sql)
o Saved: (db_update/2015_02_02_logsys_packet_logs_with_dump.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist in eng
ine
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_02_01_logsys_packet_logs.sql)
o Saved: (db_update/2015_02_01_logsys_packet_logs.sql)
ERROR 1932 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist in engine
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_19_raid_group_mentor.sql)
o Saved: (db_update/2014_10_19_raid_group_mentor.sql)

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Run pending REQUIRED updates... (5)
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
8) Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...


All times are GMT -4. The time now is 03:47 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.