You'll get much better help on a forum that's about your OS and/or postgresql, as this doesn't have anything to do with web2py.
Regards, Ales On Saturday, March 9, 2013 12:19:04 AM UTC+1, BlueShadow wrote: > > I like to change my db to postgresql. > So I installed it by the following guide: > # setting up secure ssh > adduser dbuser > export EDITOR=nano > visudo > # add this to the end of the file > # dbuser ALL=(ALL) ALL > > ssh-keygen -t rsa > # fill everything out correctly > scp ~/.ssh/id_rsa.pub dbu...@xxx.yyy.zzz.xyz:/home/dbuser/ > > mkdir /home/dbuser/.ssh > mv /home/dbuser/id_rsa.pub /home/dbuser/.ssh/authorized_keys > chown -R dbuser:dbuser /home/dbuser/.ssh > chmod 700 /home/dbuser/.ssh/ > chmod 600 /home/dbuser/.ssh/authorized_keys > vi /etc/ssh/sshd_config > > #Be sure to check the following options. > > #Port 1234 <--- change to a port of your choosing > #Protocol 2 > #PermitRootLogin yes > #PasswordAuthentication no > #X11Forwarding no > #UsePAM no > #UseDNS no > #AllowUsers demo > > iptables -L > # Yuck, we're allowing everything > wget wget http://articles.slicehost.com/assets/2007/9/4/iptables.txt > vi iptables.txt > # **IMPORTANT!!** > # Make sure to change the port for ssh!!!! 1234 > # **IMPORTANT!!** > mv iptables.txt /etc/iptables.up.rules > iptables-restore < /etc/iptables.up.rules > iptables -L > # much better, now make it permanent > vi /etc/network/interfaces > > #... > #auto lo > #iface lo inet loopback > #pre-up iptables-restore < /etc/iptables.up.rules > > ## The primary network interface > #... > > service ssh reload > > > sudo apt-get update > sudo apt-get upgrade > sudo locale-gen en_US.UTF-8 > sudo /usr/sbin/update-locale LANG=en_US.UTF-8 > > sudo apt-get install postgresql > sudo apt-get install python-psycopg2 > sudo vi /etc/postgresql/9.1/main/postgresql.conf > #Find and uncomment/change these lines > #... > #listenaddress='localhost' #uncomment > #... > #track_counts = on #73% > #... > #autovacuum = on # Enable autovacuum subprocess? 'on' > #... > > sudo /etc/init.d/postgresql restart > > sudo su - postgres > #postgres@$ createuser -PE dbuser > #answer no to superuser, create db, and create role. > #postgres@$ createdb -O dbuser -E UTF8 testdb > #postgres@$ exit > sudo vi /etc/postgresql/9.1/main/pg_hba.conf > #Find this part > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # "local" is for Unix domain socket connections only > #local all all ident sameuser > > #Change the line to read > > #local all all md5 > sudo /etc/init.d/postgresql restart > #test it > psql -U dbuser -d testdb > #ctrl+d to exit > the psql -U dbuser -d testdb didn't work: > psql: FATAL: Peer authentication failed for user "dbuser" > > I had to try but obviously when I made a new welcome app(TestPostgres) > where I changed the DAL line to: > db = DAL('postgres://dbuser:testpw@localhost/testdb') > I get this error page: > invalid function (default/TestPostgres) > > no ticket or anything > > I also tried changing the md5 in pg_hba.conf > > # "local" is for Unix domain socket connections only > #local all all md5 > > to password > > doesn't change a thing > > thanks > > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
