quasar accounting on ubuntu??

[Brian Walker]

OK, now I am getting frustrated ....

On 7/9/05, Matchless <ulist at gs1.ubuntuforums.org> wrote:
> 
> Thats it, I cannot get Quasar to run with either Firebird or Postgresql.
> Everything works, but I cannot setup as it does not recognise the dba
> user and non dba user that I created and obviously neither the
> passwords. Just for info, I used the latest version of Quasar 1.4.7 and
> the FC c3 RPM's converted to deb. I am on Kubuntu 5.04 Postgresql is
> version 7.4.7. With Firebird 1.5.1, I can create a company, get right
> into the startup screen, select the company, but cannot open it as
> again does not recognise the admin user and password. Those who have
> managed must have some magic wands or something.

Well, I could not get firebird to work at all, so I have been playing with 
postgresql as described. Following the installation instructions of Quasar 
on establishing postgresql (nice documentation) and then running:

/opt/quasar/bin/quasar_setup

and then setting user and non-dba user as dedscribed, then modifying 
pg_hba.conf by doing: gedit /usr/share/postgresql/pg_hba.conf to include the 
following lines ....

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
# Database administrative login by UNIX sockets
local all postgres ident sameuser
#
# All other connections by UNIX sockets
local all all ident sameuser
local all all trust
#
# All IPv4 connections from localhost
host all all 127.0.0.1 <http://127.0.0.1>
255.255.255.255<http://255.255.255.255>ident sameuser
#
# All IPv6 localhost connections
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff 
host all all 127.0.0.1 <http://127.0.0.1>
255.255.255.255<http://255.255.255.255>trust
host all all 192.168.2.0 <http://192.168.2.0>
255.255.255.0<http://255.255.255.0>trust

host all all ::ffff:127.0.0.1/128 <http://127.0.0.1/128> ident sameuser
#
# reject all other connection attempts
host all all 0.0.0.0 <http://0.0.0.0> 0.0.0.0 <http://0.0.0.0> reject

I still cannot get past the login where, as noted, I find admin expecting a 
password which is always rejected (as are the quasar_dba and quasar login 
names, as well as my user name (brian) and all passwords I used during the 
setup. Looking in /cvar/log/postgresql/postgresql.log I find this typical 
extract:

2005-07-19 14:19:49 [26405] LOG: connection received:
host=127.0.0.1<http://127.0.0.1>port=43172
2005-07-19 14:19:49 [26405] LOG: incomplete startup packet
2005-07-19 14:19:49 [26406] LOG: connection received:
host=127.0.0.1<http://127.0.0.1>port=43173
2005-07-19 14:19:49 [26406] LOG: could not connect to Ident server at 
address "127.0.0.1 <http://127.0.0.1>", port 113: Connection refused
2005-07-19 14:19:49 [26406] FATAL: IDENT authentication failed for user 
"quasar_dba"
2005-07-19 14:19:51 [26408] LOG: connection received:
host=127.0.0.1<http://127.0.0.1>port=43175
2005-07-19 14:19:51 [26408] LOG: could not connect to Ident server at 
address "127.0.0.1 <http://127.0.0.1>", port 113: Connection refused
2005-07-19 14:19:51 [26408] FATAL: IDENT authentication failed for user 
"quasar"

And googling reveals nothing about an "incomplete startup packet" 

People, this is now becoming personal, and I am determined to sort the 
problem out. Any ideas where I can begin? 

All the best

Brian


> snip
> --
> Matchless
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20050719/4f338bd1/attachment.html>