summaryrefslogtreecommitdiff
path: root/share/install
diff options
context:
space:
mode:
Diffstat (limited to 'share/install')
-rw-r--r--share/install/database/database_create_statements3
-rw-r--r--share/install/database/database_schema.sql15
-rw-r--r--share/install/pb_nginx.conf22
3 files changed, 40 insertions, 0 deletions
diff --git a/share/install/database/database_create_statements b/share/install/database/database_create_statements
new file mode 100644
index 0000000..9fa9e39
--- /dev/null
+++ b/share/install/database/database_create_statements
@@ -0,0 +1,3 @@
+create database if not exists asdfus;
+grant all privileges on asdfus.* to asdfus@localhost identified by 'gTYgT&M6q';
+flush privileges;
diff --git a/share/install/database/database_schema.sql b/share/install/database/database_schema.sql
new file mode 100644
index 0000000..802aa49
--- /dev/null
+++ b/share/install/database/database_schema.sql
@@ -0,0 +1,15 @@
+CREATE TABLE if not exists `im_cmd` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `date` int(11) DEFAULT NULL,
+ `remote_addr` varchar(16) DEFAULT NULL,
+ `name` varchar(16) DEFAULT NULL,
+ `url` varchar(256) DEFAULT NULL,
+ `dir` varchar(2) DEFAULT NULL,
+ `oldfile` varchar(256) DEFAULT NULL,
+ `newfile` varchar(256) DEFAULT NULL,
+ `cmd` blob,
+ `dataobj` blob,
+ `tag` varchar(50) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=386739 DEFAULT CHARSET=utf8;
+
diff --git a/share/install/pb_nginx.conf b/share/install/pb_nginx.conf
new file mode 100644
index 0000000..994f69a
--- /dev/null
+++ b/share/install/pb_nginx.conf
@@ -0,0 +1,22 @@
+server {
+
+ server_name asdf.us *.asdf.us;
+
+ access_log /var/www/asdf.us/logs/nginx.access.log;
+ location / {
+ proxy_pass http://asdf.us:8002;
+ client_max_body_size 2252K;
+ }
+ location /im/api {
+ include fastcgi_params;
+ fastcgi_split_path_info ^()(.*)$;
+ fastcgi_param PATH_INFO $document_uri;
+ fastcgi_param QUERY_STRING $document_uri;
+ fastcgi_param HTTP_X_FORWARDED_HOST "asdf.us";
+ fastcgi_pass localhost:8999;
+ }
+ location /donjuan/data/ {
+ rewrite ^/donjuan/data/(.*) http://i.asdf.us/donjuan_data/$1 permanent;
+ }
+}
+