L2Admin work with SQL error. Please look my scrins & help.
L2Admin work with SQL error. Please look my scrins & help.
What screens...? :eh:Originally Posted by kok
Damn dude that link is so* slow that is disconnects the download..
Last edited by Truthseeker; 19-01-05 at 01:05 PM.
super lag ended. =)
basically beside me such here is messages:
SOCKET_CONNECT_ERROR
screenshot 7 How did you get that to work I still get an error.. Also searching logs give me errors and many normal things do to like you have.
oh and ALL
Statistics
gives me errors
kok check pm
for Truthseeker & all: L2Admin Installation Guide
ALL THIS INFORMATION IS AVAILABLE ON THE www.ragezone.com FORUMS. All information was provided by the following people- Staziz, Stinger357 and most of all zelda803 for the translation! This is just a compiled version of their guides that has more detail. If you find any discrepencies in this guide please email L2Extreme-bugreport@gmail.com And Good Luck!
This guide was Created by BoTGoD for the www.ragezone.com Forums.
i use manual from this attach. But i don't change path for CfxTemp in file CfxSrv.ini
Last edited by kok; 19-01-05 at 05:49 PM.
Ill check it out for ya.
log l2atl
[(1)(2192)2005/01/19 16:46:05] Start L2ATL component
[(1)(2192)2005/01/19 16:46:05] DLL_PROCESS_ATTACH
[(1)(2192)2005/01/19 16:46:05] SQLDriverConnect nWorldId(0), nServerType(1), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=L2Admin;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2192)2005/01/19 16:46:05] GetDB SQLDriverConnect, SQLAllocHandle succeeded g_nQueryTimeOut(60), nConn(1), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=L2Admin;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2192)2005/01/19 16:46:15] SQLDriverConnect nWorldId(0), nServerType(3), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2log;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2192)2005/01/19 16:46:15] GetDB SQLDriverConnect, SQLAllocHandle succeeded g_nQueryTimeOut(60), nConn(3), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2log;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2192)2005/01/19 16:52:33] GetDB exception nConn(160005)
[(1)(2204)2005/01/19 16:56:56] SQLDriverConnect nWorldId(0), nServerType(6), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2world;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2204)2005/01/19 16:56:56] GetDB SQLDriverConnect, SQLAllocHandle succeeded g_nQueryTimeOut(60), nConn(6), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2world;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2204)2005/01/19 16:56:56] RunSQL. exec_error(42000)([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'lin_GetBoardList'.)(EXEC lin_GetBoardList 0, 1, 0, 0), m_nId(3), m_nConn(6)
[(1)(2216)2005/01/19 16:57:26] GetDB exception nConn(160005)
[(1)(2200)2005/01/19 16:57:59] GetDB exception nConn(160005)
[(1)(2204)2005/01/19 17:05:03] GetDB exception nConn(160005)
[(1)(2192)2005/01/19 17:05:27] SQLDriverConnect nWorldId(0), nServerType(4), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2world;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2192)2005/01/19 17:05:27] GetDB SQLDriverConnect, SQLAllocHandle succeeded g_nQueryTimeOut(60), nConn(4), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2world;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2212)2005/01/19 17:05:35] CSocketArray::GetSocket error in gethostbyname LIN:2009
[(1)(2212)2005/01/19 17:05:35] CSocketArray::GetSocket CleanUp GetLastError=11001
[(1)(2220)2005/01/19 17:05:45] CSocketArray::GetSocket error in gethostbyname LIN:2009
[(1)(2220)2005/01/19 17:05:45] CSocketArray::GetSocket CleanUp GetLastError=11001
[(1)(2312)2005/01/19 17:05:51] CSocketArray::GetSocket error in gethostbyname LIN:2009
[(1)(2312)2005/01/19 17:05:51] CSocketArray::GetSocket CleanUp GetLastError=11001
[(1)(2192)2005/01/19 17:06:48] SQLDriverConnect nWorldId(0), nServerType(2), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2db;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2192)2005/01/19 17:06:48] GetDB SQLDriverConnect, SQLAllocHandle succeeded g_nQueryTimeOut(60), nConn(2), connStr(DRIVER={SQL Server**;SERVER=LIN;DATABASE=lin2db;NETWORK=dbmssocn;Address=80.41.81.243,1433;UID=sa;PWD=my_pass;)
[(1)(2204)2005/01/19 17:07:02] CSocketArray::GetSocket error in gethostbyname LIN:2009
[(1)(2204)2005/01/19 17:07:02] CSocketArray::GetSocket CleanUp GetLastError=11001
[(1)(2212)2005/01/19 17:07:07] CSocketArray::GetSocket error in gethostbyname LIN:2009
[(1)(2212)2005/01/19 17:07:07] CSocketArray::GetSocket CleanUp GetLastError=11001
[(1)(2216)2005/01/19 17:07:14] CSocketArray::GetSocket error in gethostbyname LIN:2009
[(1)(2216)2005/01/19 17:07:14] CSocketArray::GetSocket CleanUp GetLastError=11001
log l2admin
005-01-19 20:27:26,250 [3400] INFO - SQL Name [LogDBStatus.ListInsertedLogCount] will be used.
2005-01-19 20:27:26,250 [3400] INFO - SQL Name [LogDBStatus.ListInsertedLogCount] will be used.
2005-01-19 20:27:26,312 [3400] ERROR - SQL ERROR
2005-01-19 20:27:26,312 [3400] ERROR - SQL ERROR World[0] DBType[LOG] Page[1] Rows[96] SQL[
SELECT
log_ip, log_year, log_month, log_day, log_hour,
sum ( rowsprocessed)
FROM log_insert (nolock)
WHERE log_year = 2005 and log_month = 1 and log_day = 19
GROUP BY log_ip, log_year, log_month, log_day, log_hour
ORDER BY log_ip, log_year, log_month, log_day, log_hour
]
2005-01-19 20:27:35,703 [3400] INFO - SQL Name [Castle.TaxIncomeList] will be used.
2005-01-19 20:27:35,703 [3400] INFO - SQL Name [Castle.TaxIncomeList] will be used.
2005-01-19 20:27:35,718 [3400] ERROR - SQL ERROR
2005-01-19 20:27:35,718 [3400] ERROR - SQL ERROR World[0] DBType[REPORT] Page[1] Rows[100] SQL[
SELECT castle_id, tax, sum( total_sell), sum(total_tax),
CASE WHEN castle_id=3 THEN sum(total_tax)*0.85
ELSE sum(total_tax)*0.5 END,
CASE WHEN castle_id=3 THEN sum(total_tax)*0.15
ELSE sum(total_tax)*0.5 END
FROM R2005_01_TAXINCOME_1 (nolock)
WHERE log_date BETWEEN 20050118 and 20050118
GROUP BY castle_id, tax
ORDER BY castle_id, tax
]
2005-01-19 20:27:38,593 [3400] INFO - SQL Name [Server.PerformHistoryList] will be used.
2005-01-19 20:27:38,593 [3400] INFO - SQL Name [Server.PerformHistoryList] will be used.
Last edited by kok; 19-01-05 at 06:00 PM.
I think that problem in l2atl
please say that must be here:
"W_0_SVR_LOG"="LIN:3999"
"W_0_SVR_AUTH"="LIN:2044"
"W_0_SVR_CACHE"="LIN:2006"
"W_0_SVR_CACHEINT"="LIN:2009"
"W_0_SVR_MAIN"="LIN:7777"
"W_0_SVR_UPDATE1"="LIN:2009"
"W_0_SVR_UPDATE2"="LIN:2009"
"W_0_SVR_UPDATE3"="LIN:2009"
"W_0_SVR_UPDATE4"="LIN:2009"
pc-name ? localhost ? (local) ? wan ?
pcname should work there
] ERROR - SQL ERROR World[0] DBType[REPORT] Page[1] Rows[100] SQL[
do u have report db configured properly ?
I have installed iis & l2admin & l2atl & chartfx on my local pc (wan1),
server & ms-sql installed on server-pc(wan2, pc-name=LIN).
=============
can you give l2admin.exe for dowloading to me?
thanks !
=================
Thank KoK,
I need l2admin.exe but don't l2admin_guide, can you help me?
thanks again !
Last edited by vnticmuon; 26-01-05 at 10:25 AM.
