*** reinhard has joined #gnuenterprise *** johannesV has joined #gnuenterprise good morning *** kilo has joined #gnuenterprise good morning all * johannesV is about to file a bug for python-maxdb ... sent :) *** btami has joined #gnuenterprise *** btami_ has joined #gnuenterprise *** btami has quit IRC hmm how to create a datetime.date[time] from a string (given in ISO format or whatever) ? mx.datetime can read iso formats yeah, but i don't want to use mx.datetime instead i want to use python's standard datetime lib oh >>> import time, datetime >>> print datetime.datetime.fromtimestamp (time.mktime (time.strptime ('2005-06 -27 11:10:50', '%Y-%m-%d %H:%M:%S'))) 2005-06-27 11:10:50 *** johannesV_ has joined #gnuenterprise *** johannesV has quit IRC *** holycow has quit IRC *** yure has joined #gnuenterprise *** btami_ has quit IRC *** btami__ has joined #gnuenterprise *** kilo has quit IRC *** btami has quit IRC *** erkki_ has joined #gnuenterprise *** kilo has joined #gnuenterprise *** jamest has joined #gnuenterprise *** mnemoc has quit IRC *** mnemoc has joined #gnuenterprise is there a way to give readonly access to users, enforced by appserver? no access control is not yet implemented in appserver ok *** kilo has quit IRC *** jamest has quit IRC this is amazing johannesV_ is checking how databases are able to handle fractional seconds in DATE, TIME, and TIMESTAMP columns there are *no two databases* that behave the same and there are even *no two dbsig2 modules* that behave the same i.e. even the 3 different postgres drivers we have behave differently fun:p and in fact there is no single database/dbsig2-driver combination that handles even milliseconds correctly for time and timestamp columns what excactly are the differences in the handling? reinhard: as kilo said one day oh, how big zoo God have created... kilo: lol :) dimas: :) erkki_: some can store up to 6 fractional digits in seconds (i.e. microseconds) namely postgres and if you give more, it rounds interbase can store 4, if you give more, it gives an error message mysql can't store any *** SachaS has joined #gnuenterprise sapdb can only store fractionals on timestamp columns, but not on time columns hi reinhard hi SachaS then for postgres did you have a good time in Karlsruhe? psycopg just discards the fractional parts (even though the backend would store it) pygresql returns with full resultion, but a string instead of datetime types pypgsql takes the 6 fractional digits the db returns and rounds to 2 digits SachaS: it was great plain great i bet it was. http://flickr.com/photos/beita/22133934/ http://flickr.com/photos/beita/22133932/ reinhard: have you thought about using a custom char field(s) for gnue's date,time,datetime datatypes? are there specific reasons to prefer native date types (ie sorting or whatnot) I refuse to reinvent the wheel just because others don't do it right autsch ;) actually we plan to file bug reports (if needed with patches) to the dbsig2 drivers) ok, sounds good *** kreiszner has joined #gnuenterprise *** jamest has joined #gnuenterprise What version of psycopg is preferred? I have just built common, appserver, forms and designer on gentoo and having trouble connecting to the database I am not aware of any critical differences between psycopg versions ok I will reemerge and take what they offer kreiszner: I'm using dev-python/psycopg-1.1.15 erkki_, Thats what gentoo is recommending apparently a downgrade from 1.1.18 can't comment on that, I haven't emerged world for a while:p erkki_, are you using gentoo on a production machine yes, I'm using gentoo on production machines as well, but I'm messing with gnue stuff on my home machine I have converted most of my msaccess files to postgresql and hope to use gnue as my frontend if I can get the thing to connect. so far no joy, are there any tricks to this that I should know I didn't do anything special, I didn't even install psycopg, it was installed already.. are you getting any errors or what? it says "Unable to connect to real" real is my database that I routinely connect to with psql use --debug-level 1-9, and see, if you catch any errors for forms cmdline, or whatever you're trying to access the db with Here is what I get DB001: 0:00:19.160 [DataObject:105] DB-SIG database driver backend initializing DB001: 0:00:19.161 [GConnections:302] Attaching to DataObject_Object (object) Unable to connect to real I have used several platforms over the last year or so and I have always had the same problem, connecting to the database. kreiszner, can you connect with psql? yes do you use the -h option when connecting with psql? I use no options I use expressions like echo "\l" | psql real can you paste your connections.conf entry (less any passwords) I assume this is all on one machine? (i.e., the database and your gnue install?) all on one machine, I havn't put any passwords in connection.conf [real] comment = real Database provider = psycopg host = localhost dbname = real # encoding = iso8859-1 ok can you try this: psql -h localhost real and see if you get a connection error? works fine hmm comment out the host = localhost part and see if that makes a difference no diff are you running gnue and psql as the same user? yes as postgres is connection.conf supposed to have a password entry no, it can have one for automatic logins but shouldn't be required hmm can you go into python and do >>> import psycopg >>> psycopg.connect('dbname=real host=localhost') py sorry about that may be getting somewher Traceback (most recent call last): File "", line 1, in ? NameError: name 'psycopg' is not defined what platform are you on? gentoo err, distro have you tried to "emerge psycopg" ? * jcater isn't too familiar w/gentoo * mnemoc pukes just did psycopg-1.1.15 it downgraded from 1.1.18 hmm what does >>> import sys >>> sys.version show? *** johannesV_ has quit IRC *** johannesV_ has joined #gnuenterprise '2.3.5 (#1, May 15 2005, 20:21:51) \n[GCC 3.3.5-20050130 (Gentoo Linux 3.3.5.20050130-r1, ssp-3.3.5.20050130-1, pie-' kreiszner: do you have the /usr/lib/python2.3/site-packages/psycopgmodule.so file? Apparently I do Incidentally, I am willing to install any version of any free OS to get this to work. it shouldn't matter you really shouldn't (re)install another OS just for that.. you should get it running pretty much on anywhere Sound good but this connection problem is a real bummer. have you done any non-emerge installs on this machine? none yet, this was done with the emerge directory thing which is supposed to be somewhat iffy but today it seemed to work ok "emerge directory" -- what? what does "qpkg psycopg -c -v" show? .. emerge gentoolkit, if you don't have qpkg emerge the directory where the ebuilds exist *** yure has quit IRC kreiszner: sorry, I still don't understand, what you mean I copied the ebuild to a directory on my machine and emerged like emerge /usr/local/portage/dev-python/gnue-designer/gnue-designer-0.5.4-r1.ebuild dev-python/psycopg-1.1.15 * 0/40 designer runs but just refuses to connect ok, now I understand what you meant.. anw, designer is not the issue, right now, the confusing part is that python doesn't import psycopg would a reboot possibly do any good I've reached the limit of what I can help with not unless it's windows ;) but erkki_ is right... until that import works it's an install-related issue, not gnue I know that's not any consolation, though :) and where does python get its info for where psycopg is located kreiszner, if you run python and do: *** hob has joined #gnuenterprise import sys all that I could suggest would be to re-merge python and/or psycopg sys.path that shows, in order, the directories that python is using just out of curiosity, what directory are you in? do you have a psycopg subdirectory under your current directory? /etc/gnue that shouldn't be it then kreiszner: can you import anything else from /usr/lib/python2.3/site-packages/ depending, what you've got installed, for example "import CORBA" or "import mx" I have to go now but I will investige further and see what I can do with the last couple of recommendations. *** hob has quit IRC hmm, reports 0.1.7 SimpleTabulations html filter seems to look for a missing css file bash-2.05b$ gnue-reports -D file -d test.html -f html test.grd ^[[ADB000: /usr/lib/gnue/common/formatting/GDataFormatter.py:33: DeprecationWarning: FixedPoint is deprecated; use decimal.Decimal instead DB000: from gnue.common.external.fixedpoint import FixedPoint, addHalfAndChop Error processing css file: /usr/share/gnue/filters/SimpleTabulation/tabulator.css hi, can i have __getitem__ of two arguments? mnemoc, what do you mean? poink = think[ foo, bar ] with a def __getitem__ ( self, foo, bar ) on the other side that would definitely be non-standard but as to whether it works or not, I'm not sure usually you'd pass in a tuple instead of two variables a tuple? python has to many kinds of structures to my arcaic brain :\ poink = think[ (foo,bar) ] <--- is this a tuple? or [foo,bar] ? *** gunnarahlberg_ has joined #gnuenterprise *** gunnarahlberg_ has left #gnuenterprise *** johannesV_ has quit IRC *** johannesV has joined #gnuenterprise *** johannesV has quit IRC *** kilo has joined #gnuenterprise anyone here familiar with reports? *** btami has joined #gnuenterprise hi mazohizmusom: http://www.gnuenterprise.org/~btami/win2k_qemuval.png GREAT!!! bravo az XP végleg beadta a kulcsot,és márújratelepülni sem volt hajlandó just what i need :D azt mondta, hogy érvénytelen partícióstábla persze, hiszen o csinalta :D hehe sorry, wrong window :) *thwap* *** btami has quit IRC *** btami has joined #gnuenterprise doh just was wondering why nothing happens in this channes channel but i was scrolled back a line or two and when not standing at the end of the output, gaim doesn't scroll forward with new messages rotfl haha so my screen just was staying like it was even though people posted things drop gaim! just to make sure you know i wasn't ignoring all your questions on purpose ;-) btami: unfortunately I need jabber compatibility for FSFE I was happy with xchat before I needed jabber :( poor reinhard :) reinhard: kopete :) i use it w/ jabber and IRC and recent versions don't suck :) I love software that sucks why would I be here otherwise? ;-) j/k oh my! you just forgot derek :) *** jamest has quit IRC night all *** btami has quit IRC good night *** reinhard has quit IRC *** kilo has quit IRC *** jamest has joined #gnuenterprise *** hgr1 has joined #gnuenterprise *** wendall911 has joined #gnuenterprise anybody awake that uses sql-ledger? *** SachaS has quit IRC *** holycow has joined #gnuenterprise *** wendall911 has left #gnuenterprise *** SachaS has joined #gnuenterprise *** wt has joined #gnuenterprise why does designer not save a form if it has no datasource? anyone here? If so, when was DCL last released?