Jump to content
  • 0

[Help] l2 aCis database installation


Question

Posted

Geia kai pali proekipse ena provlima me to database instalation tou l2 aCis.

afou exw vlaei to path gia to mysql bin otan trexw to installer mvgazei afto to error :

ERROR 1045 <28000>:Access denied for user '--password='@'localhost' <using password>

8 answers to this question

Recommended Posts

  • 0
Posted

Geia kai pali proekipse ena provlima me to database instalation tou l2 aCis.

afou exw vlaei to path gia to mysql bin otan trexw to installer mvgazei afto to error :

ERROR 1045 <28000>:Access denied for user '--password='@'localhost' <using password>

exeis valei password sto Mysql? an nai valto kai sta configs, i mpori na exeis kanei kati alo la8os sta configs..

ta dika mou einai etsi..sugrine kai des ti exeis kanei la8os


Login


#=============================================================

#                        Loginserver

#=============================================================

 

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname

ExternalHostname = l2*****.no-ip.biz

 

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname

InternalHostname = 127.0.0.1

 

# Bind ip of the LoginServer, use * to bind on all available IPs

LoginserverHostname = *

LoginserverPort = 2106

 

# How many times you can provide an invalid account/pass before the IP gets banned

LoginTryBeforeBan = 10

 

# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)

LoginBlockAfterBan = 600

 

# The address on which login will listen for GameServers, use * to bind on all available IPs

LoginHostname = *

 

# The port on which login will listen for GameServers

LoginPort = 9014

 

# If set to true any GameServer can register on your login's free slots

AcceptNewGameServer = False

 

# If false, the licence (after the login) will not be shown

# It is highly recomended for Account Security to leave this option as default (True)

ShowLicence = True

 

#=============================================================

#                    Database informations

#=============================================================

 

# Database info

Driver = com.mysql.jdbc.Driver

#Driver = org.hsqldb.jdbcDriver

#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

 

URL = jdbc:mysql://localhost/acis [edw to name tis Database(suni8ws l2jdb)]

#URL = jdbc:hsqldb:hsql://localhost/acis   

#URL = jdbc:sqlserver://localhost/database=acis/user=sa/password=

 

Login = root

Password =  (edw vazeis to Password an exeis)

 

MaximumDbConnections = 10

 

# Usable values: "true" - "false", use this option to choose whether accounts will be created automatically or not.

AutoCreateAccounts = True

 

# The delay in minutes after which the login updates the gameservers IP's (useful when their ip is dynamic)

IpUpdateTime = 15

 

#=============================================================

#                        Security

#=============================================================

 

# Log all events from loginserver (account creation, failed/success login, etc)

LogLoginController = False

 

# Enforce GG Authorization from client

# Login server will kick client if client bypassed GameGuard authentication

ForceGGAuth = True

 

# FloodProtection. time in ms

EnableFloodProtection = True

 

FastConnectionLimit = 15

NormalConnectionTime = 700

FastConnectionTime = 350

MaxConnectionPerIP = 50

 

#=============================================================

#        Test server, shoudnt be touched in live server

#=============================================================

 

Debug = False

Developer = False

PacketHandlerDebug = False


gameServer


# ================================================================

#                          Gameserver setting

# ================================================================

 

# Bind ip of the gameserver, use * to bind on all available IPs

GameserverHostname = *

GameserverPort = 7778

 

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname

# If this ip is resolvable by Login just leave *

ExternalHostname = l2*****.no-ip.biz

 

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname

# If this ip is resolvable by Login just leave *

InternalHostname = 127.0.0.1

 

# The Loginserver host and port

LoginPort = 9014

LoginHost = 127.0.0.1

 

# This is the server id that the gameserver will request (i.e. 1 is Bartz)

RequestServerID = 1

 

# If set to true, the login will give an other id to the server (if the requested id is already reserved)

AcceptAlternateID = True

 

# ================================================================

#                        Database informations

# ================================================================

 

Driver = com.mysql.jdbc.Driver

#Driver = org.hsqldb.jdbcDriver

#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

 

URL = jdbc:mysql://localhost/acis  [edw to name tis Database(suni8ws l2jdb)]

#URL = jdbc:hsqldb:hsql://localhost/acis   

#URL = jdbc:sqlserver://localhost/database=acis/user=sa/password=

 

Login = root

Password = (edw vazeis to Password an exeis)

 

# Maximum database connections (minimum 2, basically 10 if number under 10, default 100)

MaximumDbConnections = 100

 

# Idle connections expiration time (0 = never expire, default)

MaximumDbIdleTime = 0

 

# Datapack root directory, default to current directory from which the server is started

# DatapackRoot = C:/Work/tmp/DataPack

 

  • 0
Posted

exeis valei password sto Mysql? an nai valto kai sta configs, i mpori na exeis kanei kati alo la8os sta configs..

 

lathos sta cofigs malon giath password den exw sto mysql

  • 0
Posted

borw apla na antigrapsw ta dika sou configs ?

antigrapseta..apla alkakse ta external ip, to port sto gameserver apo 7778 kanto 7777, kai sto navicat kane database me onoma acis anti gia kati alo

ps: to gameserver den einai olo to config...adegrapse oti xriazase

  • 0
Posted

kati teleuteo to database installer einai se diaforetiko fakelo apo to configs peirazei?

deksi click kai edit to database installer...kai vazeis oti sou zitaei...prosoxh,to password,to login kai to database an thumame kala sta zutaei 2 fores...apla alakseta sumfona me ta stuxeia pou exeis sta configs
Guest
This topic is now closed to further replies.


  • Posts

    • Hello everyone I'm Albert, Starting now with the dream on have a L2 server, I'm having several issues with RS and I need someone help to Create an skill and implement to the correct class ID and make it work. Skill Required from me is  Festival Sweep  Skill or Item with the ability. I really need help guys and then after if possible i would need NPC and skins with .dressme        
    • Changeset 410 (3371)   Makers, NpcAi / Desires, Cursed Weapon rework, Bugfixes, Admincommands, Movement, Organization   Makers Fix ghost corpses. Introduce task manager for MultiSpawn spawn schedule. Introduce task managers for Npc respawn and despawn tasks. Add missing random treasurebox maker. NpcAi / Desires AttackableAttack > NpcAttack, allowing ATTACK_FINISHED event over Npc. Merge all reduceWeight from NpcAI operations. Don't broadcast MoveToPawn packet for cast hold scenarii. CH and CP managers use hold cast. Probably way more to add. Rework DesireQueue#addOrUpdate to avoid to generate a List. Drop _isInHitAnimation, avoid twice runAI calls upon attack end animation, save a ThreadPool. Implement Desire#isInvalid, used over the main loop to clean invalid Desires. All sided getDesires().removeIf are dropped, notably over AggroList/HateList. Cursed Weapon rework Fix potential task scheduling issues, reworking the whole layers. Reduce code by 1/3. Use L2OFF formulas/data for item drop rate, staging process. CW end duration now decreases when killing other Players. Bugfixes Revert schedule part from ThreadPool. Fix Pet inventory IU. Ty Denzel for the report. Fix Pet item timestamp reuse delay. Ty artemis for the fix. Disable automatic beastshots when his owner dies. Ty Root for the report. Player cannot craft while casting a skill, nor trade. Ty Root for the report. Add missing weight checks for player/summon pickup, and player craft. Ty Root for the report. Implement /graduatelist command, which displays a list of clan academy graduates for the past week. Ty RooT for the report. Fix PLAYING_FOR_LONG_TIME concept ; rest message is server related, not Player related. Ty RooT for the report. Player should stop movement when opening store. Fix Q351 occurences of itemId 4310 by 4407 one + slight fix. Fix Q365 missing memoState + poison skillId. Ty Root for the report. Fix Q417 Torai despawn over cond 11. Fix Q216 4 missing npcIds. Ty Karudin for the report. Fix the invalid comment of DeleteCharAfterDays Config. Fix NPC drop penalty level calculation. Ty Bandnentans for the report. Items are now dropped in a 30/45 donut shape around dropper. Ty Bandnentans for the report. PartyMatch fixes Don't show Party members or CW holder as available waiting members. You can't show overall List or join a PartyMatch room as CW holder. CW owner, upon acquisition, leave PartyMatch system. PartyMatch window is now automatically closed upon Player#removeMeFromPartyMatch. Remove Player from PartyMatch if Player and newly joined Party leader PartyMatch rooms differ. You can't join or be invited in a PartyMatch room if already partying/CW holding. Fix ShowLicence config when set to false. Ty artemis for the fix. Fix maximum number of macros. Ty artemis for the fix. Fix invalid IU update over //enchant. Ty artemis for the fix. Fix Castle Mass Gatekeeper HTMs. Ty kingNik0n for the fix. Drop _disabledItems implementation. Won't be used by next refactors. Ty artemis for the report. Fix loading handlers under debug. Ty Keku for the fix. Fix character_macroses table structure (commands = 12x32 chars minimum). Admincommands Merge all old spawn admincommands (//list_spawns, //spawn, //unspawnall, //respawnall, //delete) to //spawn and //unspawn (previously //delete). Generate //help. //unspawn works over all ASpawn. Merge all old fence admincommands (//spawnfence, //deletefence, //listfence) to //fence [add|remove], generate AdminFence. They now use proper Pagination. You can also teleport to it. Implementation of //show manor. Implementation of //set quest <id> [cond]. Related items must be hand-given. Implementation of //set henna [page] [add|remove symbolId]. The hennas are still bound to game logic (slots, canBeUsedBy). Movement - Ty LaRoja, Bandnentans Fix Boats IOOBE. Adapt getHeight logic from L2OFF. Introduce back WASD movement, handle boat board/unboard. Fix WATER/FLY movement logic. Avoid to pathfind diagonal cells with detected obstacle. Organization Addition of QuestVars class, holding all related variables from quests (itemIds, npcIds, questNames, sounds, etc), allowing to reduce length of each script while reusing variables. 100+ cloned variables were deleted. Refactor geometry package and Territory. Territory is now a unique 3D shape, holding any type of 2D geometry.  Remove few useless Location#clone uses. Implementation of ItemContainer#forEachItem. Clean many unused FrequentSkill. The whole enum is questionable. Drop MathUtil#checkIfInRange, implement WorldObject#isInStrictRadius (involve collision of that WorldObject, and potential WorldObject parameter). WorldObject#isIn2DRadius parameter is now a Point2D, not a Location (since a Location inherits Point2D, Location are still usable as parameter). Rework Pagination#generatePages to handle page number > 1000. Use Pagination over Tryskell SchemeBuffer. Ty CUCU23 for the share.
    • It's a custom instance used as Event not retail - like. You can re-create it easily.
    • GRAND OPENING TODAY !!! FROM - 16/05/2025, FRIDAY, 20:00 +3 GMT !
  • Topics

×
×
  • Create New...