546
edits
WebAOM: Difference between revisions
Jump to navigation
Jump to search
m
→Local database
(added source link) |
Epoximator (talk | contribs) m (→Local database) |
||
| Line 190: | Line 190: | ||
* Download and install [http://www.postgresql.org/download/ postgresql] or [http://dev.mysql.com/downloads/mysql/5.0.html mysql]. Be sure to select unicode support. | * Download and install [http://www.postgresql.org/download/ postgresql] or [http://dev.mysql.com/downloads/mysql/5.0.html mysql]. Be sure to select unicode support. | ||
* Download the JDBC Driver for [http://jdbc.postgresql.org/download.html postgresql] or [http://dev.mysql.com/downloads/connector/j/3.1.html mysql] and extract the .jar file to '{java path}/jre{version}/lib/ext'. | * Download the JDBC Driver for [http://jdbc.postgresql.org/download.html postgresql] or [http://dev.mysql.com/downloads/connector/j/3.1.html mysql] and extract the .jar file to '{java path}/jre{version}/lib/ext'. | ||
* Create the database: | * Create the database: | ||
: postgre: | |||
:* psql template1 {usr} | |||
:* create database {webaom}; \q | |||
: mysql: | |||
:* mysql -u{usr} -p{psw} | :* mysql -u{usr} -p{psw} | ||
:* create database {webaom}; exit; | :* create database {webaom}; exit; | ||
* Start WebAOM and write the jdbc url into the 'My Database' field: "jdbc:{mysql|postgre}://{host}[:port]/{webaom}[?user={usr}][&password={psw}] | |||
* Start WebAOM and write the jdbc url into the 'My Database' field: "jdbc:mysql://{host}/{webaom}[?user={usr}][&password={psw}] | |||
:* {host} is the url or ip to the host. (localhost/127.0.0.1) | :* {host} is the url or ip to the host. (localhost/127.0.0.1) | ||
:* {webaom} is the name of the database. Can be what ever you like. | :* {webaom} is the name of the database. Can be what ever you like. | ||
| Line 203: | Line 205: | ||
:* This must be done every time you start WebAOM. Should be done before adding any files. | :* This must be done every time you start WebAOM. Should be done before adding any files. | ||
:* All jobs in db that are not finished will be loaded at this point. | :* All jobs in db that are not finished will be loaded at this point. | ||
:* If you want to load info on finished files you must use the Add file/folder buttons. | :* If you want to load info on finished files you must use the Add file/folder buttons. (It's also possible to load all the jobs by adding ! in front of the jdbc url.) | ||
== Changelog == | == Changelog == | ||