*** someon has quit IRC *** Amorphous has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** dimas has joined #gnuenterprise *** johannesV has joined #gnuenterprise reinhard: thanks for fixes in NamespaceCore.py .... it's workin ! *** kilo has joined #gnuenterprise *** dimas has quit IRC good morning all johannesV: good to hear kilo: do you know any news about our windows issues? wrt strptime and wrt plugin handling? seems like btami is hiding from me ;-) *** sjc has joined #gnuenterprise reinhard: btami is working on them and they look good errrr.... I mean btami is working on windows exe packages strptime I think is OK, he ran a test against it and it correctly displayed dates and times cool but plugin handling... hmm... I'm gonna ask him in 5 minutes reinhard: btami says plugins will be ok on windows setup.exe will be ready on 1-2 days cool McMillan can be forgot, py2exe is the way to go and he is not hiding from you just working... 8-)) 'if frozen' can be forgot too that's cool cool cool cool like Siberia *** SachaS has joined #gnuenterprise hi everyone hi hi kilo hi reinhard: i just respond to your email. even when client 2 committs and client 1 runs a query after the committ, client 1 still cannot see the "just" created business object. hi johannesV: good to see you comitting ;) @weather QVU kilo: Error: No such location could be found. *** thierry has quit IRC svn: Commit failed (details follow): svn: Berkeley DB error while opening environment for filesystem /var/svn/gnue/db: DB_RUNRECOVERY: Fatal error, run database recovery svn: Your commit message was left in a temporary file: svn: '/home/johannes/prj/gnue/gnue-forms/svn-commit.tmp' SachaS: hrmm, not finished sending all commits and svn crashes ... *!")(§/$)!""! dah :| whats the current url for the irc logs? reinhard: for your info: in the client 1, client 2 example i run two forms, both with the same "hacker" user. http://www.gnuenterprise.org/irc-logs/ thanks kilo *** dimas has joined #gnuenterprise reinhard: i think you can svn up now ... :) i'm going to add the self-test stuff to common.logic.language now SachaS: is there an airport in Vaduz? reinhard: i think we should add a sample-proc to the appserver's sample.gsd using procedures with params and result *** thierry has joined #gnuenterprise SachaS: ok, will look at it johannesV: agree on the sample.gsd procedure johannesV: is it possible to pass parameters when you call the procedure in a form trigger? reinhard: there is something like a call () ... so it's possible to pass params with that (as dict) will give this a try afterwards doh svn up gives me svn: subversion/libsvn_ra_svn/marshal.c:434: vwrite_tuple: Assertion `opt || cstr' failed. f* deleting the logic directory before svn up helped wow ... seems as if svn can't handle svn remove properly DB000: File "/home/reinhard/prj/gnue/gnue-common/.cvsdevelbase/gnue/common/logic/adapters/Base.py", line 148, in __init__ DB000: self._prepare () DB000: File "/home/reinhard/prj/gnue/gnue-common/.cvsdevelbase/gnue/common/logic/adapters/python.py", line 180, in _prepare DB000: raise language.CompileError, self._traceback (1) DB000: NameError: global name 'language' is not defined ups when starting appserver sample form lost an import statement reinhard: svn up you guys are amazing! :) svn up gnue gives me also svn: subversion/libsvn_ra_svn/marshal.c:434: vwrite_tuple: Assertion `opt || cstr' failed. Aborted *** chillywilly has quit IRC SachaS: delete common/src/logic directory, then svn cleanup gnue. then svn up gnue thanks kilo is somebody here running forms against a postgres database directly? i mean without appserver? not me. have not done so for a while. are there any outstanding commits? make postgresql fails in samples dir. works for me ok. will try again. DB000: AttributesNSImpl(newattrs, qnames)) DB000: File "/usr/local/gnue/lib/python/gnue/common/definitions/GParser.py", l ine 258, in startElementNS DB000: raise MarkupError, tmsg DB000: gnue.common.definitions.GParser.MarkupError: Error processing ledata> tag [I do not know what a tag does] make: *** [postgresql] Error 1 have a fresh checkout of gnue-common ... do i need to run setup-cvs again? not sure johannesV: you still here? do you know what this means? there's a missing 'importable' in common.schema.GSParser rerun setup again. removed gnue-common before svn up SachaS: make postgresql fails ? ok is working again. i removed the gnue-common tool (rm -rf) and then did a svn up gnue-common ... but now I rerun the setup-cvs.py and it (make postgresql in samples) works again. sorry for confusion. ? johannesV: make postgresql works for me, too. again. ok guys, i'm now leavin for lunch and the some outdoor-work ... i'll be back in the evening (i hope so) thanks johannesV! i hope so too ;) * johannesV is away: family johannesV are procedures with parameters and return values working? can i test them? SachaS: if you want ;) of course I will test them. amazing how you made it work! i am amazed how well you can enhance the given code ... :) will test after lunch. reinhard: jcater gave me an account on ash, last night. so that I can scp the gnue appserver manual. a) i forgot where the place was, where I have to copy the file (was somewhere /var/www .../appserver/...) b) when I tried last night I got a permission denied. i will check a) on the irc-log a) is not in the public log :( SachaS: i'm not up to date with the website structure reinhard: thats ok. will check with jcater. reinhard: are you happy with what you have achieved the last couple of days? well strictly speaking i am happy with what johannes has achieved the last couple of days ;-) mainly haha *** btami has joined #gnuenterprise hi btami was only joking about you hiding :) good to hear things work again on windows hi yes, they will i was only a lurker in last days, but real work was very important btami: yeah, i know, that weird thing called "real life" :) @revision channellogger Vee: $Id: ChannelLogger.py,v 1.24 2004/02/17 19:04:24 jemfinch Exp $ Traceback (most recent call last): File "c:\python23\Lib\site-packages\gnue\forms\GFForm.py", line 520, in commit block.processCommit() File "c:\python23\Lib\site-packages\gnue\forms\GFObjects\GFBlock.py", line 416 , in processCommit self._resultSet.post() File "c:\python23\Lib\site-packages\gnue\common\datasources\drivers\Base\Resul tSet.py", line 274, in post self._postingRecord.post() File "c:\python23\Lib\site-packages\gnue\common\datasources\drivers\Base\Recor dSet.py", line 240, in post self._postChanges() File "c:\python23\Lib\site-packages\gnue\common\datasources\drivers\DBSIG2\Rec ordSet.py", line 54, in _postChanges statement = self._buildUpdateStatement() File "c:\python23\Lib\site-packages\gnue\common\datasources\drivers\DBSIG2\Rec ordSet.py", line 118, in _buildUpdateStatement updates.append ("%s=%s" % (field, UnicodeDecodeError: 'ascii' codec can't decode byte 0xf5 in position 4: ordinal not in range(128) trying to save 'Bajusz Tamás' in my test gfd s/'Bajusz'/'Petőfi' figured that position 4 :) if you look at DBSIG2/RecordSet.py line 118 there are 2 parameters to the %s=%s string it seems that one of them is a string and the other is a unicode can you find out which one is which? the first is string the second comes from 'Petőfi' and is uniocde or string type? i use only ascii filed/table names in my db reinhard: how do I check for an empty string of a property? if is None there is no difference between an empty string and None ok. when i check with repr ( propertyname ) i get u'somethingsomtehing' but then it's not empty? hold on. reinhard: i will try later, real work comes to me... btami: ok thanks reinhard. it was working. was my mistake. checking for None is OK. so far i have tested my old forms, old procedures with new code. had no problem. going to test a procedure with parameters, and then the return value. cool test as in making one or two sample procedures... now, because the procedure have parameters and return values I have to change my application again ;) reinhard: trying to help btami, both strings are unicode *** jamest has joined #gnuenterprise *** jamest has left #gnuenterprise in python, is there a construct to comment over more than one line? ala /* \n\n\n */ kilo: i'll have to try to reproduce it ok. string and boolean parameter work. SachaS: start every line with a # SachaS: no other possibility ok. thanks. will check return value. string return value works. cool. hehe when returning a business object from the appserver procedure to the form (traceback of form): return self._adapter._runMethod (self._methodname, *args, **params) File "/home/sacha/gnuenterprise/gnue/gnue-common/.cvsdevelbase/gnue/common/rpc/drivers/xmlrpc/pw_xmlrpc/ClientAdapter.py", line 107, in _runMethod result = to_call (*__args, **params) File "/usr/lib/python2.3/xmlrpclib.py", line 1029, in __call__ return self.__send(self.__name, args) File "/usr/lib/python2.3/xmlrpclib.py", line 1316, in __request verbose=self.__verbose File "/usr/lib/python2.3/xmlrpclib.py", line 1070, in request headers ProtocolError: did not expect it to work. hmm...appserver doesn't want to start kingpin2k did you svn up? just did *** dsmith has joined #gnuenterprise did you rebuild the gnue database? ah no thanks try that *** jcater has joined #gnuenterprise mx.DateTime works also as return value. trying a dict as return value next dict as return value works also. :) *** btami has quit IRC *** jamest_work has joined #gnuenterprise /who jamest *** jamest_work has left #gnuenterprise *** jamest_ has joined #gnuenterprise *** kilo has quit IRC SachaS: I fixed the permissions on that file if you want to try to scp again jcater: can you give me the path again, please /var/www/tools/appserver/docs/appserver_howto.pdf ok thanks *** dsmith has quit IRC *** dsmith has joined #gnuenterprise @weather perth SachaS: Error: No such location could be found. @rhat *** kreiszner has joined #gnuenterprise *** dimas has quit IRC *** dimas has joined #gnuenterprise *** kingpin2k has quit IRC *** chillywilly has joined #gnuenterprise how do you disable ipv6 in debian? my laptop is insisting on setting it up and I've set every occurance I can find of net-10-pf to off, update-modules, and rebooted *** kingpin2k has joined #gnuenterprise *** wendall911 has joined #gnuenterprise well new plugin loader works could be very interesting for you, jamest and jcater should improve error handling and such for now, i've changed rpc driver handling to use this plugin loader i think it should very well be possible for datasources/drivers not sure about forms uidrivers or reports filters or any other plugin systems we have now *** wendall911 has left #gnuenterprise *** wendall911 has joined #gnuenterprise oops, that's what the X does heh reinhard: that's cool I want to look at it as I'm sure the other examples you gave can use it too jcater: as soon as you regenerate epydoc new plugin loader? there will be a quite complete documentation in the web we now have a standard one? jamest: yes jamest: he generalized loading plugins w00t! jamest: it can do like $ gcvs plugin.py postgresql find postgresql: gnue.common.datasources.drivers.postgresql.pypgsql err well if you have a structure like we have with load ('postgresql') it will load the first available postgresql driver with load ('popy') it will load popy s/available/functional/ i'll be interested in that where functional == all dependencies fulfilled as I use plugins alot and was thinking it'd be nice to have a std handler if none of the installed drivers works, it generates an exception like this: i assume this is in common? gnue.common.apps.plugin.LoadError: Cannot load plugin xmlrpc The following plugins failed: * gnue.common.rpc.drivers.xmlrpc.py_xmlrpc: AdapterInitializationError: Unable to load xmlrpc. To use the XML-RPC interface, please install xmlrpc from: http://sourceforge.net/projects/py-xmlrpc the appropriate DEBIAN package is python-xmlrpc.deb * gnue.common.rpc.drivers.xmlrpc.pw_xmlrpc: AdapterInitializationError: Unable to load xmlrpclib. To use the XML-RPC interface, please install xmlrpc from: http://www.pythonware.com/products/xmlrpc/ yep that is if for example you wanted postgresql which means you added docs to the developers guide already right? and none of our 4 postgresql drivers work =) you get an exception that lists all 4 exceptions that happened when trying to import the drivers also it has a list() method that returns a dictionary for all installed drivers where the key is the driver name and the value is either the loaded module of the driver or the exception that hapened when trying to load it so you can generate lists like available drivers: postgresql.popy: ok postgresql.psycopg: ImportError: module foobar not defined mysql.mysql: ok etc. gack! feedback? robust code? that has no place in gnue! even worse comments! ;-) sigh but! no docs yet so there's still hope well docstrings :) i almost forgot to mention of course it doesn't need the DRIVERS = [...] list any more well apart from that johannes has done major changes in the trigger execution code it would be nice if both of you (jamest, jcater) could test do the plugin files require a dict to make all that happen? as i figure you use most of the trigger features jamest: a dict? i have apps that load an entire dir of plugins w/ no prior knowledge not sure what you mean jamest: that 's what his does scans a directory ah yes which is what dbdrivers originally did, but our win32 install won't support that which is why we added the DRIVERS = [...] thing but I think we might have a way to work around mcmillan jcater: btami confirmed today that he can make it work under windows excellent s/confirmed/pretended/ ;-) j/k if dbdrivers used the new plugin loader we could also undo that delayed loading stuff which would basically reduce some drivers to a 2-liner class Connection (Base.Connection): pass :) I'm not as sure about that how that would work but we can try in fact there *may* not be a delayed import or the loader cannot find out whether the driver is usable or not for a driver with missing dependencies an exception *must* occur upon import which sample for 2-tier gnue forms is fastest to setup? zipcode is what I use thanks *** dimas has quit IRC that's probably the most well tested piece of code in the entire project zipcode.gfd if it runs we're good for release *** kreiszner has quit IRC zipcode and intro yip :) probably sad just how true that is *** kreiszner has joined #gnuenterprise hi kreiszner hello jamest is gnu-sb actively being worked on and at what point is it i don't think it's currently being worked on sad Vee and derek were working on it but I don't know where they are at i also *think* jcater was adding in aria schema/support but got sidetracked aria? http://arias.sourceforge.net/ at least one of their developers hangs out in here dcmwai and i believe there is interest in interoperating with them they were/are looking at using pieces of gnue I have been looking at gnue practically from its inception but didn't feel earlier that I had the knowledge to actually get it up and running for my busness I have moved much of my data over to postgresql from MD access how do you access it now? but I am still using only psql as my primary interface and yet my desire is to develop or find a package to do all of my accounting and inventory management i think that is where the gnue-sb guys were working i really haven't looked at it yet though i have a client that has some interest in moving out of quickbooks for what they need aria is close which means I will have to look at gnue-sb soon sigh, i need a clone * jamest had convieniantly forgot about needed to look at aria One of my purposes for working with psql was to familiarize myself w postgresql while you are ordering clone can you order one for me to you bet. you want one of yourself or of someone else? It doesn't mater if they can help me my ride is here for lunch i'll be back in about 1 hr by if you do try gnue load common, forms, designer and you can rapidly make screens for your existing data as psql maintainenance has got to hurt :) i'll be happy to help you thru the process if you like yes I don't do actuallly accounting iit yet since my lunch ride is also my wife i really have to leave now :) bbi1h by *** kreiszner has left #gnuenterprise hi reinhard: what was the problem with client1 / client 2 ? last patch (rollback) probably yes off for today cu *** reinhard has quit IRC heheh gotta love his quit messages @gvim++ sigh i meant to tell him i'd test triggers out over the weekend s/him/reinhard ouch er, wrong window what's the path to anon svn? erm, for common anon common? svn://svn.gnuenterprise.org/var/svn/gnue/trunk is anon svn tack on /gnue-common to only get common k actually I just wanted contrib ;P I think I'll grab it all geez...website is rather large ;) contrib is separate repository svn://svn.gnuenterprise.org/var/svn/gnue-contrib bleh *** sjc has quit IRC anyone tested forms trigger with new patches from reinhard/johannesV ? SachaS: not me could anybody tell me how to give my user account permissions to print :) ok. forms still working, was my fault :) *** altis has joined #gnuenterprise *** johannesV has quit IRC wendall911? jamest: using cups, but getting a Media tray empty! message, figured it was a permissions problem can cat a message to the printer device from root and it works fine Linux printing information == crap jamest: a = {'a': b, 'c': 5} is a dict, right? and ['a','b'] is a list, right ? yes ok. seems like, when i return a dict from a appserver procedure I receive a list in the form .... a list which includes a dict. yep. a dict is packed into a list and sent back. *** kilo has joined #gnuenterprise *** altis has quit IRC *** revDeke has joined #gnuenterprise *** sjc has joined #gnuenterprise ------- if anyone gets an error like ImportError: cannot import name getLanguageAdapter rm -rf gnue-common/src/logic/language then you should be fine ------- what is status of navigator good design sessions today several things i am thinking gnue can not do well :( 0.0.6 BUT all most all of them are things required for a financial system so at some point we need to address most notably is ability to do "transaction detail" i.e. ledger detail so if you have an account and it has $45 in it you want to to change the value to $50 you don't over write $45 w/ $50 but instead add $5 now $45 + $5 = $50 ? why can't we do that now in thinking about it from the forms perspective you could do it through complex entries but it renders to a degree the power of the form useless I guess I don't get what you describe I do something similar on my sales ticket forms at the store or at least I guess hmmm maybe I misunderstand how to best explain wife enters a new line in detail block total is updated in master block i have a transaction table that has ACCT 1 it has 8 records and taxes are recalced, etc all for $1 so the total is $8 in the UI i want to show $8 (and none of the detail) i change $8 to $15 dollars and when i do so it writes a new record for $7 to that account jcater: the problem is doing that w/o doing the detail block so i was thinking in order to do it you would have to have "dummy" entry widgets then hide the detail source and the master source load the contents of the master into the dummy I see what you're saying and on save do a "diff" and write the diff as a new record in the detail same thing the spanish group hit and refresh the dummy entry though I can't imagine something behaving that way most I've seen you have to post a correction i.e. i think forms could do it via triggers and dummy entries * jcater isn't questioning need, just saying I've not seen that in any accounting systems we've used you have to account for the detail record (i.e., the change) but once we get into dummy entries why bother using forms how do the systems you use work? you have to post a $7 adjustment w/explanation i can see it only happening one of two ways (and this is more a budgeting than an accounting function) accounting i would post the $7 adjustment but with budgeting you arent thinking in terms of single transactions per say and more a global perspective ie. you want to enter what you want to spend but what you describe shouldn't be hard to w/our datasources and a little TLC not what you wanted to spend before +/- an amount to get to where you want to spend i.e., I'm sure you could mark a datasource as "transactional" jcater: i think gnue-common would handle it just fine (bad word, though, as transactions+databases usually imply something else im just not sure if i lose too much in forms that it starts to become more hassle than benefit ? audit trail is what you could call it or ledger detail the other option though less "accounting like" *** altis has joined #gnuenterprise would be to do an "audit log" so that you have no really ledger you have $20 and want to make it $40 you overwrite teh $20 w/ $40 but then in an audit table you note who changed that record at what time and what old value was and what new value was yeah, I've done both approaches here it achieves to a degree the same problem we want to solve and that is "audit trail" accountablility within the budget system however it does not look like a normal "accounting ledger" so confuses accountants the other way looks like an accounting general ledger detail which they like but unlike an accounting system you are not posting Journal Vouchers or Debits/Credits to come to a number but instead posting a number and relying on the system to auto create the transaction detail if you think it is doable that gives me great hope :) I don't see it as a big deal good night bye of course, we can't do it at the moment *** SachaS has quit IRC * revDeke was thinking it was possibly but possibly more cumbersome than just using gnue-common and pyGTK natively but I don't think it'd be a big deal to add timewise what do you think it would take to add? i REALLY want to use gnue (all pieces of gnue) for this project um well first I I'd check out papo but i am on tight time line of having to deliver by early july and see what they did and if we wnant to use their approach so amount of time putting into infrastructure enhancements will be limited on this side :( lemme think thru the datasources for a sec good news is if we did this in all gnue there would be major precendent that the framework is DEFINITIVELY ready for production financial applications the other thing that is going to kick my ass is security we HAVE to have a lot of field level permissions and im just not sure the best way to handle that right now i know that we will have tables w/in the application that store permission data but not sure best way to make forms implement that * revDeke is suspecting for now it will have to be all trigger based navigator i think will solve a lot of issues i was thinking forms fell short on previously as its tree plus "parameterized" forms solves a big issue for me in needing tree component the only big draw back is i would love a dynamic navigator :) i.t. many of the contents coming out of table instead of an xml file any random table? or just a table in general a table in general would work basically i need security in it and so if it was table driven and i could talk to my security table i could build the access trees in navigator dyanmically based on profile and security makeup for exmaple say i wanted have a form that displayed a budget so i make it a parameter that tells which department to load now i have one form and in the navigator tree i have a list of all the departments if i click on dept 10 it opens dept 10 budget if i click on dept 50 it opens dept 50 budget revDeke: what database? backend but you see if you are an OMB user you woudl see all departments if you are a sheriff user you might see only 2 departments etc jamest: mssql psych! postgresql of course as postgresql has rules that allow for a poor mans audit train train traiL choo choo! i have our db looking at that the problem is this needs to be something the end user can see readily so are those "logs" or "tables" tables here hmmmm CREATE RULE rule_note_insert AS ON INSERT TO note DO INSERT INTO log_note (claim_no,userid,date,note,mod_type) VALUES (new.claim_no,new.userid,new.date,new.note,'I'); put in 3 of those I've done both approaches in oracle using triggers insert, update, delete (which postgres could do too) sadly i want to avoid triggers in the sense i want this to be portable, but i have to do what i have to do modify that last field to be 'I','U','D' (i'll let you figure out what they stand for) you are done poor mans audit trail jamest: that solves my initial problem of the audit trail, but isnt good in that it doesnt look like a ledger about as portable as I am good looking though so is this a postgres feature? i.e. do you have to create those tables or are they created via some setting initially * revDeke was thinking of doing this as explained above as an option if need be you create them in your ledger effect, are you wanting one table and a details table? or just a single table altogether? it's really brute force, non portable jcater: it coudl be done eitehr way but it works for tracking who did what when i use it cause I'm lazy and needed it yesterday we discussed the proper db way is probably one table BUT two tables is probably better for performance over time and the second table is merely a "Bucket" for consolidation so as you write that $7 transaction to detail table it automatically resums all the keys and updates the budget table er bucket (not budget) and at anypoint you could reabuild that bucket table entirely out of the detail we are not sold on one way or another at this point we have all done both approaches at one time or another which brings up the other question i had... what is transiosolation like in postgres? do tehy have repeatable rereads or something similar so if you pull a record into memory and change it then go to save it revdeke you guys use ERWin huh? and someone has changed that record before you save can you get it to reread the original to let the programmer know if the record is clean or dirty ? what is ER Win? um it is right now we are using a white board and openoffice... soon to use emacs/gnue :) and I quote the tool set of choice for Maricopa County http://www3.ca.com/SuccessStories/Success_Detail.asp?CID=38944 ? what I intended to do (and can't remember if it's still on my todo list or done) it aint the toolset for my ass i dont know of anyone here that uses it ah, nevermind must be an elected official :) they had that link on the ERWin page sql-forms, when you first try to change a record and it's not erwin it tries to lock the record for updates (not for reading, just updates) until you save your changes jcater: i would LOVE that but i dont think postgres can do that can it? I'm sure yes as that's always one of the arguments of pgsql over mysql is mysql didn't do row-level locking for a while (can now, I think) larry bernosky eh.. i dont even know where the hell he works can we make forms do that? hold something for a lock? that would be done in the datasources wouldn't it not forms as part of the issue is once you go in edit mode you have to have locks time out yes well yes then forms would call the lock jamest: thats what i meant i think all we'd need is a select for update on the record in question that is a feature I need btw: like i said if we can do thsi all in forms.. forms will be ready for primetime financial applications jamest: yes but how portable is select for update oracle yes pgsql yes jamest: I'd do it like we do the transaction support poorly? * jamest runs the base drivers would call self._lockRecord if a database can't support it, then _lockRecord is nothing more than a return morning all I think most dbs support some form of record locking whether or not it's select for update, I dunno morning ajmitch: good morning *** altis has quit IRC heh sup ajmitch ? aw shit I gotta bust some aussie heads don't I? gidday chillywilly battery? gidday mate hmmm maybe we can talk more tonight no way *** revDeke has quit IRC *** johnf has joined #gnuenterprise Hi, I'm a newbie to IRC and GNUe. I'm using X-chat and on the right of the window there is a list of names. The Names are people logged in? hi john yes, that's correct *** dsmith has quit IRC Great - I hoping someone can help me get the GNUe working. I have been following the "SUSEQuickStart" doc's and have an error when I attempt a database connection. are you using a released version? or one of our nightlies? is that your email on the mailing list? I believe I have the released version. My common is 0.5.3 one thing I noticed is your connection.conf is slightly different than the one listed on the howto [gnue] comment = Production DB(G) provider = pygresql host = gnue dbname = gnue is what's on that quickstart notice the provider= line Right - I tried that first then the one I listed in my email (thanks for reading it). Also note that I chnaged the host, and dbname. well, given what you posted in your email I don't think it's something you did looks like that release had a bug in the pygresql drivers :( try installing a nightly, as I'm sure that's been fixed I think there's a link in that Quick Start guide ah, no there's not http://www.gnuenterprise.org/downloads/snapshots.php I'm not sure how to use SVN/cvs and I don't see a link on the 3 pages of the howto You typed it to fast- how do I use it? no, the links on that page are installable just like the released version you downloaded you don't need svn/cvs they just aren't official releases Duh!!! I get it - it's a link - I'll do it immediately. I have to run maybe someone else can help if you have any more questions BTW should I download all the links? no just the first GNUe-Common and the first GNUe-Forms listed (to test forms) Then I download only common first and test. Thanks for you help. *** jcater has left #gnuenterprise *** kilo has quit IRC I have donwload the nightly and I changed the provider = pygresql and get the following error "No module named Driver" Changing the provider to "postgresql" gets "cannot import name Connection" *** wendall911 has quit IRC *** jamest has left #gnuenterprise *** btami has joined #gnuenterprise *** jbailey has quit IRC *** sjc has quit IRC *** dyfet has joined #gnuenterprise *** jcater has joined #gnuenterprise Hi Jcater I have downloaded the new common and forms and still get errors? the same error or different errors? *** jamest has joined #gnuenterprise The same two errors - "provider=pygresql" - "No module named Driver" Using Postgres as the provider gets "Cannot import name Connection" hmm what does gfcvs --version return? that's a very odd error to still be getting where do I run gfcvs? well ag ah sorry wrong command gnue-forms --version hi johnf Hi * jcater is doing a lot of things at once and am getting confused :) I don't know where gnue-forms lives what folder/directory still having troubles w/ suse? Yes ok, i'm new to suse but I'll try and help and we can let jcater go back to sleeping or surfing for warez or whatever he's doing did you try that python import I asked about? Not sure what you making a reference too? you sent the mail to the ML right? i send a responce asking you to open python and try to manually import a dbdriver Yes - but I have not seen any replies as of yet wow, i sent that at 4:14pm cst Ok I have python open import psycopg No modue named psycopg ok, that explains the traceback the line you had provider=postgresql is kinda random in the quickstart i have provider = pygresql i imagine the sample file has the postgresql as that was the proper way back when the sample files were first created Yes I know but I thought I'd try different providers so it does, but I know nothing about how it tries them :) if you give me a moment i'll reboot into suse and help you figure this out brb *** jamest has left #gnuenterprise *** jcater has quit IRC *** jamest has joined #gnuenterprise whoops sorry about that *** jcater has joined #gnuenterprise @ping pong * jamest forgot he fragged his suse install OK but it's back up now :) i'm suse'n I have just noticed that I check the site-packages that there no folder for PG (what is the correct name) i'm checking that now >>> import pg >>> There is a pgmodule.so and two *.py import pg worked just fine ho about import pgdb import pgdb worked hmm could you try changing your provider to pygresql OK I'll try that again i'm sorry did i ask you to try pygresql or psycopg * icltlfatppl is back (gone 40:09:22) *** jcater has quit IRC Where is the import pg and pgdb files ? *** jcater has joined #gnuenterprise i have them in /usr/lib/python2.3/site-packages/ and in /usr/lib/python/site-packages/ both contain the following files I can't see them /usr/lib/python2.3/site-packages Could this be something with permissions? Oh I see they are *.py FILES sorry they are there jamest@linux:/usr/lib/python2.3/site-packages> ls -ald /usr/lib/python* lrwxrwxrwx 1 root root 9 2004-03-22 20:30 /usr/lib/python -> python2.3 drwxr-xr-x 17 root root 17704 2004-03-22 20:44 /usr/lib/python2.3 I didn't realize they were file - I was looking for folders The fact that I can import the files - does it mean I can connect to the PG database? i would think so what is the command line you are using to start gnue-forms? I first CD to GNUe-Forms0.5.3 sigh, i have to leave in about 10 minutes btw, i'll be gone about 1 hour !@#!@# customers :) then /usr/local/gnue/bin/gnue-forms states.gfd what did /usr/local/gnue/bin/gnue-forms --version return? * jcater missed that earlier states.gfd does attempt to connect to the state table so you are in the samples/zipcode directory Version 0.5.3 yes that's where I start from have we made any patches to datasources lately jcater? as I did the quickstart from the 20040322 snapshot If I had the wrong table name or wrong user name etc - would I a different error message (like I can't login) yes this is something else entirely it screams import error can you do me a favor yes psql -h dbhostname -U username nameofdatabase johnf: any luck? I can't do that from the box I'm on because I did not install any postgres client stuff I could from the postgres server hmm can you try that on the postgres server psql -h localhost -U user dbname sure just wait a minute * derek suspects you really have a driver problem not a postgres problem johnf, he's trying to make sure you have inet listeners open but the one error seemed like a dorked connection sigh the traceback he mailed shows no db driver loaded I don't understand how he's getting that version it should return jamest: there were two different errors GNUe Forms Version 0.5.3.99 GNUe Common Version 0.5.3.99 if the connection was dead he'd get a connection error in red johnf: the stupid question not 0.5.3 you grabbed the new files from url jcater gave you what did you do with them? did you setup.py install them? like you did the originals? OK that worked just fine - I'm connected to the database jamest: the traceback I saw looked like a code error not a "no datadriver installed" error i thought that error happend when it ran out of DBs *** dyfet has quit IRC I can't check my mail as for some reason johnf: after downloading snapshot of common and snapshot of forms did you reinstall? irc is the only internet-related thing I can do jcater: good my trojan worked Yes but I did not remove any old fioles bingo! files hmm 0.5.3 is broken on suse I thought the exception was something like "no module named Driver" i just installed and can confirm it you'll need to rm -rf /usr/local/gnue/lib at a minimum and install a snapshot OK yes I thought it was but the bigger question is why didn't the nightly snapshot install work? i really need to go as I have client expecting me to break their system at 7 jamest: need a hammer? i imagine w/ the trigger changes today a new release is out of the question :( * jcater has a 22oz estwing framing hammer next to my desk (good for debugging sessions) johnf, the 20040322 snapshot was what I used can someone update the wiki to point this out to people argh, i really must run l8r derek: unfortunately, ssh to ash no workie either so I can't get svn updated to work :( jamest: yes err, well I will later hmmm time to dcc jcater an svn tree ;) jamest: so current snapshots ok 0.5.3 broked? I intended to pretty much finish the website tonight if so i will update wiki now the pygresql driver is broken in 0.5.3 which is what is prepackaged for SuSE OK I should use 20030322 - right that should work Should all the modules match - forms,report etc? probably would be best given the issues we've hit :) OK I'll try it out - be back in a few BTW every time I use "./setup.py install --prefix" I have be root - is this right yes OK I get "no previously-included directories found mathcing 'etc/.svn' and 'doc/.svn' I all OK? hmm did it continue? look like it installed? I think those can be ignored ok I get "importerror: cannot import name Connection" The current provider = psycopg gnue-forms --version if it is 0.5.3.99 change your provider to provider = pygresql and try again It's still just 0.5.3 no 99 ImportError: No module named Driver i think there still exists an issue the lastest snapshot should be returning 0.5.3.99 Not using the latest but 20040322 well, any of the snapshots what directory are you running ./setup.py from BTW the error message line is either 41 or 42 from pygresql From what ever module I just installed When installing common from GNUe-Common.0.5.3 I wonder if that's your original tar -xvzf directory I'd expect it to create a directory called GNUe-Common-0.5.3.99... That's right - GNUe-Common-0.5.3.99+svn.20030322 I can attempt to rm the all the gnue folders and start over I have to take my wife to dinner (I promised) I'll be back around 7:30 PST I leave the connection open so I might be able to read any info that might help me. *** jcater has quit IRC *** jcater_ has joined #gnuenterprise *** mdean has joined #gnuenterprise *** dneighbo has joined #gnuenterprise *** derek has quit IRC sigh *** jcater_ has quit IRC *** jcater has joined #gnuenterprise *** jcater has joined #gnuenterprise for the record 0.5.3 pygresql is completely broken for all distros anyone care to test my hotfix? ugh why can I not get the db setup again? ? keep getting python errors what's wrong? from our stuff? gnue-schema I'm wondering if I've f'd something sigh brb *** jamest has quit IRC *** jamest has joined #gnuenterprise wb thanks Traceback (most recent call last): File "gnue-schema", line 24, in ? from gnue.common.schema.scripter.Scripter import Scripter File "C:\Python23\Lib\site-packages\gnue\common\schema\scripter\Scripter.py", line 25, in ? from gnue.common.schema import GSParser File "C:\Python23\Lib\site-packages\gnue\common\schema\GSParser.py", line 33, in ? from gnue.common.definitions import GParser File "C:\Python23\Lib\site-packages\gnue\common\definitions\GParser.py", line 33, in ? from gnue.common.logic.GTrigger import GTrigger File "C:\Python23\Lib\site-packages\gnue\common\logic\GTrigger.py", line 40, i n ? from gnue.common.logic.language import getLanguageAdapter, RuntimeError ImportError: cannot import name getLanguageAdapter any ideas? yes whew you running from svn, right? right I hit this today too.. nothing you've done ok, cd into gnue/ updated this mornign and then again tonight ok then rm -rf gnue-common/src/logic/language/ then you should be fine sorry about that one of the disadvantages of using svn instead of a prepackaged release :) (but there are advantages to using svn too) run setup.py again? or no? um hmm you may also need to rm -rf /usr/local/gnue/lib/gnue/gnue-common/logic/language (that path might be slightly off... it's from memory) I'm on windoze :-) ah then that path is definitely off hehe then I think it's c:\python23\\gnue\gnue-common\logic\language or, something liek that sorry, I don't have a windows machine handy to refer to no prob...I'll give it a try thanks for confirming that I'm not crazy tho lol I can't confirm that but in this instance, it wasn't anything you did true truth is, I'm the only sane one...everyone else is crazy well the evidence is pointing against you that's because you're insane ;-) you're insane, but your fix worked perfectly...thaks thanks you've tried gnue out and actually came back * jcater ducks I've got an erp package to build that makes me crazy by definittion cd .. oops hehe not crazy just dumb hmmm...I think I'd prefer crazy the hoxfix can be found on the current releases page sent mail to the list but not sure it'll go thru nite *** jamest has left #gnuenterprise * chillywilly is crazy too not that this fact is anything new *** holycow has joined #gnuenterprise *** jcater has quit IRC anyone around?