EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Windows Server Installer :: Modular & Scripted (https://www.eqemulator.org/forums/showthread.php?t=40299)

Akkadius 01-08-2016 02:49 PM

The stock launcher settings have no effect on the launcher that I've created.

sculler 01-09-2016 04:44 PM

Perl DBI
 
So I tried installing DBI via the PPM and I am getting a 401 Unauthorized error. Apparently for Perl 5.12 you need a business edition license to install these packages for Perl 5.12.

Am I wrong about this? How do I go about getting DBI installed?

Am I going to have to get the source and install it that way?

Akkadius 01-09-2016 04:47 PM

What are you talking about? Did you install using this installer? If so DBI already works from my installer

sculler 01-09-2016 04:54 PM

I did use the installer.

Sorry I took over Eriviyn and one of the scripts wasn't working with the plugin::LoadMySql call so I was thinking DBI wasn't installed.

I apologize, it seems it's another issue altogether. DBI is definitely installed.

Akkadius 01-09-2016 04:55 PM

When you run the script from console you'll know cause Perl will say whether or not it can load DBI.

My installer loads DBI manually because active state doesn't allow ppm installs without license anymore

Huppy 01-09-2016 05:01 PM

Quote:

Originally Posted by Akkadius (Post 246422)
My installer loads DBI manually because active state doesn't allow ppm installs without license anymore

Seriously, I didn't know activestate started doing that with the ppm. Vultures, lol

sculler 01-09-2016 05:14 PM

Ok, so DBI was installed but DBD-mysql isn't installed. I'm getting this now when making a DBI call.

Can't locate DBD/mysql.pm in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .
) at test.pl line 9.

In PPM, it shows DBD-mysql as not being installed.

This is weird. On my Windows 10 machine - I have DBD-mysql installed and on the Windows Server 2012 R2 machine I don't.

I used this installer on both machines. Any ideas?

Akkadius 01-09-2016 05:26 PM

Quote:

Originally Posted by sculler (Post 246424)
Ok, so DBI was installed but DBD-mysql isn't installed. I'm getting this now when making a DBI call.

Can't locate DBD/mysql.pm in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .
) at test.pl line 9.

In PPM, it shows DBD-mysql as not being installed.

If you used the installer DBD works, I've verified it once again.

If you want to fix this and you have 5.12.3 installed, follow instructions here:

http://wiki.eqemulator.org/p?Install...ethod-use-this

sculler 01-09-2016 05:36 PM

Thanks Akkadius,

I definitely used the installer in both places. One it was working and one wasn't.

I appreciate the help and you putting this together. It really is impressive.

Edit: Copied over the files from the link above and now it's working perfectly. Thanks again.

Akkadius 01-09-2016 05:49 PM

Quote:

Originally Posted by sculler (Post 246426)
Thanks Akkadius,

I definitely used the installer in both places. One it was working and one wasn't.

I appreciate the help and you putting this together. It really is impressive.

Edit: Copied over the files from the link above and now it's working perfectly. Thanks again.

ya np, glad you're working now

Dremis 01-09-2016 11:46 PM

Akkadius,
You have any idea why the mob buff window doesn't work?

NatedogEZ 01-10-2016 11:39 AM

Quote:

Originally Posted by Dremis (Post 246429)
Akkadius,
You have any idea why the mob buff window doesn't work?

Guessing you don't have the rule set to true or missing the rule from the database. (by default in source its false)


If you use other rulesets besides 1.. make sure to add rules for each set
Code:

INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Spells:AlwaysSendTargetBuffs', 'true', 'Allows the server to send the targets buffs ignoring the LAA.');

Dremis 01-10-2016 01:01 PM

The rule was missing from the database. I added it to all 7 rule sets as true. Mob buff window still doesn't show spells. I'm using default rule set.

Also NONE of the Blightfire Moors quests work and I haven't found any in Crescent reach that work yet.

Tyen05 01-11-2016 10:19 PM

My contribution


http://i.imgur.com/BLBI0cg.png

blindaviator 01-12-2016 02:04 AM

Tried the install tonight and everything went fine except for Database install. It installed the DB software fine but failed to setup or install the actual database. I check for a database with HeidiSQL and none show.

http://i.imgur.com/hkYEymR.jpg?1

Akkadius 01-12-2016 02:06 AM

Did you previously install another database engine? This could be where your problem lies as its not a true clean install.

Open CMD

Type:

echo %path%

Paste the contents in a code block here

blindaviator 01-12-2016 05:05 AM

Quote:

Originally Posted by Akkadius (Post 246485)
Did you previously install another database engine? This could be where your problem lies as its not a true clean install.

Open CMD

Type:

echo %path%

Paste the contents in a code block here

I had a previous install that I removed including MySQL and Perl... I have Visual Studio 2013 installed which installs Microsoft SQL server... Could that be the cause of it??

Code:

C:\Perl\site\bin;C:\Perl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\
Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA C
orporation\PhysX\Common;C:\Program Files (x86)\Windows Kits\8.1\Windows Performa
nce Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\xampp\mysq
l\bin;C:\xampp\mysql\lib;c:\xampp\mysql\lib;c:\Program Files\Git\mingw64\bin;C:\
Perl\site\bin;C:\Perl\bin;C:\Program Files\MariaDB 10.0\bin;C:\Perl\site\bin;C:\
Perl\bin;C:\Program Files\MariaDB 10.0\bin


Akkadius 01-12-2016 05:27 AM

It's the xamp\mysql in your path, just because you uninstall it doesn't mean it is removed from system path.

Remove it and try again.

blindaviator 01-12-2016 05:44 AM

Quote:

Originally Posted by Akkadius (Post 246488)
It's the xamp\mysql in your path, just because you uninstall it doesn't mean it is removed from system path.

Remove it and try again.

Yeah I just uninstalled everything again and cleared the path of all uninstalled programs and did a full reinstall and it worked flawlessly this time...
Appreciate the help.

blindaviator 01-12-2016 07:15 AM

Now that I have it all working I am loath to modify anything that may break it, but...

Is it possible to make Mercs and/or Bots work on this install?
I haven't really explored the install yet to see what is available but I didn't see any Bot's entries in the database and the merc vendors didn't seem to be responding.

Akkadius 01-12-2016 08:19 AM

Quote:

Originally Posted by blindaviator (Post 246490)
Now that I have it all working I am loath to modify anything that may break it, but...

Is it possible to make Mercs and/or Bots work on this install?
I haven't really explored the install yet to see what is available but I didn't see any Bot's entries in the database and the merc vendors didn't seem to be responding.

That is beyond the scope of the installer and there is no automagic configuration for those currently. You'll need to look into enabling them through whatever resources you can find on the forums. Try posting in a different thread and people can help you there

Sisca 01-12-2016 08:52 AM

Removed since Akka beat me to it... :)

ihatemyself 01-15-2016 07:16 PM

Is it possible to do database updates in this build?

When I try using the eqemu_update.pl script, multiple options say there's no database present.

hawkhunter 01-17-2016 05:22 PM

Install yesterday on windows server 2008 32bit. seemed to work fine after replacing mariaDB with the 32bit version.

Dremis 01-20-2016 06:15 PM

Akkadius,

One suggestion if I may. This should include XAMPP and the PEQ editor.

Reason: Since this installs and configures everything for you, it is a PITA trying to configure PHP and Apache for a separate MySQL install that you have to find config info for. Since you're using the PEQ database and almost everyone agrees that the PEQ editor (or your EoC) is the bestestes, easiest way to edit the DB) they should be included for a total "turn key" solution.


DISCLAIMER: Alcohol may have played a part in this post. It made sense to me when I typed it. YMMV. :)

Akkadius 01-20-2016 06:16 PM

Quote:

Originally Posted by Dremis (Post 246615)
Akkadius,

One suggestion if I may. This should include XAMPP and the PEQ editor.

Reason: Since this installs and configures everything for you, it is a PITA trying to configure PHP and Apache for a separate MySQL install that you have to find config info for. Since you're using the PEQ database and almost everyone agrees that the PEQ editor (or your EoC) is the bestestes, easiest way to edit the DB) they should be included for a total "turn key" solution.


DISCLAIMER: Alcohol may have played a part in this post. It made sense to me when I typed it. YMMV. :)

I have plans to have it retrofit other database installs, right now the requirement is an absolute clean install.

Dremis 01-25-2016 07:38 PM

Any chance of an uninstall for those (like me) that screw something up and need to start over.

I uninstalled (and where that option wasn't available) deleted everything I could find. Yet trying to start over has yielded nothing but problems. It worked once but I can't get it to work twice.

greneday 01-27-2016 09:35 PM

I have a custom non default Perl install setup on a special Array(and also no C: drive).
What method can I use to get this to work?
When I start the t_start_server.bat
Everything boots well, then I get:

"The program can't start because perl512.dll is missing from your computer.
Try Reinstalling the program to fix this problem."

It is located in F:/Perl/Bin

Akkadius 01-28-2016 03:02 AM

Quote:

Originally Posted by greneday (Post 246810)
I have a custom non default Perl install setup on a special Array(and also no C: drive).
What method can I use to get this to work?
When I start the t_start_server.bat
Everything boots well, then I get:

"The program can't start because perl512.dll is missing from your computer.
Try Reinstalling the program to fix this problem."

It is located in F:/Perl/Bin

The installer specifically says "Clean install" you can't mix breed other pre-requisites. You're going to have a bad time if you do that. You need the Perl installed that comes with the installer...

greneday 01-28-2016 10:48 AM

Thanks Akkadius for the quick reply.

I'm using the perl that comes with your installer, but it's installing it to F:/ as I don't have a usable C:/ partition(I had to tinker with this part). The scripts when booting the server seems to go call upon C:/Perl/Bin
I tried manually forcing the perl location both in Environment Variables (Windows Server) and in the bat file, but I think that just messed things up more so I started fresh.

Does that error meaning the wrong version some how got installed, or that it can't find the Perl installation?

Akkadius 01-28-2016 02:52 PM

It is hard coded to a typical C installation right now, I'll have to account for installs that use a different drive for whatever reason. I don't have time to adjust this right now though so it is what it is. You will have to change your system path to repoint from C:\Perl\bin to your F and that should fix things on your own

greneday 01-28-2016 05:32 PM

Thanks again, once again =D
Your installer is amazing, seriously.
On my VM setup it instantly worked without any edits.

In regards to changing my system path to repoint from C:\Perl\bin to F, how can I do that?
Tried Environmental Variables, but that didn't seem to do it.
Is it in the registry? Or in the installer script somewhere?

Dremis 01-28-2016 08:45 PM

Quote:

Originally Posted by greneday (Post 246820)
Thanks again, once again =D
Your installer is amazing, seriously.
On my VM setup it instantly worked without any edits.

In regards to changing my system path to repoint from C:\Perl\bin to F, how can I do that?
Tried Environmental Variables, but that didn't seem to do it.
Is it in the registry? Or in the installer script somewhere?

As I understand this, You have no C: drive and perl is installing to F:\Perl

So in environment variables, add F:\perl\bin to the PATH variable. Then it should find the required .dll.

Shiny151 02-07-2016 02:06 PM

After being away from the game for a couple years I installed this pak on a fresh copy of Win 7/64 with SP1 + updates yesterday; seems to be working great.

However, by default anyone on my LAN can run multiple accounts (same IP) of the Underfoot client to join my server; anyone external (also using Underfoot) can't get more than one account on. Does this sound right? I thought the rules by default were unlimited accounts for external and internal clients connecting via public login. What am I missing?

By the way, thanks Akk for putting this together; was very simple getting my sever back up again.

Warking 02-10-2016 06:00 AM

First I want to give props - awesome work on the installer. What might need a little focus would be the login server options. I had to use the old peqlogin server so I could get users to connect directly to me since I am not using eqemulator logins. I customize the server and client too much.

The connection settings between the login server and the server call for server ip or hostname. When external users connect the users need to add a host entry on their PC for the host and public IP since domain.com in eqhost file will not allow for more than authenticating.

Perhaps various types of options could be added after the installer installs the server to setup login server for A: eqemulator B: local LAN c: Private public server.

I'd be happy to help if needed.

Warking 02-10-2016 06:02 AM

Quote:

Originally Posted by Shiny151 (Post 246993)

However, by default anyone on my LAN can run multiple accounts (same IP) of the Underfoot client to join my server; anyone external (also using Underfoot) can't get more than one account on. Does this sound right? I thought the rules by default were unlimited accounts for external and internal clients connecting via public login. What am I missing?

In the rules_values table there are options for how many logins per IP and per account. Default looked to be set as 1. Just need to change it. I have mine set to allow 6 toons per account and 30 per IP.

Maze_EQ 02-10-2016 07:34 AM

6 toons per account?

I'm bout to hop on your server and dupe the hell outta stuff.

Shiny151 02-10-2016 03:25 PM

Quote:

Originally Posted by Warking (Post 247028)
In the rules_values table there are options for how many logins per IP and per account. Default looked to be set as 1. Just need to change it. I have mine set to allow 6 toons per account and 30 per IP.

Thanks for the response Warking. I don't want to muddy up this thread too much with this topic so we can take it to PM if necessary, but I'll just say this: I set World:MaxClientsPerIP to 4 on ALL rulesets and that didn't work. I'm going to assume there's three or four other rules I need to adjust in conjunction with this one? I don't fully understand how they work together or if they even work together at all when you want to allow a 0 status character multi/account logins from the same IP; perhaps you can provide some guidance here?

In the meantime, I have a ghetto workaround where I just allow a single account to log on more than one toon by setting World:AccountSessionLimit to more than one. That's been working fine so far.

Shiny151 02-16-2016 06:11 PM

Well I figured out my external connection issue and I'll post it here in case anyone else has this problem. I have a Pace Plc 5031NV modem/router and upgrading the firmware from 9.8 to 10.5 resolved all external connection issues. I was pulling my hair out thinking this was a database/SQL issue.

If you are having any sort of external connection issues take a look at your modem/router or at least try a different one to rule out your router when nothing else makes sense.

moltke24 02-23-2016 06:09 PM

I have two hard drives, I tried using this installation on my SSD but it was E: instead of C: so i just changed to this side of windows and tried using your installer.

When I use it on either side of windows the same thing happens:

https://www.youtube.com/watch?v=BNjH...ature=youtu.be

This repeats for a while and then it just stops. any ideas?


All times are GMT -4. The time now is 04:12 AM.

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