Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-23-2023, 12:14 PM
warmac99
Fire Beetle
 
Join Date: Jan 2011
Posts: 2
Default Local server setup using TAKP Database: How?

Hello and thanks for any help that can be provided. I am interested in setting up a local server and using/sourcing the Takp database. I have set up servers before using the installer etc. I am by no means an expert, but I do have a basic understanding of how the set up works on the back end. That being said how can i use the server installer, but then change to the takp database instead of the auto sourced in PEQ DB? Any help is greatly appreciated.
Reply With Quote
  #2  
Old 09-23-2023, 11:06 PM
nazwadi
Fire Beetle
 
Join Date: Jun 2018
Location: Eastern United States
Posts: 2
Default

The challenge with doing this is that the TAKP database doesn't use a compatible schema that EQEMU source code expects; each version of EQEMU's server is generally aligned with a PEQ db version.

From what I can tell, you would have to update the TAKP database schema to look like the PEQ db version tied to your EQEMU server version (preserving the data you are probably trying to get into your server build).

The alternative of course is to just stand up a server using TAKP's server source. Their installer script is a few folders deep in the repo, but worked great once I found it:

https://github.com/EQMacEmu/Server/b...ic-release).sh
Reply With Quote
  #3  
Old 09-24-2023, 01:48 AM
warmac99
Fire Beetle
 
Join Date: Jan 2011
Posts: 2
Default

Ahh I see so basically the fastest easiest way to get a server going with their database would be to fire up a linux VM and run that script. Thank you for the help!
Reply With Quote
  #4  
Old 09-24-2023, 10:00 AM
nazwadi
Fire Beetle
 
Join Date: Jun 2018
Location: Eastern United States
Posts: 2
Default

Yes. You can wget/curl that script, and start by editing the fields defined at the top under "System User, Database and Dirs". Once that's done, I'd start with using the "preinstall" and then "install" options. One of these two will generate a new copy of the script inside the server directory. Use this copy in that directory from here on out.

After that, you'll want to use "setupini" which generates a login.ini and db.ini file - as far as I can tell this is only needed if you are running your own loginserver (which you probably will be on a local server).

Where you may hit snags booting it up (as of this writing):
* The script puts puts a LSsettings_table field in the login.ini under the [database] section which doesn't appear to work. I don't think this is being used, but it *does* want a "loginserver_setting_table" under the [schema] section with the same tablename listed (tblloginserversettings). The default is to have a separate database for loginsserver tables.

* chat_opcodes.conf needs to be symlinked from the root of the server directory in order for ucs to boot up. You'll find this in source/utils/patches/chat_opcodes.conf. The script won't symlink that one for you.

* patch_Mac.conf need to be symlinked as well - this is found in source/utils/patches/patch_Mac.conf

* Your login.ini allows you to set up auto_registration for new accounts, but barring that (and assuming you don't have a registration website to do this) you would need to manually create accounts in your loginserver database (tblLoginServerAccounts).

* Troubleshooting Login: If you run the loginserver manually, it produces stdout/stderr output that makes it much easier to troubleshoot initial login to and from server select from your client. Running it via the script pipes that output to /dev/null because you won't want it once you get everything working.


Login Server Details:
* First add a server admin account (this is not a GM account) to tblServerAdminRegistration. You'll use this account name and password in your eqemu_config.json for the loginserver settings.

* Add your world server entry to tblWorldServerRegistration and make sure the ServerID from the previous step is added under ServerAdminID. The LongName and ShortName you set in here will also be in your eqemu_config.json

* Make sure you have a tblloginserversettings; this sets allowed client types, whether server select displays population count (or just UP/DOWN), and sets the ticker displayed on compatible clients.

* tblServerListType should have Legends, Preferred, and Standard

* User accounts, of course, go in tblLoginServerAccounts (either web registration, manual adds to the database, or via auto_registration). The server will populate these in your player data once you create a new character.

I hope that's helpful. Good luck!
Reply With Quote
  #5  
Old 10-20-2023, 08:01 PM
corduroyclancy
Fire Beetle
 
Join Date: Jul 2021
Posts: 1
Default

I know it's asking a lot, but are there any guides on setting up a local server with TAKP for someone who hasn't done it before?
Reply With Quote
  #6  
Old 01-05-2024, 03:53 PM
ozzfreak
Fire Beetle
 
Join Date: Aug 2023
Posts: 5
Default

Quote:
Originally Posted by corduroyclancy View Post
I know it's asking a lot, but are there any guides on setting up a local server with TAKP for someone who hasn't done it before?
I second this ^_^

For Windows would be great, but Linux would be good too. I've just had the most horrible of experiences setting up a Linux server.
Reply With Quote
  #7  
Old 03-24-2024, 11:12 AM
cdolick24
Fire Beetle
 
Join Date: Sep 2018
Posts: 21
Default

Did anyone ever respond on this? I also am interested in a guide
Reply With Quote
  #8  
Old 03-24-2024, 02:32 PM
noobiest
Fire Beetle
 
Join Date: Mar 2024
Posts: 1
Default Local Server Guide (kind of)

Hey, so like everyone here, I was struggling mightily to get my own server up and running, when I stumbled across this YouTube video.

It's long, and there's no timestamp/description links, but if you do what he does, you'll come out all right. My server is now working, w00t!

https://www.youtube.com/watch?v=Hjrzdlem3ZA
Reply With Quote
  #9  
Old 03-25-2024, 07:48 PM
cdolick24
Fire Beetle
 
Join Date: Sep 2018
Posts: 21
Default

Quote:
Originally Posted by noobiest View Post
Hey, so like everyone here, I was struggling mightily to get my own server up and running, when I stumbled across this YouTube video.

It's long, and there's no timestamp/description links, but if you do what he does, you'll come out all right. My server is now working, w00t!

https://www.youtube.com/watch?v=Hjrzdlem3ZA
I spent handful of hours trying to make it work, but struggled get the container to populate on docker, it might be a few years but hopefully someone much more skilled than I can come up with a batch/installer for this type of project.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:17 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3