Ah, that seems to resolve that issue. I was able to create a database and login.
I then created two users (the first two commands returned CREATE ROLE and the second two commands returned GRANT...so I believe they worked correctly): *CREATE USER nakamura WITH PASSWORD 'password'; CREATE USER nakrole WITH PASSWORD 'password'; GRANT ALL PRIVILEGES ON DATABASE sakaioae TO nakamura; GRANT ALL PRIVILEGES ON DATABASE sakaioae TO nakrole;* I quit from the database using \q and am at this part in the book: "Before hooking OAE up, make sure the database created properly:" *postgresdir/bin/psql --dbname=sakaioae --username=nakamura* So I changed the command to match our system, and ran this: */usr/lib/postgresql/9.1/bin/psql --dbname=sakaioae --username=nakamura* However, I get the following error: *psql: FATAL: Peer authentication failed for user "nakamura"* Any idea why it wouldn't authenticate to the database, even after the CREATE and GRANT commands seemed to execute correctly?? Sorry for "taking over" the email list, but time is of the essence for our install. ;) Also, I am being meticulous in my documentation, so at least I can contribute documentation notes for this install of OAE, with this version number, our environment, etc. Thanks so much! Tom On Mon, Aug 6, 2012 at 12:24 PM, Lance Speelmon <la...@rsmart.com> wrote: > IIUC you need to be running as the postgres user; i.e.: sudo su - > postgres. L > > > On Aug 6, 2012, at 9:19 AM, Tom Huffner <thuff...@gmail.com> wrote: > > That seemed to progress things, Erik...thanks! > > At least now, when I try to create a database, it recognizes it as > something exists. However, now, it doesn't recognize my username (ubuntu) > as a role that exists, throwing this error: > > *createdb: could not connect to database postgres: FATAL: role "ubuntu" > does not exist* > > hmmmm... > > On Mon, Aug 6, 2012 at 12:12 PM, Erik Froese <erik.fro...@gmail.com>wrote: > >> Tom, >> >> Looks like createdb can't connect to your postgres instance. >> Can you try starting postgres with /etc/init.d/postgres start? >> >> That script probably configures the postgres daemon properly for your >> system. >> >> Erik >> >> On Mon, Aug 6, 2012 at 3:09 AM, Tom Huffner <thuff...@gmail.com> wrote: >> > Exciting stuff happening on Mars isn't it?? >> > >> > Anyways - I was able to shut down the database using the following >> command: >> > >> > /usr/lib/postgresql/9.1/bin/pg_ctl stop -D/usr/var/postgresql/9.1/main/ >> > >> > But am having an issue creating a database within the service. >> > >> > I can start a clean database server with the following commands: >> > >> > /usr/lib/postgresql/9.1/bin/pg_ctl -D \ >> > /home/ubuntu/postgres/dbdata -l \ >> > /home/ubuntu/postgres/db_logfile start >> > >> > But can't seem to create a database. What is recommended is the >> following: >> > >> > postgresdir/bin/createdb sakaioae >> > >> > I found two createdb files, and tried both commands (logged in as both >> the >> > sakai user and as postgres) to try and create a database within the >> service, >> > but get the same error with each command (listed after): >> > >> > /usr/lib/postgresql/9.1/bin/createdb sakaioae >> > /usr/bin/createdb sakaioae >> > >> > Error I received with both: >> > createdb: could not connect to database postgres: could not connect to >> > server: No such file or directory >> > Is the server running locally and accepting >> > connections on Unix domain socket >> > "/var/run/postgresql/.s.PGSQL.5432"? >> > >> > Any ideas? >> > >> > Thanks, >> > Tom >> > >> > >> > On Fri, Aug 3, 2012 at 2:57 PM, Zach A. Thomas <zach.tho...@gmail.com> >> > wrote: >> >> >> >> Hi, Tom. /Library is a Mac OS X path. >> >> >> >> We're using PostgreSQL on one of our ubuntu servers, and while it's a >> >> somewhat older version, this is the command we use: >> >> /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c >> >> config_file=/etc/postgresql/8.4/main/postgresql.conf >> >> >> >> So you might have luck looking in /usr/lib, /var/lib, and /etc for what >> >> you need to run your db. >> >> >> >> regards, >> >> Zach >> >> >> >> On Aug 3, 2012, at 1:12 PM, Tom Huffner <thuff...@gmail.com> wrote: >> >> >> >> Hey Max, thanks for the web site! I am actually doing our install on >> 1.3 >> >> and I can't seem to get things straight. >> >> >> >> Is the directory structure of 1.2 vs. 1.3 the same or any different?? >> I >> >> switched to the postgres user, tried to run the following command as >> listed >> >> on the web site: >> >> >> >> /Library/PostgreSQL/9.1/bin/pg_ctl stop -D/Library/PostgreSQL/9.1/data/ >> >> >> >> But do not see a Library folder, even after searching for one. Is >> this a >> >> wildcard library folder or (again), am I missing something? >> >> >> >> Thanks! >> >> Tom >> >> >> >> On Thu, Aug 2, 2012 at 1:23 PM, Max Whitney <m...@nyu.edu> wrote: >> >>> >> >>> Hi Tom: >> >>> >> >>> I did Postgres install notes for OAE version 1.2 back in June. They >> are >> >>> not current with 1.4, but might provide some insight. The notes are >> posted >> >>> on the OAE community instance, which has a lot of useful information. >> >>> >> >>> >> >>> >> https://oae-community.sakaiproject.org/content#p=lbmK1eqsKub/Sakai%20OAE%201.2%20Postgres%20Installation >> >>> >> >>> You might also consider the O'Reilly book which provides an overview >> of >> >>> installation on 1.2: http://shop.oreilly.com/product/0636920023241.do >> >>> >> >>> Max Whitney >> >>> >> >>> >> >>> On Aug 1, 2012, at 1:21 AM, Tom Huffner wrote: >> >>> >> >>> Hey everyone...my name is Tom Huffner and I am working with Dr. Wang >> at >> >>> the University of Delaware to get an instance of OAE up and running >> where we >> >>> can make our own changes. >> >>> >> >>> I'm at the point of beginning database integration, and we would like >> to >> >>> use PostgreSQL in our Ubuntu environment. >> >>> >> >>> I followed the simple instructions on how to install it from the web >> >>> site: http://www.postgresql.org/download/linux/ubuntu/ and simply >> ran this >> >>> command: sudo apt-get install postgresql-9.1 >> >>> >> >>> My question is: is this the only command I should run to install it?? >> >>> There are 5 other packages that I can install (as listed in the above >> web >> >>> site)...are all/any of those necessary for OAE/PostgreSQL >> integration? In >> >>> my OAE Deployment and Management instructions, it then tells me to >> work in >> >>> the bin directory of Postgres, but I can't seem to find it in >> /etc/postgres >> >>> or /etc/postgres-common Am I missing something?? >> >>> >> >>> Thanks so much! >> >>> Tom >> >>> _______________________________________________ >> >>> oae-dev mailing list >> >>> oae-dev@collab.sakaiproject.org >> >>> http://collab.sakaiproject.org/mailman/listinfo/oae-dev >> >>> >> >>> >> >> >> >> _______________________________________________ >> >> oae-dev mailing list >> >> oae-dev@collab.sakaiproject.org >> >> http://collab.sakaiproject.org/mailman/listinfo/oae-dev >> >> >> >> >> > >> > >> > _______________________________________________ >> > oae-dev mailing list >> > oae-dev@collab.sakaiproject.org >> > http://collab.sakaiproject.org/mailman/listinfo/oae-dev >> > >> > > _______________________________________________ > oae-dev mailing list > oae-dev@collab.sakaiproject.org > http://collab.sakaiproject.org/mailman/listinfo/oae-dev > > >
_______________________________________________ oae-dev mailing list oae-dev@collab.sakaiproject.org http://collab.sakaiproject.org/mailman/listinfo/oae-dev
