Skip to content

Instantly share code, notes, and snippets.

View fifiteen82726's full-sized avatar

Coda fifiteen82726

6 followers · 10 following
View GitHub Profile
@fifiteen82726
fifiteen82726 / sql
Created October 13, 2014 17:58
<?php
$dbhost = 'mysql16.000webhost.com';
$dbuser = 'a2212810_coda';
$dbpass = '2wsx1qaz';
$dbname = 'a2212810_coda';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$sql = "SELECT * FROM `account`";
$result = mysql_query($sql) or die('MySQL query error');
while($row = mysql_fetch_array($result)){
@fifiteen82726
fifiteen82726 / sql
Created October 13, 2014 17:59
<?php
$dbhost = 'mysql16.000webhost.com';
$dbuser = 'a2212810_coda';
$dbpass = '2wsx1qaz';
$dbname = 'a2212810_coda';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$sql = "SELECT * FROM `account`";
$result = mysql_query($sql) or die('MySQL query error');
while($row = mysql_fetch_array($result)){
@fifiteen82726
fifiteen82726 / C# string to int
Last active August 29, 2015 14:17
string[] input_mp_per;
// input Mp series number
do
{
temp = Console.ReadLine();
input_mp_per = temp.Split(' ');
Console.WriteLine(input_mp_per.Length);
int counter = 0;
if (input_mp_per.Length > second)
@fifiteen82726
fifiteen82726 / hw1
Created March 19, 2015 04:11
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApplication2
{
class Program
@fifiteen82726
fifiteen82726 / gist:b561bbd9cdcb9bf36032
Last active August 29, 2015 14:20
DataNode.log
2015-04-27 07:27:32,270 INFO org.apache.hadoop.hdfs.server.datanode.DataNode: STARTUP_MSG:
/************************************************************
STARTUP_MSG: Starting DataNode
STARTUP_MSG: host = ubuntu/127.0.1.1
STARTUP_MSG: args = []
STARTUP_MSG: version = 2.6.0
STARTUP_MSG: classpath = /usr/local/hadoop/etc/hadoop:/usr/local/hadoop/share/hadoop/common/lib/paranamer-2.3.jar:/usr/local/hadoop/share/hadoop/common/lib/apacheds-kerberos-codec-2.0.0-M15.jar:/usr/local/hadoop/share/hadoop/common/lib/commons-compress-1.4.1.jar:/usr/local/hadoop/share/hadoop/common/lib/slf4j-api-1.7.5.jar:/usr/local/hadoop/share/hadoop/common/lib/httpcore-4.2.5.jar:/usr/local/hadoop/share/hadoop/common/lib/hamcrest-core-1.3.jar:/usr/local/hadoop/share/hadoop/common/lib/commons-httpclient-3.1.jar:/usr/local/hadoop/share/hadoop/common/lib/commons-el-1.0.jar:/usr/local/hadoop/share/hadoop/common/lib/jackson-jaxrs-1.9.13.jar:/usr/local/hadoop/share/hadoop/common/lib/jackson-core-asl-1.9.13.jar:/usr/local/hadoop/share/ha
@fifiteen82726
fifiteen82726 / gist:02dcf095b5a23c1570b0
Last active August 29, 2015 14:20
NameNode logs
2015-04-27 07:25:47,778 INFO org.apache.hadoop.hdfs.server.namenode.NameNode: STARTUP_MSG:
/************************************************************
STARTUP_MSG: Starting NameNode
STARTUP_MSG: host = ubuntu/127.0.1.1
STARTUP_MSG: args = []
STARTUP_MSG: version = 2.6.0
STARTUP_MSG: classpath = /usr/local/hadoop/etc/hadoop:/usr/local/hadoop/share/hadoop/common/lib/paranamer-2.3.jar:/usr/local/hadoop/share/hadoop/common/lib/apacheds-kerberos-codec-2.0.0-M15.jar:/usr/local/hadoop/share/hadoop/common/lib/commons-compress-1.4.1.jar:/usr/local/hadoop/share/hadoop/common/lib/slf4j-api-1.7.5.jar:/usr/local/hadoop/share/hadoop/common/lib/httpcore-4.2.5.jar:/usr/local/hadoop/share/hadoop/common/lib/hamcrest-core-1.3.jar:/usr/local/hadoop/share/hadoop/common/lib/commons-httpclient-3.1.jar:/usr/local/hadoop/share/hadoop/common/lib/commons-el-1.0.jar:/usr/local/hadoop/share/hadoop/common/lib/jackson-jaxrs-1.9.13.jar:/usr/local/hadoop/share/hadoop/common/lib/jackson-core-asl-1.9.13.jar:/usr/local/hadoop/share/ha
@fifiteen82726
fifiteen82726 / gist:f58717c1f452b4b21610
Last active August 29, 2015 14:20
Error message after typing start-all.sh
coda@ubuntu:/usr/local/hadoop/sbin$ start-all.sh
This script is Deprecated. Instead use start-dfs.sh and start-yarn.sh
15/04/30 01:07:25 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Starting namenodes on [localhost]
coda@localhost's password:
localhost: chown: changing ownership of ‘/usr/local/hadoop/logs’: Operation not permitted
localhost: mv: cannot move ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.4’ to ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.5’: Permission denied
localhost: mv: cannot move ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.3’ to ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.4’: Permission denied
localhost: mv: cannot move ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.2’ to ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.3’: Permission denied
localhost: mv: cannot move ‘/usr/local/hadoop/logs/hadoop-coda-namenode-ubuntu.out.1’ to ‘/usr/local/had
@fifiteen82726
fifiteen82726 / gist:d0b6fdc43caef587bb7b
Created May 5, 2015 11:51
CREATE TABLE DIRECTOR(
DIR_NUM VARCHAR(20) NOT NULL,
DIR_LNAME VARCHAR(30) NULL,
DIR_DOB DATETIME NULL,
PRIMARY KEY (DIR_NUM),
)
CREATE TABLE PLAY(
PLAY_CODE VARCHAR(20) NOT NULL,
PLAY_NAME VARCHAR(50) NULL,
DIR_NUM VARCHAR(20) NULL,
@fifiteen82726
fifiteen82726 / Dataset
Last active December 13, 2015 08:19
Change table
group: UIBK - R, S, T
description: Tables from and for the lecture [Databases: Foundations, Data Models and System Concepts - University of Innsbruck](http://dbis-informatik.uibk.ac.at/249-0-VO-Datenbanksysteme.html) chapter 3
Customer = {
CId, Name, Birthday, Phone, Address, Email
1, 'John', '2011-1-4', '12345678' , 'unknow','unknow'
3, 'Nancy', '2011-2-4', '12345678' , 'unknow','unknow'
4, 'Jack', '2011-3-4', '12345678' , 'unknow','unknow'
}
@fifiteen82726
fifiteen82726 / Heroku logs.bash
Last active June 16, 2016 01:07
2016-06-15T13:52:34.591071+00:00 app[web.1]: from /app/vendor/bundle/ruby/2.2.0/gems/railties-4.2.5/lib/rails/commands/commands_tasks.rb:75:in `tap'
2016-06-15T13:52:34.591085+00:00 app[web.1]: from /app/vendor/bundle/ruby/2.2.0/gems/railties-4.2.5/lib/rails/commands/commands_tasks.rb:75:in `server'
2016-06-15T13:52:34.591057+00:00 app[web.1]: from /app/vendor/bundle/ruby/2.2.0/gems/railties-4.2.5/lib/rails/commands/commands_tasks.rb:80:in `block in server'
2016-06-15T13:52:34.591133+00:00 app[web.1]: from bin/rails:9:in `require'
2016-06-15T13:52:34.591147+00:00 app[web.1]: from bin/rails:9:in `<main>'
2016-06-15T13:52:34.591118+00:00 app[web.1]: from /app/vendor/bundle/ruby/2.2.0/gems/railties-4.2.5/lib/rails/commands.rb:17:in `<top (required)>'
2016-06-15T13:52:35.789410+00:00 heroku[web.1]: Process exited with status 1
2016-06-15T13:52:35.986144+00:00 heroku[web.1]: State changed from starting to crashed
2016-06-15T13:52:47.291220+00:00 heroku[router]: at=error code=H10 desc="App crashed