Server + Client @ 1.4.2 & Guide

I can not log in as root pwAdmin What can I do? :/:

PHP Code:

---

<%@page import="java.io.*"%>

<%
    // pwadmin access password as md5 encrypted string
    // default password is root -> 63a9f0ea7bb98050796b649e85481845
    String iweb_password = "63a9f0ea7bb98050796b649e85481845";

    // connection settings to the mysql pw database
    String db_host = "localhost";
    String db_port = "3306";
    String db_user = "root";
    String db_password = "marcelo";
    String db_database = "pw";



//----------------------------- END SETTINGS 


---

String iweb_password is failed -> passwd: marcelo > String iweb_password in md5 > 995bf053c4694e1e353cfd42b94e4447

I tried that. I Can create account by pwAdmin But Can not login: (
as ussar phpmyadmin to see the db?

mine was different from marcelo

i can login to pwAdmin but mysql database can connect when i try to register ID, i already import dbase from /PWServer/.setup/pwdb.sql

Spoiler:

http://img838.imageshack.us/img838/1281/15410381.jpg

Uploaded with ImageShack.us

here configuration at .pwadminconf.jsp

Spoiler:

<%@page import="java.io.*"%>

<%
//-------------------------------------------------------------------------------------------------------------------------
//------------------------------- SETTINGS --------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------

// pwadmin access password as md5 encrypted string
// default password is root -> 63a9f0ea7bb98050796b649e85481845
String iweb_password = "63a9f0ea7bb98050796b649e85481845";

// connection settings to the mysql pw database
String db_host = "localhost";
String db_port = "3306";
String db_user = "root";
String db_password = "root";
String db_database = "pw";

// Type of your items database required for mapping id's to names
// Options are my or pwi
String item_labels = "pwi";

// Absolute path to your PW-Server main directory (startscript, stopscript, /gamed)
// requires a tailing slash
String pw_server_path = "/PWServer/";

// If you have hundreds of characters or heavy web acces through this site
// It is recommend to turn the realtime character list feature off (false)
// to prevent server from overload injected by character list generation
boolean enable_character_list = true;

String pw_server_name = "Your PW Servername";
String pw_server_description = "+ Your server description here<br>+ 2 x 2.4 GHz, 2048 MB RAM, 100 MBit LAN<br>+ all dungeons open<br>+ tideborn nirvana weapons<br>+ World bosses";

//-------------------------------------------------------------------------------------------------------------------------
//----------------------------- END SETTINGS ------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------

String pw_server_exp = "?";
String pw_server_sp = "?";
String pw_server_drop = "?";
String pw_server_coins = "?";

BufferedReader bfr = new BufferedReader(new FileReader(pw_server_path + "gamed/ptemplate.conf"));

String row;
while((row = bfr.readLine()) != null)
{
row = row.replaceAll("\\s", "");
if(row.indexOf("exp_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_exp = row.substring(10, pos);
}
if(row.indexOf("sp_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_sp = row.substring(9, pos);
}
if(row.indexOf("drop_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_drop = row.substring(11, pos);
}
if(row.indexOf("money_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_coins = row.substring(12, pos);
}
}

bfr.close();

if(request.getSession().getAttribute("items") == null)
{
String[] items = new String[30001];

try
{
bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/default.dat")), "UTF8"));
if(item_labels.compareTo("my") == 0)
{
bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/my.dat")), "UTF8"));
}
if(item_labels.compareTo("pwi") == 0)
{
bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/pwi.dat")), "UTF8"));
}
int count = 0;
while((row = bfr.readLine()) != null && count < 30001)
{
items[count] = row;
count++;
}
bfr.close();
}
catch(Exception e)
{
}

request.getSession().setAttribute("items", items);
}
%>

.pwconf.conf

Spoiler:

[GameDBClient]
type = tcp
port = 29400
address = 127.0.0.1
so_sndbuf = 65536
so_rcvbuf = 65536
ibuffermax = 1048576
obuffermax = 1048576
so_broadcast = 1
udp_nodelay = 1

[DeliveryClient]
type = tcp
port = 29100
address = 127.0.0.1
so_sndbuf = 65536
so_rcvbuf = 65536
ibuffermax = 1048576
obuffermax = 1048576
so_broadcast = 1
udp_nodelay = 1

[FactionClient]
type = tcp
port = 29500
address = 127.0.0.1
so_sndbuf = 65536
so_rcvbuf = 65536
ibuffermax = 1048576
obuffermax = 1048576
so_broadcast = 1
udp_nodelay = 1

[UniqueNameClient]
type = tcp
port = 29401
address = 127.0.0.1
so_sndbuf = 65536
so_rcvbuf = 65536
ibuffermax = 1048576
obuffermax = 1048576
;so_broadcast = 1
tcp_nodelay = 0
accumulate = 268435456
isec = 2
iseckey = baxiyEwt4fuqrysyoylfy7Fxbmhobo
osec = 2
oseckey = baxitf91jvrQarnjwbyvlcdxqdvuqp

[ThreadPool]
config = (1,2)

FIX it, just my bad, i should not import dbsae sql from adminer @_@

Navicat don't corrupts the accounts passwords when importing from a mysql dump to the database...

Adminer and Phpmyadmin corrupts the passwords...

Link for Navicat: http://www.navicat.com/en/download/download.html

And you can choose the free version...

need help please...
I've downloaded PWServer.tar.bz2 4 times and always failed...
http://img35.imageshack.us/img35/163/erroral.jpg

Quote:

---

Originally Posted by Romulan

Navicat don't corrupts the accounts passwords when importing from a mysql dump to the database...

Adminer and Phpmyadmin corrupts the passwords...

Link for Navicat: Navicat - Download Center - Download the World's Best Oracle Manager, MySQL Front End, SQLite GUI, MariaDB Frontend & PostgreSQL GUI for Windows, Mac OS X & Linux - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administra

And you can choose the free version...

---

I've never had an issue with phpMyAdmin corrupting anything when it exports or imports o.o

Old versions maybe... but new ones never

I only use Navicat for my php apps that use sqlite, since well... there is no good php management app for sqlite 2

Quote:

---

Originally Posted by technology05

need help please...
I've downloaded PWServer.tar.bz2 4 times and always failed...
http://img35.imageshack.us/img35/163/erroral.jpg

---

you was downloading while i've uploaded new server files, now they are online...

Quote:

---

Originally Posted by Romulan

Navicat don't corrupts the accounts passwords when importing from a mysql dump to the database...

Adminer and Phpmyadmin corrupts the passwords...

Link for Navicat: Navicat - Download Center - Download the World's Best Oracle Manager, MySQL Front End, SQLite GUI, MariaDB Frontend & PostgreSQL GUI for Windows, Mac OS X & Linux - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administra

And you can choose the free version...

---

Quote:

---

Originally Posted by das7002

I've never had an issue with phpMyAdmin corrupting anything when it exports or imports o.o

Old versions maybe... but new ones never

I only use Navicat for my php apps that use sqlite, since well... there is no good php management app for sqlite 2

---

thx guys, everything is ok now, i just forget to use the command: COMMAND~: mysql -u root -pPASSWORD -h localhost pw < /PWServer/.setup/pwdb.sql and, like what romulan says, importing dump sql from adminer was buging.

iam testing this guide with ubuntu, and i thing it fully working with ubuntu, good work ronny :thumbup:

Quote:

---

Originally Posted by hrace009

thx guys, everything is ok now, i just forget to use the command: COMMAND~: mysql -u root -pPASSWORD -h localhost pw < /PWServer/.setup/pwdb.sql and, like what romulan says, importing dump sql from adminer was buging.

iam testing this guide with ubuntu, and i thing it fully working with ubuntu, good work ronny :thumbup:

---

Also, like I said earlier, dont forget that /emul/ia32-linux/usr/lib in his guide is just /lib32 on ubuntu, and /lib64 is a symbolic link to /lib for 64 bit

stuck here...

Spoiler:

http://d.imagehost.org/0613/error1.jpg

Quote:

---

At the top of the page is a link to pwAdmin and adminer. pwAdmin is the pw-server web administration interface, adminer is a php based mysql administration interface.
Click pwAdmin

---

where is the link??

Spoiler:

http://d.imagehost.org/0723/error2.jpghttp://b.imagehost.org/0408/error3.jpg

what should i do with this???

I've edited "/etc/tomcat6/tomcat-users.xml" but, after i entered the ID and pass it still prompt me for ID and pass..

Quote:

---

Originally Posted by technology05

stuck here...

Spoiler:

http://d.imagehost.org/0613/error1.jpg

where is the link??

Spoiler:

http://d.imagehost.org/0723/error2.jpghttp://b.imagehost.org/0408/error3.jpg

what should i do with this???

I've edited "/etc/tomcat6/tomcat-users.xml" but, after i entered the ID and pass it still prompt me for ID and pass..

---

you didn't follow the guide exactly (debian net-install without any package), you have another web application server running (tomcat 6) and there is a conflict with the web application server delivered with the server files (jetty 7) because both listen to port 8080...

Can I have your old post of this Server ronny? U've updated and remove the MD5 password guide. Can I have that included?

Because, I tried this new guides without setting the MD5, the generated code of my password, the server cant get to connect to MySQL database causing cannot login in the game. I can see that on my pwAdmin on the accounts tab "Connection to MySQL Database Failed" and on the server configuration tab it says "Users: 0 / -1"

Or is there any other way to solve that? :/:

oh..
sorry, i didn't notice that...
i've removed tomcat6 and showed pwAdmin...
I'm really sorry for posting useless post because of my mistake... X(

---------- Post added at 11:36 AM ---------- Previous post was at 10:39 AM ----------

sorry...
I have another problem...
4 services won't work...
hot to solve it??
I have checked it here, http://forum.ragezone.com/f452/vbox-...ml#post5625760

but no answer replied to that post..
so i'll try to ask at this thread...
here's my SS..

Spoiler:

http://img140.imageshack.us/img140/1764/errorvn.jpg

i got item with id 28641 Generals Summer's Token

what is this for? :blushing:

it says : "A token signed with General Summer's blood. You can use it to command the soldiers of Archosaur.
Given by General Summer.
If you have enough Medals of Glory, you can use it to exchange for Rank IX gears from the Commander-in-chief"" then i go to commander-in-chieft, no quest for it 0.0
------------------------------------------------------------------
BTW i added some NPC to your NPCGEN.DATA (Mobs for WB and Celestial Messanger and other's)