Jump to content

Shinryuu

Moderators
 View Profile  See their activity

  • Posts

    1,025

  • Joined

  • Last visited

  • Days Won

    40

 Content Type 

Posts posted by Shinryuu

    [Solved] Johnny Innodb

    in Customer Service

    Posted

    It's been over a week so I guess we should throw in a slight update, we're looking into the problem but it's quite a mess. Before Johnny died this time MySQL could be considered a bit sluggish by the optimistic, post-crash MySQL would start up with all engines enabled and start a crash recovery process, this recovery would actually crash and MySQL would fail to start. Disabling InnoDB allowed MySQL to start without issue, and it shouldn't have been a real issue since most users just go with the default which is MyISAM. Our speculation is perhaps you guys are using a database backed up from another host or maybe your CMS weirdly decided to use InnoDB as an engine, either way, we don't like that you guys can't access your databases at all any more than you do.

     

    Here's the thing though, since InnoDB has been disabled MySQL queries have responded faster and in general it seems leaving InnoDB off might help Johnny in the long run. We do want to enable it, at least temporarily, so you can convert the database tables to another engine or take a backup of your information. It's a hard call to make and the finer detail of getting MySQL to run with it enabled still needs to be dealt with first, but I figured you guys could use something to help with the nail-biting suspense.

     

    TL;DR Your data is recoverable, and can be converted to avoid the situation again. We hope to be able to let you have access to your data sometime soon, but it will take more time. InnoDB may be permanently disabled in the future to keep improved MySQL response times. If anything new comes up we'll let you guys know, thank you for your patience.

    [Solved] Suspended: Coldwin

    in Suspended and Queued Accounts

    Posted

    Posted 18 March 2013 - 07:10 PM

     

    Your account was suspended for inactivity, because you haven't logged into your account in the last 30 days. To reactivate your account, please visit http://www.heliohost...t/scripts/renew. To prevent this from happening in the future please remember to visit http://heliohost.org/ to log into your account at least once every 30 days.

     

     

    If you are still seeing the Account Suspended page after renewing your account, please clear your cache.

     

    1) The place to post is under the Queued/Suspended subforum.

    2) There's a format to titling an ususpension request that simplifies our jobs of looking up your account, please use it.

    3) You were already told how to handle your account renewal 2 weeks ago.

    [Answered] Nameserver Changes

    in Questions

    Posted

    That's really a horrible policy on the part of your registrar and you should look into telling them as much. By default cPanel requires your domain's NS records to point to the server you want to host your site on. Our domain change tool allows you to change your main domain, forcing our nameservers to create entries for your site. Doing that and waiting for our nightly maintenance's next run should appease your registrar's backward system and allow you to host your co.za domain with us.

    • Like 1

    Login Script

    in Website Management and Coding

    Posted 

    <?php

$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name=""; // Database name 
$tbl_name=""; // Table name 

// Connect to server and select databse.
$con = mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
$db = mysql_select_db($db_name, $con);
if(!$db){
echo "connection failed";
}
else{
echo "connection worked";
}

// username and password sent from form 
$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 

// To protect MySQL injection (more detail about MySQL injection)
/*
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword"); 
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}*/
?>

     

    works for me http://shinryuu.net/db_test.php

    [Answered] Java Applets And A Question Of Appropriateness

    in Questions

    Posted

    Applets are run by invoking a JVM on the client machine, so server details are irrelevant. Keep in mind that to run it the client will need to install java, and even then they could refuse to allow your applet permission to run. Applets are really viewed as the technology of yesteryear, but if you know Java or have a decent Java beginner's book, then an applet is easy to make without learning anything too complicated.

    [Answered] Why Mysql Charset Is Latin1

    in Questions

    Posted

    Utf8 is supported, latin1 is just the default, we could probably change the default charset to utf8 without breaking anything though. There's a drop-down for setting charsets in fields that are characters/strings and the one you want to choose is utf8_general_ci for utf8.

    [Solved] Domain Owned By Another User

    in Customer Service

    Posted

    That's simply marked as inactive since the last login was valentine's day. I've sent a message to the email that user registered with, if they reply I'll go ahead and manually delete it. Standard procedure is only the account owner can request account deletions.

     

    The reason that your attempt to delete via the script failed is because the password becomes scrambled when an account is suspended, blocking all access to the account.

     

    EDIT: Alright, response was received and the account has now been deleted, it may take some time before the system allows you to transfer the domain.

×
×
  • Create New...