Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
  • 0

i need some help with java server i am absoulitle newbie :)

kafroylis

Asked by kafroylis,

 Share

Question

kafroylis Newbie

kafroylis

Posted
Posted

i puss startserverlogin.bat and it write me this

 

Starting L2J Login Server.

 

INFO : loading login config

INFO : MLog clients using log4j logging.

INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; tracestart

: 10]

INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav

a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [num

ThreadsAwaitingCheckoutDefaultUser] ]

WARN : SQL Error: 1045, SQLState: 28000

ERROR : Access denied for user 'root'@'localhost' (using password: NO)

WARN : Could not obtain connection metadata java.sql.SQLException: Access denied

for user 'root'@'localhost' (using password: NO)

       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)

       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)

       at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)

       at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)

       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)

       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

       at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

       at java.lang.reflect.Constructor.newInstance(Unknown Source)

       at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:283)

       at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag

erDataSource.java:119)

       at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:143)

       at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:132)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:696)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:257)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:271)

       at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

       at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.

getConnection(LocalDataSourceConnectionProvider.java:81)

       at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:

84)

       at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009

)

       at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav

a:1292)

       at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession

Factory(LocalSessionFactoryBean.java:804)

       at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi

onFactory(LocalSessionFactoryBean.java:744)

       at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr

opertiesSet(AbstractSessionFactoryBean.java:131)

       at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)

       at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)

       at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:429)

       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:250)

       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:141)

       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:247)

       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:161)

       at org.springframework.beans.factory.support.DefaultListableBeanFactory.

preInstantiateSingletons(DefaultListableBeanFactory.java:270)

       at org.springframework.context.support.AbstractApplicationContext.refres

h(AbstractApplicationContext.java:346)

       at org.springframework.context.support.ClassPathXmlApplicationContext.<i

nit>(ClassPathXmlApplicationContext.java:92)

       at org.springframework.context.support.ClassPathXmlApplicationContext.<i

nit>(ClassPathXmlApplicationContext.java:77)

       at net.sf.l2j.L2Registry.loadRegistry(L2Registry.java:65)

       at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:104)

       at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

 

INFO : Loaded 127 server names

INFO : LoginManager initiating

INFO : Cached 10 KeyPairs for RSA communication

INFO : RandomIntGenerator: initialized

INFO : Stored 20 keys for Blowfish communication

WARN : SQL Error: 1045, SQLState: 28000

ERROR : Access denied for user 'root'@'localhost' (using password: NO)

WARN : SQL Error: 1045, SQLState: 28000

ERROR : Access denied for user 'root'@'localhost' (using password: NO)

Exception in thread "main" org.springframework.transaction.CannotCreateTransacti

onException: Could not open Hibernate Session for transaction; nested exception

is org.hibernate.exception.GenericJDBCException: Cannot open connection

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

       at org.hibernate.exception.SQLStateConverter.handledNonSpecificException

(SQLStateConverter.java:103)

       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:91)

       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:43)

       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:29)

       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager

.java:424)

       at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.

java:144)

       at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)

       at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:

57)

       at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326

)

       at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi

n(HibernateTransactionManager.java:497)

       at org.springframework.transaction.support.AbstractPlatformTransactionMa

nager.getTransaction(AbstractPlatformTransactionManager.java:349)

       at org.springframework.transaction.interceptor.TransactionAspectSupport.

createTransactionIfNecessary(TransactionAspectSupport.java:255)

       at org.springframework.transaction.interceptor.TransactionInterceptor.in

voke(TransactionInterceptor.java:102)

       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

ReflectiveMethodInvocation.java:176)

       at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc

eptor.intercept(Cglib2AopProxy.java:616)

       at net.sf.l2j.loginserver.services.GameserversServices$$EnhancerByCGLIB$

$418817a8.getAllGameservers(<generated>)

       at net.sf.l2j.loginserver.manager.GameServerManager.load(GameServerManag

er.java:208)

       at net.sf.l2j.loginserver.manager.GameServerManager.<init>(GameServerMan

ager.java:111)

       at net.sf.l2j.loginserver.manager.GameServerManager.getInstance(GameServ

erManager.java:82)

       at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:113)

       at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi

ng password: NO)

       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)

       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)

       at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)

       at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)

       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)

       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

       at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

       at java.lang.reflect.Constructor.newInstance(Unknown Source)

       at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:283)

       at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag

erDataSource.java:119)

       at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:143)

       at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:132)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:696)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:257)

       at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:271)

       at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

       at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.

getConnection(LocalDataSourceConnectionProvider.java:81)

       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager

.java:421)

       ... 16 more

 

Server terminated abnormaly

 

 

server terminated

 

Press any key to continue . . .

6 answers to this question

Recommended Posts

  • 0
Hax0r Newbie

Hax0r

Posted
Posted 

Access denied for user 'root'@'localhost' (using password: NO)

You'll have to edit server.properties and loginserver.properties with MySQL's password.

  • 0
extr3me Newbie

extr3me

Posted
Posted 

ERROR : Access denied for user 'root'@'localhost' (using password: NO)

 

Go in config and search or in gameserver.properties or network.properties or server.properties and loginserver.properties and you will find that 

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... www.google.com
Driver = com.mysql.jdbc.Driver
#Driver = org.hsqldb.jdbcDriver
#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
URL = jdbc:mysql://localhost/l2jdb
#URL = jdbc:hsqldb:hsql://localhost/l2jdb
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = 
#Database user info (using root user is not recommended)
Login = root
Password =

 

Put Your Password witch you used on mysql server [sorry for my bad english]

  • 0
Erol Newbie

Erol

Posted
Posted

dont spam !...

 

check your password in your Config

ERROR : Access denied for user 'root'@'localhost' (using password: NO)

 

Go in config and search or in gameserver.properties or network.properties or server.properties and loginserver.properties and you will find that 

# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... www.google.com
Driver = com.mysql.jdbc.Driver
#Driver = org.hsqldb.jdbcDriver
#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
URL = jdbc:mysql://localhost/l2jdb
#URL = jdbc:hsqldb:hsql://localhost/l2jdb
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = 
#Database user info (using root user is not recommended)
Login = root
Password =

 

Put Your Password witch you used on mysql server [sorry for my bad english]

thnx for the help

he didn't fixed it since 2008. GOD.

 

Locked.

Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • AngelD17
      Principiante Creando un server GvE c6 Con lucera2

      By AngelD17 · Posted

      tratando de crear un GvE tengo problemas con el scripts como no se mucho de esto me estoy ayudando con IA pero no puedo salir de este bache      [06:19:43]  WARN Quest GvE_AI not found! [06:19:45]  WARN Quest GvE_AI not found! [06:19:50]  WARN Quest GvE_AI not found! [06:25:51]  WARN Quest GvE_AI not found!
    • Maxtor
      Lineage 2 Top.MaxCheaters.com Changelog updates **

      By Maxtor · Posted

      ## [1.5.5] - 2026-02-02   ### ✨ New Features - **Discord Login**: You can now sign in with your Discord account. Admins enable and configure Discord login in **cpadmin → Users** (Discord auth settings: Client ID, Client Secret, Redirect URI). If you already have an account with the same email (e.g. forum, Google, or legacy), signing in with Discord links to that account so you keep one profile. Discord login is available on Add Server, My Servers, Vote page, and Premium Ads booking. - **Setup Links**: In **cpadmin → Users**, both Google and Discord login settings now include direct links to their official developer portals (Google Cloud Console and Discord Developer Portal) for easier OAuth app setup.   ### 🔒 Security - **Email Required for Registration**: New user registration via OAuth (Forum, Google, Discord) now requires a valid email address. If the OAuth provider doesn't provide an email (e.g. unverified Discord email), registration is rejected with a clear message. This prevents anonymous accounts and ensures all users can receive important notifications.   ### 🔄 Improvements - **User Auth Badges**: In **cpadmin → Users**, the Registered Members table now shows auth method badges: **Forum**, **Google**, **Discord**, or **Legacy**. Users can have multiple badges if they've linked multiple login methods. - **Server Info Labels**: Translated server info labels (Owner Name, Language, Server Location) are now properly localized in all 5 languages (English, Spanish, Portuguese, Greek, Russian).   ---   ## [1.5.4] - 2026-02-01   ### ✨ New Features - **Google Login**: You can now sign in with your Google account. Admins enable and configure Google login in **cpadmin → Users** (Google auth settings: Client ID, Client Secret, Redirect URI). If you already have an account with the same email (e.g. forum or legacy), signing in with Google links to that account so you keep one profile. The login menu (navbar and login prompts) offers **Login with Forum Account**, **Login with Google** (when enabled), and **Create Forum Account**. Google login is available on Add Server, My Servers, Profile Settings, Vote page, and Premium Ads booking. - **Ban/Unban Members**: In **cpadmin → Users**, admins can ban or unban registered members. Banned users see a full-page message: "Sorry, you are banned from using this site." When a user is banned, all their servers are set to inactive. - **Moderator Activity Log**: **cpadmin → Moderators** now records when a moderator or admin enters the CPAdmin panel (e.g. "Moderator X entered CPAdmin panel at &lt;time&gt;") and when they change any cpadmin settings (only write actions are logged; read-only use is not). - **Clear Moderator Logs**: Admins can clear all moderator activity log entries via a **Clear logs** button with confirmation. Logs are shown at 100 per page with pagination. - **Filter by Moderator**: In the Moderator Activity Log, a **Filter by moderator** dropdown lets you view activity for a specific moderator or "All moderators." - **cpadmin → Users Tab**: New **Users** tab in the admin panel with Registered Members list (paginated), Google auth settings card, and per-user Ban/Unban and server links.   ### 🔄 Improvements - **cpadmin → Servers**: Each server name in the servers table is now clickable and opens that server’s info page. - **cpadmin → Users – Servers column**: The servers count/list is clickable and opens a small modal listing that user’s servers; each server name in the modal links to the server info page. - **cpadmin → Users – Search**: A search bar above the Registered Members table lets you search by **username**, **email**, or **server name**. Results are filtered on the server (paginated); clearing the search resets the list. - **Moderator Activity Log**: Pagination shows "Showing X–Y of Z" and "Page N of M" with Previous/Next when there are more than 100 entries. - **Login UI**: Login options (Forum, Google, Create account) are shown in a consistent dropdown and in modals (Add Server, My Servers, Vote, Premium Ads) for a clearer sign-in experience. - **Vote Page – Unauthenticated**: When you must log in to vote, the page now shows "Vote for [Server Name]" as the main heading and presents login options in a compact section.   ---   ## [1.5.3] - 2026-01-30   ### ✨ New Features - **File Logs in Admin Panel**: Admins can now view CodeIgniter PHP logs (api/writable/logs) directly in **cpadmin → Logs**. Select a date to view the log file, refresh to reload, or delete all log files to free up space.   ### 🔄 Improvements - **Cache System**: Full cache audit and improvements — when you clear cache in cpadmin, both backend and frontend caches are cleared. Server listings, My Servers, pricing, ad config, and chronicles all refresh with fresh data. New paid servers now appear in listings and My Servers immediately. - **Admin Panel – Server Rates**: Server rates in the admin servers table now display in compact format (e.g. x10000 → x10k, x100000 → x100k, x1000000 → x1m) for easier scanning. Hover to see the full value.
    • VPSLab
      — VPSLAB — Fast & Private RDP/VPS | 100% Instant Setup

      By VPSLab · Posted

      Active & Taking Orders!
    • Lineageadvertise
      WTB High Five source running on Salvation/Fafurion client

      By Lineageadvertise · Posted

      WTB High Five source running on Salvation/Fafurion client
    • MoMoProxy
      MoMoProxy - 80M+ New Clean Rotating Residential Proxies!

      By MoMoProxy · Posted

      MoMoProxy has updated more static residential proxies for USA location, anyone interested in can view: https://momoproxy.com/static-residential-proxies

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..