[00:00] Last message repeated 1 time(s). jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) hi LuftHans jcater (~jason@cpe-024-165-193-024.midsouth.rr.com) joined #gnuenterprise. trouble sleeping? or just getting up early jcater ? um just got back into town actually :( psu (psu@manorcon.demon.co.uk) joined #gnuenterprise. jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. jcater (~jason@cpe-024-165-193-024.midsouth.rr.com) left irc: "Client Exiting" psu (psu@manorcon.demon.co.uk) left #gnuenterprise. jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) Sacha (~Sacha@dialup-196-102.wasp.net.au) joined #gnuenterprise. hey Derek http://traxel.com/maricopa/results.html that's going on http://greplaw.org/ tomorrow, send suggestions to Robert Bushman SachaS_ (~Sacha@dialup-196-98.wasp.net.au) left irc: Read error: 110 (Connection timed out) Sacha (~Sacha@dialup-196-102.wasp.net.au) left #gnuenterprise ("Client Exiting"). Arturas (arturas@bit.codeworks.lt) joined #gnuenterprise. Hello hi hello Arturas hello ajmitch jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. hi Dmitry hi ajmitch Action: ajmitch waits for the hellos to die down :) it's echo :) :) SachaS (~Sacha@dialup-196-102.wasp.net.au) joined #gnuenterprise. SachaS (~Sacha@dialup-196-102.wasp.net.au) left #gnuenterprise ("Client Exiting"). jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) kemitix (~chatzilla@proxy1.lauder.ac.uk) joined #gnuenterprise. jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. LuftHans (~lufthans@wsip68-14-212-27.ph.ph.cox.net) left irc: Read error: 110 (Connection timed out) jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. kemitix (~chatzilla@proxy1.lauder.ac.uk) left irc: Remote closed the connection Action: drochaid is back (gone 11:03:59) jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. alexey_ (~Alexey@techkran.vladimir.ru) left irc: "[x]chat" jamest (~jamest@hobbes.math.ksu.edu) joined #gnuenterprise. hello jamest hi jamest :) hi jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. siesel (jan@dial-195-14-226-62.netcologne.de) joined #gnuenterprise. hi all hi see you tomorrow :) bye Arturas (arturas@bit.codeworks.lt) left #gnuenterprise ("Client Exiting"). who's the documentation manager for GNUe? jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) siesel (jan@dial-195-14-226-62.netcologne.de) left irc: "Real programmers code it into the client" jamest (~jamest@hobbes.math.ksu.edu) got netsplit. jamest (~jamest@hobbes.math.ksu.edu) returned to #gnuenterprise. siesel (jan@dial-194-8-209-78.netcologne.de) joined #gnuenterprise. anyone knows, which command line to use to login + checkout acclite? we don't have anon cvs for that yet but snapshots are at http://www.gnuenterprise.org/~jcater/snapshots/acclite/ jcater: I remeber to have an account on ash :) jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. siesel (jan@dial-194-8-209-78.netcologne.de) left irc: "later" kemitix (~chatzilla@proxy1.lauder.ac.uk) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) left irc: Remote closed the connection jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. fil_c (~username@public1-cosh3-3-cust12.cosh.broadband.ntl.com) joined #gnuenterprise. kemitix (~chatzilla@proxy1.lauder.ac.uk) left irc: "ChatZilla 0.8.7 [Mozilla rv:1.0.0/20020618]" ariel_ (~ariel@ppp-217-133-244-30.dialup.tiscali.it) joined #gnuenterprise. siesel (jan@dial-213-168-97-107.netcologne.de) joined #gnuenterprise. kemitix (~chatzilla@proxy1.lauder.ac.uk) joined #gnuenterprise. dneigbo: you here? I saw that 'data' and 'database schema' is split into two sql files in acclite. and the GNUe Schema Definition file has no way to put some base data into it. (quite ok for a SCHEMA definition ;) ) but data should be stored in an XML representation too. for ease of use I would like to put schema and data into ONE file. any objections, ideas? dneighbo_ (~dneighbo@tmp-200253.flinthills.com) joined #gnuenterprise. hi dneighbo_, can you read the backlog? um in a second Action: drochaid raises a hand tentatively to object ... fil_c (~username@public1-cosh3-3-cust12.cosh.broadband.ntl.com) left irc: "Client Exiting" siesel you still here Remosi: backlog grr re : acclite split was from NOLA definitely we need to have the 'data' statements as part of our schema spec its just a matter of definining and making xslt xsl for it about putting together or separating i like to work in sizeable chunks so i like them separate im one of these wierdos that would actually like every table or grouping of tables to be own file (but i know im in the minority there) im open to debate though btw: jcater has added in designer ability to make our 'xml schema' off existing databases so if you have a postgres database you can from designer run a tool that will create a 'gnue xml schema' :) I think puting every table into a seperate file is ok, if there is ONE comand to create a whole table, or if there is one gsd file which includes the other ones :) siesel well xml/xslt supports includes /a whole table/a whole table set/ so way i figured it was you would do granular (to what level i have no consensus) then you make a 'initial install' xml file let's back up a second I see xslt as a means to an end not the end itself in the not-so-distant future GNUe-COmmon's dbdrivers will accept a schema tree that simply includes the whole enchalada (sp) and each driver will be able to create the schema natively thats fine Action: dneighbo_ sees it similar way so I'm just saying, let's not say "sure, we can do that as xslt supports xxxxxxx" btw, I like sizable chinks too s/chinks/chunks/ in fact for designer and some other things i almost would like to have it go off the schema opposed to the db jcater, dneighbo: does the way xslt includes files differ from the GParser way? Action: jcater knows nothing about xslt includes :( Action: dneighbo_ notices that visual studio .NET has gone that route and it made for some trick features in their 'designer' stuff but thats another discussion siesel : i cant answer that i specifically called out xslt can do 'x' because currently we are using xslt i assume when we go to internally doing it, that its not a huge issue in that we have control so we can make it do includes :) jcater : i see this functionality as being important also for integrator as well as designer :) btw: xslt iirc does include as so very simplistic though technically its not on teh stylesheet side but on the source side where they include would happen which would follow normal xml include rules (iirc) back to that xml format for data: I think it, 1. should be outside of that tag 2. possibly could look like... oops, I don't know why, but most of the stuff was send to nickserv :( Peter Miller GNUe street 9393 GNU town (that would be simple initialisation without fieldnames. There should be a mode for initialisation with fieldnames too.) no not outside of schema tag but outside of tables tag GParser depends on there being a single enclosing tag around an entire file (i.e., the "root" element) so you'd have .... .... at least, this is what I was imagining Just asking, if we do it that way, is still the right name for the root tag? Action: jcater thinks so as to me required datasets are still part of a schema definition ok, but, because I want to use GSD as a dump format for the appserver, would you object to put "non-required" datasets into it? jcater: i agree keeping in schema root im not sure i follow dump format? like pg_dump writes the contents of a db into one file. a appserver_dump would create a ?.GSD? file. I see no problem with that most tools like that include an option to dump only schema or schema + data anyway works for me great. now to the details, is ......tabledata> ok? works for me ok, last question before modifing xslt's: do we need type's for definitions? I would like Peter22.4.1999. jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. and would make Peter22.4.1999 optional? ok, I will provide appserver/samples/sample.gfd as an example dneighbo: how can I select a value between two tags my_value using xslt? yogurt2unge (~charlie@modem117-adsl.capfed2.sinectis.com.ar) joined #gnuenterprise. can someone help me? I'm struggling with the sample forms in GNUe-Forms. I will try :) which sample are you running? thanks. inventory/forms/company.gfd I've added the sql for inventory and location the traceback claims 'DB000: gnue.common.GComm.DistantError: Error 'gnue.common.GDataObjects.ProviderNotSupportedError: No database driver found for provider type 'pygresql'' occured on server connected by XMLRPC' i've installed pygresql ok, seems like you are using appserver to provide the data :) yup or atleast i'm trying to there is no provider called pygresql. The GNUe name for the PyGreSQL based driver is called "postgresql" jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) okay, i'll try changing that (common/README.databases), so you have to edit your connection.conf getting further but still not getting the form to appear I'll have to leave it for now - the buildings about to close don't feel like getting locked in. :) thanks for your help no problem kemitix (~chatzilla@proxy1.lauder.ac.uk) left #gnuenterprise. siesel (jan@dial-213-168-97-107.netcologne.de) left irc: "(figuring out XSLT during dinner :))" i dont like it crap seisel is gone must run dneighbo_ (~dneighbo@tmp-200253.flinthills.com) left irc: "home" ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" siesel (jan@dial-213-168-92-142.netcologne.de) joined #gnuenterprise. hi again siesel :) crap dneigbo is gone yeah ran away about 40min ago [07:14:37] i dont like it [07:15:08] crap seisel is gone [07:42:30] must run hi ajmitch sigh, seems like i need to throw something together this afternoon so as to avoid other people's messy designs :) jhs (~jhs@cs6668105-78.austin.rr.com) joined #gnuenterprise. what do you want to THROW TOGETHER? bsic accounting forms and a nice UI to access them :) for acclite? nah, something far smaller at the moment anyway, must have breakfast now, cya :) psu (psu@manorcon.demon.co.uk) joined #gnuenterprise. Gun[around] (GunAndGiz@ip68-10-44-170.rn.hr.cox.net) joined #gnuenterprise. greetz chillywilly (danielb@mke-24-167-202-50.wi.rr.com) joined #gnuenterprise. Nick change: Gun[around] -> stbain hi chillywilly hi psu (psu@manorcon.demon.co.uk) left #gnuenterprise ("switching logins"). jamest (~jamest@hobbes.math.ksu.edu) left #gnuenterprise. jhs (~jhs@cs6668105-78.austin.rr.com) left irc: Read error: 110 (Connection timed out) siesel (jan@dial-213-168-92-142.netcologne.de) left irc: "later" hi stbain crap siesel is gone :) we just missed one another yes :) and both ssaid 'crap $x is gone' Action: jcater will change the vicious cycle crap dneighbo is here how's that? jcater: you here? yes you running woody? its most odd i did apt-get install of postgresql this am well, the cute one just left however i cant get it to run i do /etc/init.d/postgresql start and it says it restarts morning jcater, dneighbo latitude:/home/dneighbo# su - postgres postgres@latitude:~$ createuser Enter name of user to add: dneighbo Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y psql: 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"? createuser: creation of user "dneighbo" failed postgres@latitude:~$ and ps ax |grep post shows its NOT running even after latitude:/home/dneighbo# /etc/init.d/postgresql start Starting PostgreSQL postmaster. postmaster successfully started latitude:/home/dneighbo# ps ax|grep post 6779 pts/2 S 0:00 grep post latitude:/home/dneighbo# hmm, looks broken, check logs ajmitch:/opt# ps axu |grep post postgres 5207 0.0 0.0 8552 280 pts/5 S May17 0:07 /usr/lib/postgresql/bin/postmaster postgres 5209 0.0 0.0 9544 192 pts/5 S May17 0:00 postgres: stats buffer process postgres 5210 0.0 0.0 8668 228 pts/5 S May17 0:00 postgres: stats collector process postgres 14595 0.0 0.2 8976 856 pts/5 S Jul10 0:00 postgres: ajmitch gnue 127.0.0.1 idle in transaction do a dpkg-reconfigure postgresql i do a dpkg-reconfigure and now it makes SOME sense i recall it asking me if i wanted to upgrade my version of postgres(which is odd as i didnt have one) unless some dependency installed 6.5 as this is FRESH install of woody i chose (y) and ran out door it appears that the binary to do the conversion is missing so now i choose N and its says everything goes smooth but it doesnt sigh crappy packaging i assume which is so odd as i have yet to have issues really with postgres on debian doing an upgrade nothing to upgrade sigh dneighbo: check postgresql.conf in data directory in mine is /var/lib/pgsql postgresql has found a pre-existing database, and believes that it will be able to update it automatically to the new version. There is some risk to your data in this. If you have not got an up-to-date backup of /var/lib/postgres/data, you should say no at this point. In the course of the update, your existing /var/lib/postgres/data will be moved to a parallel directory and a new directory created in its place. The saved dump of your existing database will then be loaded into the new database. If you have a lot of data, this may take a considerable time; if your database is sufficiently large, it may fail for lack of disk space. The backup of /var/lib/postgres/data will be on the same filesystem; the dump file will be in /usr/lib/postgresql/dumpall/. Do you want me to continue with the automatic update? [y/N] y The upgrade will now be done; the time taken will depend on the size of your database(s). There are no binaries for dumping database format 7.2 check the tcpip_socket variable Sorry; the automatic database upgrade failed. latitude:/home/dneighbo# it just uses pg_dump this must be true for pg server to accept connections via tcp/ip tcp/ip is turned ON by default IIRC not sure all that is fine this is im certain a package problem # TCP/IP access is allowed by default, but the default access given in # pg_hba.conf will permit it only from localhost, not other machines. tcpip_socket = 1 im getting postgres-contrib and postgresql-dev doods im telling you thats NOT it its not a CONNECTION problem the damn thing wont even START no shit http://www.komotv.com/stories/19291.htm roflmao is that for real? Action: dneighbo forgets how do you do an initdb i think this might solve my issues where would i find postgres logs? doesnt seem to be in syslog and cant find any postgres logging initdb -D / initdb command not found explicity state path *explicitly StyXman (~mdione@modem117-adsl.capfed2.sinectis.com.ar) joined #gnuenterprise. im uninstalling postgres anything and deleting all postgres dirs hi. why aren't no data-unaware widgets? dneighbo: rtfm ;) then trying again the tfm sucks no it does not again this is a packaging issue posgres has excellent documentation dneighbo: tfm ? as im running 8.2 ah the manual the docs are bloody excellent er 7.2 7.2.1 I would hope dneighbo er installing 7.2 and it says (found an OLD db) let me upgrade and the upgrade fails saying there is no upgrade tool for 7.2.1 which im like NO DUH reinstall the version the db was for pg_dumpall remove old install and install 7.2.1 pg_restore [after initdb of course] it wont let me initdb not yet so im wiping ALL references to postgers and starting over bulding from source or deb/rpm? grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr i think i found the problem now that i finally found the log Action: drochaid backs off and runs to the corner using dhcp here and home im static syntax for initb -> http://chillywilly.dyndns.org/postgres/installation.html initdb even so my hosts file had static ip for me :o that would be a problem chillywilly: yea, thats real heheh funky a fish that can breathe air and walk on land cool yogurt2unge (~charlie@modem117-adsl.capfed2.sinectis.com.ar) left irc: "Client Exiting" grr that still didnt do it siesel (jan@dial-195-14-235-132.netcologne.de) joined #gnuenterprise. wb siesel dneighbo: did you rehash the postmaster? Action: drochaid plays Counting Crows, Hard Candy album to relax dneighbo latitude:/var/log# /etc/init.d/postgresql start Starting PostgreSQL postmaster. postmaster successfully started latitude:/var/log# less postgres.log PGSTAT: bind(2): Cannot assign requested address i dont get it still anyone ever see fight club? latitude:/var/log# less /etc/hosts 127.0.0.1 localhost 127.0.0.1 latitude 192.168.100.90 carpine.com carpine # The following lines are desirable for IPv6 capable hosts # (added automatically by netbase upgrade) ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts cw: yes dneighbo: what's in your pg_hba.conf ? crazymike let me borrow it gack WTF how come pump didnt bring up lo? settle down mister why would you want it to? latitude:/var/log# ps ax |grep post 8459 pts/2 S 0:00 /usr/lib/postgresql/bin/postmaster 8461 pts/2 S 0:00 postgres: stats buffer process 8463 pts/2 S 0:00 postgres: stats collector process 8473 pts/2 S 0:00 grep post latitude:/var/log# sigh that WAS the problem Action: dneighbo has never had lo not start before shouod be setup in your interfaces file then when the networking inti script runs it should come up at least init its a long story you can also setup 'interfaces' file to use dhcp for the ethx interface Action: chillywilly 's server does this dneigbo: what didn't you like hey dneighbo what does { } do in XSLT? I was told you are da xsl masta i dont have my xsl bible darn i remember briefly about it but not enough what book is that? um fact that you were doing what is you "xsl bible"? data or something where i think it should be data data or the like later you then seemed to reference something like this even including a datatype ^chewie (~chad@cyan.ima.umn.edu) joined #gnuenterprise. but i wasnt sure sorry I was away im fixed up now did you do the dpkg-reconfigure? i think yeah lo wasnt up as I imagine it had to do with a failed dump ah was problem, but still the package has an issue Action: jcater had hell upgrading to 7.2 as it SHOULD NOT try to upgrade when there is no postgres :) i.e. a fresh install and apt-get install postgresql should say we found a database want to upgrade it er shouldnt