个人工具

“UbuntuHelp:QuasarAccountingInstallation”的版本间的差异

来自Ubuntu中文

跳转至: 导航, 搜索
(New page: {{From|https://help.ubuntu.com/community/QuasarAccountingInstallation}} {{Languages|php5}} == Introduction == Quasar is accounting software for Linux. It's powerful and easy to use – ...)
 
第20行: 第20行:
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo apt-get install build-essential libqt3-mt-dev tcl8.4-dev tk8.4-dev libpq-dev qt3-apps-dev postgresql-8.1 libicu34-dev xinetd postgresql-server-dev-8.1
 
sudo apt-get install build-essential libqt3-mt-dev tcl8.4-dev tk8.4-dev libpq-dev qt3-apps-dev postgresql-8.1 libicu34-dev xinetd postgresql-server-dev-8.1
</nowiki></code>
+
</nowiki></pre>
  
 
For Feisty (version 7.04):
 
For Feisty (version 7.04):
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo apt-get install build-essential libqt3-mt-dev tcl8.4-dev tk8.4-dev libpq-dev qt3-apps-dev postgresql-8.2 libicu34-dev xinetd postgresql-server-dev-8.2
 
sudo apt-get install build-essential libqt3-mt-dev tcl8.4-dev tk8.4-dev libpq-dev qt3-apps-dev postgresql-8.2 libicu34-dev xinetd postgresql-server-dev-8.2
</nowiki></code>
+
</nowiki></pre>
  
 
And then:
 
And then:
第34行: 第34行:
 
./configure
 
./configure
 
make
 
make
</nowiki></code>
+
</nowiki></pre>
  
 
Unfortunately, it's necessary to modify the install script before proceeding (if you prefer, replace nano with a different text editor such as Gedit or Kate):
 
Unfortunately, it's necessary to modify the install script before proceeding (if you prefer, replace nano with a different text editor such as Gedit or Kate):
第40行: 第40行:
 
<pre><nowiki>
 
<pre><nowiki>
 
nano install
 
nano install
</nowiki></code>
+
</nowiki></pre>
  
 
Edit the first line to look like this:
 
Edit the first line to look like this:
第46行: 第46行:
 
<pre><nowiki>
 
<pre><nowiki>
 
#!/bin/bash
 
#!/bin/bash
</nowiki></code>
+
</nowiki></pre>
  
 
You can now complete installation with this command:
 
You can now complete installation with this command:
第52行: 第52行:
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo make install
 
sudo make install
</nowiki></code>
+
</nowiki></pre>
  
 
Quasar installs itself to /opt rather than the Ubuntu standard for user-installed software of /usr/local, so you can't start it without entering the full path to the executable file.  That doesn't matter too much, though, as we're going to create our own Gnome menu entries and /opt survives intact when you upgrade to a new Ubuntu release.  
 
Quasar installs itself to /opt rather than the Ubuntu standard for user-installed software of /usr/local, so you can't start it without entering the full path to the executable file.  That doesn't matter too much, though, as we're going to create our own Gnome menu entries and /opt survives intact when you upgrade to a new Ubuntu release.  
第62行: 第62行:
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo nano /usr/share/applications/Quasar.desktop
 
sudo nano /usr/share/applications/Quasar.desktop
</nowiki></code>
+
</nowiki></pre>
  
 
Paste this text into the file:
 
Paste this text into the file:
第76行: 第76行:
 
Type=Application
 
Type=Application
 
Categories=Application;Office;
 
Categories=Application;Office;
</nowiki></code>
+
</nowiki></pre>
  
 
Now create an entry for the administration program:
 
Now create an entry for the administration program:
第82行: 第82行:
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo nano /usr/share/applications/Quasar-Admin.desktop
 
sudo nano /usr/share/applications/Quasar-Admin.desktop
</nowiki></code>
+
</nowiki></pre>
  
 
and paste this text into it:
 
and paste this text into it:
第96行: 第96行:
 
Type=Application
 
Type=Application
 
Categories=Application;Office;
 
Categories=Application;Office;
</nowiki></code>
+
</nowiki></pre>
  
 
== Step 3: Set up the PostgreSQL database ==
 
== Step 3: Set up the PostgreSQL database ==
第107行: 第107行:
 
createuser -E -P quasar
 
createuser -E -P quasar
 
exit
 
exit
</nowiki></code>
+
</nowiki></pre>
  
 
Now we need to ensure that Quasar is allowed to access the database.  For Edgy (version 6.10), replace 8.2 with 8.1:
 
Now we need to ensure that Quasar is allowed to access the database.  For Edgy (version 6.10), replace 8.2 with 8.1:
第113行: 第113行:
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo nano /etc/postgresql/8.2/main/pg_hba.conf
 
sudo nano /etc/postgresql/8.2/main/pg_hba.conf
</nowiki></code>
+
</nowiki></pre>
  
 
Make sure that your file contains this line; if not, add it:
 
Make sure that your file contains this line; if not, add it:
第119行: 第119行:
 
<pre><nowiki>
 
<pre><nowiki>
 
host    all        all        127.0.0.1/32          md5
 
host    all        all        127.0.0.1/32          md5
</nowiki></code>
+
</nowiki></pre>
  
 
Now restart the database server to make your changes effective.  For Edgy (version 6.10), replace 8.2 with 8.1:
 
Now restart the database server to make your changes effective.  For Edgy (version 6.10), replace 8.2 with 8.1:
第125行: 第125行:
 
<pre><nowiki>
 
<pre><nowiki>
 
sudo /etc/init.d/postgresql-8.2 restart
 
sudo /etc/init.d/postgresql-8.2 restart
</nowiki></code>
+
</nowiki></pre>
  
 
== Step 4: Connect Quasar to the PostgreSQL server ==
 
== Step 4: Connect Quasar to the PostgreSQL server ==

2007年5月13日 (日) 12:37的版本


Introduction

Quasar is accounting software for Linux. It's powerful and easy to use – certainly more so than commercial small business Windows-based alternatives that I've encountered in the UK – and a full range of support packages are available from the authors. It needs a Linux server, but clients are available for both Windows and Linux. This how-to only covers installation on a single Ubuntu box that acts as both client and server. If you need multi-user access but can't work out how to do it yourself, it sounds like you need to get a support package.

Unfortunately, Quasar's not straightforward to install on Ubuntu, as no pre-built packages are available. In principle, it should be possible to install one of the packages built for other distributions, but building from source is likely to be more reliable. That's the approach that I've adopted here.

This documentation is for Feisty (7.04) and Edgy (6.10) but will work with minor tweaking on Dapper (6.06 LTS). Quasar can be installed on earlier releases but needs a different approach as not all depenedencies are available through the package manager.

Step 1: Install and build Quasar

Go to www.linuxcanada.com, and download the file quasar-1.4.7_GPL.tgz to your desktop (note that if you download a newer version you'll have to change all subsequent references to it). While you're there, also download the comprehensive product documentation provided by Linux Canada.

Now ensure that you have the Universe repositories installed, open up a terminal session, and enter the following:

For Edgy (version 6.10):

sudo apt-get install build-essential libqt3-mt-dev tcl8.4-dev tk8.4-dev libpq-dev qt3-apps-dev postgresql-8.1 libicu34-dev xinetd postgresql-server-dev-8.1

For Feisty (version 7.04):

sudo apt-get install build-essential libqt3-mt-dev tcl8.4-dev tk8.4-dev libpq-dev qt3-apps-dev postgresql-8.2 libicu34-dev xinetd postgresql-server-dev-8.2

And then:

cd ~/Desktop
tar xvvf quasar-1.4.7_GPL.tgz
cd quasar-1.4.7_GPL/
./configure
make

Unfortunately, it's necessary to modify the install script before proceeding (if you prefer, replace nano with a different text editor such as Gedit or Kate):

nano install

Edit the first line to look like this:

#!/bin/bash

You can now complete installation with this command:

sudo make install

Quasar installs itself to /opt rather than the Ubuntu standard for user-installed software of /usr/local, so you can't start it without entering the full path to the executable file. That doesn't matter too much, though, as we're going to create our own Gnome menu entries and /opt survives intact when you upgrade to a new Ubuntu release.

Step 2: Create the menu entries

Quasar doesn't generate menu entries by default, so we need to create our own:

sudo nano /usr/share/applications/Quasar.desktop

Paste this text into the file:

[Desktop Entry]
Name=Quasar
Comment=Quasar accounts
Exec=/opt/quasar/bin/quasar
Icon=/opt/quasar/setup/quasar_client.xpm
StartupNotify=true
Terminal=false
Type=Application
Categories=Application;Office;

Now create an entry for the administration program:

sudo nano /usr/share/applications/Quasar-Admin.desktop

and paste this text into it:

[Desktop Entry]
Name=Quasar Admin
Comment=Quasar accounts administration and setup tool
Exec=gksudo /opt/quasar/bin/quasar_setup
Icon=/opt/quasar/setup/quasar_setup.xpm
StartupNotify=true
Terminal=false
Type=Application
Categories=Application;Office;

Step 3: Set up the PostgreSQL database

Next, we need to create some database users for Quasar to use. Enter the following code, answering yes to all questions and entering new passwords where appropriate:

sudo su postgres
createuser -d -E -P quasar-dba
createuser -E -P quasar
exit

Now we need to ensure that Quasar is allowed to access the database. For Edgy (version 6.10), replace 8.2 with 8.1:

sudo nano /etc/postgresql/8.2/main/pg_hba.conf

Make sure that your file contains this line; if not, add it:

host    all         all         127.0.0.1/32          md5

Now restart the database server to make your changes effective. For Edgy (version 6.10), replace 8.2 with 8.1:

sudo /etc/init.d/postgresql-8.2 restart

Step 4: Connect Quasar to the PostgreSQL server

The final step is to lodge the database settings with Quasar. Open Quasar's administration tool (Applications --> Office --> Quasar Admin), go to the Drivers tab, and hit Configure. Enter these settings:

Hostname: localhost

Port: 5,433 (for Edgy, version 6.10, use 5,432)

Library: /usr/lib/libpq.so

DBA username: quasar-dba

DBA password: whatever you entered earlier

Username: quasar

Username password: whatever you entered earlier

Character set: UNICODE

Step 6: Start using it!

Linux Canada's documentation is excellent, and I'm not going to attempt to explain how to use Quasar here. It might initially appear complex, but if you're an accountant or experienced bookkeeper you'll feel familiar pretty quickly. Enjoy.


CategoryDocumentation