ARP Database Notes

Software configuration for commodity x86/86_64 linux art research platform.

Prerequisites

Assume Fedora 27. See base document for full software stack.

Database Setup 1: server mysql

Both the wiki and wordpress require a database. So, pick the MySQL database, which is packaged as mariadb on Fedora. Project page for MariaDB.

dnf install -y mariadb mariadb-server php-mysqlnd phpMyAdmin

Secure it (and set the root password on the database) with

mysql_secure_installation

And enable and start it via

systemctl enable mariadb.service
systemctl start mariadb.service

To use the web-ui to administer, go to

http://localhost/phpmyadmin/

Configuration file is: /etc/my.cnf
Log file is:/var/log/mariadb/mariadb.log
The site files are in prefix:/var/lib/mysql

Database Setup 2: per-user postgressql

For non-platform use, aka for individual users, pick the glom front-end for the postgres database. Some platform notes are here.

dnf install -y postgresql postgresql-server postgresql-libs postgresql-contrib phpPgAdmin

Initialize the database

postgresql-setup --initdb --unit postgresql

Then enable and start

systemctl enable postgresql
systemctl start postgresql

To use the web-ui to administer, go to

http://localhost:8080/phppgadmin

There is a graphical database called glom that is similar to FileMakerPro on the mac and Access on windows.

dnf install -y glom
Advertisements

Artistic Research Platform Notes

Software configuration for commodity x86/86_64 linux art research platform.

Prerequisites

Assume Fedora 27.

Background

The wide variety of web and print platforms for contemporary artistic research can be found at the survey.

Components

  1. Database
  2. Webserver
  3. Content Management System
  4. Wiki
  5. Etherpad
  6. IPFS

iAM/iCAN CJ Redux

sky.(selectionS+).32

iAM/iCAN is a multimedia documentary shot in Austin, Texas in 1994. It featured tagged/searchable video embedded into a raster graphic interface. Five subjects discussed gender, race, nascent-on-line culture, technology, hopes and dreams for the future. Given the technical constraints of the time, this meant 4:3 aspect video compressed to a rather severe 160 x 160 pixels, so that streaming off of a state-of-the-art 2x cd-rom player was feasible. Video was shot by Shane Herman, and edited with Premiere. An interface was coded in Director. We called it New Media but didn’t really even understand the Old Medias.

background(james)

Years later, the video is small and grainy and the interface elements seem rather small, but still pretty. The audio is still quite powerful. The interface doesn’t work anymore but the individual graphic elements can be clicked on and the original files are still valid. Still holding interest: the audio, the actual interviews.

Here are all the interviews with CJ Manetta-Romano, who has fearlessly given permission to share his commentary from 1994.


Politics, Working Together, Unity


Interactive Entertainment, Technology as Adult Toys


Internet Culture


Was Intimidated by Technology


Future Interactive Education


Gender Generation Gap


Gender Stereotypes and Rave Flyers


Anarchy, Raves as Free Space


Future Raves, After Raves