apt-get install nginx php-fpm php-mysql
apt-get install mariadb-server-10.0
apt-get install git
apt-get install lib32z1 # for rainbow
mysql -u root -e "CREATE USER 'tracenoizer'@'localhost' IDENTIFIED BY 'somerandompassword';"
mysql -u root -e "GRANT ALL PRIVILEGES ON * . * TO 'tracenoizer'@'localhost';"
mysql -u root mysql -e "select * from user;"
mysql -u root -e "create database tracenoizer;"
sed 's/MyISAM/INNODB/g' tracenoizer.sql > tracenoizer_innodb.sql
mysql -u root tracenoizer < tracenoizer_innodb.sql
do set a root password for mysql!
mysql -u root mysql -e "update user set authentication_string=PASSWORD('"password"') where User='root'; flush privileges;"
mysql -u root tracenoizer -e "show tables;"
mysql -u root tracenoizer -e "drop database tracenoizer"
On an old server tracenoizer.net was running until August 9. 2011. (Date from a .log file timestamp). This version was not working, because search API was defunct for years.
- Code was not polished in any way to look good.
- Biggest change code wise: centralization of DB-Connection / Google API / Handling of GET/POST in PHP
- Security was enhanced in parts, where code had to be touched anyway. I tried to make it in the part, where new code is used, to keep most old code intact.
Now confidential configurations like db connection and API keys are not hard coded and written down in several files anymore.
config.ini is the file where db config and api keys are stored, see tracenoizer.net/config.ini.example
now mysqli_ is used, not outdated mysql_ used
see tracenoizer.net/db_connect.php
In the old days $var could be used directly from url?var=test. Since years PHP only allows $_GET['var'] or $_POST['var']
see below
see below
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'll do our best to improve things and get you the information you need. . Franz M' at line 1 at trace_centralV4.pl line 860.
Using Config::IniFiles from cpan (https://metacpan.org/pod/Config::IniFiles)
cpan
to see all installed modules, use this
cpan -l
install Config::IniFiles
- https://metacpan.org/pod/WWW::Google::CustomSearch
- https://metacpan.org/pod/WWW::Google::CustomSearch::Result
- https://metacpan.org/pod/WWW::Google::CustomSearch::Item
Installation of Google CostumSearch for perl
cpan
install WWW::Google::CustomSearch
Account of [email protected] (Do not send any mail to this account, its not checked)
-
Public Search: https://cse.google.com/cse?cx=005586137235572118471:emva1jwhri4
-
API Call Stats: https://console.developers.google.com/apis/dashboard?folder&project=tracenoizer
For every run there are two searches, "forename surname" and "surname forename"
puff cannot get https content, so replaced with curl in fc2374dfcc58f149bea3109ff5bc9d2620cd55dd
puf is able to download in parallel, thus faster than wget or curl
in 2001 tracenoizer used puf-0.9.1beta6.tar
see install_tracnoizer.tar for original software used or here https://sourceforge.net/projects/puf/
tar -zxf puf-1.0.0.tar.gz cd puf-1.0.0 ./configure make cd src ./puf -h make install
Rainbow is a program that performs statistical text classification.
Documentation:
- https://www.cs.cmu.edu/~mccallum/bow/rainbow/
- http://archive.is/Wjp6o
- http://archive.is/download/Wjp6o.zip
Source Code:
- http://www.cs.cmu.edu/~mccallum/bow/src/
- http://archive.is/otho7
- http://archive.is/download/otho7.zip
I have a compiled version from 2003, after installing some 32 bit library I was able to run rainbow on Ubuntu 14 LTS (3.13.0-142-generic)
tracenoizer/tracenoizer.net/public_html/rainbow
apt-get install lib32z1
Rainbow is not to compile with gcc version 5 on Ubuntu 14 LTS. There are some errors. By uncommenting them, I was able to reduce them, but was not able to get a executable code. And even there would be some function missing. Also, code failed to compile with older gcc version.
wget http://www.cs.cmu.edu/~mccallum/bow/src/bow-20020213.tar.gz tar -zxf bow-20020213.tar.gz cd bow-20020213 CPPFLAGS='-w' CC='gcc -traditional' ./configure --prefix=/usr/local/ make
make throws this error:
^./bow/libbow.h: At top level: ./bow/libbow.h:2071:26: error: array type has incomplete element type ‘struct argp_child’ extern struct argp_child bow_argp_children[]; ^ array.c: In function ‘bow_array_new_with_entry_size_from_data_fp’: ./bow/libbow.h:1591:5: warning: function with qualified void return type called _bow_error (FORMAT , ## ARGS); \ ^ array.c:195:4: note: in expansion of macro ‘bow_error’ bow_error ("Proper header not found in file."); ^ Makefile:90: recipe for target 'array.o' failed make: *** [array.o] Error
perl trace_centralV4.pl 14 'Franz Mueller'
http://tracenoizer.net/control_firstV4.php?userID=4
2001:
- 2002 Kontrollfelder - Programmieren als künstlerische Praxis, hartware medien kunst verein in Dortmund/Deutschland (020227_tracenoizer_mailingliste)