PW 136 Server files for use with MySql

Hi I managed to get the server (full) running and running well the other day but after I shut it down via the GM console I can't get it back up.

Quote:

---

I have ran the full PW server successfully on my linux server and closed it down using the GM console in-game. Since, I've edited the gshop.data file and the bonus stats (such as drops and exp) numbers in ptemplate.cfg but now the server GAMEDBD says "err: Initialize storage environment failed" and gdeliveryd can't connect it. I reverted to the original gshop.data and ptemplate.cfg files but it is still doing it. I've checked as much as I can think of but can't figure out what else. Even restarting the computer itself didn't help.

---

Anyone manage to start their server using this server files?

Quote:

---

Originally Posted by test1234567

Hi I managed to get the server (full) running and running well the other day but after I shut it down via the GM console I can't get it back up.

---

I had the same problem, deleting all characters:

Code:

---

cd /dbf/dbhomewdb/
rm -r -f dbdata
mkdir dbdata

---

Code:

---

cd /export/uname/
rm -r -f dbdata
mkdir dbdata

---

then dropping the database then remaking and running dbo.sql again fixes it.

Quote:

---

Originally Posted by cr8tive

Anyone manage to start their server using this server files?

---

yes, they work.

That's going to be a pain clearing the DB every so often unless I make a backup just before it shuts down.:glare:

Code:

---

<? //=====Script by trash=====//
//=====For MySQL Database=====//
include "config.php";

$Data = '<form action=register.php method=post>
Login: <br><input type=text name=login><br><br>
Password:<br><input type=password name=passwd><br><br>
Repeat password:<br><input type=password name=repasswd><br><br>
Email:<br><input type=text name=email><br><br>
<input type=submit name=submit value="Registration">
</form>';

if (isset($_POST['login'])) {
$Link = MySQL_Connect($DBHost, $DBUser, $DBPassword) or die ("Can't connect to MySQL");
MySQL_Select_Db($DBName, $Link) or die ("Database ".$DBName." do not exists.");

$Login = $_POST['login'];
$Pass = $_POST['passwd'];
$Repass = $_POST['repasswd'];
$Email = $_POST['email'];
$Login = StrToLower(Trim($Login));
$Pass = StrToLower(Trim($Pass));
$Repass = StrToLower(Trim($Repass));
$Email = Trim($Email);

if (empty($Login) || empty($Pass) || empty($Repass) || empty($Email)) {
echo "All fields is empty.";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Login, $Txt)) {
echo "Login have a incorrect format.";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Pass, $Txt)) {
echo "Password have a incorrect format.";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Repass, $Txt)) {
echo "Repeat password have a incorrect format.";
}
elseif (StrPos('\'', $Email)) {
echo "Email have a incorrect format.";
}
else {
$Result = MySQL_Query("SELECT name FROM users WHERE name='$Login'") or ("Can't execute query.");

if (MySQL_Num_Rows($Result)) {
echo "Account <b>".$Login."</b> is exists";
}
elseif ((StrLen($Login) < 4) or (StrLen($Login) > 10)) {
echo "Login must have more 4 and not more 10 symbols.";
}
elseif ((StrLen($Pass) < 4) or (StrLen($Pass) > 10)) {
echo "Password must have more 4 and not more 10 symbols.";
}
elseif ((StrLen($Repass) < 4) or (StrLen($Repass) > 10)) {
echo "Repeat password must have more 4 and not more 10 symbols.";
}
elseif ((StrLen($Email) < 4) or (StrLen($Email) > 25)) {
echo "Email must have more 4 and not more 25 symbols.";
}
elseif ($Pass != $Repass){
echo "Password mismatch.";
}

else {
$Salt = $Login.$Pass;
$Salt = md5($Salt);
$Salt = "0x".$Salt;

MySQL_Query("call adduser('$Login', $Salt, '0', '0', '0', '0', '$Email', '0', '0', '0', '0', '0', '0', '0', '', '', $Salt)") or die ("Can't execute query.");

echo "Account <b>".$Login."</b> has been registered.";
}
}
}
echo $Data;

?>

---

It becomes it like this if it registers from PHP for the above-mentioned registration.
http://substem.servegame.org/uploda/src/up0002.jpg

I have a few problem to make this running. Here is the error.

=== Jakarta Tomcat ===
: command not foundtomcat-5.5.9/bin/setclasspath.sh: line 6:
: command not foundtomcat-5.5.9/bin/setclasspath.sh: line 9:
'usr/local/jakarta-tomcat-5.5.9/bin/setclasspath.sh: line 74: syntax error near unexpected token `do
'usr/local/jakarta-tomcat-5.5.9/bin/setclasspath.sh: line 74: ` for i in "$OSXHACK"/*.jar; do
Using CATALINA_BASE: /usr/local/jakarta-tomcat-5.5.9
Using CATALINA_HOME: /usr/local/jakarta-tomcat-5.5.9
Using CATALINA_TMPDIR: /usr/local/jakarta-tomcat-5.5.9/temp
Using JRE_HOME:
Iweb Started === DONE ==

=== UNIQUENAMED ===
./start.sh: line 36: 14288 Segmentation fault ./uniquenamed gamesys.conf > $PW_PATH/logs/uniquenamed.log
=== DONE! ===

=== AUTH ===
./authd: line 6: /usr/java/jdk1.6.0_12/bin/java: Permission denied
./authd: line 9: syntax error near unexpected token `done'
./authd: line 9: `done'
=== DONE! ===

=== GAMEDBD ===
./start.sh: line 48: 14296 Segmentation fault ./gamedbd gamesys.conf > $PW_PATH/logs/gamedbd.log
=== DONE! ===

=== GACD ===
./start.sh: line 54: 14298 Segmentation fault ./gacd gamesys.conf > $PW_PATH/logs/gacd.log
=== DONE! ===

=== GFACTIOND ===
./start.sh: line 60: 14300 Segmentation fault ./gfactiond gamesys.conf > $PW_PATH/logs/gfactiond.log
=== DONE! ===

=== GDELIVERYD ===
TRACE : gdeliveryd::Max player allowed is 6000
./start.sh: line 66: 14302 Segmentation fault ./gdeliveryd gamesys.conf > $PW_PATH/logs/gdeliveryd.log
=== DONE! ===

=== GLINKD ===
./start.sh: line 75: 14304 Segmentation fault ./glinkd gamesys.conf 1 > $PW_PATH/logs/glink.log
./start.sh: line 75: 14305 Segmentation fault ./glinkd gamesys.conf 2 > $PW_PATH/logs/glink2.log
./start.sh: line 75: 14306 Segmentation fault ./glinkd gamesys.conf 3 > $PW_PATH/logs/glink3.log
./start.sh: line 75: 14307 Segmentation fault ./glinkd gamesys.conf 4 > $PW_PATH/logs/glink4.log
=== DONE! ===

=== MAIN WORLD ===
./start.sh: line 81: 14309 Segmentation fault ./gs gs01 > $PW_PATH/logs/game1.log
=== DONE! ===

=== MAIN WORLD ===
./start.sh: line 81: 14309 Segmentation fault ./gs gs01 > $PW_PATH/logs/game1.log
=== DONE! ===

=== OTHER WORLD ===
./start.sh: line 87: 14314 Segmentation fault ./gs arena01 > $PW_PATH/logs/game_all.log
=== ARENA1 DONE! ===

./start.sh: line 91: 14316 Segmentation fault ./gs arena02 > $PW_PATH/logs/game_all.log
=== ARENA2 DONE! ===

./start.sh: line 95: 14319 Segmentation fault ./gs arena03 > $PW_PATH/logs/game_all.log
=== ARENA3 DONE! ===

./start.sh: line 99: 14321 Segmentation fault ./gs arena04 > $PW_PATH/logs/game_all.log
=== ARENA4 DONE! ===

./start.sh: line 135: 14323 Segmentation fault ./gs is11 > $PW_PATH/logs/game_all.log
=== Valley of Disaster / Disaster Valley DONE! ===

My server is Ubuntu 8.10 anyone can help me solve this problem?

Quote:

---

Originally Posted by CrumX

I have a few problem to make this running. Here is the error.

=== Jakarta Tomcat ===
: command not foundtomcat-5.5.9/bin/setclasspath.sh: line 6:
: command not foundtomcat-5.5.9/bin/setclasspath.sh: line 9:
'usr/local/jakarta-tomcat-5.5.9/bin/setclasspath.sh: line 74: syntax error near unexpected token `do
'usr/local/jakarta-tomcat-5.5.9/bin/setclasspath.sh: line 74: ` for i in "$OSXHACK"/*.jar; do
Using CATALINA_BASE: /usr/local/jakarta-tomcat-5.5.9
Using CATALINA_HOME: /usr/local/jakarta-tomcat-5.5.9
Using CATALINA_TMPDIR: /usr/local/jakarta-tomcat-5.5.9/temp
Using JRE_HOME:
Iweb Started === DONE ==

=== UNIQUENAMED ===
./start.sh: line 36: 14288 Segmentation fault ./uniquenamed gamesys.conf > $PW_PATH/logs/uniquenamed.log
=== DONE! ===

=== AUTH ===
./authd: line 6: /usr/java/jdk1.6.0_12/bin/java: Permission denied
./authd: line 9: syntax error near unexpected token `done'
./authd: line 9: `done'
=== DONE! ===

=== GAMEDBD ===
./start.sh: line 48: 14296 Segmentation fault ./gamedbd gamesys.conf > $PW_PATH/logs/gamedbd.log
=== DONE! ===

=== GACD ===
./start.sh: line 54: 14298 Segmentation fault ./gacd gamesys.conf > $PW_PATH/logs/gacd.log
=== DONE! ===

=== GFACTIOND ===
./start.sh: line 60: 14300 Segmentation fault ./gfactiond gamesys.conf > $PW_PATH/logs/gfactiond.log
=== DONE! ===

=== GDELIVERYD ===
TRACE : gdeliveryd::Max player allowed is 6000
./start.sh: line 66: 14302 Segmentation fault ./gdeliveryd gamesys.conf > $PW_PATH/logs/gdeliveryd.log
=== DONE! ===

=== GLINKD ===
./start.sh: line 75: 14304 Segmentation fault ./glinkd gamesys.conf 1 > $PW_PATH/logs/glink.log
./start.sh: line 75: 14305 Segmentation fault ./glinkd gamesys.conf 2 > $PW_PATH/logs/glink2.log
./start.sh: line 75: 14306 Segmentation fault ./glinkd gamesys.conf 3 > $PW_PATH/logs/glink3.log
./start.sh: line 75: 14307 Segmentation fault ./glinkd gamesys.conf 4 > $PW_PATH/logs/glink4.log
=== DONE! ===

=== MAIN WORLD ===
./start.sh: line 81: 14309 Segmentation fault ./gs gs01 > $PW_PATH/logs/game1.log
=== DONE! ===

=== MAIN WORLD ===
./start.sh: line 81: 14309 Segmentation fault ./gs gs01 > $PW_PATH/logs/game1.log
=== DONE! ===

=== OTHER WORLD ===
./start.sh: line 87: 14314 Segmentation fault ./gs arena01 > $PW_PATH/logs/game_all.log
=== ARENA1 DONE! ===

./start.sh: line 91: 14316 Segmentation fault ./gs arena02 > $PW_PATH/logs/game_all.log
=== ARENA2 DONE! ===

./start.sh: line 95: 14319 Segmentation fault ./gs arena03 > $PW_PATH/logs/game_all.log
=== ARENA3 DONE! ===

./start.sh: line 99: 14321 Segmentation fault ./gs arena04 > $PW_PATH/logs/game_all.log
=== ARENA4 DONE! ===

./start.sh: line 135: 14323 Segmentation fault ./gs is11 > $PW_PATH/logs/game_all.log
=== Valley of Disaster / Disaster Valley DONE! ===

My server is Ubuntu 8.10 anyone can help me solve this problem?

---

I saw some permission errors in there, did you set everything u uploaded to 0777?

Okay after I change the permission file to 777 it seems that the segmentation fault still there.

I'm now getting this:

AUTH
/libjvm.so'.sr/java/jdk1.5.0_05/jre/lib/i386/server
./authd: line 7: syntax error near unexpected token `done'
./authd: line 7: `done'
DONE!

Quote:

---

Originally Posted by test1234567

I'm now getting this:

AUTH
/libjvm.so'.sr/java/jdk1.5.0_05/jre/lib/i386/server
./authd: line 7: syntax error near unexpected token `done'
./authd: line 7: `done'
DONE!

---

the same problem that i have

Code:

---

=== AUTH ===
/libjvm.so'.sr/java/jdk1.6.0_12/jre/lib/i386/server
./authd: line 9: syntax error near unexpected token `done'
./authd: line 9: `done'

---

please help us!!^^

O.o ( ... )

@CrumX
hmmm,... LOL !!! Not only the start.sh...
You may do chmod -R 777 on the following folders:
gacd, authd, gamed, gamedb, and others in /home; /usr/java folder ; /usr/local/jakarta-tomcat-5.5.9 folder.
After this, i think the Segmentation Fault error will not come back again...


@test1234567 ; @Yunta
1. authd file is maybe corrupted ?
2. java folder is maybe corrupted ?
3. both of them are corrupted .... ?

Check it! ^^

I've already checked as much as I could for the java folder and authd files. I'm pretty stumped in what I can try other than reupload all the java, jarkata and then server files themselves again.

Thanks for share. Btw I cant get into dungeons which are located in "Thousand Stream City"
Guess maps are broken. Do you have any updates etc? Is it for client 131 or 136 cause im using 131

You can't enter in Blue door or Red door ? :/

nice thanks, should come in useful.