Re: pwAdmin (iWeb) Final Release
Quote:
Originally Posted by
Romulan
Bash has tried something on this... But without any results also...
And for the gamedbd, yeah it would be cool to write a java program to replace this damn gamedbd and use mysql instead of oracle berkeley...
I think I'll make a "proxy" daemon that just takes all requests to it, logs them, then forwards it to the actual gamedbd and works both ways so I can get a better understanding of how it works then try and work on a replacement that just goes directly to mysql which would be godly... and a step into finally getting a reverse engineering project for the server off the ground instead of PW-Emu and its bullshit...
Edit: On second thought... it might be easier to just install Xfce or something and get wireshark and just monitor the local loop (only have gamedbd running on it and all other daemons bound to the lan ip instead) and then just dig through that...
Re: pwAdmin (iWeb) Final Release
Quote:
Originally Posted by
das7002
I think I'll make a "proxy" daemon that just takes all requests to it, logs them, then forwards it to the actual gamedbd and works both ways so I can get a better understanding of how it works then try and work on a replacement that just goes directly to mysql which would be godly... and a step into finally getting a reverse engineering project for the server off the ground instead of PW-Emu and its bullshit...
Edit: On second thought... it might be easier to just install Xfce or something and get wireshark and just monitor the local loop (only have gamedbd running on it and all other daemons bound to the lan ip instead) and then just dig through that...
It's looks like a good idea...
Makes a hybrid server using some Java program coded by our own with the others PW binaries executables server...
Especialy for GameDB in a first time...
Re: pwAdmin (iWeb) Final Release
Quote:
Originally Posted by
giovanoty
Friends, here I show the problem I have, not that I'm failing, if I can help thank you.
Will say that I am very tiring but well we are learning a lot from all of you xD. :P:
Friends, good night, if anyone can help me know if I'm wrong in something like the picture shows I am very grateful. Please thank you very much.
---------- Post added at 09:05 PM ---------- Previous post was at 08:57 PM ----------
Back and mount the image, sorry xD, is this pursuit I have reviewed but can not find the problem, thank you. :thumbup:
Re: pwAdmin (iWeb) Final Release
das already answered on the previous page.
Basically you are trying to run "./jetty start" from the wrong directory. What you are trying to run is a script called "jetty" with the start parameter. This script is located in the jetty folder you download not root.
so you need to cd (change directory) to where jetty is on your server before trying to execute it.
Code:
cd /PWServer/jetty-7.1.6/
./jetty start
1 Attachment(s)
Re: pwAdmin (iWeb) Final Release
Sorry again, what a pity to disturb so much but we are learning, well now this is the error and I edit the jetty, unregister_service.sh register_service.sh and also change the permission. Pwadminconf.jsp and. Pwconf.conf to 0644 .
What else could be wrong? :?:
Thanks
Re: pwAdmin (iWeb) Final Release
Quote:
Originally Posted by
giovanoty
Sorry again, what a pity to disturb so much but we are learning, well now this is the error and I edit the jetty, unregister_service.sh register_service.sh and also change the permission. Pwadminconf.jsp and. Pwconf.conf to 0644 .
What else could be wrong? :?:
Thanks
chmod +x jetty
Re: pwAdmin (iWeb) Final Release
Quote:
Originally Posted by
das7002
chmod +x jetty
das Sorry, I did not understand, how can I chmod + x jetty
Re: pwAdmin (iWeb) Final Release
...no space between the + and the x (+x)
Re: pwAdmin (iWeb) Final Release
I could use some help here =p
I updated my pwadmin to this newest version and its working and all but when i go to the tab charecters i just get a blank page well it displays the header and the menu tabs but underneath that its just white anyone else haveing this problem? and does anyone know how to fix this?
---------- Post added at 11:47 AM ---------- Previous post was at 11:31 AM ----------
I tried using version 1.5 instead of 1.6 and it helped sort of cause the page isn`t blank anymore but it doesn`t load the charecters and when i click on a template it says loading charecter data failed...
http://i858.photobucket.com/albums/a...ket/afcasf.png
so anyone know how to fix this?
(and no its not because of my server isn`t running cause i can login to the game and stuff like that)
Re: pwAdmin (iWeb) Final Release
v1.5+ > look at addons -> import ...
http://pwadmin.codeplex.com/releases/view/41999
Release Notes v1.6
Quote:
# character list will now be read from mysql database (table: roles) to save dedicated system resources (especially for large character lists)
# added plugin for character list sql import
Re: pwAdmin (iWeb) Final Release
k i found the plugin but now i need to create a table calld roles but how? how many rows?
http://i858.photobucket.com/albums/a...t/asgfthgt.png
and what should i fil in here?
http://i858.photobucket.com/albums/a...et/htyjuty.png
Re: pwAdmin (iWeb) Final Release
Quote:
Originally Posted by
michel100
k i found the plugin but now i need to create a table calld roles but how? how many rows?
A whole bunch of nothing...
pwAdmin automatically makes that table as long as it has the proper permissions with the MySQL user to do so... (which it should just fine...)
Re: pwAdmin (iWeb) Final Release
nope i get a big error:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Table 'dbo.roles' doesn't exist
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
javax.servlet.ServletException: Table 'dbo.roles' doesn't exist
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.addons.Role_0020SQL_0020Import.index_jsp._jspService(index_jsp.java:293)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dbo.roles' doesn't exist
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782)
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625)
org.apache.jsp.addons.Role_0020SQL_0020Import.index_jsp._jspService(index_jsp.java:206)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.28
Re: pwAdmin (iWeb) Final Release
i hope its helpful ... [ @ you own risk ... ]
PHP Code:
DROP TABLE IF EXISTS `roles`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `roles` (
`roleid` int(11) NOT NULL,
`accountid` int(11) NOT NULL,
`name` varchar(32) NOT NULL,
`level` smallint(6) NOT NULL,
`race` tinyint(4) NOT NULL,
`occupation` tinyint(4) NOT NULL,
`gender` tinyint(4) NOT NULL,
`spouse` varchar(32) NOT NULL,
`pvp1` int(11) NOT NULL,
`pvp2` int(11) NOT NULL,
`pvp3` int(11) NOT NULL,
`pvp4` int(11) NOT NULL,
`factionid` int(11) NOT NULL,
`factionname` varchar(32) NOT NULL,
`placeholder1` int(11) NOT NULL,
`placeholder2` int(11) NOT NULL,
`placeholder3` int(11) NOT NULL,
`placeholder4` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
Re: pwAdmin (iWeb) Final Release
when i run the SQL import it now says: Roles Imported to MySQL But when i go to charecter list stil noiting did i forget something?
