Hi,
What is exactly happening. I use F11 and running gambas2.13.1
As I never used postgresql before I prefer mysql but never mind.
I tried to use the example "Picture Database' and changed to postgresql
by opening the main forms code and uncommenting the postgresql part.
It did not work - but I realized that postgresql was not installed.
So I installed postgresql and postgresql server by
su
yum install postgresql postgresql-server
then once installed i ran
code:
chkconfig postgresql on
service postgresql initdb
service postgresql start
endcode:
to make sure it was started i ran
service postgresql restart
I ran the example again but still no luck, but after some digging I
found this.
Need to change this file to 'trust'
as su
code:
gedit /var/lib/pgsql/data/pg_hba.conf
end code:
find this section
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
and change ident to trust like so
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 trust sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
Restart postgresql
code:
service postgresql restart
end code:
I tried again and now I can connect.
So have a look at your setup. Fedora may have the rpm packages set up
wrong but they do all work i.e they are complete. Just make sure you
have the gambas db component installed
Tell me how you get on.
Steven
On Tue, \
2009-06-23 at 13:01 +0200, Charlie Reinl wrote:
> Am Dienstag, den 23.06.2009, 03:25 -0700 schrieb Swee Kwang Tan:
> > fedora 11
>
> Salut,
>
> I do not know where fedora 11 stores its' gambas lib files
> (normaly /usr/local/lib/gambas<VERSION>)
> nor witch gambas version you use ?
>
> but look at your box if this files or links :
> gb.db.postgresql.component
> gb.db.postgresql.la
> gb.db.postgresql.so -> gb.db.postgresql.so.0.0.0
> gb.db.postgresql.so.0 -> gb.db.postgresql.so.0.0.0
> gb.db.postgresql.so.0.0.0
>
> If not you can not open a postgresql DB.
>
------------------------------------------------------------------------------
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
