*** reinhard has joined #gnuenterprise
*** kilo has joined #gnuenterprise
*** wt has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
<johannesV> good morning
<wt> hi
<kilo> good morning
<reinhard> hello all
*** dcmwai_ has quit IRC
<johannesV> hmm, that firebird is sometimes very strange in it's behavior ...
<kilo> ie?
<johannesV> regarding referential constraints ...
<johannesV> having one table a referring another one b, there must be a unique index on table b including the referred fields - that's ok
<johannesV> but it does not work if one creates such a unique index
<johannesV> instead one must create a "unique constraint"
<johannesV> which get's automatically converted into a unique constraint by the firebird-server
<johannesV> isn't that strange ?!
<johannesV> so why can't we just create that index directly to have it working ?
<kilo> hmmm
<johannesV> anyway .... firebirds index-support is a bit sloppy
<johannesV> as you cannot have indices wider than about 60 to 70 characters (depending on the number of fields included in the index)
<johannesV> SQL> create table ixcheck (name varchar(62) not null, id char(5) not null);
<johannesV> SQL> create unique index ixfoo on ixcheck (id, name);
<johannesV> Statement failed, SQLCODE = -607
<johannesV> unsuccessful metadata update
<johannesV> -key size exceeds implementation restriction for index "IXFOO"
<kilo> yep, some stupid restricitions are there
<johannesV> if i were about to use firebird/interbase this would be something very bad ...
<johannesV> since this is a very low bound then ... just think about an index including a person's name, ...
<kilo> yes
<johannesV> ok, i'll leave that as it is for now ...
<kilo> and the one that hurts me most is string size limit
<kilo> when in unicode mode, it is about 11000...
<johannesV> yeah
<kilo> and it can give problems when you have loooong procedure code
*** dcmwai has joined #gnuenterprise
*** mnemoc_ has joined #gnuenterprise
*** krizz has joined #gnuenterprise
<krizz> hello
<krizz> I'm trying to implement the ZipCode Form Guide but I get an error when try to run the form
<krizz> AttributeError: GFField instance has no attribute 'fk_key'
*** johannesV_ has joined #gnuenterprise
<krizz> any idea?
*** johannesV has quit IRC
<krizz> anyone active in hete?
<reinhard> more or less
<krizz> :)
<reinhard> the zipcode sample is available in the samples directory of gnue-forms
<krizz> hi reinhard
<reinhard> hi krizz
<krizz> oh.. ok thanks
<krizz> I was just trying to follow the tutorial guides
<reinhard> we are just in the (very slow) process of updating the tutorials to match the actual state of the programs
<reinhard> any help with that is highly appreciated BTW
<krizz> that's the reason, I was playing arround. To get familiar, with Gnue.
<krizz> and maybe then I could help some way
<reinhard> yes, great :))
*** mnemoc has quit IRC
<krizz> I could provide some greek locale also, if interested
<reinhard> that's excellent
<krizz> translation is just releasing a language file in po directory?
<reinhard> right
<reinhard> start with the .pot file, fill in the translations, and done
<reinhard> usually we do prereleases a few days before the release
<reinhard> so usually you wait for the prerelease, grab the .pot file from there, translate it, and your translation will be included in the final release
<krizz> so I must wait for a pre-lease bore starting? Or just get from svn?
<reinhard> you can of course work on SVN versions
<reinhard> and merely update when we do the prerelease
<krizz> something else, do you know how i can connet to mysql in non default port. Tried port attribute in connections.conf, but didn't do
<reinhard> SVN version?
<dimas> hello all
<dimas> anybody has an example of master-detail in a report?
<dimas> reports
<krizz> I'm not sure anymore, but i think it's current stable now
<krizz> hello dimas
<dimas> krizz: hi
*** dcmwai has quit IRC
<reinhard> krizz: I have never used MySQL
<reinhard> maybe johannesV_ can try if he has time
<johannesV_> is it urgent ?
<krizz> no, no urgent johannesV_ . I can find a work arround
<krizz> It's that I have mysql set with transaction in another port. In mysql 3 (default port) transactions are not set
<johannesV_> i think the problem is that gnue's mysql-driver does not pass a port-arg to the connect method
<krizz> I could also install a postgre, to play with gnue. But at the momen I'm not very familiar with it (postgre)
<reinhard> krizz: you are very welcome to use mysql
<johannesV_> ok, i could fix our mysql-driver to support the port-arg (as well as a few others)
<reinhard> as most of us use postgres and mysql is less tested than postgres
<reinhard> so especially when you're "only" playing you could improve the quality of mysql driver
<reinhard> (just as you did right now)
<johannesV_> but i will be afternoon or maybe tomorrow then ...
<krizz> hey you are really active and quick. it's ok johannesV_ when you have time
<krizz> one last question? :D
<reinhard> shoot
<krizz> in windows (atleast), i can't type greek in forms. Is this a problem of wxwidgets, or has to do with gnue?
<reinhard> try native windows driver
<krizz> i'll do that, thanks
<krizz> gnue works only win python 2.3? I read something in the site about it
<krizz> not win with :)
<reinhard> svn version yes
<reinhard> last release worked with 2.1 and 2.2 also
*** btami has joined #gnuenterprise
<btami> dimas: there is one in reports samples/location
<btami> and another in gnue-contrib/gnue-invoice/reports
*** krizz has quit IRC
<dimas> btami: thanks
*** bigbrother has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
<dimas> btami: in location example it did not output from detail section
<dimas>         <section name="statedetail" source="states">
<dimas>           <field source="states" name="description"/> (<field source="zips" name="state"/>)
<dimas>         </section>
<dimas> 
<btami> dimas: never tried, but the gnue-invoice report is ok
*** holycow has quit IRC
*** dimas has quit IRC
*** btami has quit IRC
*** kilo has quit IRC
*** titopbs has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** jamest has left #gnuenterprise
*** titopbs has quit IRC
<johannesV_> bbl
*** johannesV_ has quit IRC
*** titopbs has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** jamest has left #gnuenterprise
*** dcmwai has joined #gnuenterprise
<reinhard> wow
<reinhard> just had the shock of the year
<reinhard> noticed that sshd_config option PermitEmptyPasswords is meaningless if UsePAM is set to yes
<reinhard> and instead the "nullok" from pam.d holds
<reinhard> and a passwordless shell account was open for > 1 year over ssh
<reinhard> on my server
<reinhard> thank god I don't run ssh over port 22 :)
*** estragon has joined #gnuenterprise
*** dcmwai has quit IRC
<reinhard> bbl
*** estragon has quit IRC
*** estragon has joined #gnuenterprise
*** wendall911 has joined #gnuenterprise
*** estragon has left #gnuenterprise
*** yure has joined #gnuenterprise
*** kilo has joined #gnuenterprise
<reinhard> *****************
<reinhard> note to all
<reinhard> intrusive change in datasources upcoming
<reinhard> please do not use SVN HEAD in production for a week or so
<reinhard> **************
<reinhard> (unless your name is reinhard or you know his telephone number) ;-)
*** wendall911 has quit IRC
<reinhard> in case anybody here can easily test a master/detail report please tell me if it still works
<wt> is gnue cool yet?
<wt> hehe
*** uglykidjoe has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** uglykidjoe has quit IRC
<reinhard> jcater: FYI I just did the event thingy we recently talked about
<reinhard> doing all this notification datasource->block stuff via standard events
<reinhard> so you can for example just register an event handler on the event 'dsCursorMoved' and your event handler will be called whenever the record pointer of the current result set in the datasource is moved around
<reinhard> night all
*** reinhard has quit IRC
*** yure has quit IRC
*** kilo has quit IRC
*** titopbs has quit IRC
*** wt has quit IRC
*** ahz has joined #gnuenterprise
<ahz> Is GNUe a good choice for a generic non-profit donor, volunteer, and prospect database system?
*** jcater has quit IRC
*** holycow has joined #gnuenterprise
*** SachaS has quit IRC
*** dcmwai has joined #gnuenterprise
*** mdean has joined #gnuenterprise
*** jcater has joined #gnuenterprise