Jump to content
  • 0

Problem Installing L2J On Ubuntu Server


linager

Question

Hi,

I have problems with the database installer.

 

Sofware installed:

 

OpenJDK Runtime Environment (IcedTea 2.5.4) (7u75-2.5.4-1~trusty1)

OpenJDK 64-Bit Server VM (build 24.75-b04, mixed mode)

MySQL - 5.5.41-0ubuntu0.14.04.1

 

Eclipse 3.8

 

Server files:

http://svn.l2jdp.com/branches/L2J_DataPack_IT/

 

This is my log (after running the database_installer.sh):

 

updates parser results. Last run: Fri Mar 20 19:57:45 ART 2015
050912-[1033].sql
ERROR 1061 (42000) at line 1: Duplicate key name 'key_item_id'
051016-[1334].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'custom_type1'
051103-[1438].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'clan_privs'
051104-[1447].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'wantspeace'
051112-[1505].sql
no errors
051112-[1506].sql
no errors
051129-[1670].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'crest_id'
051205-[1768].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'class_index'
051205-[1769].sql
no errors
051208-[1876].sql
no errors
060215-[c4_1489].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'crest_large_id'
060215-[c4req_update].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'type'
11012007_3477.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'paid'
20060305-[1575].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'onlinetime'
20060314-[1581].sql
no errors
20060412.sql
ERROR 1060 (42S21) at line 21: Duplicate column name 'heading'
20060424b.sql
no errors
20060424.sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'friend_id'
20060527-[2012].sql
ERROR 1060 (42S21) at line 4: Duplicate column name 'in_jail'
20060712-[2209].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'periodOfDay'
20060712-[dp1888].sql
no errors
20060712-[dp1896].sql
no errors
20060720-[2229].sql
no errors
20060920-[dp2090].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'power_grade'
20060925-[dp2103].sql
no errors
20061010-[dp2162].sql
no errors
20061015-[dp2197].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'nobless'
20070501.sql
no errors
update05052006.sql
no errors
update05092006.sql
no errors
update05152006.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'class_index'
update06072007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'owner_exp_taken'
update06082007.sql
no errors
update06122007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'mana_left'
update09122007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'death_penalty_level'
update10152006.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'nobless'
update12092007.sql
no errors
update17092007.sql
no errors
update17112007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'buff_index'
update20060522.sql
no errors
update20060607.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'isin7sdungeon'
update20060614.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'absorb_level'
update20061118.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reputation_score'
update20061124.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'last_recom_date'
update20061126.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reuse_delay'
update20061204.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'fornoble'
update20061206.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'lvl_joined_academy'
update20061207.sql
no errors
update20061208.sql
no errors
update20061223.sql
no errors
update20061230.sql
ERROR 1060 (42S21) at line 3: Duplicate column name 'auction_bid_at'
update20070101.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'varka_ketra_ally'
update20070210.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'dropable'
update20070216.sql
ERROR 1091 (42000) at line 1: Can't DROP 'objId'; check that column/key exists
update20070221.sql
no errors
update20070223.sql
ERROR 1091 (42000) at line 1: Can't DROP 'respawn_delay'; check that column/key exists
update20070303.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'ally_penalty_expiry_time'
update20070503-[dp2978].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'count'
update20070503-[dp2980].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'item_skill_id'
update20070511.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'expBeforeDeath'
update20070601.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'lastServer'
update20070929-[dp3399].sql
no errors
update20071203.sql
no errors
update25052007.sql
ERROR 1091 (42000) at line 1: Can't DROP 'inDebt'; check that column/key exists

 

 

 

I also had some problems with Java and Eclipse, I ended up downloading the data using "wget -m -np" and using those files (maybe that's a problem)

 

Can someone help?

 

Thanks.

 

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0

What L2J Datapack should I use? I want a try an Interlude server. First I would like to with a Free one just to know if i can make it work. After that I will look foward buying one. 

At 1st I kept getting the error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" And I was able to solve it by creating the database in the mysql console and granting privilegies to root. At first I tryed with LAMPP and I couldn't gre throught error "Access denied for user 'root'@'localhost' (using password: YES)"

 

So...all this problems are because of the server files I am using?

 

Thank you all

Link to comment
Share on other sites

  • 0

You didn't set the password inside the server.prop of your database.

 

Take aCis and enjoy.

 

http://acis.i-live.eu/index.php?topic=1974.0

Link to comment
Share on other sites

  • 0

You didn't set the password inside the server.prop of your database.

 

Take aCis and enjoy.

 

http://acis.i-live.eu/index.php?topic=1974.0

 

Great! Is it ok if I wget them? Or I have to checkout the files via Eclipse?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • MidnightSell team WTB/WTS GOLD TWW EU/US all servers Cataclysm all servers Payment Visa/Master/Btc/Eth/Trc-20/Erc-20 (all payments within 10 min) For all question pls dm Discord https://discord.gg/h8AN57qJjK Or Telegram @MidnightSell
    • GOSTEI MUITO DO VIASUAL DO SERVE COMO POSSO ADQUIRI ESSA REV PACK   
    • Helly everyone . I use L2jmobius interlude , i did everything , installed the db compiled the Build in eclipse Gameserver seems to lead OK , but it fails to connect to loginserver When i click to start the loginserver it says  "Loginserver terminated abnormally" This is wheat gameserver shows me :    [05/10 17:25:12] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:12] LoginServerThread: LoginServer not available, trying to reconnect... [05/10 17:25:17] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:17] LoginServerThread: LoginServer not available, trying to reconnect... [05/10 17:25:22] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:22] LoginServerThread: LoginServer not available, trying to reconnect...   And This is my login config file:   # --------------------------------------------------------------------------- # Login Server Settings # --------------------------------------------------------------------------- # This is the server configuration file. Here you can set up the connection information for your server. # This was written with the assumption that you are behind a router. # Dumbed Down Definitions... # LAN (LOCAL area network) - typically consists of computers connected to the same router as you. # WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet). # x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # --------------------------------------------------------------------------- # Networking # --------------------------------------------------------------------------- # Bind ip of the LoginServer, use 0.0.0.0 to bind on all available IPs # WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u> # WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u> # Default: 0.0.0.0 LoginserverHostname = 0.0.0.0 # Default: 2106 LoginserverPort = 2106 # The address on which login will listen for GameServers, use * to bind on all available IPs # WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u> # WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u> # Default: 127.0.0.1 LoginHostname = 127.0.0.1 # The port on which login will listen for GameServers # Default: 9014 LoginPort = 9014 # --------------------------------------------------------------------------- # Database # --------------------------------------------------------------------------- # Specify the JDBC driver class for your database. # Default: org.mariadb.jdbc.Driver Driver = org.mariadb.jdbc.Driver # Database URL # Default: jdbc:mariadb://localhost/l2jmobiusinterlude?useUnicode=true&characterEncoding=utf-8&useSSL=false&connectTimeout=10000&interactiveClient=true&sessionVariables=wait_timeout=600,interactive_timeout=600&autoReconnect=true URL = jdbc:mariadb://localhost/l2jmobiusinterlude?useUnicode=true&characterEncoding=utf-8&useSSL=false&connectTimeout=10000&interactiveClient=true&sessionVariables=wait_timeout=600,interactive_timeout=600&autoReconnect=true # Database user info. Default is "root" but it's not recommended. Login = root # Database user password, leave empty for no password. Password = root # Maximum number of database connections to maintain in the pool. # Default: 5 MaximumDatabaseConnections = 5 # Determine whether database connections should be tested for availability. # Default: False TestDatabaseConnections = False # --------------------------------------------------------------------------- # Automatic Database Backup Settings # --------------------------------------------------------------------------- # Generate database backups when server restarts or shuts down.  BackupDatabase = False # Path to MySQL bin folder. Only necessary on Windows. MySqlBinLocation = C:/xampp/mysql/bin/ # Path where MySQL backups are stored. BackupPath = ../backup/ # Maximum number of days that backups will be kept. # Old files in backup folder will be deleted. # Set to 0 to disable. BackupDays = 30 # --------------------------------------------------------------------------- # Thread Configuration # --------------------------------------------------------------------------- # Defines the number of threads in the scheduled thread pool. # If set to -1, this will be determined by available processors divided by 2. ScheduledThreadPoolSize = 2 # Defines the number of threads in the instant thread pool. # If set to -1, this will be determined by available processors divided by 2. InstantThreadPoolSize = 2 # --------------------------------------------------------------------------- # Security # --------------------------------------------------------------------------- # How many times you can provide an invalid account/pass before the IP gets banned. # Default: 5 LoginTryBeforeBan = 5 # Time you won't be able to login back again after LoginTryBeforeBan tries to login. # Default: 900 (15 minutes) LoginBlockAfterBan = 900 # If set to True any GameServer can register on your login's free slots # Default: True AcceptNewGameServer = True # Flood Protection. All values are in milliseconds. # Default: True EnableFloodProtection = True # Default: 15 FastConnectionLimit = 15 # Default: 700 NormalConnectionTime = 700 # Default: 350 FastConnectionTime = 350 # Default: 50 MaxConnectionPerIP = 50 # --------------------------------------------------------------------------- # Misc Login Settings # --------------------------------------------------------------------------- # If False, the license (after the login) will not be shown. # Default: True ShowLicence = True # Default: True AutoCreateAccounts = True # Datapack root directory. # Defaults to current directory from which the server is started. DatapackRoot = . # --------------------------------------------------------------------------- # Scheduled Login Restart # --------------------------------------------------------------------------- # Enable disable scheduled login restart. # Default: False LoginRestartSchedule = False # Time in hours. # Default: 24 LoginRestartTime = 24    
  • Topics

×
×
  • Create New...