Help Account Creation

[tk422]

Greetings

 

 

I'm looking for some help to get an account registration script working with AdvExt64's interlude pack.

 

The typical tools i'd use to create accounts such as L2AC or L2GMPanel don't seem to be working.

 

(I think there is an issue with how the SQL is structured. The errors i get seem to indicate that)

 

Does anyone have experience with this or could offer some guidance?

 

I've been out of the loop for many years so please excuse this noob question.

 

Thanks in advance...  :)

 

Edited May 7, 2014 by Universe

[mcbigmac]

Considering AdvExt uses hauthd as well.... there's zero difference almost to the lin2db structure.

 

So it should work fine - most likely your SQL credentials and setup are cocked.

[tk422]

Considering AdvExt uses hauthd as well.... there's zero difference almost to the lin2db structure.

 

So it should work fine - most likely your SQL credentials and setup are cocked.

 

 Hmm ok, Will tare everything down tomorrow and run though setup again. Maybe i missed a step somewhere.

 

What's strange is that the server runs. CacheD, and L2Server report no errors other than not being able to connect to LogD.

Everything seems to be working ok, I just cant actually create an account to test :P

 

Do you have any specific idea what could be causing it or what i should check?

 

I'm using SQL Server 2008R2, Does that matter?

 

Either way, thanks for getting back to me! :)

Edited March 23, 2014 by tk422

[xeL]

Hey,

 

1. Install this lin2db.sql from attach

2. Install the hauthd sql

3. Make account with l2offgmpanel

4. Done :)

 

Should work 100%

 

3_lin2db.zip

[tk422]

Hey,

 

1. Install this lin2db.sql from attach

2. Install the hauthd sql

3. Make account with l2offgmpanel

4. Done :)

 

Should work 100%

 

I deleted all the databases and DSN's then set them up again. I used the SQL included in the AdvExt64 pack which again didn't work. I then used the SQL you uploaded which worked perfectly. I was able to create an account no problem.

 

Do you know what the issue could be with their SQL? Is it safe to not use it?

 

Thank you so much for the help!!!

[xeL]

I deleted all the databases and DSN's then set them up again. I used the SQL included in the AdvExt64 pack which again didn't work. I then used the SQL you uploaded which worked perfectly. I was able to create an account no problem.

 

Do you know what the issue could be with their SQL? Is it safe to not use it?

 

Thank you so much for the help!!!

Is safe, don't worry. Maybe in the sql is something different on tables and structure. Never used that.

[LooLand]

same problem and i fix with yr sql ty

[solstise]

http://www.blogdemegastar.com/2010/09/pasos-para-configurar-sql-server-2008.html

[caganitas]

I had that problem and in my case  it was just the Stored Procedure used to create an account by L2GMPanel and L2AC is not included in the sql scripts provided by AdvExt