[Guide] Complete C3 server setup guide L2J

gekaz · Jun 17, 2005

Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1050e1f [ con
nectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@157
1886 [ acquireIncrement -> 3, autoCommitOnClose -> true, connectionTesterClassNa
me -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation ->
null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 60
000, initialPoolSize -> 1, maxIdleTime -> 600000, maxPoolSize -> 5, maxStatement
s -> 100, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManage
rDataSource@e24e2a [ description -> null, driverClass -> null, factoryClassLocat
ion -> null, jdbcUrl -> jdbc:mysql://localhost/l2jdb, properties -> {user=root,
password=** ] , propertyCycle -> 300, testConnectionOnCheckout -> false ] , facto
ryClassLocation -> null, numHelperThreads -> 3 ]
GameServer listening on IP:* Port 7777
Maximum Numbers of Connected Players: 100
ID Factory could not be initialized correctly:java.sql.SQLException: General err
or message from server: "Table 'l2jdb.items' doesn't exist"
Could not read object IDs from DB. Please run convertData.
Exception in thread "main" java.lang.Exception: Could not initialize the ID fact
ory
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:204)
at net.sf.l2j.Server.main(Server.java:73)
Для продолжения нажмите любую клавишу . . .

help me please

zabbix · Jun 17, 2005

install datapack

Vexane · Jun 18, 2005

re-read the guide.

Hayzari · Jun 18, 2005

I've done everything like in guide, i have read all guide twice and i still have this error.
What i need to do now???????????
Plz help me. :zoo_fox4:

Hayzari · Jun 18, 2005

now i can enter but i don't have any NPC's

Hayzari · Jun 19, 2005

Now i have server on but i don't have any mobs and NPC's

sk4848 · Jun 19, 2005

when i excute startserver.bat file, bottom of screen display...

=====================================================
...
...

created 26942 Spawn handlers
1 announcements added
door.csv is missing in data folder
unable to load language: jython: java.lang.NoClassDefFoundError: org/python/core
/PyException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.lang.Class.getConstructor0(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.apache.bsf.BSFManager.loadScriptingEngine(Unknown Source)
at org.apache.bsf.BSFManager.exec(Unknown Source)
at net.sf.l2j.gameserver.model.quest.jython.QuestJython.init(QuestJython
.java:13)
at net.sf.l2j.gameserver.model.quest.Quest.init(Quest.java:60)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:329)
at net.sf.l2j.Server.main(Server.java:73)
Initialising Clans
Started, free memory 26 Mb of 63 Mb
LoginServer listening on IP:127.0.0.1 Port 2106
Hostname for external connections is: 127.0.0.1
Hostname for internal connections is: 127.0.0.1
Automatically creating new accounts: true
2 banned IPs defined
===============================================================

and when i excute l2.exe, then i have login test/test..

it displays about that..

DB connections busy:1 idle:2
could not check password:java.sql.SQLException: Unknown column 'lastIP' in 'fiel
d list'
LoginServer: Client terminated the connection.

this problem has crazy me..

what should i solve for this problem?

=======================================================

my pc spec is AMD 1700@2200 Thoroughbred B, 512 3200 DDR RAM,

WindowsXP sp2, Java SDK 1.5 , My-Sql 4.1..

kadar · Jun 19, 2005

In navicat

1. Right click on accounts.sql
2. Click Design Table
3. Click Insert Field
4. Fill in the blanks as follows

lastIP varchar 16 0 Allow Null (checked)

5. Save

sk4848 · Jun 19, 2005

hu... as I do kadar's advise, I could login.
but I can't make Character.

so, I juest reinsalled OS(Windows 2003 standard), Java SDK 5, My-sql, so on..
but the result is sameness.

I guess that the Java compile process is problem.. because the java error is as still..

=======================================================

19 CharCreateOk >>> sk4848
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
at net.sf.l2j.gameserver.model.L2Character.addSkill(L2Character.java:215
5)
at net.sf.l2j.gameserver.model.L2PcInstance.addSkill(L2PcInstance.java:2
532)
at net.sf.l2j.gameserver.clientpackets.CharacterCreate.initNewChar(Chara
cterCreate.java:184)
at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:128)
at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

0e StatusUpdate
0e StatusUpdate
0e StatusUpdate
.
.
.

=========================================================

please help me...

&p.s... however, I thank kardar really.. have a nice day ^^

Hayzari · Jun 19, 2005

how can i make npc's???????????

Crawlerzx · Jun 19, 2005

man88e said:
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@18558d2 [ con
nectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e@1bd
747e [ acquireIncrement -> 3, autoCommitOnClose -> true, connectionTesterClassNa
me -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation ->
null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 60
000, initialPoolSize -> 1, maxIdleTime -> 600000, maxPoolSize -> 5, maxStatement
s -> 100, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManage
rDataSource@18a47e0 [ description -> null, driverClass -> null, factoryClassLoca
tion -> null, jdbcUrl -> jdbc:mysql://localhost/l2jdb, properties -> {user=root,
password=** ] , propertyCycle -> 300, testConnectionOnCheckout -> false ] , fact
oryClassLocation -> null, numHelperThreads -> 3 ]
java.sql.SQLException: Syntax error or access violation message from server: "Un
known database 'l2jdb'"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1997)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1906)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 2520)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:81 7)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1786)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java

what dose this mean i need help i feel i am really close lol I have MSSQL and MYSQL... some times MYSQL dosent work and says "cannot create windows service for MySQL. error: 0" I set the "full_instal.bat" to "C:\Program Files\MySQL\MySQL Server 4.1\bin" i dont know whats wrong... **I just tried it on another computer that didnt have sql on it same problem.. i cant figure this one out...**
Quote:
Installing new content.
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'
ERROR 1049 (42000): Unknown database 'l2jdb'

getting this pm the full_install.bat **Ok I think i know what the problem was the conection name was l2jdb but not the data base i am redoing it now i will tell you how it goes ***OMFG IT WORKED WOOT!** alittle self help right here lol ;-)

I have exatly the same problem, the problem with the Mysql
"cannot create windows service for MySQL. error: 0"
I have too Help me man88e

Toqeer1986 · Jun 20, 2005

You must be registered to see links

i donwloaded this file and it keeps saying ( Either multipart or corrupt ZIP archive) can sum1 help me on this one plz

Hayzari · Jun 20, 2005

- Copy the file jython.jar into your L2J server directory (same folder as startserver.bat, server.cfg etc etc...)
- Edit your startserver.bat as following :

@java -Xmx128m -cp bsf.jar;bsh-2.0.jar;c3p0-0.8.4.5.jar;mysql-connector-java-3.0.16-ga-bin.jar;l2jserver.jar;jython.jar -Dpython.home=XXX -Dpython.path=YYY net.sf.l2j.Server
@pause

PhOeNiX~ · Jun 20, 2005

if i try to start server my dos command gives me theat poop ... can anyonr plz help me ... thnx

Adrien · Jun 20, 2005

1.

bijou said:
- Copy the file jython.jar into your L2J server directory (same folder as startserver.bat, server.cfg etc etc...)
- Edit your startserver.bat as following :

@java -Xmx128m -cp bsf.jar;bsh-2.0.jar;c3p0-0.8.4.5.jar;mysql-connector-java-3.0.16-ga-bin.jar;l2jserver.jar;jython.jar -Dpython.home=XXX -Dpython.path=YYY net.sf.l2j.Server
@pause

but remember that where there is :
XXX=(yourjythondirectory)
YYY=(yourl2jdirectory
example:
if you have jython in c:\jython and l2j in c:\l2j

Code:

@java -Xmx128m -cp bsf.jar;bsh-2.0.jar;c3p0-0.8.4.5.jar;mysql-connector-java-3.0.16-ga-bin.jar;l2jserver.jar;jython.jar -Dpython.home=C:\jython -Dpython.path=C:\l2j
@pause

2.
PhOeNIX~ check this
Installed Java?
Installed mySQL?
Did you do what i have posted now?

Toqeer1986 · Jun 20, 2005

rite well where is the jython.jar i cnt find it

theres a file calld quest jython but dats not a jar file so where can i get the file?

i have a few jar files but i dnt knw whick one to put it unless they have been renamed after u made it

i have found it and will be doing as u sed nw

Adrien · Jun 20, 2005

now i cant find anymore jython link

Hayzari · Jun 20, 2005

You must be registered to see links

:zoo_fox4:

Toqeer1986 · Jun 21, 2005

DB connections busy:1 idle:3
LoginServer: Client terminated the connection. this error keeps comming up what do i do bout this ne1 help lol

PhOeNiX~ · Jun 21, 2005

Adrien said:
1.

but remember that where there is :
XXX=(yourjythondirectory)
YYY=(yourl2jdirectory
example:
if you have jython in c:\jython and l2j in c:\l2j

Code:

@java -Xmx128m -cp bsf.jar;bsh-2.0.jar;c3p0-0.8.4.5.jar;mysql-connector-java-3.0.16-ga-bin.jar;l2jserver.jar;jython.jar -Dpython.home=C:\jython -Dpython.path=C:\l2j @pause

2.
PhOeNIX~ check this
Installed Java?
Installed mySQL?
Did you do what i have posted now?

I hawe done it ... i hawe MySQL and i hawe Sun Java also MS Java but it still gives me error ... what did i do wrong??

Welcome!

[Guide] Complete C3 server setup guide L2J

Initiate Mage

Newbie Spellweaver

Initiate Mage

Skilled Illusionist

Attachments

Skilled Illusionist

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Skilled Illusionist

Elite Diviner

Attachments

Skilled Illusionist

Newbie Spellweaver

Skilled Illusionist

Skilled Illusionist

Newbie Spellweaver

Elite Diviner

RaGEZONE Sponsor

About Us

Forum statistics

Partners