Difference between revisions of "Set up an internet cafe"
(problem only occurs on mac) |
|||
| Line 10: | Line 10: | ||
*A back-end library to abstract all database work out for ease of maintenance and stability across the various components.ok | *A back-end library to abstract all database work out for ease of maintenance and stability across the various components.ok | ||
| − | == | + | == Postgresql Configruation == |
Add an entry to ''/etc/postgresql/8.3/main/pg_hba.conf'' to allow plaintext password connections over TCP/IP from any workstations: | Add an entry to ''/etc/postgresql/8.3/main/pg_hba.conf'' to allow plaintext password connections over TCP/IP from any workstations: | ||
host all all 127.0.0.1/32 password | host all all 127.0.0.1/32 password | ||
| Line 16: | Line 16: | ||
Set ''listen_addresses'' to '*' in ''/etc/postgresql/8.3/main/postgresql.conf'' | Set ''listen_addresses'' to '*' in ''/etc/postgresql/8.3/main/postgresql.conf'' | ||
| − | sudo -u postgres createuser -D -A -P | + | Create a Postgresql outkafe user and database: |
| − | sudo -u postgres createdb -E utf8 -O | + | sudo -u postgres createuser -D -A -P outkafe-user |
| + | sudo -u postgres createdb -E utf8 -O outkafe-user outkafe | ||
| + | |||
| + | Populate the ''outkafe'' database from the [http://outkastsolutions.co.za/outkast/index.php?option=com_docman&task=doc_download&gid=4&Itemid=31 outkafe.sql] schema file. | ||
sudo -u postgres psql -e outkast < outkafe.sql | sudo -u postgres psql -e outkast < outkafe.sql | ||
Use ''--keep'' to analyse the files before installation | Use ''--keep'' to analyse the files before installation | ||
| + | |||
| + | == Outkafe installation == | ||
| + | Under normal circumstances, the installer (download [http://outkastsolutions.co.za/outkast/index.php?option=com_docman&task=doc_download&gid=6&Itemid=31 here], or [http://outkastsolutions.co.za/outkast/index.php?option=com_docman&task=doc_download&gid=6&Itemid=31 64bit]) can be extracted and executed. This installer will ask for the database username and password which were created above. | ||
| + | |||
| + | == Mac install problem == | ||
| + | On a Macbook running Ubuntu we had a problem of ''libpq.so.4'' not being found. To get round this run the installer from shell with the ''--keep'' option so that the extracted files remain in a ''setup'' directory instead of being deleted, then edit the ''setup/setup.sh'' file and comment out or delete the following lines: | ||
| + | <bash> | ||
| + | if ldd $WHERE/files/outkafe | grep "not" ; then | ||
| + | ldd $WHERE/files/outkafe | grep "not" >> $WHERE/messages/dep.msg | ||
| + | ./installergui message "Missing dependency" $WHERE/messages/dep.msg "outkafe Installer" $WHERE/dyk/dyk1.msg | ||
| + | exit | ||
| + | fi | ||
| + | </bash> | ||
== See also == | == See also == | ||
| + | *[http://www.outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=45&id=outkafe About] | ||
*[http://outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=&id=outkafe:installation Installation manual] | *[http://outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=&id=outkafe:installation Installation manual] | ||
*[http://outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=&id=outkafe:administration Admin manual] | *[http://outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=&id=outkafe:administration Admin manual] | ||
*[http://outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=&id=outkafe:howtos HOWTO's] | *[http://outkastsolutions.co.za/outkast/index.php?option=com_openwiki&Itemid=&id=outkafe:howtos HOWTO's] | ||
| − | |||
*[http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html The pg_hba.conf file] | *[http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html The pg_hba.conf file] | ||
Revision as of 10:20, 29 September 2008
|
Set up an internet cafe Organic Design procedure |
In order to achieve it goals OutKafe comprises a number of core components:
- A server-daemon for counting time down centrally outkafed
- A management console where you can add time, kick users, define special offers etc. outkafe-admin
- A number of platform specific clients apps which control login on your terminals including clients for linux and windows
- A central database server (currently only postgresql is supported)
- A back-end library to abstract all database work out for ease of maintenance and stability across the various components.ok
Postgresql Configruation
Add an entry to /etc/postgresql/8.3/main/pg_hba.conf to allow plaintext password connections over TCP/IP from any workstations:
host all all 127.0.0.1/32 password
Set listen_addresses to '*' in /etc/postgresql/8.3/main/postgresql.conf
Create a Postgresql outkafe user and database:
sudo -u postgres createuser -D -A -P outkafe-user sudo -u postgres createdb -E utf8 -O outkafe-user outkafe
Populate the outkafe database from the outkafe.sql schema file.
sudo -u postgres psql -e outkast < outkafe.sql
Use --keep to analyse the files before installation
Outkafe installation
Under normal circumstances, the installer (download here, or 64bit) can be extracted and executed. This installer will ask for the database username and password which were created above.
Mac install problem
On a Macbook running Ubuntu we had a problem of libpq.so.4 not being found. To get round this run the installer from shell with the --keep option so that the extracted files remain in a setup directory instead of being deleted, then edit the setup/setup.sh file and comment out or delete the following lines: <bash> if ldd $WHERE/files/outkafe | grep "not" ; then ldd $WHERE/files/outkafe | grep "not" >> $WHERE/messages/dep.msg ./installergui message "Missing dependency" $WHERE/messages/dep.msg "outkafe Installer" $WHERE/dyk/dyk1.msg exit fi </bash>
