*** johannesV has joined #gnuenterprise
<johannesV> good morning
<dimas_> good morning
*** kilo has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** johannesV has quit IRC
*** johannesV has joined #gnuenterprise
*** btami has quit IRC
*** reinhard has quit IRC
*** yure has joined #gnuenterprise
*** yure has quit IRC
*** reinhard has joined #gnuenterprise
*** johannesV has quit IRC
*** yure has joined #gnuenterprise
*** yure has quit IRC
*** kilo has quit IRC
*** dneighbors has quit IRC
*** btami has joined #gnuenterprise
*** ninja has quit IRC
*** yure has joined #gnuenterprise
*** btami has quit IRC
*** sjc has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** sjc_ has joined #gnuenterprise
*** sjc has quit IRC
*** sjc_ is now known as sjc
*** ibr has joined #gnuenterprise
<ibr> Hi!
<btami> hi ibr
<ibr> I'm still trying to get my first gnue app running.
<ibr> I installed postgres and gnue packages.
<ibr> I can open form.gfd from the examples dir.
<ibr> What should I do further?
<btami> you have to create and edit your own connections.conf file (based on sample.connections.conf)
<btami> then you can try forms using datasources
<btami> the easyest way maybe using gnue-designer's wizards
<ibr> I copied sample.connections.conf to connections.conf.
<btami> File -> New -> From Wizard
<ibr> There are 4 sections: gnue, devel, prod, appserver.
<ibr> Which one should I edit?
<btami> are you installed any python driver for Postgresql?
<btami> try gnue first
<btami> most examples use this connection name
<ibr> Something like python2.4-pygresql?
<btami> you have to install psycopg orpygresql or pypgsql
<btami> yep
<ibr> Installing...
<btami> then you can write
<btami> provider = pygresql
<ibr> Ok. What is psycopg?
<btami> same as pygresql
<btami> but you needonly one
<ibr> So, I have the following:
<btami> python-pg binding package
<ibr> [gnue] comment = GNUe Test Database; aliases = dcl test; provider = psycopg; host = localhost; dbname = gnue
<ibr> How should I test that this connections.conf is ok?
<btami> you installed psycopg, right?
<ibr> Erm, I installed python2.4-pygresql, if that is the same.
<btami> no
<btami> then you have to use
<btami> provider = pygresql
<ibr> Ah, these are kind of different postgres apis for python?
<btami> they are different packages for the samefunctionality
<ibr> Ok, I see.
<ibr> BTW, I have also python2.4-psycopg. Is it better?
<btami> dunno, some use one, one use another...
<ibr> Ok, trying pygresql...
<ibr> Ok, changed /etc/gnue/connections.conf.
<ibr> How can I test it?
<btami> now you have to create your gnue database
<ibr> Let me check, I remember doing smth. like that...
<btami> some examples contain scripts for doing this
<btami> or
<btami> gnue-appserver has a creation script too
<ibr> Aha, I've created the db but not the tables. How the sql script is called?
<btami> forappserver there is a gnue-setupdb iirc
<btami> and in the appserver docs dir there is a another script for creating sample data
<btami> setup-db.sh
<btami> but you don't have to use appserver first
<ibr> I have /usr/share/doc/gnue-appserver/examples/setup-db.sh, is that what I want?
<ibr> Aha. So what did I need connections.conf for?
<btami> if you want to try appserver too
<btami> then you have the [appserver] section too
<ibr> AFAICU, I need it if I want to create 3-tier apps, right?
<btami> yep
<ibr> Great. And what is [gnue] for?
<btami> gnue is the real backend database connection name used by appserver to store data and business rules
<btami> but forms and reports use the appserver name as connection name
<ibr> Aha. So, I want to create a form and see it running. What should I do?
<btami> if you succesfully run gnue-setupdb then setup-db.sh
<ibr> I started gnue-designer and put a label and a button.
<btami> you have to start appserver first
<btami> ah
<btami> ok
<btami> you have 2 coice
<btami> you can try forms in 2-tier mode  if you have a simple postgresql database with tables
<ibr> I think I can convert a 2-tier app to a 3-tier app later, no?
<btami> or if you have an installed appserver you can a 3-tier app too
<btami> yep
<ibr> Ok, I'll try the ui part first.
<ibr> I have a label and a button.
<ibr> Do I need to create the tables?
<btami> yes
<ibr> ibr@medeu:~/tmp/h/gnue$ gnue-setupdb
<ibr> readgsd: Cannot load plugin 'pygresql'
<ibr> For help, type: readgsd --help
<ibr> These are some internal gnue tables, right?
<btami> yep
<btami> are your pygresql version same as your python's ?
<ibr> Let me check...
<btami> 2.4 ?
<btami> yust start python
<ibr> Hmm, python2.4-pygresql didn't require python2.4... Odd.
<ibr> Installed python2.4.
<ibr> Hmm, "python" is still 2.3. Installing python2.3-pygresql...
<btami> in the python interpreter try
<btami> import pgdb
<ibr> gnue-setupdb started, do I still need this?
<btami> for 3-tier, yep
<ibr> What does this do?
<ibr> ibr@medeu:~/tmp/h/gnue$ python
<ibr> Python 2.3.5 (#2, Jun 19 2005, 13:28:00)
<ibr> [GCC 3.3.6 (Debian 1:3.3.6-6)] on linux2
<ibr> Type "help", "copyright", "credits" or "license" for more information.
<btami> itcreates basic "system" tables for gnue-appserver
<ibr> >>> import pgdb
<btami> ok
<ibr> Umm, I meant, do I need "import pgdb"?
<btami> pygesql is working
<btami> :)
<btami> sorry ,misunderstand
<ibr> :)
<btami> so, gnue-setupdb was ok?
<ibr> Aha, removed python2.4-pygresql, import pgdb failed. Great.
<ibr> No, it wants to create the gnue db.
<ibr> And I have it already.
<ibr> But it is empty.
<btami> aha
<btami> delete it
<ibr> Ok.
<btami> gnue-setupdb willcreate it with data for you
<ibr> It asks a password. Which user is it?
<btami> the db admin ?
<ibr> Hmm, if I would remember it... :/
<ibr> I can login to psql without a password.
<reinhard> good night all
*** reinhard has quit IRC
<btami> sorry, but i'm not a pg expert, using firebird here...
<ibr> No problem, googling for postgres admin manual...
<btami> have to sleep now, you on the way now, i think,so
<btami> good night
*** btami has quit IRC
<ibr> Thanks!
<ibr> Bye!
*** ibr has quit IRC
*** jamest has left #gnuenterprise
*** ibr has joined #gnuenterprise
<ibr> Hi!
<ibr> Could anyone help me with gnue-setupdb?
<ibr> It says 'readgsd: FATAL:  password authentication failed for user "gnue"'
<ibr> I have the following line in pg_hba.conf:
<ibr> local all all trust
*** ibr has quit IRC
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** jamest has quit IRC
*** jcater has quit IRC
*** sjc has quit IRC