Windows Server Repack (EQEmu Akka's PEQ Repack)

[Toony]

Just to clarify, max level with this repack is 65?

[lerxst2112]

Originally Posted by Toony

Just to clarify, max level with this repack is 65?

I don't know what the default it, probably whatever PEQ has it set to, but you can customize the database to anything you like.

[Uleat]

A rework of bots is on the long list..but, there are many, many other things that need more immediate attention...

If the mob class rework becomes more than just dev bantor, maybe a more stable bot will ensue

[Toony]

Up and running a few weeks now, but I noticed running the backup DB .bat gives a 0 byte sql file in the backup folder; am I looking in the wrong place?

[Akkadius]

Originally Posted by Toony

Up and running a few weeks now, but I noticed running the backup DB .bat gives a 0 byte sql file in the backup folder; am I looking in the wrong place?

Are you sure its 0 bytes and you haven't refreshed? Do you see the backup bat displaying errors?

[Toony]

Originally Posted by Akkadius

Are you sure its 0 bytes and you haven't refreshed? Do you see the backup bat displaying errors?

They are 0 bytes, but the window was closing before I could read any error message. I was able to get a little farther once I used the cmd prompt below.

[ghanja]

Originally Posted by Toony

Up and running a few weeks now, but I noticed running the backup DB .bat gives a 0 byte sql file in the backup folder; am I looking in the wrong place?

I'm going to go out on a limb and assume your Maria DB (specifically the location of mysql.exe, mysqldump.exe, etc.) is not within your Environment Path.

Follow these instructions for your applicable version of Windows:

Windows 8

    Drag the Mouse pointer to the Right bottom corner of the screen
    Click on the Search icon and type: Control Panel
    Click on -> Control Panel -> System -> Advanced
    Click on Environment Variables, under System Variables, find PATH, and click on it.
    In the Edit windows, modify PATH by adding the location of the MariaDB binaries (i.e. C:\Program Files\MariaDB 10.0\bin)  to the value for PATH.
    Close the window.


Windows 7

    Select Computer from the Start menu
    Choose System Properties from the context menu
    Click Advanced system settings > Advanced tab
    Click on Environment Variables, under System Variables, find PATH, and click on it.
    In the Edit windows, modify PATH by adding the location of the MariaDB binaries (i.e. C:\Program Files\MariaDB 10.0\bin)  to the value for PATH.


Windows XP

    Start -> Control Panel -> System -> Advanced
    Click on Environment Variables, under System Variables, find PATH, and click on it.
    In the Edit windows, modify PATH by adding the location of the MariaDB binaries (i.e. C:\Program Files\MariaDB 10.0\bin)  to the value for PATH.
    Close the window.


Windows Vista

    Right click My Computer icon
    Choose Properties from the context menu
    Click Advanced tab (Advanced system settings link in Vista)
    In the Edit windows, modify PATH by adding the location of the MariaDB binaries (i.e. C:\Program Files\MariaDB 10.0\bin)  to the value for PATH.

If there is NOT a trailing semi-colon at the end of the existing "Variable value" for "Variable Name" of PATH, then you need to put a semi-colon before adding C:\Program Files\MariaDB 10.0\bin

An example of what the value of variable Path may look like (and this assumes your AKKA REPACK was installed in C: drive of course):

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\system32\wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0;c:\Program Files\WIDCOMM\Bluetooth Software;c:\Program Files\WIDCOMM\Bluetooth Software\syswow64;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\Tools\Binn;C:\Program Files\Microsoft SQL Server\100\DTS\Binn;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Common Files\Autodesk Shared\;C:\Program Files (x86)\Autodesk\Backburner\;C:\Microchip\MPLAB C32 Suite\bin;C:\FPC\2.6.2\bin\i386-Win32;C:\Program Files\MariaDB 10.0\bin;

Also, run the t_backup_server_database.bat from an elevated command prompt.

Left click Windows/Start
Type in search: cmd
cmd.exe should show up, right click that
Left click "Run as administrator"
Click "Yes" (if running UAC, if not it will go straight to a dos prompt)
C:
CD "\EQ - AKKA'S PEQ REPACK\EQEMU SERVER"
t_backup_server_database.bat

You'll be able to copy/paste any errors from the command prompt (just highlight whatever text you want copied, there is no right clicking to it in a dos prompt).

Then just left click in a post/reply here to paste the error(s).

[Toony]

Ok, I got farther that time..

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>CD "\EQ - AKKA'S PEQ REPACK\EQEMU SERVER"

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER>t_backup_server_database.bat

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER>echo "Backing up database to Backups folder..."
"Backing up database to Backups folder..."

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER>perl DB_Dumper.pl compress loc="Backups"


Todays Date: 11-16-2014
Compression SET
Backup Directory: Backups
Directory currently exists... Adding files to it...

Backing up Database peq...

--- CMD ---
mysqldump -uroot -p"**************" peq > "Backups\peq 11-16-2014.sql"
---------------------------------------

'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

Error occurred... exiting...

[ghanja]

Did you add the proper path of where Maria DB 10.0 is installed?

To my knowledge, the repack installs on the boot drive (which is in most if not all cases the C: drive).

Verify that MariaDB 10.0 is here:

C:\Program Files\MariaDB 10.0\

If so, then you either did not add to the environment value correctly, or you did not exit from a command prompt you already had opened and then open a new one. That is to say, changes to the environment variable (Path) will not take effect until a new command prompt is open.

[ghanja]

Here, just do this instead (if it creates a duplicate path it isn't a big deal):

Perform this in an elevated (i.e. "Run as Administrator") cmd.exe (aka dos prompt):

setx path "%PATH%;C:\Program Files\MariaDB 10.0\bin"

[Toony]

Originally Posted by ghanja

Here, just do this instead (if it creates a duplicate path it isn't a big deal):

Perform this in an elevated (i.e. "Run as Administrator") cmd.exe (aka dos prompt):

setx path "%PATH%;C:\Program Files\MariaDB 10.0\bin"

It ran and generated a compressed backup in the folder, it was like 24 megs vs. the 230 the DB is? but seems like it ran fine.

Thanks

[Khaldore]

I had to manually add MariaDB's bin folder to the PATH variable as well... for some reason, I was expecting the repack installer to do it. *shrug*

Having said that, this repack is fantastic, lot of respect to Akkadius for putting it together. I haven't tried tinkering with my own server since I last owned a working PC, so having something quick and easy to drop into a VM is wonderful for testing.

[Akkadius]

When I went through the first 5-6 tries of getting the installer to cleanly do its thing. I had the PATH added there, it was the one thing that was missed in the final build :P

[Zudz]

Heyo. I got this set up, and I've been wandering around Steamfont (thanks so much for that!), but it seems like things don't aggro me. They'll fight me if I pull them, but otherwise everything is indifferent towards me. Is there something I can/should do to correct that?

[joligario]

Originally Posted by Zudz

Heyo. I got this set up, and I've been wandering around Steamfont (thanks so much for that!), but it seems like things don't aggro me. They'll fight me if I pull them, but otherwise everything is indifferent towards me. Is there something I can/should do to correct that?

You might need to clarify if you went to old steamfont or new one.