they come, they go, they dont say a word hi #gnuenterprise: mode change '+o derek' by ChanServ!ChanServ@services. Action: ajmitch just stays & lurks just got back from an exam Topic changed on #gnuenterprise by derek!~derek@cpe-24-221-112-50.az.sprintbbd.net: Dumb ChanServ Never Resets the Topic Correctly derek: I converted the main Kardia partner table to Postgres and am trying to get Designer to see it.... am not entirely clear on how to do it... can't get to the "properties" of the data source.... file->Connect to->kardia doesn't appear to do much can you give me five? and post the postgres create script somewhere? so i can 'follow' along ok... SachaS (~Sacha@203.190.196.98) joined #gnuenterprise. http://12.225.21.62/other/kardia.sql BTW, there are quite a few SQL tables and there's a lot of fields. This is NOT a "less than a night" project. :) this is only the "main" table. It also has some foreign keys, which aren't in this version till I convert the other tables. :) psu (~psu@manorcon.demon.co.uk) joined #gnuenterprise. hi psu hi dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. i never said less than a night i said from what i saw (three screenshots) probably a day brb switching to workstation Action: derek HAS to get Debian on the laptop its too painful using RH :( grrr lost my net connection ok downloaded file give me a minute to play RH "too painful"??? sheesh yeah I guess the screenshots don't show a whole lot yes too painful as im running rh6.2 BTW the guy at Operation Mobilization thought my comments on GNUe were good and he's forwarding them to others ah and only way i know to upgrade from 6.2 to something is not pretty 7.3 rocks to upgrade from debian stable to debian sid is change one line one file and apt-get update apt-get dist upgrade come back in a few hours and viola I tried installing Debian in April. couldn't get X to work. Didn't try *really* hard though perhaps I could just copy my XF86Config from Red hat to the debian partition??? ptnr_pkey_i integer, ptnr_okey_i integer, getting X working is always a bit of a rite of passage im lost here why two keys? less so these days than it was not sure, but they were in the sybase table what is up with the _c in all the tables i.e. these guys appear to be on database crack hehe. They were there too. I guess they're for putting the type in the field name. I never really liked that practice, but I elected to copy all the names straight oh BTW, the sybase schema specified unsigned integer. does PG support unsigned? almost done with form where you want me to post it huh? huh? I'm just trying to figure out how to connect form fields in DB to fields in Designer! or should I use the wizard? is that what you're doing? just don't ever ask overfiend when xfree86 4.2 packages will be out ajmitch: answer is presumably a variation of RSN (Real Soon Now) but with various interesting yip wizard new words inbetween? hehe form is done and created (a minute or two ago) just cleaning it up a little noww ok, trying it with the wizard... I put in a title and selected kardia datasource..... but I click Continue and nothing happens reinhard (~rm@62.47.246.193) joined #gnuenterprise. if you can point me to a screenshot of what they have now i can duplicate within 5 minutes or so im pretty certain MicahY: do you have connections.conf file configured properly? I think so. also for some reason when clicking that next box it puts hte dialog it pops up under the others so it appears to be doing nothing but if you move the others out of the way its there [kardia] comment = Kardia on GNUe provider = postgresql host = localhost dbname = kardia designer worked for me(tm) a few days ago you have postgresql driver installed? uhhh... I did last time I played with gnue.... is postgresql best driver to use for that? do I need an upgrade? ? that was a while ago dont know its your machine :) i prefer pyscopg but thast on debian ok let me try something... all i can say is holy moses designer is SWEET when you use it on a real machine i have only been using it on a p 233mhz with 64mb ram that runs webserver and postgres and x on my duron 1.2ghz its a dream Action: psu has always worked on the "Rule of 10" i.e. new PC when clock speed is x10 previous ok, if I try to run an OLD form file I had working with PG, it says no PG driver. that might be it. :) so I went from a 2.5Mz 8-bit system to a 386/25 to a PII 233 almost time again ;-) hehe and this time I don't need a pre-installed OS Isomer (dahoose@port-62-158.jet.net.nz) joined #gnuenterprise. hmmm the pygresql page refers to postgres 7.0.2... ok... I think the problem was that pygresql was only installed for python 1.5.2 just installed it for 2.2 and now my old form works. :) cool btw: ugly form is ready has all fields some what compact ugly as hell ok can you give a screen shot of their working application? I'm sure it will be ugly until we get the other tables in if so i can probably clean it up to match and have proper drop down selections and links & such yes, but still could make it look more pretty probably. Hopefully i can remember how to start it on my box. :) hey, how well does remote X work over the Internet ? badly on 128kbps :) would it be practical for me to send a Netscape session to you? Action: ajmitch has tried using designer over 128kbps dsl actually maybe you could just connect to the server here on my box... Action: ajmitch instead opened up tcp access for mysql http://gnuenterprise.org/~dneighbo/kardia.png very ugly but fully functional form based on that table start what? my uplink speed is pretty slow forms runs great across ssh :) its like citrix server on crack :) ssh -C -X is the best was to push X clients. netscape over high-latency connection IS a VERY bad idea though esands we actually have a little script jcater made that just rocks it sets up ssh tunnel to postgres db :) and then you can use forms locally that tunnels its postgres connectoins over net Since most of the sql is text it probably works quite well and its pretty darn fast sweet derek: do you have Netscape 4.7x? if so you can try to connect to me and play with it MicahY: im suprised you even have to ask that question it does MONSTROUS but amazing things with javascript is 4.7x free software? ah, right. :) I used to use tcpserver to do that with ssh, but there is a option in the new openssh to do it with straight ssh. I've tunneled everything with ssh, even ssh. ;) will mozilla or galeon work? it unfortunately requires that no actually i do have netscape on rh6.2 let me check the version hi its me they're hoping to write a mozilla display driver ths summer long walk to the other computer hopefully it will support XUL and they think tehy are farther than gnue ? muhahaha heh looky what i found Netscape® Communicator 4.72 maybe having a rh6.2 box around comes in handy btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. ok sweet tell me what to do grasshopper hi btami let me add a junk user he calls me junk then asks for help.... sigh (j/k) ;) http://12.225.21.62:8000/kardia/kardia.app login test password test morning all No widgets have been defined for your browser type. Your browser was identified as: Mozilla/4.72 sigh hmmm surely it dosn't require 4.78??? dont know be glad i like you anyone else there have easy access to netscape 4.7x? apt-getting netscape for you aegagrus:/home/dneighbo/cvs/kardia# apt-get install netscape Reading Package Lists... Done Building Dependency Tree... Done The following extra packages will be installed: communicator communicator-base-477 communicator-smotif-477 libstdc++2.9-glibc2.1 netscape-base-4 netscape-base-477 netscape-java-477 The following NEW packages will be installed: communicator communicator-base-477 communicator-smotif-477 libstdc++2.9-glibc2.1 netscape netscape-base-4 netscape-base-477 netscape-java-477 0 packages upgraded, 8 newly installed, 0 to remove and 21 not upgraded. Need to get 12.6MB of archives. After unpacking 23.3MB will be used. Do you want to continue? [Y/n] hopefully 4.77 will suffice I have 4.79 I think whatever came with RH 7.3 let these guys know that having to get 12mb of browser when you already have 10 browsers installed is well painful :) yeah 79 a non free one at that ok... :) if you are able to replicate what they have done only with gnue in a matter of say a week or two what do you think they will say? but if you can get it to work you have to admire thier javascript prowess.... probably i wont too much between mdean and nickr it's hard to say css and dhtml and javascript im hard to impress now :) Yeah, just a sec they're pretty excited about Centrallix smackola that 12mb already download but the OM guy is seeing the GNUe light I think mommy im gonna cry i had to click a license agreement you know how long its been since i did that Sounds you have a nice fast connection dneighbo uh-oh. you probably agreed to be Steve Case's towelboy late at night (like now) its not uncommon for me to pull near 10Mbps er near 10Mbps BUT i only get 19Kpbs uplink NO MATTER WHAT (grrr) the golden rule with cable modems is to tell your neighbors how bad they are 10Mbps downstream is almost worth 19Kbps upstream so they don't want to share your pipe esands: but during day its more like 1 - 3 Mbps figures. 19K BITS uplink? and when im used to work (i work for government which provides the backbone to arizona) I have cable and I think it's 256Kbits now. i sit on a STEADY 1.5Mbps up/down at work MicahY: this is the slowest app i have ever seen it took a good 1 minute to prompt me for log in nice, that's at almost at the 2Mb sweet spot. and its still not even drawing anything but its thinking hmmmm but it's getting further than it did did it ask you to log on last time with 4.72? I'm still trying to d/l that page, but it seems to be grab stuff. Maybe I should stop so I dont split the bandwidth shut down nutscrape and retrying login much quicker and hey its drawing something Its a big page whatever you are showing me its not what that table is i.e. like only two or three fields match esands: seen maxnet's news? true. there are other tables besides that one. that was the main one and the only one I have ported to PG but that's what it does. btw: i still dont think this is much more than a day or so work you can scroll through the list of people, and click "supporting churches" to find out which church(es) support them. as it is maybe not. I know they're working on other stuff too.... Isomer (dahoose@port-62-158.jet.net.nz) left irc: "Client Exiting" its a pretty slick little environment ajmitch: yeah. Interesting. I sent an email seeking clafication and did you see the relationship box? it shows how supporters are related. :) yeah the JS is amazing. unfortunately JS sucks. :) yeah if you had all the tables ported i think you could match functionality pretty quickly most of my traffic is local, which is completely flat rate now. So I dont care. I dont use donkey for much either and honestly if you did as single tabbed form its quite possible the phpForms client would handle as it seems to do a bit now oh and there's also a demo on the Centrallix.net web site that you can run with netscape 4.7x. it shows other widgets (tabs & such) phpForms? is that a GNUe client? or something else? esands: only high-usage stuff i do is over ssh or http its a php based web client for GNUe Forms i.e. it reads .gfd's just like python forms and makes a webui for it ok cool I take it triggers only work in the wxPython client? that may be an issue there is a demo on the gnue site yes but deploying the Python client probably wouldn't be a big deal especially re what i said about central postgres ssh'd over net with nearly no performance loss and the gfd can be on the net as well interesting anyhow you want that form? its probably not of major use as most of that data isnt used in any of their samples er the application you showed me anyhow sure or maybe I'll just try to create it w/wizard did you use "simple form wizard"? eventually we'll probably need master/detail that's probably how they did the church linkage http://www.gnuenterprise.org/~dneighbo/kardia.gfd you will definitely need master/detail and fk entries but the other tables werent there to do that the biggest ouchie on the wizard right... I'll try to get the other tables ported tomorrow is we havent grokked wx scrollbars yeet so you end up getting a form that is say 100 pixels tall psu (~psu@manorcon.demon.co.uk) left #gnuenterprise ("cool quit msg are so lame..."). that's the biggest problem with forms samples, the useful ones require a db to be setup right :) but the designer scrollbar is hardcoded at say 40 pixels so its kind of a pain to get the widgets below 40 moved up dneighbo: was there an option in the form to turn off toolbar, etc? i've gotten good at it ajmitch: i dont know where that pattch stands ok styxman made it work dont know if patch wsa sent or if applied but jcater doesn't know if it's best way to go? something like that Action: ajmitch recalls vigorous discussion on the issue :) not as vigorous as chillywilly's diatribes tho MicahY: let me check on something derek: think I should just drop the type suffixes from field names (_c, _i, etc)? would be prettier I think, but I'm concerned about compatibility with them you have ANY influence with these guys? as we have an xml schema for databases i.e. you define a database in XML then use XSL and it creates the create_db.sql type file currently it supports sybase :) and postgres (plus lots more) and it has self documentor can it convert sybase TO xml? i.e. an XSL sheet that produces html docs from schema here's the deal: I just met them at ICCM that sounds cool and went to their presentation on this stuff dneighbo: where is it? they were looking for people to come to Atlanta for the summer to work on Centrallix publically available? ex: http://goats.gnue.org/~dneighbo/fsf/datadictionary.html is the output it would be working with Operation Mobilization and LightSys in doc mode and I was tempted to do it.... click a table name and get the schema ajmitch: yes its in dcl cvs under scripts/install/ I think they're listening to me, but they're also pretty heavily invested in Centrallix iirc ok cool, will look MicahY: this would have NOTHHING to do with centralliz its useful regardless it would let them write a db schema ONE time and have it work for several dbs ok cool so if they every chose to work with ANYTHIGN other than sybase they are set its not a 'gnue' thing in that regard its a gnue tool yes, but its usefull to anyone wanting to make create/insert scripts for more than one db but not maintain files for every db vendor and get a nice documented html file as well btw: based on discussions with jcater today it might be done at somepoint we go from db to xml i.e. using common's drivers and introspection create the .xml schema files from the db itself so in your case you would do convert to .xml form sybase convert from .xml to postgres and be on your way sounds good url? but as of today if you did it in xml i.e. converted the sybase to xml then go from xml to postgres then convince them to use the xml then no one has to convert again :) its in dcl cvs under scripts/install/ uyikes its beddy bye time bbl Action: dneighbo is away: sleep mgedmin (mg@bit.codeworks.lt) joined #gnuenterprise. esands (~nic@mdr1-port45.jetstart.maxnet.co.nz) left irc: "reboot" esands (~nic@mdr1-port45.jetstart.maxnet.co.nz) joined #gnuenterprise. wb esands sir btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: Remote closed the connection btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. alga (alga@bit.codeworks.lt) joined #gnuenterprise. wow, someone made IRC logs sorted nice hi alga hi btami hi all hello alga, btami hi ra3vat hi all http://www.codeworks.lt/~mg/gnue/index_html#irc Johannes (~jve@62.47.246.115) joined #gnuenterprise. MicahY ([1ohHKhyL4@12-225-21-62.client.attbi.com) left irc: "[x]chat" esands (~nic@mdr1-port45.jetstart.maxnet.co.nz) left irc: "TE) (Swing them udders" esands (~nic@mdr1-port45.jetstart.maxnet.co.nz) joined #gnuenterprise. siesel (jan@xunzi.sinologie.uni-bonn.de) joined #gnuenterprise. hi all ! hi siesel SachaS_ (~Sacha@dialup-196-117.wasp.net.au) joined #gnuenterprise. Action: siesel is going to the MENSA Action: btami is away: lunch SachaS (~Sacha@203.190.196.98) left irc: Read error: 110 (Connection timed out) btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: Remote closed the connection Action: Yurik is back (gone 17:35:30) is it possible to open a second form on a button click? apparantly it is I remember seeing this question somewhere... GNUe kernel cousin or IRC but I can't find it atm yeah, i asked last week too :) there were two solutions -- os.system() and some trigger/event/whatever derek says yes, using triggers, but he can't recall just how atm i think maybe look at navigator code to see how it opens form, implement that in triggers? Action: ajmitch is random guessing, might not be best idea how usable is navigator atm? Action: mgedmin is ashamed he has never tried it seems to be getting quite a bit better lately ah, it wasn't included in the 0.3.0 group release, that's why I newer saw it yeah, wasn't near ready it's got a bit of luvin since then ariel_ (~ariel@ppp-217-133-243-92.dialup.tiscali.it) joined #gnuenterprise. gnue-navigator uses the os.system("gnue-forms %s") approach does it? mgedmin: navigator uses os.system and and other approach for the other approach you have to look in UIwxpython.py