*** jamest has quit IRC
*** holycow has joined #gnuenterprise
*** bluesbaron_ has joined #gnuenterprise
*** bluesbaron_ has left #gnuenterprise
*** shomodj has joined #gnuenterprise
*** shomodj has quit IRC
*** bluesbaron_ has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
*** wt has joined #gnuenterprise
*** wt has quit IRC
*** bluesbaron_ has left #gnuenterprise
*** mhe_ has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** SachaS has quit IRC
<johannesV> reinhard, gnue-message should be 'testable' now :)
*** switch has quit IRC
<dimas> hi all
*** ncjp has quit IRC
<dimas> johannesV: we have base.gsd in gnue-appsserver/samples which needed to initialize appserver's db and base.gcd in gnue-packages/base which keeps common(base) classes for packages, is not the same naming gives some confusion in that?
<dimas> i would prefer to see base.gsd like appserver-init.gsd and not in samples dir
<dimas> or am i missunderstanding some?
<reinhard> dimas: you are not misunderstanding
<reinhard> and I actually agree with you
<reinhard> base.gsd doesn't belong into samples
<reinhard> bbl
*** reinhard has quit IRC
<dimas> ok, thanks reinhard :)
*** reinhard has joined #gnuenterprise
*** qman has quit IRC
*** btami has joined #gnuenterprise
<dimas> hello btami, reinhard
<dimas> btami: do you know where is kilo gone to? and for how long? :)
<btami> hi dimas
<btami> kilo is on hes 2 week holidys
<dimas> ah
<btami> this week was the 1.
<btami> :)
<dimas> good for him :)
<btami> hi is in croatia with family
<dimas> ok
<btami> a link how others made report designer: http://www.inventivedesigners.com/scriptura/screenshots.html
<bigbrother> Title: scriptura @ inventive designers : Screenshots (at www.inventivedesigners.com)
<btami> bigbrother: shut up :)
<btami> _wery_ impressive
*** holycow has quit IRC
*** reinhard has quit IRC
<dimas> Scriptura XBOS puts your output process in the best of hands: yours
<dimas> :)
*** switch has joined #gnuenterprise
*** ncjp has joined #gnuenterprise
<btami> remind me to derek's PR speech :)
<btami> s/remind/reminds
<dimas> :)
*** SachaS has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** btami has quit IRC
*** mixi has quit IRC
*** dsmith has joined #gnuenterprise
<dsmith> Howdy Gnue-ers! Anyone awake and care to talk to me about mysql on Debian (Sarge)?
<dsmith> I never have a problem with postgres, but I just can't figure out how to create a user/set passwords etc.
<dsmith> (with mysql)
<dsmith> The docs in /usr/share/doc/mysql-server don't seem to be quite right.
<dimas> i have notes to make it something like
<dimas> mysql --user=root mysql
<dimas> mysql> INSERT INTO user VALUES('localhost','dimas',PASSWORD('some_pass'),
<dimas>                 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
<dimas> creates new user
<dimas> then
<dimas> mysql mysql
<dimas> mysql> grant all privileges on *.* to dimas@localhost identified by '';
<dimas> Query OK, 0 rows affected (0.00 sec)
<dimas> mysql> FLUSH PRIVILEGES;
<dimas> Query OK, 0 rows affected (0.00 sec)
<dimas> mysql>
<dimas> defines permissions
<dimas> i could be wrong, fighting with it each time i use mysql :)
<dsmith> dimas: THanks.  That looks very familar.
<dsmith> dimas: But "mysql --user=root mysql" gives me an "Access denied" message. :(
<dimas> np
<dsmith> THat's where I'm stuck.
<dimas> it is where i can't help anymore :(
<dsmith> heh
<dsmith> Thanks anyway.
* dsmith curses mysql yet again
<dimas> :)
*** mixi has joined #gnuenterprise
<mhe_> dsmith: try "mysql -u root -p"
<dsmith> Hey!
<dsmith> (I also did a --purge and a re-install)
<mhe_> what -p does is that it tells mysql that you have a password for the user that you want to enter
* chillywilly thwaps dsmith 
* dsmith endures under the pressure
<mhe_> Does it wirte anythin else than "Access denied" when you try to login with the client
* chillywilly uses both mysql and postgres extensively
<chillywilly> our email backend is mysql
<chillywilly> ;P
<chillywilly> postfix + courier + mysql
<dsmith> mhe_: Well, the error message has scrolled to far back.
<chillywilly> + some other shit
<chillywilly> :P
<chillywilly> did you use grant statements or hack the mysql databse yourself?
<mhe_> dsmith: cant you replicate it?
<chillywilly> mysql is actually easier to configure, imho, because it is all in the db
<chillywilly> postgres should steal that ;)
<dsmith> mhe_: No, it seems to be workign now.
<dsmith> mhe_: I must haev set a password previously or soemthing.
<mhe_> dsmith: ok....thats the most important
<mhe_> dsmith: so the -p was all you needed
<dsmith> After I set the password, yes.
<dsmith> But this was failign for me initially:
<dsmith> mysqladmin -u root password PASSWORD
<chillywilly> teh mysql client is alos better because you can connect and then do USE database; It does not force you to choose a db..and you can swicth back and forth
<dsmith> *That* was sayign access denied.
<chillywilly> USE foo;
<chillywilly> USE bar;
<dsmith> But it worked after I re-installed.
*** johannesV_ has joined #gnuenterprise
<chillywilly> also phpmyadmin is better than phppgadmin
<dsmith> It's there a way to create a user from the command line?
<chillywilly> it's all done with grant statements or manually insertions into the mysql db
<chillywilly> afaik
<chillywilly> ooh wait
<chillywilly> mysqladmin tool probably can do it
<chillywilly> I don't use that thing much
<mhe_> As fr as I can tell you cannot, even with mysqladmin http://dev.mysql.com/doc/mysql/en/mysqladmin.html
<bigbrother> Title: MySQL Manual | 8.4 mysqladmin, Administering a MySQL Server (at dev.mysql.com)
<chillywilly> I just use phpmyadmin and fill in the form and insert rows ;P
<dsmith> mysql --user=root mysql -p
<dsmith> Enter password:
<dsmith> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
<chillywilly> you can use host, db, and user tables
<dsmith> Bah!
<chillywilly> did you set a password for root?
*** johannesV has quit IRC
<chillywilly> intially he has no password
<dsmith> Yes I was using it just a minute ago.
<chillywilly> do an UPDATE on mysql.user table
<mhe_> what you can do, is insert an text file with the necessary SQL commands into the mysql client at runtime like "mysql -u root -p FOOBAR < createuser.sql"
<chillywilly> :P
<mhe_> you are entering the wrong password
* dsmith tries again
* dsmith is embarrased
<chillywilly> heheh
<mhe_> :)
*** jamest has joined #gnuenterprise
<chillywilly> hi jamest
*** johannesV_ has quit IRC
<dimas> anyone really using gnue-packages?
<dimas> i can't get base/location/insert-en-country-codes.gsd loaded
<reinhard> dimas: no, noone using that
<reinhard> it's just a few files kilo converted from old gcd format
<dimas> gsd is trying to load rows like
<dimas>         <row>
<dimas>           <value field="gnue_id" key="Y">00000000000000000000002000000001</value>
<dimas>           <value field="loc_code">AF</value>
<dimas>           <value field="loc_name">Afghanistan</value>
<dimas>           <value field="loc_phone"></value>
<dimas>         </row>
<dimas> where in loc.gcs class Country defined as
<dimas>   <class name="Country" comment="">
<dimas>     <property name="code"       type="CORE_CountryCode"     nullable="False"    comment="ISO 3166-1 c
<dimas>     <property name="phone"      type="string(4)"                                comment="Phone countr
<dimas>     <property name="formatted"  type="string"                                   comment="Returns coun
<dimas> ...
<dimas> and where is no direct loc_name column
<dsmith> Thanks again people.  All I needed was to get the root password working again.  I'm messing about with blootbot.  That package actually handled all the mysql stuff, I just needed the root password.
<dsmith> Again, many thanks.
<dimas> it should get it somehow from core/core.gcd but it did not
<chillywilly> mozilla mail and thunderbird sure do use a lot of IMAP connections
<dimas> reinhard: can you help to find what should be changed to make it work?
<reinhard> just a second
* chillywilly has set MAXDAEMONS=80 and MAXPERIP=120 in /etc/courier/imapd
<chillywilly> I have always wished that my computer would be as easy to use as my
<chillywilly>  telephone. My wish has come true. I no longer know how to use my
<chillywilly>  telephone."
<chillywilly>    -Bjorne Stroustrup, computer science professor,
<chillywilly>                        designer of C++ programming language (1950- )
*** dsmith has left #gnuenterprise
<reinhard> dimas: sorry, from what I can tell, most of the stuff in the subdirectories of gnue-packages/base is broken and unusable
<reinhard> I've started to redo stuff cleanly in gnue-packages/base/base.gcd
<reinhard> but I've not gotten very far yet :(
<dimas> how it should be done there? what's the idea?
<dimas> i'd like to test it even from this very early stage
<reinhard> dimas: look at base.gcd
<reinhard> as an example
<reinhard> sigh, will be AFK again for > 24 hrs
<reinhard> I hate having no time for gnue :((
<reinhard> see you tomorrow
<reinhard> must go :(
<reinhard> bye
*** reinhard has quit IRC
<dimas> heh
*** Amorphous has joined #gnuenterprise
*** Amorphous has left #gnuenterprise
*** qman has joined #gnuenterprise
*** insanekane has joined #gnuenterprise
<insanekane> Can i use the GCD parser in the appserver package for my own applications ? or is it meant for use only within the AppServer ?
*** lxf has joined #gnuenterprise
*** lxf has joined #gnuenterprise
*** lxf has quit IRC
*** insanekane has quit IRC
*** evangineer has joined #gnuenterprise
*** evangineer has left #gnuenterprise
*** lekma has quit IRC
*** mixi^ has joined #gnuenterprise
*** mixi has quit IRC
*** sjc has joined #gnuenterprise
*** holycow has joined #gnuenterprise
*** mhe_ has quit IRC
*** insanekane has joined #gnuenterprise
*** insanekane has quit IRC