Jump to content

Recommended Posts

Posted

If it's double post please delete.

 

This Guide experts in Creating your servers databases,databases users,configuring Daedalus L2J Account Manager,in a way that your server is fully protected.

This Guide is addressed for account managers,installed in a different server than the server your gameserver is running on,with your account manager configured properly,to be able to connect to your gameserver's loginserver database securely.

 

 

This is a very important part about your server's security.

 

First of all i suggest you to have seperate databases for loginserver and gameserver.

A good choice is to make a database called loginserver for your loginserver(Login server database includes,your server's accounts basically)

As for the  gameserver i suggest you to make a database called gameserver.

I assume you already know how to install your l2j server database in 2 seperate databases.(one database for login server,one database for gameserver)

Now,that you have your databases installed,make sure you make the step 1 from database part.(This step is to later in this Guide)

 

Okay,you must now set up the proper permissions user/database permissions in  order to proceed to the Account Manager Tutorial.

 

In this tutorial you will create 1 extra user for your account manager in your website to have access in your database.

 

1)Open your Navicat. (www.navicat.com)

2)open your connection to the localhost

3)Click the "Manage Users" icon.

4)Now you see there is already a user in your mysql server.The (root@localhost) user,click create new user.In the hostname field write the server ip that you have your website.

(Note**The ip i am telling about isn't the ip you see in your Cpanel,or the ip you got from your hosting account information.It is the true server ip that your website is hosted in this server,This is because the ip of your website has blocked inbound traffic,and your script won't work.So you must ask your hosting provider what is the server's basic ip address)

Then the ip address they told you,you must put it in the hostname field.

For username we are gonna use "web_acm" without the quotes for this tutorial.

As for the password you can use whatever you like,but make sure you write them down on a paper,because you can forget this information.

Okay,now you have succesfully created the user that has access to your loginserver database, from your website.

5)You must now,give proper permissions to that user.Now left click,on your web_acm user,you will now see your 2 databases.(loginserver,gameserver),left click again to loginserver.(now you can see some tables)left click to accounts table(you can now see some fields.The only permissions you must give are "Select, Insert, Update".

Now do the same thing for the account_data table,but now you must give these permissions."select, insert, delete"

6)Done,your permissions are set correctly.

 

                    ACCOUNT MANAGER TUTORIAL

 

 

Download it's latest version by clicking this link.

New Version  :Account Manager  http://trac2.assembla.com/l2j_manager/changeset/latest/account_manager/?old_path=/&format=zip

SVN Version : SVN http://svn2.assembla.com/svn/l2j_manager/

Timeline : Account Manager http://trac2.assembla.com/l2j_manager/timeline

Old Version : Account Manager http://heliosdaedalus.free.fr/account_manager.tar.gz

Follow the steps bellow.

 

 

1)Upload this .zip folder in your webspace,in plublic_html(if you have Cpanel as your  control panel) and if you don't have Cpanel this is probably your web folder (www) that you need to upload your .zip file.

2)Extract it.You will see now a folder called account_manager.

3)Rename account_manager folder to acm.

4)We need to set permissions for some files in order to install and make the account manager work.

5)In the root directory of acm (/acm/) set permissions of all files to 644.

6)Inside of (/acm/libs/) set permissions to all files to 644.

7)Inside of (/acm/libs/plugins/) set permissions to all files to 644.

8)Inside of (/acm/libs/internals/) set permissions to all files to 644.

9)Inside of (/acm/language/) set permissions to all files to 644.

10)Go in (/acm/classes) and change permissions of all files to 644.

11)Inside  (/acm/templates/) you can see the templates you have.For each template you want to use,go inside it's folder and give 644 permissions to all the files,and then go to its /image folder and give 755 permissions to all images too.

Warning!

Don't try to give 644 privilenges to the files of a folder,by giving 644 to the folder,this will not change the privilenges of the files inside.

 

Configuration part

 

Configure in the (/acm/) the config.php to match your loginserver's database settings.(in the hostname put your dedicated server's ip,for database use your loginserver database,and for user use the user you created for your website to access your loginserver "web_acm is the user used in this tutorial",in the password put your user's password)

 

Database part

 

Execute the db.sql to the login server database.

 

Test

 

Run the install.php to see if all things go right.

If you see all things as ok then all went right.

 

 

Finished!

Your Account Manager is now perferctly configured and your database is secured.

Have fun.

 

 

Tutorial not mine, original source http://www.hopzones.net/forum/topic/116/

Guest
This topic is now closed to further replies.
  • Posts

    • Hi everyone, Since I’m no longer interested in L2 servers, if anyone is willing to continue the project, let me know. I’m currently selling the entire project. DM me for more information if you’re genuinely interested. I can offer limited free support for the first couple of months. It is not cheap. The sale includes the domain, the recently fully redesigned website, the updater, the interface, server files with Lucera ext source, and the database (excluding account passwords, emails, and other private information; character data can remain).   Server for test: https://lineage2.gold/download Server Info: https://lineage2.gold/info Over 110 videos YouTube playlist: https://www.youtube.com/watch?v=HO7BZaxUv2U&list=PLD9WZ0Nj-zstZaYeWxAxTKbX7ia2M_DUu&index=113  
    • You invent yourself a life - bad for you, one of the inner core dev, fernandopm, which worked hard over aCis quests from 2011 to 2016 is argentinian. I teached him back in time to work and make proper quests. My dev team comes from 10+ countries and I'm myself french. "Racist/nationalist" card ? Not working bro.   Not sure why I should thank you to send me questions, and regarding bug reports, so far, I got none of yours in either discord, gitlab, or forums. I'm sorry if you feel "ignored", but that's more a psychanalyst you need to speak with if you put emotions towards someones' appreciation over a forum. I never ignore a bug report, and if so (like skills reports), it's because I got a bigger plan (skills refactor, in that case). In any case, I delivered cookies for the bug report/fix, even if it dated of months, with proper credits over changesets. "Victim card" ? Not really working, but ok, maybe you're "emotional".   I barely make money out of aCis, for the spent time - simply selling my services, or even coding/administrating a minecraft/L2J server would make far more money. Breaking intentionally things would be stupid. If you don't understand I'm not the only one working on that pack, I can't help you. Also, the scale of edits is sometimes extreme - AI L2OFF ? 1800 files added. How do you want everything works in a single shot ? "Exploiting noobz for money" card ? Still not working, or I'm a terrible businessman.   Meanwhile - you shadow advertise your project, L2JOne (since 2017 btw) - you should maybe start by the beginning saying you're a competitor and aCis is actually a spike in your foot. That also explains why you act like that. RusAcis got the exact same strategy, speaking bad of me, saying they got unique fixes (you speak about I break things, they break and recode things 4 times sometimes, btw), but successfully reselling latest revision with poorly executed stuff. "aCis is good, Tryskell is ok, but I solve all issues in extreme low time so I can piss over him" card ? Mmmmhhhh.   Our conversation ends here if you want, I don't force ppl to speak with me if they don't want - hopefully, people would understand I'm not the arrogant one and the one who doesn't want to talk, or even collaborate. :). I understand you got your own project and got no will to improve aCis.   NOTE : I'm extremely happy for your call of ExShowServerPrimitive with getValidGeoLocation, extremely impressive. Arrogant, no. Sarcastic ? Maybe.   Good night everyone.
    • Hi. @GX-Ext, svn does not work. is there anywhere else where we can get source code? Thank you so much.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock