Setting up new server.

[GhettoTech]

I am new to EQemu and trying to get a server up and running.
No matter what I try the database is not accessible. I have used the Grant All Priv. and that didnt work. I also used the gui to give all rights to the user and that didnt work.
Windows XP sp2
MySql 4.1.14 (I also tryed 4.0 and had no luck)
Perl and other stuff installed acording to the few guides i found

I am not sure on what database to use with 6.2. I know there are alot asking for guides out there but I hope my questions are simple enough. I downloaded the Velious DB sql files but am not able to restore them ( i think that is how you do it) I lock up about 3% into analysing. I am not asking for someone to send me a DB just please let me know if I am on the right track....
I have tryed using the 5.8 from peq and some other full package noinstall.zip with no luck.
thanks
G

[jillmatik]

Aside from some of the issues that others are dealing with regarding version 0.6.2, I've successfully setup a PEQ Velious RC1 database using the following guide as a guideline (it doesn't work if you follow step by step):

http://www.eqemulator.net/forums/showthread.php?t=18707

When you download the database files, the *.sql files should be extracted to (assuming default installation) C:\mysql\bin

I too have set this up on WinXP Pro SP2.

Good luck.
J

[GhettoTech]

Thanks I will try looking at that one... I used a similar one but i will try this one. I also used it as a guideline and spent another 8 hours trying to get it work saturday night :(

What version of mysql are you using?

and does anyone know if it is possble to run on a 2003 server machine using Microsofts SQL and not MYSQL?

EDIT: I think I posted a little too soon.... I forgot to add the guide I had didnt have

Source load_system.sql;
Source load_empty_users.sql;
Source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
Source 0.6.1-upgrade.sql;
Source ZONECFG.SQL;
Source altadv_vars-contents.sql;

I was trying to restore them into mysql
thanks again

[jillmatik]

Originally Posted by GhettoTech

Thanks I will try looking at that one... I used a similar one but i will try this one. I also used it as a guideline and spent another 8 hours trying to get it work saturday night :(

What version of mysql are you using?

and does anyone know if it is possble to run on a 2003 server machine using Microsofts SQL and not MYSQL?

EDIT: I think I posted a little too soon.... I forgot to add the guide I had didnt have


I was trying to restore them into mysql
thanks again

Just a note that I got a bunch of errors when I tried sourcing all those into the RC1 PEQ database. That guide was built for the Beta DB.

[GhettoTech]

Just spent about 4 more hours trying to get up and running with no luck.
I am still having #2006 errors like it cant see my database.

[tallerin]

the guide that is linked to in here can be used but you only need to source in the 2 load files from the rc1 zip

source into mysql

Source load_system.sql;
Source load_empty_users.sql;

edit: also on side note i am also running win xp sp2 and i am useing mysql-4.0.22-win

[rojadruid]

Originally Posted by GhettoTech

Just spent about 4 more hours trying to get up and running with no luck.
I am still having #2006 errors like it cant see my database.

Post your db.ini file for me, I was getting that error too, found it in that file as the problem.

[GhettoTech]

Originally Posted by tallerin

the guide that is linked to in here can be used but you only need to source in the 2 load files from the rc1 zip

source into mysql

Source load_system.sql;
Source load_empty_users.sql;

edit: also on side note i am also running win xp sp2 and i am useing mysql-4.0.22-win

I figured that after I saw the messages saying the tables existed.

DB.ini is:

[Database]
Host=localhost
User=xxx
Passworrd=xxx
Database=eq

I have granted permission on all and checked thought the admin interface and the user does have rights.

Thanks for the help guys


Edit: what about the Perl 13th floor part?
I keep getting -u unknown switch any idea?

[rojadruid]

Originally Posted by GhettoTech

I figured that after I saw the messages saying the tables existed.

DB.ini is:

[Database]
Host=localhost
User=xxx
Passworrd=xxx
Database=eq

I have granted permission on all and checked thought the admin interface and the user does have rights.

Thanks for the help guys


Edit: what about the Perl 13th floor part?
I keep getting -u unknown switch any idea?

Humm the file looks right,

Try this just for the heck of it.
copy below with no trailing spaces into a notepad file and save it over top of yours as db.ini. it may sound crazy but it might also work, it could be the format the file is in.

# READ README.TXT!

[Database]
host=localhost
user=xxx
password=xxx
database=eq


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

[jillmatik]

If you go to your C:\mysql\data directory.. do you see a folder named EQ?

You should see a folder for your database name, and this folder name should match the database field in your db.ini file.

What do you see there?

[GhettoTech]

yep its there and its also in my schema when using the admin gui