[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Login problems



Ashley,

The plot thickens! lol

OK I tried the following, after doing a

sudo su postgres

and then psql

and then got the


postgres=#


prompt and entered the following, with teh following result:


postgres=# GRANT ALL ON SESSION TO "ledger-smb";
ERROR:  relation "session" does not exist


Then I tried this, with the following result:

postgres=# GRANT ALL ON * TO "ledger-smb";
ERROR:  syntax error at or near "*" at character 14
LINE 1: GRANT ALL ON * TO "ledger-smb";
                    ^

Is my next step to find that config file? Must I be missing something from it?

- Matt




On 3/5/07, Ashley J Gittins <..hidden..> wrote:
On Tue, 6 Mar 2007, Matt Jackson wrote:
> Ashley,
>
> Tried first command and got:
>
> postgres=# GRANT ALL ON SESSION TO ledger-smb;
> ERROR:  syntax error at or near "-" at character 31
> LINE 1: GRANT ALL ON SESSION TO ledger-smb;
>                                       ^

Ahh, you'll need to quote the username, as the hyphen is an operator, I guess.
I think double quotes (") around just the username should do it. Ie:

grant all on * to "ledger-smb";

If that gives you and error then it's single quotes - I always get mixed up
between them with psql :-)

> Next did the "psql -h localhost -U ledger-smb lsmb-db-name" as:
> psql -h localhost -U ledger-smb ledger-smb
> and I got the "ledger-smb=#" prompt.

Cool, that means the username and password you used are correct.

> I don't know how to check the conf file as you indicated. As you can
> probably tell, I am very green. Green but trying! lol

On an sql-ledger install, it's where you unpacked SL,
named "sql-ledger.conf" - I dunno if it'll be sql-ledger.conf or
ledger-smb.conf or what - but go to where you installed LSMB and do an ls -
that will show you the files, I expect there'll only be one .conf file, so
note the name and open it up in your favourite editor, take a look at the
database connection info. I doubt that's your problem though - get the grant
command working first.

> Anyhow, I tried the previous "grant all" command again under this
> account and got the same thing:
>
> ledger-smb=# grant all on session to ledger-smb;
> ERROR:  syntax error at or near "-" at character 31
> LINE 1: grant all on session to ledger-smb;
>                                       ^

Yep. Same quoting thing as above - but that account won't have permission to
grant rights on that db anyway, most likely - you want to do it from the
postgres account.

--
Regards,
        Ashley J Gittins
        web:    http://www.purple.dropbear.id.au
        jabber: ..hidden..

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Regards,
Matt