I got an error by leaving the template blank, but no the same you got. For me it says "FATAL 1: Database "user=myuser" does not exist in the system catalog." so it looks like a blank name is just ignored and it picks up the username as a data base name. I believe that that's the data base where the users are actually created. If I put in another name I get the same error about the database not existing.
I did a search on DEJA for this error and came up with this idea:
Try checking the file "pg_hba.conf" ( Usually in /usr/local/pgsql/data). It seems that your connectionMiguel
requires a password. try to set the "auth_type" to "trust" in "pg_hba.conf" to skip password check or use "pg_connect(dbname=baseball user=postgres password=<password of the user account "postgres");"
I believe that may be the problem. My installation is set up to "trust". My line there says:
local all trust
host all 127.0.0.1 255.255.255.255 trust
However, it only accepts connections from the host machine. If your web server is on another machine you need
to specify it here.
Randy Just wrote:
[EMAIL PROTECTED]">At 04:23 PM 6/22/2002 -0300, you wrote:Randy;
After you install Sql-ledger, be sure to get the patch and apply that
too. I neglect that step and had some slight problems.
I installed Sql-Ledger about 2 weeks ago. To create the user, the
command to it is:
/usr/local/pgsql/bin/createuser -d -P myuser
-d means that this user can create data bases
-P means that you will be prompted for a password
(My system is Red Hat 7.1, but since I installed PostgreSQL afterwards>from sources, my path may be different from yours).If you make a mistake just use:
/usr/local/pgsql/bin/dropuser myuser
You can get more details from
http://www.postgresql.org/idocs/index.php?app-createuser.html
After that it was reall easy. I connetced with the admin user to
http://your.url/sql-ledger/admin.pl (you have to set up the web server
to recgnize the url this way) and went into Pg Database Administration.
Thanks for the info. Still having problems though.
I did the above step of createuser (actually called the user myuser)
I then went onto the screen of http://localhost/sql-ledger/admin.pl
I go to the interface asking for Host, Port, User, Password and Connect to
I leave Host and Port blank. I type myuser and it's associated password
into the files. The Connect To option is a bit of a mystery to me. It
comes up with a default of templates1 I have left it blank and have left
it with the default option.
I get an error message of FATAL 1: IDENT authentication failed
for user "myuser" when I select the Create Dataset option.
Just Computers! - Phone: 209-369-6550 FAX: 209-367-8518
E-mail: [EMAIL PROTECTED]
---------------- ---------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive http://www.mail-archive.com/[email protected]/
------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.mail-archive.com/[email protected]/
