EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::Server Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=601)
-   -   Updated Solo Server Package (https://www.eqemulator.org/forums/showthread.php?t=42039)

bigwhitebuddha 05-01-2020 10:00 AM

Quote:

Originally Posted by djeryv (Post 264870)
Which NPCs specifically?

These are the following NPC's:

Sister Talsir, Shokar, Greska, Bresta, Frakla, Peshir, Annabe, Martal, Nebris, Ruskal, Ortizk, Evalla, Xeryth, Catala

djeryv 05-01-2020 10:05 AM

I just talked to Frakla with no issue. Do you have the perl scripts in your quests/global folder?

bigwhitebuddha 05-01-2020 10:18 AM

Quote:

Originally Posted by djeryv (Post 264872)
I just talked to Frakla with no issue. Do you have the perl scripts in your quests/global folder?

Yes, I do. I downloaded the scripts again, and placed them into my global folder, just in case. I am still encountering the same issue.

djeryv 05-01-2020 10:27 AM

Can you talk to any of the artisans or arcanums in town? Do they show you any items you can buy from them?

bigwhitebuddha 05-01-2020 10:34 AM

Quote:

Originally Posted by djeryv (Post 264874)
Can you talk to any of the artisans or arcanums in town? Do they show you any items you can buy from them?

I am able to speak to the Emerald Eye Sage, but I cannot buy from the artisan or the arcanum. I can speak to them though

djeryv 05-01-2020 10:37 AM

Then I would guess that you don't have Perl installed with the Perl DBI (Database Integration) so plugin::LoadMysql(); works correctly. Can you verify that is installed? I am now also guessing you are running a Windows server?

bigwhitebuddha 05-01-2020 10:38 AM

Quote:

Originally Posted by djeryv (Post 264876)
Then I would guess that you don't have Perl installed with the Perl DBI (Database Integration) so plugin::LoadMysql(); works correctly. Can you verify that is installed? I am now also guessing you are running a Windows server?

I am running a windows server. I have the "Perl Package Manager" installed (I believe this is Activeperl Build 1204), but I am unfamiliar with "Perl DBI".

djeryv 05-01-2020 10:42 AM

I run a Linux server...but I think you need to open the package manager and make sure something like this is installed:

DBD:mysql

bigwhitebuddha 05-01-2020 10:48 AM

Quote:

Originally Posted by djeryv (Post 264878)
I run a Linux server...but I think you need to open the package manager and make sure something like this is installed:

DBD:mysql

I found something similar (DBD-mysql). I installed the package, and restarted the server. Still not working ATM.

djeryv 05-01-2020 10:51 AM

This is older info I found, but make sure these are installed in Perl:

DBI
DBD-MYSQL - you stated you just did this one.
IO-STRINGY

bigwhitebuddha 05-01-2020 10:53 AM

Quote:

Originally Posted by bigwhitebuddha (Post 264879)
I found something similar (DBD-mysql). I installed the package, and restarted the server. Still not working ATM.

I have gotten it to work! I installed the following packages from the perl package manager:

DBD-mysql
DBD-mysqlPP
MySQL-RunSQL

I appreciate the help in this issue. I am fairly newer to all of this, and it helps to have a community like this!

Zia 05-24-2020 07:25 PM

How does one install those things in the new Strawberry release? It does not seem to have any package manager but CPAN, which I apparantly do not understand.

djeryv 05-25-2020 10:12 AM

What does this have to do with the solo server package?

Zia 05-25-2020 11:05 AM

Quote:

Originally Posted by djeryv (Post 265076)
What does this have to do with the solo server package?

It has to do with the new 64-bits installer. It comes with Strawberry Perl instead of ActivePerl.

djeryv 05-25-2020 06:12 PM

Oh...so nothing to do with the solo server package. Perhaps try a different part of the forums for your specific installation issue. This solo server package is a series of perl scripts and MySQL queries that alter the server after it is installed and working successfully. If you cannot get a server to even run properly, you shouldn't worry about this package yet.

Zia 05-25-2020 08:56 PM

Quote:

Originally Posted by djeryv (Post 265080)
Oh...so nothing to do with the solo server package. Perhaps try a different part of the forums for your specific installation issue. This solo server package is a series of perl scripts and MySQL queries that alter the server after it is installed and working successfully. If you cannot get a server to even run properly, you shouldn't worry about this package yet.

Well, it used to run just fine (with all the small snags along the way as usual), but for various reasons I had to reinstall it. Now your quest NPC's will not talk to me, which is the same issue discussed earlier in the thread. It used to be fixed by installing certain Perl packages using the PPM that came with ActivePerl. Now the server installation package instead comes with Strawberry, which does not (as far as I am able to find) include anything like that, except CPAN, which I am not able to get to work.

So, yes, it does have to do with your server package, which I think is pretty great when it works.

Uleat 05-25-2020 10:16 PM

Before this gets out of control (as everyone still seems amiable..)

..let's address this as an EQEmu issue rather than a 'Solo Server Package' issue since the problem came about after core changes to the emulator installer.

Zia, please start a new thread with missing Perl DBI functionality in new installer dependencies - thanks! :D


(This issue will affect more than just this package.)

dreadbones 06-28-2020 09:53 AM

Hi

Great mod, thanks

friendlinzh 07-30-2020 04:04 AM

you don't have Perl installed with the Perl DBI

Draugr 08-01-2020 12:42 AM

Hi.

I just got my EQemu server setup and running. I was looking for a way to lower the HP of every monster since my server will only be a few players. Then I stumbled upon this thread and was happy to see the same person worked on this as Ultima Online Odyssey (djeryv). :)

Anyhow, I wanted to ask a few questions regarding this single player database mod.

1. Will this database work with the latest EQemu and PEQ database?

2. Does the modifications in this single player mod cover all the current zones in EQemu/EQ?

I guess that is all for now. I've been playing with the standard PEQ database for now and it is fun, but something like a solo player experience or at least an experience for a small group is perfect for what I'd need on my server.

Thanks,
John

woton 08-02-2020 04:24 PM

It works with RoF2. It is mostly finished up thru omens of war xpac. Everything else beyond that, the mobs are in most zones but nothing like quests work and the mobs themselves have very low hps and insane regen. If youre hoping to make things soloable, youll have to do a bit more work. Most raid mobs have insane aoe damage which you can fix with the gm command #npcedit spellscale (0-100). Some raid mobs have scripted damage, like Bristlebane, that scales up rapidly. Youll have to fix that in his script. Even using the spellscale setting, some spells still do max damage, youll have to change those in the spell file. A few that come to mind are chaos claws that all gates trash mobs use and a couple spells used by mata muram.

woton 10-26-2020 03:20 PM

Was wondering how you removed the flags needed for planar progression? Due to rampant crashing issues we started over on our server and decided to just do the changes ourselves but having issues with planar mobs. For instance we cannot get Rallos Zek to spawn. Also seems we need Rallos Zek flag to click down to Solusek Ro.

hmmyespanda 01-06-2023 06:53 PM

I came across this a couple of weeks ago and have been playing non stop since. One issue I am now running against is getting to Dranik's Scar. When overriding the priests of discord, they no longer port me to the zone. Is there an alternate route provided, or am I missing something?

hmmyespanda 01-08-2023 12:04 PM

SQL workaround, though this may be unnecessary. I updated zone ID and x,y,z coordinates of the character data to be the succor point in Dranik's Scar:

update character_data
set zone_id = 302, y = -1519, x = -1468, z = 260
where id = 2;

Telememore 03-02-2023 12:54 PM

Thanks djeryv,

For this solo server DB.

When I source solo_server.sql (HeidiSQL) into peq db I receive SQL 1264 - out of range value for column maxcash at row 25712

The maxcash is set to 4



Any help would be greatly appreciated

Sandysham 04-02-2023 07:22 PM

What server is using your package ?

Shaneplourde1@gmail.com 04-27-2023 09:13 AM

I know this is a thread is a few years old and I'm a complete newb to trying to get a server up and running (never done anything like it before). But is this still viable to get up and running? It sounds exactly like what I'm looking for out of a solo server that me and my buddy could play on

Nukester 11-07-2023 08:52 PM

I cant seem to get the merchants to show up in the Bazaar. I get the new merchants that sell the non obtainable spells, but the merchants stalls are empty. Ive tried with both the Titanium and RoF2 clients. Any suggestions?

Also the witches wont load due to missing columns in the DB. They would be cool to have but Im most concerned about getting the Bazaar running. Thanks in advance!

Nukester 11-09-2023 01:49 AM

Im good. I was able to get the bazaar up and running

fluent2332 05-04-2024 11:28 PM

Hey guys! Another newb here trying to get this installed, hoping for the best! Anyone figure out if this still works at all with the newest version of EQ??

Quote:

Originally Posted by Nukester (Post 269379)
Im good. I was able to get the bazaar up and running

Maybe you could post how you did that for some peeps who may be just arriving here? :)


All times are GMT -4. The time now is 02:38 PM.

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