*** reinhard has joined #gnuenterprise *** johannesV has joined #gnuenterprise hmm, sees as if svn is down works for me? *** johannesV_ has joined #gnuenterprise johannesV_: looks like your internet connection was down, not svn ;-) my connection is up *** johannesV has quit IRC *** wayneg has joined #gnuenterprise *** kilo has joined #gnuenterprise hi everyone reinhard: you here? hi kilo can you answer me some questions about your interbase/firebird ? hi johannesV_, are you still working??? i'll try ok on what plattform do you run interbase ? linux/win? yes, linux and winXP, win2k great is there a tool 'isql[-fb]' on all platforms ? yes is there a tool 'gsec' on all platforms ? dunno if there is on win i'll check it in a few minutes if it's missing on win, how can users be added/modified/deleted via command line ? ok got to boot up a win machine :) yes there is gsec on win, in the firebird/bin directory great, is this firebird/bin directory in the path ? so calling "gsec -user SYSDBA -password -add gnue" would add the user gnue to the security database ? yes, it is on the path (with a password of course) ok hmmm, is a valid password? 8-)) so it seems as if i can implement a createDatabase () for the interbase driver and isql is called "isql" on all your platforms. there's no "isql-fb" (especially on linux) ? on my debian (sarge) this is called 'isql-fb' there's no isql hmm, it is called isql maybe debian packagers decided to call it isql to differentiate from other db engines' isql ok, i'll add a parameter to the conections.conf 'isqlbin' which defaults to 'isql' to be complete i'll add a parameter 'gsecbin' too which defaults to 'gsec' and where will you implement createDatabase()? in the drivers.interbase.Schema.Creation.Creation.py PostgreSQL has it by now interbase will get it in a few minutes you are then able to call "gnue-schema --connection=foobar --createdb foo.gsd bar.gsd ... wow and you will get a database created as described in the connection 'foobar' with all tables created as described in foo.gsd, bar.gsd with all data populated so there shouldn't be any sql-files necessary any longer of course one can add the option "--ouput=foo.sql" to gnue-schema; in this case all sql-statements will be logged to this file (except the data-additions) why omit them? because i cannot get them from the underlying dbsig2-driver kilo: can't i create a user without a password for interbase ? i have never tried to do such blasphemous thing... hmm, our sample user is 'gnue' without a password and it does not allow t? i'm able to add the user without a password but i cannot log into the database it refuses the connection with an answer like 'you have not login; go ask your admin ...' even if you write -p ? i'll try with -p '' great, the first create-db update schema insert-data- run has successfully completed :) no it doesn't log me in with no or an empty password even if i create the user with -pw ' ' so the only problem still there is the "default character set utf8" i can create the database with this default but when it comes to the first 'create tabel' the db will error out does this mean there's something missing in my setup (concerning utf8) ? *** btami has joined #gnuenterprise or should we say "default character set utf-8" hi johannesV_ hi btami just reading log... i'm currently fiddling with interbase please look at http://kinterbasdb.sourceforge.net/dist_docs/usage.html#adv wow -- this is great ! and i did this all by foot ... (don't know the proper english) and utf8 is OK, we used it in appserver samles interbase.sh yes, i've seen this so this was why i'm using it too i'll try it using the kinterbasedb.create_database () statement have to go home, bbl *** btami has quit IRC *** dimas_ has joined #gnuenterprise kilo: i am here hi all i'm about to do new gnue install under windows hi dimas_ i was so silly lately talking with somebody (don't remember whom) hello reinhard and saying "well, i didn't see ra3vat for a very long time, wonder where he's gone" then about a few hours later hi, i have asked those questions from my wife in the evening :) i remember that you're it :) so i can answer now in greater detail kilo: excellent what would you recommend to install from? windows installation? nightly builds? dimas_: gnue install on win -> go and see the wiki reinhard: so account numbers are not numbered in the law, only categories are named * dimas_ went to wiki accounting numbers only come from a recommendation from the ministry but really everyone sticks to these recommendations this is identical her here an accounting number can be as long as you decide to it only helps classification btw, is there a python driver to progress db? and corresponding gnue's one? they are purely numbers there is a big registry of goods (called ITJ) and of services (called SZJ) that list all the good and service categories some good or service has to fall into ah it is also hierarchical and accounting is done by this categories? and VAT is linked to these categories ah ok so if you are a system administrator at a firm, you produce a bill for them and on it there is "SZJ72.30.10 Computer system administration" what is GNUe-Runtime-Environment-2004.04.10.exe? and it is fixed that is has a VAT of 25% 72 is computer-related services 72.10 is hardware support 72.20 is software production and support ah ok and do companies use these categories in their item numbers? and so on or do they mention the category number as a supplemental information? they dont have to but when it comes to producing an invoice, it has to be written on the invoice ok so internally you can use any other item numbers here we have the common understanding that writing invoices is not a part of accounting but accounting starts at the point when you "book" the invoice yes, same here i.e. register it on the several accounts ok i think all goods and services have a VAT assigned, there is no good or service without VAT but maybe there are goods or services with VAT of 0% nearly all here i am not sure yes there is a single thing i know of when you buy a fridge, you have to pay for disposal of it (in advance, already at the time you buy) this disposal fee is 0% vat that's the only thing i know of and my wife couldnt tell as she is a revisor and she only knows last 5 years' tax laws 8-))) yeah and postal stamps for example and some other things sand joining the eu something must have changed... probably :) s/sand/and so to "side books" valued customers or suppliers get a number in the accounting, but not all of them only those who buy or ship regularly ok, GNUe-Runtime-Environment is required to install gnue-common all the others are grouped to a collective accounting number kilo: yes, same here *** dimas_ has quit IRC but even the "collective" accounting numer is an account in the side book, right? and so the sum of them can be created quickly yes ok might sound funny now but i think most of our accounting standards come from the monarchy time maybe yes, but i think it is older oh sorry i'm not sure when HU started to be part of the monarchy this double-booking system was invented by someone earlier afaik austria was part of it since 800 a.d. :) *** dimas_ has joined #gnuenterprise we have to define first what is "to be part of a monarchy" 8-))) well i don't want to get into this too deep :)) you have more items to tell me? me not either, history is not my favorite well, there are special cases but that is outside of our scope now, am i right? hmm, this is really strange ... that utf8 thing doesn't work so i'm wondering how could this have been working before ? kilo: probably yes kilo: thanks for all this information it makes me quite sure that we will be able to build a common accounting system that works for all of continental europe (at least) off to lunch now that would be great * dimas_ wondering is russia in continental europe? *** dimas has quit IRC *** btami has joined #gnuenterprise *** dimas_ has quit IRC *** Amorphous has joined #gnuenterprise *** Amorphous has quit IRC *** Amorphous has joined #gnuenterprise *** havoc has quit IRC *** Amorphous has quit IRC *** havoc has joined #gnuenterprise *** kilo has quit IRC johannesV_: have you looked into services.py in kinterbasdb? seens it has addUser() too s/seens/seems no, btami where can i find services.py ? i've looked in /usr/lib/python2.3/site-packages/kinterbased btami: having an adduser-command would be great it's under /usr/lib/python2.3/site-packages/kinterbasdb here but these are uhu packages made by me :) what version you have? pre7 hmm, what do you mean with 'made by me', the services.py or the package the packages for UHU-Linux maybe it's new in pre7, and you have older version how can i check the version ? in docs index.html or in changelog.txt Version: 3.1_pre7 ) ( This distribution was created on 2004.01.06 at 03:28 EST. ) ok and you don't have services.py ? no, there's no service.py (at least it's not in site-packages) services.py what files you have under kinterbasdb dir? __init__.py __init__.pyc __init__.pyo _kinterbasdb.so hmm, i have lots of additional files please, download the tar.gz, and install it with "python setup.py install" well, this can't be a solution since others will likely be using the 'default' package too what kind of package are you using? debian's 'python-kinterbasedb' url? it's in sarge, i haven't downloaded it separatly hmm but it's working with the 'gsec' way too; it's not that elegant, but it's working from debianplanet's package search i just get an older package 3.0.1 that's ok .. why? ah, no oh, well the version string in __init__.py says:__version__ = (3, 0, 1, 'final', 0) sigh so you have a rather old one the pre7 is definitely THE stable version 2004.01.07 - New Version Available: kinterbasdb-3.1_pre7 kinterbasdb-3.1_pre7 ( download, changelog ) is the third release candidate of kinterbasdb 3.1. This version is ready for production use; it replaces 3.0.2 as the "recommended stable version". from http://kinterbasdb.sourceforge.net/ i think anybody can install it from tar.gz with "python setup.py install", if hes distro is soo..., hmmm so slow :) i think Debian never vas the reference platform for GNUe, just one of the mostly tested :) i liked Debian, but finally changed to UHU-Linux it has a wondeful, easy to use packaging system, a good community i can collaborate with, and it's hungarian and if i need a new package, i can produce it (http://uhu.linuxuser.hu/index.php?id=0) or ask my friends there to make it for me maybe the .deb packager is waiting for 3.1, but it's something like waiting for gnue 1.0 :) 3.1pre1 was at 2002-09-10 17:00 *** jamest has joined #gnuenterprise reinhard gave me some hints; the package in sarge is really 3.0.1 and it has been packaged in 2003 Dawid Rushby is more conservative in versioning but he support is simply GREAT, just look at http://sourceforge.net/forum/forum.php?forum_id=30917 s/he/hes the .deb packager really needs a goat-trout :) *** dsmith has joined #gnuenterprise anyhow, this isn't a big issue, we can change the "gsec solution" later to use services.py yeah, i think so too i've found another problem concerning the driver it doesn't convert a string '81.5' into a numeric value 81.5 but raises an error (string-conversion) this is really bad, because it means, that importing data from gsd could be troublesome may i ask you to try with 3.1-pre7 please? hmm, so i think i'll do some further tests and changes after my holidays or can you instruct me what to test i'm just back from my holidays, so a bit underinformed about latest gnue events :) ok, so if i'm using a -section in the gsd it's working will erm, s/will/well/g *** bluesbaron_ has joined #gnuenterprise *** bluesbaron_ has left #gnuenterprise *** dcmwai has joined #gnuenterprise *** johannesV_ has quit IRC *** reinhard has quit IRC *** havoc has quit IRC *** btami has quit IRC *** Vee has quit IRC *** ajmitch has quit IRC *** dcmwai has quit IRC *** wayneg has quit IRC *** Vee2d2 has quit IRC *** jamest has quit IRC *** jamest has joined #gnuenterprise *** bluesbaron_ has joined #gnuenterprise *** havoc has joined #gnuenterprise *** btami has joined #gnuenterprise *** Vee has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** bluesbaron_ has left #gnuenterprise *** reinhard has joined #gnuenterprise *** dsmith has quit IRC *** Vee2d2 has joined #gnuenterprise *** dcmwai has joined #gnuenterprise *** wayneg has joined #gnuenterprise *** jcater has joined #gnuenterprise *** dsmith has joined #gnuenterprise *** havoc has quit IRC *** ajmitch has quit IRC *** btami has quit IRC *** Vee has quit IRC *** havoc has joined #gnuenterprise *** btami has joined #gnuenterprise *** Vee has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** Vee2d2 has quit IRC anyone interested in a gmail invite? *** Vee2d2 has joined #gnuenterprise *** bluesbaron_ has joined #gnuenterprise *** bluesbaron_ has left #gnuenterprise *** wendall911 has joined #gnuenterprise *** holycow has joined #gnuenterprise *** dcmwai has quit IRC can someone tell me how I can get a list of installed packages on a Debian box? dpkg -l ? dpkg --get-selections Vee2d2: ty Vee2d2: do you know the package that I can remove to get rid of the debian stuff on the gnome desktop? Vee2d2: the menu is a bit redundant get rid of debian.. oh the menu? yeah not sure.. I tend to use it pretty often as there's a lot of stuff that doesnt show up anywhere else Vee2d2: it's a remnant of the old gnome that hasn't gone away typical debian...they'll remove it in 10 yrs or so *** nickr has quit IRC wendall911: You want to remove the debian menu system perhaps? never the less, it's the only way short of the command line, I have access to any kde apps or anything else that's not in the std gnome menu dsmith: yeah, that would be great wendall911: menu dsmith: ty * dsmith boggles Vee2d2: I don't use any kde only apps dsmith: I like the standard gnome menu is all. I don't see the use in having two menus *** nickr has joined #gnuenterprise wendall911: Did removing that module work? dsmith: don't know yet, I'm just at the cl right now *** bluesbaron_ has joined #gnuenterprise *** bluesbaron_ has left #gnuenterprise *** johannesV has joined #gnuenterprise good evening :) hey johannesV hi jamest jamest: do you know why the commit-mails don't come along the last days ? nope I think derek was fscking around in there which broke the emails ya, that's it i didn't even know they were broken damn that derek *** nickr_ has joined #gnuenterprise *** nickr has quit IRC hmm and i thought they were just 'slow', but in this case ... :) I just assumed every one has been very busy the past few weeks and no time to gnue *lol* i can't remember the last day i hadn't time for gnue :) i would say no week without at least a few commits but that's why i wrote the last mail to the mailing-list anyway, i hope some of you guys can do some testing of the schema.creation stuff so we can track down all bugs i've missed :) *** ogger has joined #gnuenterprise jcater: that behavior-parameter in the connections.conf; is this thought to be a module-path (like gnue/common/drivers/postgresql/schema/creation) or the name of a driver like "postgres" ? err, i mean 'gnue/common/..../Schema/Discovery/Introspection' name of a drivert driver ah, ok, that's fine so this could be fixed next time ok, i'm sorry but i've to leave now have a nice day *** johannesV has quit IRC *** btami has quit IRC *** jamest_ has joined #gnuenterprise wendall911: check out deborphan it shows you a list of all packages that you could remove without breaking a dependency apt-get --purge remove $(deborphan) *** sjc has joined #gnuenterprise dsmith: yeah, if you repeat that until it doesn't change anything you get a *very* minimal debian system espeically when you do deborphan -na well it would just work to the point when it will remove deborphan itself :) Yes, I do that whenever I remove something huge, like gnome. (but not -na) yeah, then you only clean the libs but not other packages *** jcater has quit IRC It's fun to try and find the one key package to remove all of kde (for example). hehe for gnome that's easy libglib2.0 :) reinhard: Have you ever heard of a tool that also cleans up all the leftover ~/.* files? nope i think the dependencies between packages and ~/.* files are not defined clearly enough Yep. *** jcater has joined #gnuenterprise It's fun to try and find the one key package to remove all of kde (for example). <-- hehe :D i can't tell you how many times i've found the one key package that removed kde in an *oops* fashion :) *** sjc has quit IRC * reinhard remembers once removing ld.so there wasn't much left that worked after that :) *** wendall911 has quit IRC *** kilo has joined #gnuenterprise night all *** reinhard has quit IRC *** dsmith has quit IRC *** jamest has left #gnuenterprise *** seb__ has joined #gnuenterprise just tried to grab latest gnue from SVN. I first did apt-get gnue-designer to get all the dependencies then entered the line from the web site: svn co svn://svn.gnuenterprise.org/var/svn/gnue/trunk gnue but all i got was: svn: Can't connect to host 'svn.gnuenterprise.org': Connection refused have i done ssthing wrong? *** sjc has joined #gnuenterprise *** jcater has quit IRC *** seb__ has quit IRC *** jamest has joined #gnuenterprise *** kilo has quit IRC *** jcater has joined #gnuenterprise *** sjc has quit IRC *** bluesbaron_ has joined #gnuenterprise *** bluesbaron_ has left #gnuenterprise *** jcater has quit IRC *** wendall911 has joined #gnuenterprise *** holycow has quit IRC *** jcater has joined #gnuenterprise *** jamest has quit IRC *** drewc has joined #gnuenterprise *** wendall911 has quit IRC *** drewc has left #gnuenterprise *** ogger has quit IRC *** nickr has quit IRC *** ogger has joined #gnuenterprise *** nickr has joined #gnuenterprise *** jcater has quit IRC *** DeadKitty has joined #gnuenterprise *** ogger has quit IRC *** nickr has quit IRC *** DeadKitty has quit IRC *** Vee2d2 has quit IRC *** havoc has quit IRC *** ajmitch has quit IRC *** Vee has quit IRC *** wayneg has quit IRC *** chillywilly has quit IRC *** Vee2d2 has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** Vee has joined #gnuenterprise *** havoc has joined #gnuenterprise *** wayneg has joined #gnuenterprise *** chillywilly has joined #gnuenterprise *** DeadKitty has joined #gnuenterprise *** nickr has joined #gnuenterprise *** ogger has joined #gnuenterprise *** chillywilly has joined #gnuenterprise *** wayneg has quit IRC *** chillywilly has quit IRC *** ogger has quit IRC *** DeadKitty has quit IRC *** nickr has quit IRC *** Vee2d2 has quit IRC *** havoc has quit IRC *** ajmitch has quit IRC *** Vee has quit IRC *** wayneg has joined #gnuenterprise *** Vee2d2 has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** Vee has joined #gnuenterprise *** havoc has joined #gnuenterprise *** nickr has joined #gnuenterprise *** ogger has joined #gnuenterprise *** holycow has joined #gnuenterprise *** chillywilly has joined #gnuenterprise *** havoc has quit IRC *** ajmitch has quit IRC *** Vee has quit IRC *** havoc has joined #gnuenterprise *** Vee has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** Vee2d2 has quit IRC