Hi,
Thanks for the ideas everyone!
Erik,
I entered the
SELECT * FROM defaults WHERE setting_key = 'version';
you gave me and got:
postgres=# SELECT * FROM defaults WHERE setting_key = 'version';
ERROR: relation "defaults" does not exist
LINE 1: SELECT * FROM defaults WHERE setting_key = 'version';
and also with the “greater than (>) symbol in your mail
postgres=# > SELECT * FROM defaults WHERE setting_key = 'version';
ERROR: syntax error at or near ">"
LINE 1: > SELECT * FROM defaults WHERE setting_key = 'version';
select * from USERS;
gives
select * from USERS;
ERROR: relation "users" does not exist
LINE 1: select * from USERS;
SELECT * FROM lsmb_roles;
gives
postgres=# SELECT * FROM lsmb_roles;
ERROR: relation "lsmb_roles" does not exist
LINE 1: SELECT * FROM lsmb_roles;
postgres-# \l
gives:
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-----------+-----------+---------+-------+-----------------------
aels | postgres | UTF8 | C | C |
ledgersmb | ledgersmb | SQL_ASCII | C | C |
mytestdb | postgres | SQL_ASCII | C | C |
postgres | postgres | SQL_ASCII | C | C |
template0 | postgres | SQL_ASCII | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | SQL_ASCII | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
(6 rows)
I deleted the other ledgersmb databases and now the only database created
by ledgersmb is 'aels'
Håvard,
Logging in at setup.pl gives the database as 'postgres'
Thanks in advance.
Billy
On Sun, Mar 18, 2012 at 8:21 PM, Håvard Sørli <[email protected]> wrote:
> On 17. mars 2012 23:51, billy akazawa wrote:
> > All ideas and advice are greatly appreciated.
>
> When you login with setup.pl what does it read on the
> "Logged in as" line ?
>
>
> ============================
> Database Management Console
>
> Confirm Operation
> Logged in as ledgersmbadm
> LedgerSMB 1.3 found
> Rebuild/Upgrade?
> ===========================
>
>
> H
>
>
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
