Hi folks,
I got stuck at the (apparently famous) step 10 and could only get past the first bit by changing "ident sameuser" to "trust".
Now I'm stuck at the other part of step 10.
Using "postgres" as the user I get the following error output (electing to empty database):
Expected to find sequences, found none.
DB Error: no such table
DB Error: no such table
DB Error: no such table
DB Error: no such table
DB Error: no such table
DB Error: no such table
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
DB Error: insufficient permissions
If I choose not to empty database I get:
DB Error: unknown error
Can anyone help me?
I'm running Debian (sarge) and all the latest versions via apt-get.
I'm afraid I (like sooo many other people) am not Postgresql savvy. Were this MySQL I could almost certainly answer my own question. FWIW…
Chris
Emptying the database goes through the list of tables defined in the db and deletes them. Unfortunately postgres doesn't have a simple dropdb / createdb way of doing things, and requires some extra permissions and access in the database to be able to read the tables that store the info about table names. What happens if you manually dropdb and then createdb from the commandline before installing? Are you specifying the database owner when you create the database (ie createdb -U postgres -O youruser yourdbname)?
With the problem with the ident sameuser, the postgres user you connect as must match the linux user you're connecting as, and the linux user must already be authenticated. So the user you create for postgres must be the apache user, as this is the user that php script is running as when it connects to the db. However, it then means you can't access the db from the command line later (yeah, pg sucks sometimes ;)).
Hi Marcus,
Thanks for your help.
'Fraid that didn't help me.
I did 'su - postgres', then 'dropdb matrix' (I called the database 'matrix' - I assume this is OK?), then 'createdb -U postgres -O postgres matrix', ran the installer again and still get the same error…
Got any more clues…?
Chris
You still got the DB Error: unknown error ? What error level do you have set in your main.inc file? (make sure it's on 2 or 3, you should get a bit more info that way).
Errr…
I don't have a file called main.inc on the entire server…
I guess you are referring to the log level: I set this to high (3) but I'm guessing this only exists in session variables until I have finished the install when it presumably gets written out to something…?
I just tried this again and I get exactly the same errors (i.e. with and without checking the 'empty database' checkbox).
I feel like I'm doing something really stupid here but I have no idea what it could be.
Any help would be greatly appreciated - can I give you more information…?
Maybe using the postgres user isn't the best thing from a security point of view but it should work, shouldn't it?
Chris
Maybe I need a better hat?
Are you able to try a CLI install at all?
I was dreading you'd say that (just time constrained).
Okay - I'll give it a shot and let you know.
I'll be setting it up on OS X next so I'm curious to see how that goes (read all the stuff about Firefox and Java…).
Talk soon,
Chris
I don't think this has much to do w/ postgresql not working properly. I think the web-based installer just doesn't work right. I have direct access to my postgres db and I've tried a bit of everything (use different owners/templates and tried the createlang line) and nothing works. I still have the same "DB Error: unknown error" when I try to connect to my database.
I'm pretty much ready to give up and move on.
Okay, I've updated the installer again (http://matrix.squiz.net/download) to let you through step 10 even if there's a DB error; it'll still appear, but you'll be able to go through into uncharted waters regardless :).