Perfect World 1.5.1 Server Setup SIMPLIFIED

[mobus1]

i Edit gshop with the gshop edit i add items etc i assure that no one is 0 on price , then i export twice for ghop and gshop1 then export server gshopsev and gshopsev1 but it says always out of phase any help please i'm tired of looking since 3 days now

i Edit gshop with the gshop edit i add items etc i assure that no one is 0 on price , then i export twice for ghop and gshop1 then export server gshopsev and gshopsev1 but it says always out of phase any help please i'm tired of looking since 3 days now

ok fixed finally , Now last question the character page is empty i verified the conf files logins are fine so ... and if user appears can't modify anything its loaded forever ... any clue

 

[nhhoang]

i spend 3 day for install , readding and dowload but not success . so i hope someone can help me .
my server ubuntu 15 x 64 bit
- on steps of thread i can't sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf ( mabe the phpmyadmin.conf is change path in ubuntu 15 x64 ) it is one of my fail .

 

[Swoosh91]

Yeah, step one would be to not use phpmyadmin. I thought that was obvious by now.

 

[daddy]

Hi there,
everything works for me
the only question i have its do i have to start all maps when i start the server?
which maps are necessary to be started? right now i just have gs01 and is62, but i cannot go to any of the instances like fb19 or deception or any cave
thanks

 

[qweadmin]

error creat account

[B][COLOR=#ee0000][B]Connection to MySQL Database Failed

[/B][/COLOR][/B]
Class.forName("com.[COLOR=#000080]mysql.jdbc[/COLOR].Driver").newInstance();
                                Connection connection = DriverManager.getConnection("[COLOR=#0000cd]jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password[/COLOR]);
                                Statement statement = connection.createStatement();
                                ResultSet rs = statement.executeQuery("SELECT ID, passwd, email FROM users WHERE name='" + login + "'");
                                String email_stored = "";
                                String password_stored = "";
                                String id_stored = "";
                                int count = 0;
                                while(rs.next())
                                {
                                    email_stored = rs.getString("email");
                                    id_stored = rs.getString("ID");
                                    password_stored = rs.getString("passwd");
                                    count++;
                                }
file .pwadmin.conf
    // 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 = "[COLOR=#0000cd]localhost[/COLOR]";
    String db_port = "[COLOR=#0000cd]3306[/COLOR]";
    String db_user = "[COLOR=#0000cd]root[/COLOR]";
    String db_password = "[COLOR=#0000cd]root[/COLOR]";
    String db_database = "[COLOR=#0000cd]pw[/COLOR]";

    // 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 = "/home/";

    // 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 = "Perfect World";
    String pw_server_description = "Fixed by DaMadBoy, 151 iweb from Bola, Merged by Sora1984";

i have just changed user phpmyadmin
user pw
pass qwe

user sql pw
user sql pass qwe
change pass in pwadmin config user pw, database pw, pass qwe
change table.xml user pw pass qwe

now localhost/pwAdmin can not show login frame become unavailable to log in

 

[Bruikoga]

How do I set up a server to instant spiritual cultivation?

 

[Ben]

How do I set up a server to instant spiritual cultivation?

Edit the starter template in pwAdmin or make a quest that will hand out the cultivation level.

 

[Bruikoga]

Edit the starter template in pwAdmin or make a quest that will hand out the cultivation level.

please teach me step by step ...

 

[qweadmin]

install ubuntu 15.10 server
ip static
/etc/hosts file

127.0.0.1 localhost
127.0.1.1 pwserver

# The following lines are desirable for IPv6 capable hosts
::1 localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
192.168.40.200 localhost.localdomain
192.168.40.200 gmserver.localdomain link1 link2 game1 game2 game3 game4 delivery database backup audb aumanager auth manager
127.0.0.1 gmserver.localdomain link1 link2 game1 game2 game3 game4 delivery database backup audb aumanager auth manager
127.0.1.1 gmserver.localdomain link1 link2 game1 game2 game3 game4 delivery database backup audb aumanager auth manager

file
/etc/network/interfaces

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

source /etc/network/interfaces.d/*

# The loopback network interface
auto lo eno16777728
iface lo inet loopback

# The primary network interface
iface eno16777728 inet static
address 192.168.40.200
netmask 255.255.255.0
broadcast 192.168.40.255
network 192.168.40.0
gateway 192.168.40.2
dns-nameservers 192.168.40.0 8.8.8.8 8.8.4.4

iface eno16777728 inet6 manual
pre-up /sbin/modprobe -q ipv6 ; /bin/true
--------------------------

sudo apt-get update
sudo apt-get install apache2
ip addr show eth0 | grep inet | awk '{ print $2; }' | sed 's/\/.*$//'
curl

You must be registered to see links

sudo apt-get install mysql-server php5-mysql
sudo mysql_install_db 'errot timestamp so'
sudo mysql_install_db --explicit_defaults_for_timestamp
sudo mysql_secure_installation

sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt
'edit file '
sudo nano /etc/apache2/mods-enabled/dir.conf
<IfModule mod_dir.c>
DirectoryIndex index.php index.html index.cgi index.pl index.xhtml index.htm
</IfModule>

sudo service apache2 restart

apt-cache search php5-

apt-cache show package_name

sudo apt-get install php5-cli

sudo nano /var/www/html/info.php

<?php
phpinfo();
?>

You must be registered to see links

sudo apt-get install php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt

sudo apt-get install php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl
service apache2 restart

sudo apt-get install php5-xcache
service apache2 restart

apt-get install openjdk-6-jre

apt-get install phpmyadmin
Web server to reconfigure automatically: <-- apache2

Configure database for phpmyadmin with dbconfig-common? <-- No

add user 'use table host' pass qwe132 grant all priveledge
import


sudo apt-get install tomcat7-docs tomcat7-admin tomcat7-examples
sudo apt-get install default-jdk
sudo apt-get install ant git
sudo nano /etc/tomcat7/tomcat-users.xml

<tomcat-users>
<role rolename="manager-gui"/>
<role rolename="admin-gui"/>
<user username="php" password="qwe132" roles="manager-gui,admin-gui"/>
</tomcat-users>
sudo service tomcat7 restart

import sql pw database with php username pass qwe132

file pwadminconf.jsp
// pwadmin access password as md5 encrypted string
// default password is root -> 63a9f0ea7bb98050796b649e85481845
String iweb_password = "4af98ff496f55e3b7d31e5566b6f0483";

// connection settings to the mysql pw database
String db_host = "192.168.40.200";
String db_port = "3306";
String db_user = "php";
String db_password = "qwe132";
String db_database = "pw";



but still error

BROWSE ACCOUNTS
ID	Name	Creation Time
Connection to MySQL Database Failed

CAN YOU HELP ME FIGURE OUT WHY???????????????

 

[Bruikoga]

how to start map hell/heaven?

 

[qweadmin]

After
sudo apt-get install libmysql-java
in /etc/environment
export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java-5.1.32.jar

edit /etc/mysql/java/conf.d/mysqld.cnf
bind-address = 192.168.40.200
i imported successfully roles and "browe account" section not error Connection to MySQL Database Failed
but i still can not creat account due to failed in section "account registration"
Connection to MySQL Database Failed


ican not creat account

 

[qweadmin]

so i try insert sql code copy from account page
call adduser('" + login + "', " + password + ", '0', '0', '0', '0', '" + mail + "', '0', '0', '0', '0', '0', '0', '0', '', '', " + password + ")
to
call adduser('qwert', "qwert", '0', '0', '0', '0', 'mail', '0', '0', '0', '0', '0', '0', '0', '', '', "qwert")
so it add to sql
and i can add gm and cubi from pwadmin pages


so what wrong with account page code????
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="java.security.*"%>
<%@include file="WEB-INF/.pwadminconf.jsp"%>

<%!
String pw_encode(String salt, MessageDigest alg)
{
alg.reset();
alg.update(salt.getBytes());
byte[] digest = alg.digest();
StringBuffer hashedpasswd = new StringBuffer();
String hx;
for(int i=0; i<digest.length; i++)
{
hx = Integer.toHexString(0xFF & digest);
//0x03 is equal to 0x3, but we need 0x03 for our md5sum
if(hx.length() == 1)
{
hx = "0" + hx;
}
hashedpasswd.append(hx);
}
salt = "0x" + hashedpasswd.toString();

return salt;
}
%>

<%
boolean allowed = false;

if(request.getSession().getAttribute("ssid") == null)
{
out.println("<p align="right"><font color="#ee0000"><b>Login for Account administration...</b></font></p>");
}
else
{
allowed = true;
}

String message = "<br>";
if(request.getParameter("action") != null)
{
String action = new String(request.getParameter("action"));

if(action.compareTo("adduser") == 0)
{
String getlogin = request.getParameter("getlogin");
String login = getlogin.toLowerCase();
String getmail = request.getParameter("getmail");
String mail = getmail.toLowerCase();
String password = request.getParameter("password");

if(login.length() > 0 && password.length() > 0)
{
if(login.length() < 4 || login.length() > 10 || password.length() < 4 || password.length() > 10)
{
message = "<font color="ee0000">Only 4-10 Characters</font>";
}
else
{
String alphabet = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-_";
boolean check = true;
char c;
for(int i=0; i<login.length(); i++)
{
c = login.charAt(i);
if (alphabet.indexOf(c) == -1)
{
check = false;
break;
}
}
for(int i=0; i<password.length(); i++)
{
c = password.charAt(i);
if (alphabet.indexOf(c) == -1)
{
check = false;
break;
}
}

if(!check)
{
message = "<font color="ee0000">Forbidden Characters</font>";
}
else
{
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM users WHERE name='" + login + "'");
int count = 0;

while (rs.next())
{
count++;
}
if(count > 0)
{
message = "<font color="ee0000">User Already Exists</font>";
}
else
{
password = pw_encode(login + password, MessageDigest.getInstance("MD5"));
rs = statement.executeQuery("call adduser('" + login + "', " + password + ", '0', '0', '0', '0', '" + mail + "', '0', '0', '0', '0', '0', '0', '0', '', '', " + password + ")");
message = "<font color="00cc00">Account Created</font>";
}

rs.close();
statement.close();
connection.close();
}
catch(Exception e)
{
message = "<font color="#ee0000"><b>Connection to MySQL Database Failed</b></font>";
}
}
}
}
}

 

[Bruikoga]

I edit the template pwAdmin with 16, but the max user id 8 job while PW 151 10 job , how to get 10 job ?

 

[qweadmin]

###########so i assumed host computer win 7
and you run virtual machine in software vmware12(vmware 11 have error creat mount folder in ubuntu 15.10, so recommended vmware12)
follow intructions here till you can see your webmin page on host computer win7
you may be up date it by choose download ubuntu 15.10server.iso

You must be registered to see links

open webmin page

You must be registered to see links

edit file
sudo nano etc/webmin/miniserv.conf
find ssl=1 change to ssl=0
this to avoid error when open webmin

Error - Document follows

This web server is running in SSL mode. Try the URL

You must be registered to see links

instead.

reboot

##########make ip static
before choose one ip address, you need choose one from vmware or vitualbox with right address configuration
with vmware12 i choose NAT configure and address 192.168.40.xxx
please google for this step informations

because low download or may be avoid mistakes for shorter pratice time if failed
i recommended you copy file to your server after download to host computer win7
you need extract all PWserverfile151.tar.gz
edit wit notepad++ programe or some good edit software
change all address you foung in file .conf to ip address of server
some adress 127.0.0.1 or localhost or similar 0.0.0.0 to your choiced ip address
#####################
chosse one user and pass
this is user and pass you use in file ./pwadminconf.jsp and curl-reg.php, and registration.php, phpmyadmin
so choose and write down this user and pass.
you need read link below first
you need read link below first
http://forum.ragezone.com/f754/perfect-world-1-5-1-a-1045161/
#######################
use winrar make zip file type of pw server files
###################
**********you need remove ssl-cert-snakeoil file if you do not want make error keys of your server
edit host file to suitable configure with webmin page
this is my host file

127.0.0.1 localhost
127.0.1.1 pwserver

# The following lines are desirable for IPv6 capable hosts
::1 localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
192.168.40.200 localhost.localdomain
192.168.40.200 gmserver.localdomain link1 link2 game1 game2 game3 game4 delivery database backup audb aumanager auth manager
127.0.0.1 gmserver.localdomain link1 link2 game1 game2 game3 game4 delivery database backup audb aumanager auth manager
127.0.1.1 gmserver.localdomain link1 link2 game1 game2 game3 game4 delivery database backup audb aumanager auth manager
and file in webmin page edit

/etc/network/interfaces

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

source /etc/network/interfaces.d/*

# The loopback network interface
auto lo eno16777728
iface lo inet loopback

# The primary network interface
iface eno16777728 inet static
address 192.168.40.200
netmask 255.255.255.0
broadcast 192.168.40.255
network 192.168.40.0
gateway 192.168.40.2
dns-nameservers 192.168.40.0 8.8.8.8 8.8.4.4

iface eno16777728 inet6 manual
pre-up /sbin/modprobe -q ipv6 ; /bin/true

and reboot

#########################
check sure host fil and ip correct with
ifconfig -a

sudo adduser your choice
this is user and pass you use in file ./pwadminconf.jsp and curl-reg.php, and registration.php, phpmyadmin
so choose and write down this user and pass.
you need read link below first
http://forum.ragezone.com/f754/perfect-world-1-5-1-a-1045161/
and refence ubuntu link about add user and root access

You must be registered to see links

continued
install server perfectworld. you need snapshot or clone your virtual machine after 10 or 15 steps for practice or restore if mistakes

sudo apt-get update
sudo apt-get install apache2
ip addr show eth0 | grep inet | awk '{ print $2; }' | sed 's/\/.*$//'
you may replace eth0 with your ethernet connect(found with command sudo ifconfig -a)
curl

You must be registered to see links

show your puplic address ip if you care connect out side LAN network
sudo apt-get install mysql-server php5-mysql
choose pass (you need pass you have choosen before)
sudo mysql_install_db
if it pop out 'errot timestamp so'
sudo mysql_install_db --explicit_defaults_for_timestamp
i am not sure about this because i am a newbie for linux, you need google to find what is this
sudo mysql_secure_installation
have pass
choose no when required change pass
choose default for all below questions
sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt
"edit file change phrase index.php to first "

sudo nano /etc/apache2/mods-available/dir.conf
<IfModule mod_dir.c>
DirectoryIndex index.php index.html index.cgi index.pl index.xhtml index.htm
</IfModule>

sudo service apache2 restart

apt-cache search php5-

apt-cache show package_name

sudo apt-get install php5-cli
create file info.php to test php
sudo nano /var/www/html/info.php

<?php
phpinfo();
?>

You must be registered to see links

and i think you should install all things
sudo apt-get install php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap
###################

sudo apt-get install php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl
service apache2 restart

sudo apt-get install php5-xcache
service apache2 restart
######################

sudo apt-get install phpmyadmin
Web server to reconfigure automatically: <-- apache2

Configure database for phpmyadmin with dbconfig-common? <-- No
open page of phpmyadmin

You must be registered to see links

your ip)
add user 'use table host' pass qwe132 grant all priveledge
""login phpmyadmin with user root and pass
click user tab
click add user
input name pass
click check all at global privileges
click go"""

import sql of database pw like intructions at
http://forum.ragezone.com/f754/perfect-world-1-5-1-a-1045161/
"""log out and log in user you creat at phpmyadmin page
click sql tab
click import
choose file sql you downloaded or copy all code to sql windown and click go
check any error it say to you until it imported successfully""
you should log in to user you have just create and import sql file to avoid error

install java for pwAdmin web page because it run by java 6 so you must install java6
sudo apt-get install openjdk-6-jre

sudo apt-get install tomcat7-docs tomcat7-admin tomcat7-examples
sudo apt-get install default-jdk
sudo apt-get install ant git
sudo nano /etc/tomcat7/tomcat-users.xml
added this to final lines inside two bracket <tomcat-users> and </tomcat-users>
choose your username and pass
***<tomcat-users>(not add)
<!--
<role rolename="manager-gui"/>
<role rolename="admin-gui"/>
<user username="admin" password="password" roles="manager-gui,admin-gui"/>
-->
***</tomcat-users>(not add)
sudo service tomcat7 restart

sudo apt-get install libmysql-java
edit file
sudo nano /etc/environment
add line to file
export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java-5.1.32.jar

edit file
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
change bind address like this with your ip address
bind-address = 192.168.40.200

goto webmin page . Go to your mount folder at host win 7
and copy file PWserfile1.5.1, pwadmin1.5.1 you have prepare at first to folder /
and unzip them, remember not override file if you not sure
move file curl_reg.php and registration in folder /var/www/ to var/ww/html

and go on to start and stop server like intructions at
http://forum.ragezone.com/f754/perfect-world-1-5-1-a-1045161/
you need creat account at page

You must be registered to see links

(replace your ip address)
because account registration of pwAdmin can not work proper or st like need train for right configure it
with newbie you should creat account at

You must be registered to see links

Have FUN

 

[Milos]

unless the OP can provide new download links this thread needs to be closed and all download links removed. only "working" links go to 4shared.com which will not let you download the files unless you let it install its malware on your pc.

 

[Henmoro]

I actually didn't have that problem, could you show me screenshots of this please?

 

[meborrh]

Hello i have two questions for you
1: is pwAdmin supossed to be able to start and stop maps, create accounts and so on? mine is not being able to do so.
2: im assuming i need to set an my ip somewhere for my client to be able to see the server so i did the client side but still not seeing the server im thinking i might have to do this on the server side too? am i correct? any clue where if any specific spots at all?
Thank you

 

[bluebyte]

Good Morning Guys,

I was wondering that i could'nt login after character-creation.
I started the entry-world with ./gs is62 manually.
Then it starts.
I opened the gs.conf but I could'nt find any mistakes.
I have compared it with my file of the Server 1.4.1.
Any ideas.
Thank you for reading.
All Thanks to crucifix.
Have a nice weekend

bluebyte

I play with me, in my Perfect World - alone

 

[crucifix]

Wonder if I should do a new version of this guide? Now that I am back?

 

[James Latcham]

Wonder if I should do a new version of this guide? Now that I am back?

Can you do a elements.data one? I've followed others and no luck still have error loading message. Think we need a uptodate one I've seen a few people asking for one.