Hi all,
I have tried everything I can think of and I am kinda stumped now.
My users are having massive delay when logging in, the point database is also not resetting it just crashes from the looks of it but when I shut the server down it will only reset once the server reboots, kinda like the login server is having issues.
Any ideas what could be causing this?
Something wrong with the authd process. Never know what is causing that. A simply kill/restart solves the problem... temporarily...
Are you hosting the account database separately from the game box?
Read auth logs but my fix do this "REPAIR point"
---------- Post added at 04:06 PM ---------- Previous post was at 04:05 PM ----------
Xd your point table is broken>
Ok I assume it needs a crontab to fix every X time the point table...
yep do you need the script? because i do it before daly reboot:POriginally Posted by Romulan
Wow o.0 my server been having this exact same issue the past few months, still been trying to find a fix for it.
Yea sure
Brian, use another auth from another serverfiles, see if that helps... also, check your dedicated machine to see if you can find any network error or hardware errors...
Well, I know you're pro in server development, but I will say it: My server had this problem, and this was caused by the high memory use, and then I created a .sh script to drop the memory cache and the problem stopped... sometimes the memory goes to hell.
Yeah, it's almost obvious that you have thought about this, but who knows? xD
Anyway, the problem can be anything, because as das7002 say: "PW Dev is a Russian roulette". Good luck trying to fix it.
this is old issue right?our authd is buggy. not support symbols or chinesse username and password, change encoding to ascii on table.xml
Brian said that the problem is a massive delay...this is old issue right?
*mumbles something about adding it as an init script that runs on 6 and 0*
Can you share this script? I'm interested for it too.
Sorry i had some problems here is the scripts:
Form.php :
PHP Code:<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<form name="formname" method="post" action="repair.php">
<input name="db_host" value="localhost" type="text"/>
<input name="db_user" value="root" type="text"/>
<input name="db_password" type="text" value="root"/>
<input name="db_ignore" type="text" value="dbo"/>
<input type="submit" value="List_DBs_and_Tables" />
<br>
<input name="do_list" type="checkbox" value="on" checked="checked" disabled="disabled" />List
<input name="do_repair" type="checkbox"checked="checked" value="on" />Repair
<br>
</form>
<body onload="document.forms.formname.submit();">
repair.php
PHP Code:<?php
$db_host = $_POST['db_host'];
$db_user = $_POST['db_user'];
$db_password = $_POST['db_password'];
$do_repair = $_POST['do_repair'];
$db_ignore = ($_POST['db_ignore']) ? $_POST['db_ignore'] : "nodbignore" ;
if(!$db_host || !$db_user){ die(); }
mysql_connect("$db_host","$db_user","$db_password") or die("Error: No BD Connection");
$rs = mysql_query("show databases");
while($arr=mysql_fetch_array($rs)){
echo "<h2>$arr[0]</h2><ol>";
mysql_select_db("$arr[0]");
$rs2 = mysql_query("show tables");
while($arr2=mysql_fetch_array($rs2)){
if($do_repair){
$rs4 = mysql_query("repair table `$arr2[0]`"); echo mysql_error();
$arr4=mysql_fetch_array($rs4);
}
echo "<li>$arr2[0] <b>$arr4[3]</b>";
}
echo "</ol>";
}
?>
Thx, I'll try this if I get the problem again.
just in-case you have to regenerate database daly or when you reboot i do this form Monday to Friday and i never got any issues
That's simple..
Save it as .sh script and edit crontabCode:#!/bin/bash echo 3 > proc/sys/vm/drop_caches
Then use chmod in the .sh scriptCode:crontab -e * * * * * ~/refresh.sh
Now the script will automatically drop the memory caches.
You don't need shell scripts for cron unless it is an actual shell script. Putting that command directly into cron works perfectly fine...
Nah, with the script you can type ./name.sh at any time.
@Adriana
Sorry, your fix doesn't work for me. It's a problem from authd not from the pw mysql db.
Last edited by Romulan; 21-08-11 at 03:09 AM.
i posted that script for bash and you said you want it to it repairs all tables in MySQL that's all it do.
Yea because I believed that it was a problem with the point table. But I discovered that the issue was not from the point table in my case...
No I host all on same machine.
I have checked everything that the login process is linked to and everything is fine though.
I have never had this issue before either.
I actually over-looked possible memory issues since my machine has over 30GB of memory but what I have noticed is my system load has been over 1 recently which isnt bad but its different since it never peaks over 0.1 I will try monitor the flow the next few days see what could be causing this.
My server doesnt handle any symbols only 1-9 a-zthis is old issue right?
just put wrong ID and password with symbol or chinese name without registered,force it 4 times or more.. ur authd will be crash.. xD
Check logs in Auth nofxpunkerbrian
start Auth in sh make log ->
$CLASSPATH org.mono.Authd > /log
You too can debug true file ->
table.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="table.xsl"?>
<application debug="false" >
after
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="table.xsl"?>
<application debug="true" >
I am currently working with Swoosh91 to force the user to use a client made by me to prevent hacks once and for all.
Remembering that I add some things in Auth (java) and Swoosh91 in assembler:)
The Bug to force user and make dupping is because of the Auth and is another thing that will get
If you need some help add me on skype: zdarks2joci
[B]aSH
Reply With Quote