Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

Problem Installing L2J On Ubuntu Server

linager

Asked by linager,

 Share

Question

linager Newbie

linager

Posted
Posted

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.

 

9 answers to this question

Recommended Posts

  • 0
linager Newbie

linager

Posted
  • Author
Posted

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

  • 0
linager Newbie

linager

Posted
  • Author
Posted

Checkout via eclipse, there is a svn link.

Ok, I'll do that. Just for curiosity...what's the difference between checking out data via eclipe and downloading the files with wget?

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.

×
 Share
Go to question listing


  • Posts

    • rufi
      InertiaX AutoFarm

      By rufi · Posted

      Faltan demasiados archivos,  y lógicas en clases claves como L2pcInstance, entre otras. si bien muchas cosas están y el flujo es valorable.  Gracias por tu esfuerzo es bastante... pero realmente no esta completo el código, falta que subas todas las modificaciones en clases colaterales... podrías intentar subir un diff de todo el mod  completo de tu pack y bueno ahí si que cada uno adapte... pero faltan muchas cosas, dudo que haya gente que lo haya echo funcionar con esto... 
    • Celestine
      [Active Anticheat] When Promises Fall Short

      By Celestine · Posted

      I know people who have fully bypassed and reversed AAC. One day, they might even release the full source code, but for now, they’re still making money off it. I won’t name anyone, but it’s clear that there aren’t any truly solid anticheats for Lineage2. As I’ve said before, kernel level anticheats are the only real solution. Anything that runs as Internal and injects gets flagged, and your account ends up getting kicked or banned. That’s just how most games handle it nowadays. To TL;DR the whole thing cheating will always exist because there are people out there smart enough to bypass any protection and run private cheats. Public cheats are always detected eventually, so I don’t see any point in buying AAC, especially when they claim it blocks adr, which simply isn’t true.
    • nicu30
      [L2J] L2 Adonis

      By nicu30 · Posted

      🌐 Website: https://l2adonis.com 📅 GRAND OPENING: July 18, 2025 – 20:00 (UTC+2) 💬 Discord: https://discord.com/invite/tZBj8JxAwx 🚫 No auto-farm • No auto-macro • No pay-to-win • No custom   Some Basic Info's (More detalied info's on website)  EXP/SP: x25  Adena: x15  Drop: x15  Spoil: x15  Seal Stones: x15  Raid Boss Drop: x10  Epic Boss Drop: x1  Manor: x10  Safe Enchant: +4  Max Enchant: +16  Normal Scroll Chance: 50%  Blessed Scroll Chance: 66% (If enchant fail item remain +4)  Buff Slots (30+4 extra with Divine Inspiration)  Dances/Songs Slots 14  Auto-learn skills  ⚔️ Real PvP • Real Progression • Retail-like experience JOIN NOW and relive the real L2 experience!
    • Utchiha-Market
      Full Verified 2015 - 2022 Discord Token's For Just $0.69

      By Utchiha-Market · Posted

      Discord         :  utchiha_market Telegram        : https://t.me/utchiha_market Auto Buy Store  : https://utchihamkt.mysellauth.com/ Not sure if we’re legit? Check Our server — real reviews, real buyers https://discord.gg/uthciha-servicess  | https://campsite.bio/utchihaamkt
    • MrVercetti
      LF DEVELOPER

      By MrVercetti · Posted

      Looking for a Developer – Lineage II Interlude (Vanganth Files)   I’m seeking a developer to collaborate on a project based on Vanganth Interlude files.   Important: Applicants with a bad attitude, lack of respect, or unwillingness to work will be immediately rejected. Payment: Hourly rate, not per task. Contact: Please reach out to me via PM.

  • Topics

×
×
  • Create New...

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