pwAdmin 151

[sora1984]

PwAdmin actually creates a .sh script and runs it, so make sure it has permission to write and execute files...

 

[lordmegamanx72]

Hello,
I have fallow all the steps
Edited .pwadminconf.jsp
Changed db_user
db_password according to my user name in phpmyadmin i have even tried to add new user and try my luck
I made sure that db_database was correct and i had created file that is pwadmin.sh and installation worked out!!!
but i wonder why AFTER i had tried and fallow all steps ,Login page of pwAdmin seem only like address without book lol, for short You can see the pwadmin but you can't log it and when you use the user name you edited in that file * .pwadminconf.jsp * all what you get that you don't log in and the page doesn't tell that you have logged on or not , it looks like you refresh page on browser or something lmao
So i will be glad for any little help and maybe there is part i haven't noticed
Considering me as stupid or smart won't help me at all so please i hope that any little guide will be helpful
i want to pass this issue i am getting in my pw admin
Sorry for long message if it is
and i will be thankful for any little help
Here all the steps i have done
Sudo apt-get proftpd to give access to File zilla
Used sudo passwd root to gain access to root
so i can use su to turn from my user to root directly Later on
http://forum.ragezone.com/f751/pw-server-files-1-5-a-989364-post7990311/#post7990311
in first server while trying i fallow steps but i stucked up at some steps so i said lets get it shorter use easy installer
http://forum.ragezone.com/f751/pw-1-5-1-easy-1014795/
Changed premisions by Filezilla instead of chmod (easy for me ) to do cd / to type in ./pw.sh
I made sure that /home/ contains the servers files within .server and chmod
i have replaced pwAdmin and iweb using FileZilla ofc after i have changed permission to 775 or 755 * i perfered 775*
Edited .pwadminconf.jsp
Changed db_user
db_password and made sure that db_database was correct
Now the following issues i am facing and they are
I changed server list of my own client to ipaddress of my own server it seem it isn't online * i think i need pwAdmin * to activate the maps which i can't log at
I can't access to iweb as well
alot of issues that made me insane until i jumped like a monkey who starve for banana hahahahahahaha
so someone better help me please if there someone noble and want to help
ah yea another thing I want to my best and special thanks to ragezone it forced me to study programming and i almost head up for system and information college because of this great website ^^
thanks and sorry... if i bother

 

[GTXBack]

can 1 upload database? o:

 

[MikeMadez]

when i move the file to the root... the files /.pwadminconf.jsp disappear :C

 

[343]

no it doesn't



try ls -hla you'll see



Never-mind, your other post I saw explains a LOT (you use GUI)...

Ditch the GUI, get SERVER edition OS - STEP ONE

 

[lordmegamanx72]

alright i can access now to pw admin and solved all the problems
i have 2 problems
my first problem , I could log on server , created character and when i press start it gives the following
*Failed to log on server *
my second problem
i can't add maps it gives message error like *Failed to add map* by pw admin

 

[sora1984]

is62 isnt running if you cant log in.
Where the code is to start the maps in your start script, you could replace the whole section with this...

cd /home/gamed
for map in gs01 is62 #Add each map you want to start 
do
echo "Loading $map"
sleep 3
./gs $map > /home/logs/$map.log &
done

You can add more maps to the loop if you want more to start at server boot.

or make a new text file paste the code, rename it to whatever.sh chmod it and run it

Did you give pwAdmin the correct permissions?

 

[lordmegamanx72]

yes i did and it seem to work thank you very much for the quick installer
but i have another 5 bugs i got
1 -pw admin gets glitchs in addons options * as it gives blank pages or fail pages *
2- character can't be edited by spirit or exp in character list after importing the missing table
3- server configuration works luckily which mean it is too rare to find it working it takes age to load in an endlessly way
4- adding cubi or giving cubi to my gm character doesn't work
5- i can't register any new account by pwadmin it tells the following *Failed to connect to database SQL* how is that happening ? and i have created tables already into database called pw but register page of /var/www is working that how i managed to created new account .
i have one more question, how to make your server public ? i have seen or known that it isn't possiable with ip addresses 192.168.1.(4 or 5 or 6)
if you can just links to these solutions i will be thankful and another question , iweb is facing serious problem i used iweb from jakarta folder and added it webapps with pwAdmin it doesnt work maybe because i have to take entire jakarta folder and put it in any place on server but it worked out that way but only 2 pages are getting blank as well and they monitor pages
a lot of bugs and a lot of bother sorry about that but some help will be perfectly needed and i will be glad so hard if i get any
thanks, again my greetings

 

[lordmegamanx72]

i fixed all now but i need to find out what makes server configuration of pwAdmin work when server is online
it goes to be unresponsive once
when server is offline it works perfectly
the same with iweb in server managment and some pages of iweb are blanked as well
and i have an important question that i need answer for it
how can i make my server as public server ?
any little help will be good

 

[abileneken]

Is there a way to list characters by account id# ?

or is there a query that could be run on the database to get this info?

I have yet to implement an email verification and have a couple accounts with non valid email addresses and would like to check with the players in case of mistype of email before just deleting the account.

 

[Ben]

Is there a way to list characters by account id# ?

or is there a query that could be run on the database to get this info?

I have yet to implement an email verification and have a couple accounts with non valid email addresses and would like to check with the players in case of mistype of email before just deleting the account.

As far i know i didn't see an pre-set feature to list characters on account ID, either tho the pwAdmin includes the account ID on the character page next to the online/offline field

 

[Perplexed]

@khatvong0702 config:

String db_host = "localhost";
String db_port = "3306";
String db_user = "YOUR MYSQL USER";
String db_password = "YOUR MYSQL PASSWORD";
String db_database = "YOUR MYSQL DATABASE NAME";

Make sure you have role table in your perfect world database.

role Table???? Ok, I get that I have to import role table to mysql, do I export to perfect world database? or are you refering to the

"pw" db created in this script?

 

[Perplexed]

account.jsp
serverctrl.jsp
addons
WEB-INF
You need to override the four folders these.

Override how exactly?

 

[Perplexed]

Ok, I have used the easy installer 1.5.1... I can not use terminal to connect to phpMyAdmin or pwAdmin Please someone shed some light? 3 days no sleep now :'( Server is up, everything fine except pwAdmin ( And I am assuming Database in phpMyAdmin )





EDIT. I found a nice little tool that allows me to access phpMyAdmin on Windows.... WampDevelopers Pro... Now anyone want to help me a little? Also, Can I enable the misses to access the server from her pc? Same IP only dif port

 

[Perplexed]

Noob install for centos users also:

cd /home
wget http://212.175.84.61/pwadmin/pwadmin.sh
chmod 755 pwadmin.sh
./pwadmin.sh

pwadmin.sh:

#!/bin/bash
#noob install pwadmin for centos

ip=`/sbin/ifconfig|grep inet|head -1|sed 's/\:/ /'|awk '{print $3}'`

cd  /var/lib
wget http://www.eu.apache.org/dist/tomcat/tomcat-7/v7.0.52/bin/apache-tomcat-7.0.52.tar.gz
tar xzf apache-tomcat-7.0.52.tar.gz
mv /var/lib/apache-tomcat-7.0.52 /var/lib/tomcat7
cd /var/lib/tomcat7/webapps/
wget https://dl.dropboxusercontent.com/u/19918926/pwadmin1.5.1.zip
unzip -o pwadmin1.5.1.zip
cd /var/lib/tomcat7/bin/
./startup.sh
echo "Install done"
echo "Open your browser and go to http://"$ip":8080/pwAdmin/"
echo "Edit /var/lib/tomcat7/webapps/pwAdmin/WEB-INF/.pwadminconf.jsp for admin password"
echo "Default admin password is "root"

btw works great thanks for release

that's that problem solved haha



I hardly use pwAdmin I start my server using a bash script I wrote haha

Any idea's on when this is ready enough to be released? Because it looks awesome



So is the ONLY thing we edit the string iweb password and the string db password?

And how do we sync with server and mysql?

 

[gunse]

Any idea's on when this is ready enough to be released? Because it looks awesome



So is the ONLY thing we edit the string iweb password and the string db password?

And how do we sync with server and mysql?

You can do manually, crond, or any daemon script to sync server-sql...

 

[Perplexed]

You can do manually, crond, or any daemon script to sync server-sql...

?

 

[DaRealGE]

Finally got pwAdmin working ^_^ Yay... It seems you need to change the string iweb password and make sure your string db password matches your mysql password.... That's basically all you need to change I think?

Although authd still offline :/

and server config just keeps loading


Oh, and get item isn't working


Sending items in via mail 2 works, however whole server crashed when I sent in a NA " insert Chinese text here " named item......

 

[crucifix]

Ok this worked very well except one problem. I can get to the panel login and see everything is running etc all the options are there but I cant stay logged in so I cant edit anything as soon as I click anything it logs me out I edited the file as instructed and since its able to read that all my stuff is started I am sure the parts I did are right. However I am wondering if I missed something Cause it just wont stay logged in



I tried fixing the md5 like was suggested in a help thread that didnt work



I have my whole server online i can see the processes running just cant login to do anything game login even works

 

[crucifix]

Ok I have read every thread I could find. I have changed my database to make sure it wasn't corrupt reinstalled multiple times. ch modded the pwAdmin folder the only thing I can think of is I am missing something I need to configure can someone give me a run down of what needs to be edited. My db name is pw by default already user name is default too Maybe these lines arent configured right? / 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/";

Please help I have been working on this for over eight hours so its not like I haven't tried I just can't figure it out. I can go to my pwAdmin page it shows up I can see all the options under server config it shows all my stuff including auth as running which I know it is cause I can log in and play the game. But if I try to login to pwAdmin so I can use the options it closses the tabs and the login box dissapears but as soon as I click anything like server config it comes back up as me not being logged in.