apt-get install postgresql
PostgreSQL databases can be created with any one of a number of different character encodings. Please choose the default encoding, which will be used for all newly-created databases in the absence of a specific encoding specification. The choices are: SQL_ASCII ASCII EUC_JP Japanese EUC EUC_CN Chinese EUC EUC_KR Korean EUC EUC_TW Taiwan EUC UNICODE Unicode(UTF-8) MULE_INTERNAL Mule internal LATIN1 ISO 8859-1 English and some European languages LATIN2 ISO 8859-2 English and some European languages LATIN3 ISO 8859-3 English and some European languages LATIN4 ISO 8859-4 English and some European languages LATIN5 ISO 8859-5 English and some European languages LATIN6 ISO 8859-10 ECMA-144 Latin Alphabet No.6 LATIN7 ISO 8859-13 Latin Alphabet No.7 LATIN8 ISO 8859-14 Latin Alphabet No.8 LATIN9 ISO 8859-15 Latin Alphabet No.9 LATIN10 ISO 8859-16 ASRO SR 14111 Latin Alphabet No.10 ISO-8859-5 ECMA-113 Latin/Cyrillic ISO-8859-6 ECMA-114 Latin/Arabic ISO-8859-7 ECMA-118 Latin/Greek ISO-8859-8 ECMA-121 Latin/Hebrew KOI8 KOI8-R WIN Windows CP1251 ALT Windows CP866 Enter default encoding (SQL_ASCII): LATIN2 You need to specify the locale under which the postmaster will run. (This mainly affects the sorting of text. Use of any locale but C will reduce the efficiency of index access; however, it will also force sorting by ASCII code rather than by national collating order.) You have the following locales enabled in your system: pl_PL Select locale [C]: pl_PL
Phpgroupware może zostać zainstalowane z paczek lub ręcznie - z tar.bz2.
asterix:# apt-get install phpgroupware* Reading Package Lists... Done Building Dependency Tree... Done The following extra packages will be installed: imagemagick libdps1 liblcms libmagick5 libtiff3g libwmf0.2-2 libxml2 phpgroupware phpgroupware-addressbook phpgroupware-admin phpgroupware-api phpgroupware-api-doc phpgroupware-bookkeeping phpgroupware-bookmarks phpgroupware-brewer phpgroupware-calendar phpgroupware-chat phpgroupware-chora phpgroupware-comic phpgroupware-core phpgroupware-core-doc phpgroupware-developer-tools phpgroupware-dj phpgroupware-eldaptir phpgroupware-email phpgroupware-filemanager phpgroupware-forum phpgroupware-ftp phpgroupware-headlines phpgroupware-hr phpgroupware-img phpgroupware-infolog phpgroupware-inv phpgroupware-manual phpgroupware-messenger phpgroupware-napster phpgroupware-news-admin phpgroupware-nntp phpgroupware-notes phpgroupware-phonelog phpgroupware-phpsysinfo phpgroupware-phpwebhosting phpgroupware-polls phpgroupware-preferences phpgroupware-projects phpgroupware-registration phpgroupware-setup phpgroupware-skel phpgroupware-soap phpgroupware-stocks phpgroupware-todo phpgroupware-tts phpgroupware-wap phpgroupware-weather phpgroupware-xmlrpc The following NEW packages will be installed: imagemagick libdps1 liblcms libmagick5 libtiff3g libwmf0.2-2 libxml2 phpgroupware phpgroupware-addressbook phpgroupware-admin phpgroupware-api phpgroupware-api-doc phpgroupware-bookkeeping phpgroupware-bookmarks phpgroupware-brewer phpgroupware-calendar phpgroupware-chat phpgroupware-chora phpgroupware-comic phpgroupware-core phpgroupware-core-doc phpgroupware-developer-tools phpgroupware-dj phpgroupware-eldaptir phpgroupware-email phpgroupware-filemanager phpgroupware-forum phpgroupware-ftp phpgroupware-headlines phpgroupware-hr phpgroupware-img phpgroupware-infolog phpgroupware-inv phpgroupware-manual phpgroupware-messenger phpgroupware-napster phpgroupware-news-admin phpgroupware-nntp phpgroupware-notes phpgroupware-phonelog phpgroupware-phpsysinfo phpgroupware-phpwebhosting phpgroupware-polls phpgroupware-preferences phpgroupware-projects phpgroupware-registration phpgroupware-setup phpgroupware-skel phpgroupware-soap phpgroupware-stocks phpgroupware-todo phpgroupware-tts phpgroupware-wap phpgroupware-weather phpgroupware-xmlrpc postgresql 0 packages upgraded, 56 newly installed, 0 to remove and 0 not upgraded. Need to get 10.5MB of archives. After unpacking 45.8MB will be used. Do you want to continue? [Y/n] phpGroupWare supports any web server that php3/php4 does, but this configuration process only supports Apache and Apache-SSL. Feel free to submit any hint or patch that would help me in the setup of other Web Servers to phpgroupware@packages.qa.debian.org or wwwconfig-common@packages.qa.debian.org Which Web Server are you running? Apache Apache-ssl Both None 'Header Admin', is the section in which the phpGroupWare administrator can define the information which will let the application to 'start' (i.e. DBMS settings, directories location etc.) Please, insert phpGroupWare 'Header Admin' password: Tajnehasłonumer1 The 'Setup/Config Admin' is the section in which the phpGroupWare administrator access the following facilities: (1) Simple Application Management (2) Configuration (general) (3) Language Management (4) Advanced Application Management Please, insert the phpGroupWare 'Setup/Config Admin' password: Tajnehasłonumer2 phpGroupWare DB setup NOTE. Now you should specify the DBMS settings. You must provide the host name on which the DBMS server is installed, the type (i.e. PostgresQL, MySql, mSQL etc.), the DB name, the DBMS administrator user-name, etc. phpGroupWare This is the name (and so the type) of The DBMS you will use. NOTE: Debian only support PostgresQL and MySql for automatic system configuration. Other DBMS are either no more, not yet supported or proprietary one. Please, select phpGroupWare DB type: PostgresQL MySql mSQL Sybase Oracle MicrosoftSQL ODBC Compliant none This should be the host-name or IP address that phpGroupWare will use to access the DB. Please, insert phpGroupWare DB host name: localhost This user-name will be used to access the DBMS to create (if needed): (1) The DB (2) The new DBMS account that phpGroupWare will use to access the DB It should be 'postgres' for PostgresQL or 'root' for MySql. Please, insert the DBMS administrator user-name: postgres This is the password that will be used along with the DBMS administrator user-name. NOTE: This password will not be asked twice, since it's not a new password. Please, insert the DBMS administrator password (if any): tajnehasłodlapostgresa This is the name of the DB that phpGroupWare will use. Please, insert phpGroupWare DB name: phpgroupware This is the user-name that phpGroupWare will use to access the DB. Please, insert the DBMS user-name to access the DB: phpgroupware This is the password that phpGroupWare will use, along with user-name you provided, to access the DB. Please, insert the password to access the DB: Tajnehasłodobazy Please insert the DB access password again. If the password you are going to retype mismatch the previous inserted one, I'll ask you to insert them again. Please, retype the password to access the DB: Tajnehasłodobazy Datas subjected to this question are the DBMS account, the DB and the phpGroupWare users ang group files. Do I have to delete ALL datas whenever the the phpgroupware package will be completely removed from the system? Delete ALL? No
Pobieramy wybraną wersję PhpGroupWare z 
http://phpgroupware.org/downloads:
cd /tmp
Rozpakowujemy archiwum do /usr/share/phpgroupware:
tar -xjf phpgroupware-0.9.16RC3.tar.bz2 -C /usr/share/
Nadanie praw itp:
chown -R root:www-data /usr/share/phpgroupware/ chmod -R 750 /usr/share/phpgroupware/
vim /etc/postgresql/pg_hba.conf
Zamieniamy:
local all ident sameuser host all 127.0.0.1 255.0.0.0 ident sameuser
na:
local all password host all 127.0.0.1 255.0.0.0 password
su - postgres
postgres@asterix:$ createuser -D -A -P phpgroupware Enter password for user "phpgroupware":Tajnehasłodobazy Enter it again:Tajnehasłodobazy CREATE USER
postgres@asterix:$ createdb phpgroupware CREATE DATABASE
Restart pgsql:
asterix:# /etc/init.d/postgresql restart Restarting PostgreSQL database: postmaster Stopped /usr/lib/postgresql/bin/postmaster (pid 23243 23245 23247). Starting PostgreSQL postmaster. postmaster successfully started . asterix:#
Pozostaje dopisanie rekordu CNAME do strefy, restart binda, oraz dodanie do apacha do pliku /etc/apache/httpd.conf:
<IfModule mod_dir.c>
DirectoryIndex index.php index.html index.htm index.shtml index.cgi
</IfModule>
<VirtualHost 212.160.33.149>
ServerAdmin webmaster@asterix.wonder.pl
DocumentRoot /usr/share/phpgroupware/
ServerName phpgw.asterix.wonder.pl
ErrorLog /var/log/apache/error.log
CustomLog /var/log/apache/access.log combined
</VirtualHost>
Restart Apacha:
/etc/init.d/apache restart
Odpalamy przeglądarkę i wpisujemy adres: http://phpgw.asterix.wonder.pl/setup/
Możemy również ręcznie wyedytować plik (w przypadku ręcznej instalacji plik ten należy stworzyć poprzez skopiowanie go z /usr/share/phpgroupware/header.inc.php.template):
asterix:# vim /usr/share/phpgroupware/header.inc.php
$GLOBALS['phpgw_domain']['default'] = array (
'db_host' => 'localhost',
'db_name' => 'phpgroupware',
'db_user' => 'phpgroupware',
'db_pass' => 'Tajnehasłodobazy',
// Look at the README file
'db_type' => 'pgsql',
11.01.2004 - LiNiO - dodany opis instalacji "ręcznej" 12.06.2002 - Robert LiNiO Litwiniec, Tomasz Pawelec,linio@gnu.pl
Ostatnio zmieniana Friday, April 6, 2007 9:33:27 am.
|
|
Książki informatyczne na allegro (używane) - OKAZJA !!!
|
 |
|