about accounts creation /about security

[babyjason]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

hello,

i would like to know if the accounts are set to autocreate there is some sort of protection not to spam new account creations? and if yes, how can i set it (wich lines and in wich config are those, i suppose in loginconfig )

2. it is secure to leave port 3306 port opened from outside to server, in order for account managers on website to access data base in order to create accounts? i was told it s not, that s why i want to find a better solution.

[lucan]

1 - I think it has no anti spam addition to these settings...

Code: Select all

# Flood Protection. All values are in MILISECONDS.# Default: TrueEnableFloodProtection = True # Default: 15FastConnectionLimit = 15 # Default: 700NormalConnectionTime = 700 # Default: 350FastConnectionTime = 350 # Default: 50MaxConnectionPerIP = 50

2 - You can open the firewall on your dedicated server just for the local and internal IPs (192.168.xx, 127.0.0.1 ...) and also for the IP of your webserver.
Assuming your web page is in the IP xxx.yyy.zzz.www frees you to access port 3306 only those IPs. Works for me perfectly and no one can access my MySQL.

[babyjason]

yes my webpage is LINK REMOVED but in the router setting i have only port forwarding... so where should i search for settings to allowe only the website to be allowed in the 3306 mysql of my server?

[lucan]

Yes, if you want only your site access your MySQL server from external, open the port 3306 of your router only for the IP of your webserver.

[babyjason]

Yes, if you want only your site access your MySQL server from external, open the port 3306 of your router only for the IP of your webserver.

sry for beeing pushy, thing is on the server i dont have an option to make a port forwarding available ONLY for an ip from the outside.

can this be done somehow else? maybe yb mysql config, my.cnf, but so my db can still be accesed locally ofc.

i googled lots but no clear answer, please help if possible,ty so much

[lucan]

Open the webserver IP to port 3306 in windows firewall or linux firewall, leave open por 3306 for any ip in the router.