from os import path
basepath = path.dirname(__file__)
DATABASE_NAME = path.join(basepath, 'DB名')
DEBUG = True
TEMPLATE_DEBUG = DEBUG
ADMINS = (
# ('Your Name', 'your_email@example.com'),
)
MANAGERS = ADMINS
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
'NAME': DATABASE_NAME, # Or path to database file if using sqlite3.
# The following settings are not used with sqlite3:
'USER': '',
'PASSWORD': '',
'HOST': '', # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
'PORT': '', # Set to empty string for default.
}
}
/**
* メーリングリストへの登録
*/
function entry_ml() {
var password = "hoge";
var adminAdress = "hoge@hoge.sakura.ne.jp";
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // チェックするデータの開始行
var numRows = 100; // チェックするデータの数
// Fetch the range of cells A2:B3
var dataRange = sheet.getRange(startRow, 2, numRows, 7);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (i in data) {
var row = data[i];
if (row[0] == "") {
break;
}
var name = row[0];
var emailAddress = row[1];
var confirmed = row[6];
var subject = "";
if (confirmed != "") {
var message = "approve " + password + " add " + emailAddress;
//Browser.msgBox(name + "\n" + emailAddress + "\n" + message);
MailApp.sendEmail(adminAdress, subject, message);
sheet.getRange(startRow + parseInt(i), 9).setValue(1);
}
}
}
どんだけ頑張っても「OSC did not start」となってしまいUSBの初期化ができない。
なぜかと思って調べてみるとUSBホストシールド2.0からリセット信号の回路上での取り回しが変わっている（D7からRSTへ）
そのため、ライブラリ2.0はSparkfun製のシールドでは使えないとのことです。
しかし、ここでも記載がありますが、配線を変えることでSparkfun製のシールドでも使えます。
D7から伸びる信号線をカットし、RSTから信号を取り回す改造をすることで無事初期化ができることを確認しました。
./arduino
Experimental: JNI_OnLoad called.
Stable Library
=========================================
Native lib Version = RXTX-2.1-7
Java lib Version = RXTX-2.1-7
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
check_group_uucp(): error testing lock file creation Error details:許可がありませんcheck_lock_status: No permission to create lock file.
please see: How can I use Lock Files with rxtx? in INSTALL
やはり、sudoで起動するとエラーは出なかった。
sudo ./arduino
[sudo] password for naoki:
Experimental: JNI_OnLoad called.
Stable Library
=========================================
Native lib Version = RXTX-2.1-7
Java lib Version = RXTX-2.1-7
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [82:13644]
:RH-Firewall-1-INPUT - [0:0]
-A INPUT -j RH-Firewall-1-INPUT
-A FORWARD -j RH-Firewall-1-INPUT
-A RH-Firewall-1-INPUT -i lo -j ACCEPT
-A RH-Firewall-1-INPUT -p icmp -m icmp --icmp-type any -j ACCEPT
-A RH-Firewall-1-INPUT -p esp -j ACCEPT
-A RH-Firewall-1-INPUT -p ah -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
-A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 8080 -j ACCEPT
-A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 8009 -j ACCEPT
-A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT
-A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 20022 -j ACCEPT
-A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 20021 -j ACCEPT
-A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 20025 -j ACCEPT
-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited
COMMIT
で、jenkinsの起動
$ sudo service jenkins start
Starting Jenkins [ OK ]
はい。この[ OK ]に騙されていました。
プロセスを確認してみるとjenkinsが動いとりません。
$ sudo ps -x
なんでかなぁと思い、みやびーに聞いた所、直接jenkinsを起動してみろとのこと。
$ cd /usr/lib/jenkins
$ java -jar jenkins.war
Running from: jenkins.war
webroot: $user.home/.jenkins
2012/04/25 23:36:19 winstone.Logger logInternal
INFO: Beginning extraction from war file
2012/04/25 23:36:22 hudson.WebAppMain contextInitialized
SEVERE: Failed to initialize Jenkins
java.lang.ExceptionInInitializerError
at java.lang.Class.initializeClass(libgcj.so.10)
at hudson.WebAppMain.installLogger(WebAppMain.java:256)
at hudson.WebAppMain.contextInitialized(WebAppMain.java:107)
at winstone.WebAppConfiguration.(WebAppConfiguration.java:875)
at winstone.HostConfiguration.initWebApp(HostConfiguration.java:129)
at winstone.HostConfiguration.(HostConfiguration.java:71)
at winstone.HostGroup.initHost(HostGroup.java:87)
at winstone.HostGroup.(HostGroup.java:47)
at winstone.Launcher.(Launcher.java:177)
at winstone.Launcher.main(Launcher.java:384)
at java.lang.reflect.Method.invoke(libgcj.so.10)
at Main._main(Main.java:273)
at Main.main(Main.java:98)
Caused by: java.lang.NullPointerException
at com.thoughtworks.xstream.core.JVM.isOpenJDK(JVM.java:72)
at com.thoughtworks.xstream.core.JVM.canUseSun14ReflectionProvider(JVM.java:198)
at com.thoughtworks.xstream.core.JVM.bestReflectionProvider(JVM.java:175)
at com.thoughtworks.xstream.XStream.(XStream.java:431)
at com.thoughtworks.xstream.XStream.(XStream.java:385)
at com.thoughtworks.xstream.XStream.(XStream.java:323)
at hudson.util.XStream2.(XStream2.java:75)
at jenkins.model.Jenkins.(Jenkins.java:3677)
at java.lang.Class.initializeClass(libgcj.so.10)
...12 more
2012/04/25 23:36:22 winstone.Logger logInternal
SEVERE: Error during context startup for webapp webapp
java.lang.ExceptionInInitializerError
at java.lang.Class.initializeClass(libgcj.so.10)
at hudson.WebAppMain.installLogger(WebAppMain.java:256)
at hudson.WebAppMain.contextInitialized(WebAppMain.java:107)
at winstone.WebAppConfiguration.(WebAppConfiguration.java:875)
at winstone.HostConfiguration.initWebApp(HostConfiguration.java:129)
at winstone.HostConfiguration.(HostConfiguration.java:71)
at winstone.HostGroup.initHost(HostGroup.java:87)
at winstone.HostGroup.(HostGroup.java:47)
at winstone.Launcher.(Launcher.java:177)
at winstone.Launcher.main(Launcher.java:384)
at java.lang.reflect.Method.invoke(libgcj.so.10)
at Main._main(Main.java:273)
at Main.main(Main.java:98)
Caused by: java.lang.NullPointerException
at com.thoughtworks.xstream.core.JVM.isOpenJDK(JVM.java:72)
at com.thoughtworks.xstream.core.JVM.canUseSun14ReflectionProvider(JVM.java:198)
at com.thoughtworks.xstream.core.JVM.bestReflectionProvider(JVM.java:175)
at com.thoughtworks.xstream.XStream.(XStream.java:431)
at com.thoughtworks.xstream.XStream.(XStream.java:385)
at com.thoughtworks.xstream.XStream.(XStream.java:323)
at hudson.util.XStream2.(XStream2.java:75)
at jenkins.model.Jenkins.(Jenkins.java:3677)
at java.lang.Class.initializeClass(libgcj.so.10)
...12 more
2012/04/25 23:36:22 winstone.Logger logInternal
INFO: HTTP Listener started: port=8080
2012/04/25 23:36:22 winstone.Logger logInternal
INFO: AJP13 Listener started: port=8009
2012/04/25 23:36:22 winstone.Logger logInternal
SEVERE: Error during servlet context shutdown
java.lang.NoClassDefFoundError: jenkins.model.Jenkins
at java.lang.Class.initializeClass(libgcj.so.10)
at hudson.WebAppMain.contextDestroyed(WebAppMain.java:339)
at winstone.WebAppConfiguration.destroy(WebAppConfiguration.java:1149)
at winstone.HostConfiguration.destroyWebApp(HostConfiguration.java:148)
at winstone.HostConfiguration.destroy(HostConfiguration.java:156)
at winstone.HostGroup.destroy(HostGroup.java:77)
at winstone.Launcher.shutdown(Launcher.java:337)
at winstone.Launcher.(Launcher.java:199)
at winstone.Launcher.main(Launcher.java:384)
at java.lang.reflect.Method.invoke(libgcj.so.10)
at Main._main(Main.java:273)
at Main.main(Main.java:98)
2012/04/25 23:36:22 winstone.Logger logInternal
INFO: Winstone shutdown successfully
2012/04/25 23:36:22 winstone.Logger logInternal
SEVERE: Container startup failed
java.io.IOException: Failed to start a listener: winstone.ssl.HttpsListener
at winstone.Launcher.spawnListener(Launcher.java:229)
at winstone.Launcher.(Launcher.java:185)
at winstone.Launcher.main(Launcher.java:384)
at java.lang.reflect.Method.invoke(libgcj.so.10)
at Main._main(Main.java:273)
at Main.main(Main.java:98)
Caused by: java.lang.NoClassDefFoundError: winstone.ssl.HttpsListener
at java.lang.Class.initializeClass(libgcj.so.10)
at java.lang.Class.forName(libgcj.so.10)
at winstone.Launcher.spawnListener(Launcher.java:213)
...5 more
Caused by: java.lang.ClassNotFoundException: sun.security.util.DerValue not found in java.net.URLClassLoader{urls=[file:/tmp/winstoneplgbf6jar], parent=gnu.gcj.runtime.SystemClassLoader{urls=[file:jenkins.war], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}}
at java.net.URLClassLoader.findClass(libgcj.so.10)
at java.lang.ClassLoader.loadClass(libgcj.so.10)
at java.lang.ClassLoader.loadClass(libgcj.so.10)
at java.lang.Class.initializeClass(libgcj.so.10)
...7 more
を遠隔操作しました。
