*** dimas has joined #gnuenterprise *** SachaS has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** sjc has joined #gnuenterprise *** johannesV has joined #gnuenterprise good morning good morning hi SachaS *** mnemoc has quit IRC *** SachaS has quit IRC *** mnemoc has joined #gnuenterprise *** wt has joined #gnuenterprise *** kilo has joined #gnuenterprise *** btami has joined #gnuenterprise reinhard: gnue-forms/samples/zipcode/states.gfd, stepping down with cursor key until record# 15 File "/home/gabor/SVN/gnue/.cvsdevelbase/gnue/common/datasources/drivers/Base/ResultSet.py", line 159, in isLastRecord if self._currentRecord < len(self._cachedRecords) - 1 or \ File "/home/gabor/SVN/gnue/.cvsdevelbase/gnue/common/datasources/drivers/Base/ResultSet.py", line 240, in __cacheNextRecord row = self.__generator.next () File "/home/gabor/SVN/gnue/.cvsdevelbase/gnue/common/datasources/drivers/DBSIG2/ResultSet.py", line 157, in _fetch rows = self.__cursor.fetchmany (cachesize) File "/usr/lib/python2.3/site-packages/kinterbasdb/__init__.py", line 1677, in fetchmany return self._fetchmany(size, self._fetch) File "/usr/lib/python2.3/site-packages/kinterbasdb/__init__.py", line 1635, in _fetchmany row = fetchMethod() File "/usr/lib/python2.3/site-packages/kinterbasdb/__init__.py", line 1603, in _fetch row = _k.fetch(self._C_cursor) ProgrammingError: (-504, 'fetch.isc_dsql_fetch: Dynamic SQL Error. SQL error code = -504. Cursor unknown. ') *** dimas has quit IRC *** dimas has joined #gnuenterprise hello all hi dimas hello kilo *** wt has quit IRC *** wt has joined #gnuenterprise *** GI has joined #gnuenterprise hi reinhard - we have some questions *** GI has left #gnuenterprise *** GI has joined #gnuenterprise GI, we who? back GI: I'm here now but must leave again in 15 minutes gnue looking any better GI? what would it take to make gnue really work for a company for tracking inventory and accounting for 3 locations? I mean, would it be possible to have multiple locations with independent servers that sync up? evening hi wt: good question you mean several appservers syncing? I have to admit, I don't think that gnue in its current form is really useful to me I wish it were I really like the project what is the main problem It f'in difficult and there is no GL app it should really accept xml schema as an input in addition to gnu schema that way you could use some standardized schemas easily with it like the adis stuff url? http://www.gnuenterprise.org/cgi-bin/twiki/view under other important info they ship it with XML schema defs so that other apps can just use that to incorporate it I wouldn't want to even try to keep gnue in sync with it must run for lunch it should just use those data files bbl I can't see how to make gnue-schema accept another format *** rynik has quit IRC the gnue schema stuff is embedded deep without an abstraction gnue schema stuff is in xml but it is not XML Schema http://www.w3.org/XML/Schema *** rynik has joined #gnuenterprise all gnue tool has it's own DTD wt: what other schemas besides adis would be usefull for you? it would be nice if schema were also supported XML schema's can be used to pass data between companied XML schema's can be used to pass data between companies I think it would be cool to be able to use the same schema to define a business object in gnue as is used to pass the data between companies instead of having to generate a gnue-schema and an xml schema in that case http://www.xcbl.org/ DTD to XML Schema translator dtd2xs (LuMriX) now go the other way when someone gives me a schema IRS uses xml schema you'd be able to publish the interfaces to objects with the xml schema and use it in other apps for instance, I think the xcbl stuff defines purchase orders and other stuff it would be really useful to be able to use that standardized stuff which standard to follow? xcbl? ebxml? ubl? ...? XML schema btw, I consider the IRS stuff the most important and I wouldn't be too surprized if other gov't took info via xml schema defined docs wt: which standardization organisation did define the XML schema? and where is it available? W3C http://www.w3.org/XML/Schema it's intended to replace DTDs it's less ambiguous It's actual XML. and it is an actual standard hmmm I'm not sure if it is targeted at database schemas it does not contain, for example, lengths of string fields also it defines complex types, a feature not frequently found in SQL databases that could be implemented with foreign relations AFAICT this seems to be targeted (like you said) at replacing dtd's and lengths can be added as a gnue specific attribute or assumed in cases where it's not given so not to define relational database schemas but to define XML schemas and it is used in many standards for exchanging data I think that GNUe may be to limited by the thoughts of relational databases but of course it could be possible to use gnue to import such a definition lol gnue may be to limited by *using* relational databases but as long as we *use* them, we have to stick with what they can do :) they can do more than it first appears you just won't have a one-to-one mapping with classes to tables *** docelic has joined #gnuenterprise just think, a complex type could be supported by using many tables to define it Hi, can you help me a little? I went following the developers btw, ADIS is standardized by many countries' postal services and it would be great to be able to create a free repository of address templates address templates are what define how an address is laid out on an envelope that is defined in adis developers' guide, and upon copy-pasting first extension to the basic hello world program, I get a strange error: http://colt.projectgamma.com/tmp/helloworld I just don't think gnue will make it to the big time without direct schema support since it is used to transport and validate so much important data not only that, I think that schema support would make it able to take advantage of work already done by standardization bodies *** tiredbones has joined #gnuenterprise anyhow I tell you what how much would it cost to get schema support? I mean a donation to the project docelic: you seem to have a tab before COMMAND_OPTIONS that should be two spaces wt: xml schema seems to be a rather complex standard, so it's not easy to say how long it would take to implement it *** yure has joined #gnuenterprise one would as a first step have a deeper look at the standard and then decide how to map the elements to appserver classes or db tables reinhard: ah excellent, thanks. I am not used to python so.. @seen derek kilo: derek was last seen here 2 weeks, 2 days, 4 hours, 10 minutes, and 8 seconds ago saying: nevermind i found it @seen dneighbors kilo: I have not seen dneighbors. @seen dneighbo kilo: dneighbo was last seen here 14 weeks, 6 days, 11 hours, 18 minutes, and 17 seconds ago saying: * dneighbo hugs his debian @seen derek_ kilo: derek_ was last seen here 9 weeks, 1 day, 16 hours, 36 minutes, and 35 seconds ago saying: haha famous last words... "haha" ROTFL maybe i can have a (quick first) look at that xml schema thingy ... after doing some work on curses forms client *** btami has quit IRC bbl Developers crap key Developers' documentation says gnue-schema --vendor= , but my version of gnue-schema from gnue-common (0.5.14) doesn't have that option. Is it deprecated , and if yes, what's the current syntax ? hi reinhard, how can we generate a gsd file from an existing database (gnue-gsdgen --connection=gnue --output=/home/gnue/d_geminfo.gsd doesn't function) not sure, but please try with --connection=appserver no should work with --connection=gnue what does it do when you try? error mesasge? then i get the error "gnue-gsdgen: (111, 'Verbindungsaufbau abgelehnt')" what do you get with --connection=gnue? i think I was not right with --connection=appserver then i get a lot of messages and the last line is DB000: ProgrammingError: (1146, "Table 'd_geminfo.gnue_module' doesn't exist") this gnue table (and the others doesn' exist (not yet)) ah sorry I completely misunderstood you have an old legacy database? non-gnue? our database has already data and we want to use gnue to handle them, but we don't want to reinput! ok you have to create this gsd file "by hand" gnue-gsdgen can only export data from gnue databases usually you should be able to do an sql dump or something like that and with a little vi magic create the xml file if you send me the sql dump by mail and your gcd (to which the data should match) I can do the conversion for you, it's not much work if you know vim well enough :) What should I use instead of gnue-schema --vendor= option to generate database from .gsd file? --vendor is not supported in gnue-common 0.5.14 on Debian, and I don't see a suitable replacement option in --help output docelic: now you can gnue-schema --connection= to import data directly into an active database connection is there really no tool which can generate a gsd file from an existing Structure of a database reinhard: aha, so if I use --connection X -f, and X is defined to be mysql DB in connections.conf, then the database will not be contacted, but the output file would contain mysql definitions? reinhard: (btw, I am updating the developers' guide .sxw) GI: the problem is that for existing databases, the system can't determine the dependency structure between the tables (and therefore can't determine the correct order of tables) we are talking right now about how one could work around that as I agree it would be a good thing to have (we = johannesV and me) it is not for this time but in the future it could be possible that we want to migrate db's for gnue handling which are very big and have many dependencies! right like I said I agree it would be an useful option at the moment i can do it by hand there is a separate project called "gnue-integrator" that is targeting at exactly this that would even allow repeated data migration but that's not yet in a usable state :( might be that we have to put more priority into that --username option to gnue-schema does not work Bono spent the night together with Bill Gates first M.Jackson, now Bill... oh my, oh my Bono? Bonobo? Ah jezus, this gnue-schema is hopeless... docelic: sorry, didn't see your latest question yes to that --connection -f thing docelic: what is your problem with --username? bbl *** kilo has left #gnuenterprise reinhard: gnue-schema -o registration.out -f --debug-level 1-10 -d -c prod --username gnue2 --password gnue registration.gsd ... You are about to create the new database 'prod'. Continue [y,N]: y.... mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'prod'' reinhard: then I add --username=gnue2, and : reinhard: then I add --username=gnue2, and still : ERROR 1044: Access denied for user: '@localhost' to database 'prod' docelic, this message comes from mysqladmin ... your current username seems to be not allowed to access mysql ? (at least for admin tasks) johannesV: that's ok, but obviously gnue-schema isn't passing the username... manually I can invoke mysql -u gnue2, and create/drop prod have you tried with mysqladmin ? johannesV: mysqladmin -u gnue2 create/drop prod works fine of course :) but have you tried mysqladmin without gnue2 ? there's a chicken-egg problem .... usually the user (gnue2) should be created if --createdb option is given as well as the db. so this user can't be privileged to create a db if he doesn't exist ... johannesV: then I get the same error message as above, yes, but shouldn't gnue-schema take care of passing -u to mysqladmin, if gnue-schema is supplied with --username ? that's why the user running gnue-schema with --createdb option should have enought permissions to create a db (and user) no, the user and password passed to gnue-schema will be (created on --createdb) and used for loggin into the (maybe created) database it has nothing to do with the account used to create new databases (as stated above this user usually won't (might not) exist in that case) you could add a .my.cnf file to your home-dir johannesV: aha, ok, thanks for clarification. I had also tried with ~/.my.cnf settings, but only provided [mysql] section and not [mysqladmin] right you should add a mysqladmin section then ... yeah, obviously. thanks np Heh. Ok so gnue-schema now connects to the DB, and the mysql line it wants to run has an error: CREATE TABLE registration (registration_id int unsigned AUTO_INCREMENT DEFAULT nextval ('registration_registration_id_seq') NOT NULL, name varchar (50) NOT NULL, address varchar (50), address2 varchar (50), city varchar (50), state varchar (30), zip varchar (20), zip4 varchar (4), phone_number varchar (30), CONSTRAINT pk_registration_id PRIMARY KEY (registration_id)); ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'nextval ('registration_registration_id_seq') NOT NULL, name var *** jamest has joined #gnuenterprise Good day jamest hi is not nextval a postgresql specific? dimas: i don't recall oracle doing it that way but then again i haven't used oracle since 98 :) docelic has i problem with mysql does nextval ever exist in mysql? I dont think so however isn't that what gnue-schema should be doing ?:) being aware of DB specifics i thought mysql had a serial type (as does postgresql) or maybe it's called autoincrement field jamest: the problem I have is running an example from developer but then again i haven't used mysql since....ever :) developer's guide, and it tries to invoke CREATE TABLE registration (registration_id int unsigned AUTO_INCREMENT DEFAULT nextval ('registration_registration_id_seq') NOT NULL in mysql docelic: can you find out how the correct syntax for mysql is? reinhard: sure and can you please paste the part of the gsd file you used? http://lists.mysql.com/maxdb/316 reinhard: here's the .gsd (verbatim copy from devel guide): http://colt.projectgamma.com/tmp/registration.gsd docelic: thanks docelic: on the phone with johannesV, thanks for your report, he is already fixing it reinhard: excellent, thanks jamest: can you take care about merging the fixes to devguide docelic sent to gnue-dev? reinhard: well, if I get gnue-schema to work, I'd go over the whole devel guide and submit a complete update then sure but the only email from gnue-dev I have has the subject Vl'AGRA WALLIUM ClALlS\ not sure if that's really something I should be merging in :) rofl *** johannesV_ has joined #gnuenterprise *** johannesV has quit IRC johannesV_: found the mysql-specific variant ? yes, only AUTO_INCREMENT is needed aha, great that's right as you can see from the diff above you'd have to remove line 102 from mysql/Schema/Creation/Creation.py to make it work ... *** titopbs has joined #gnuenterprise *** kilo has joined #gnuenterprise *** GI has quit IRC *** jamest has left #gnuenterprise bbl *** reinhard has quit IRC *** reinhard has joined #gnuenterprise kilo: sorry I missed your bug report this morning but the bug was already there in our last release and it's autocommit related the commit destroys open cursors BTW comparing latest release and current svn it looks like svn is *way* faster it's really about time that common gets ready for next release strange i did not remember it was in the released version I have installed debs in parallel and it's the same there wanna talk with j* about how to solve it ok, thx *** jamest has joined #gnuenterprise *** reinhard has quit IRC *** wendall911 has joined #gnuenterprise *** wt has quit IRC *** wendall911 has quit IRC *** wendall911 has joined #gnuenterprise *** tiredbones has quit IRC *** johannesV_ has quit IRC *** jcater has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** thesandroid has joined #gnuenterprise *** wendall911 has quit IRC *** tiredbones has joined #gnuenterprise *** thesandroid has left #gnuenterprise good night all *** rynik has quit IRC *** jamest has left #gnuenterprise night all *** reinhard has quit IRC *** kilo has left #gnuenterprise *** jamest has joined #gnuenterprise *** jcater has quit IRC *** yure has quit IRC *** jcater has joined #gnuenterprise *** sjc has quit IRC *** titopbs has quit IRC *** docelic has quit IRC *** dimas has quit IRC *** ajmitch_ has quit IRC *** docelic has joined #gnuenterprise *** dimas has joined #gnuenterprise *** ajmitch_ has joined #gnuenterprise *** docelic has quit IRC *** ajmitch_ has quit IRC *** dimas has quit IRC *** ajmitch_ has joined #gnuenterprise *** dimas has joined #gnuenterprise *** docelic has joined #gnuenterprise *** jcater has quit IRC *** jamest has quit IRC *** ajmitch has quit IRC *** chillywilly has quit IRC *** Amorphous has quit IRC *** jcater has joined #gnuenterprise *** jamest has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** chillywilly has joined #gnuenterprise *** Amorphous has joined #gnuenterprise *** titopbs has joined #gnuenterprise *** titopbs has quit IRC *** jcater has quit IRC