| chat.freenode.net #tryton log beginning Thu May 27 00:00:02 CEST 2010 | ||
| 2010-05-27 00:00 <cedk> ebanders: you miss encoding part | ||
| 2010-05-27 00:00 <cedk> ebanders: I don't know Debian enough to tell you where to add it | ||
| 2010-05-27 00:04 <paepke> cedk, you mean that?: http://ashtech.net/~syntax/blog/archives/160-PostgreSQL-Upgrade-to-8.3-on-Debian-Encoding-Issues.html | ||
| 2010-05-27 00:04 <paepke> its about reinit the db | ||
| 2010-05-27 00:06 <cedk> paepke: I don't think | ||
| 2010-05-27 00:06 <cedk> paepke: the error message clearly says that UTF-8 is not allowed because of locale "en_US" | ||
| 2010-05-27 00:07 <cedk> so locale must be set to "en_US.UTF-8" | ||
| 2010-05-27 00:07 <paepke> ah. thats "dpkg-reconfigure locales". mentioned in the link, too. | ||
| 2010-05-27 00:10 <ebanders> I've been working within gnome, so environment variables seem to be static within at least this X session. | ||
| 2010-05-27 00:11 <cedk> ebanders: I guess it is the locale of the user running postgresql that needs to be changed | ||
| 2010-05-27 00:12 <ebanders> where is that stored? | ||
| 2010-05-27 00:13 <paepke> ebanders, use "dpkg-reconfigure locales". is there a special need not using utf8 systemwide? | ||
| 2010-05-27 00:14 <ebanders> no reason. currenlty the default is set to en_US.UTF-8 | ||
| 2010-05-27 00:15 <ebanders> and I receive the same error from a tty which reports that default when running 'locale' | ||
| 2010-05-27 00:16 <ebanders> Is there a locale specified somewhere for the postgres user? | ||
| 2010-05-27 00:17 <paepke> ebanders, it could be that those template1 db is not on utf8. thats why i posted that link. but i'm not sure | ||
| 2010-05-27 00:18 <cedk> ebanders: are you sure it is en_US.UTF-8 because you said locale returnd only en_US | ||
| 2010-05-27 00:18 <ebanders> http://pastebin.com/2ucufKxq seems to indicate that. | ||
| 2010-05-27 00:20 <paepke> ebanders, cedk: i assume the template1 database was created on your system before generating that utf8 locale. | ||
| 2010-05-27 00:20 <cedk> paepke: yes perhaps | ||
| 2010-05-27 00:20 <cedk> what is the -l options in createdb ? | ||
| 2010-05-27 00:21 <ebanders> cedk: locale | ||
| 2010-05-27 00:21 <cedk> ebanders: it is not part of option of my createdb | ||
| 2010-05-27 00:22 <ebanders> it seems to be in mine (man createdb) | ||
| 2010-05-27 00:22 <ebanders> "Specifies the locale to be used in this database. This is equivalent to specifying both --lc-collate and --lc-ctype." | ||
| 2010-05-27 00:23 <cedk> ebanders: which version? | ||
| 2010-05-27 00:23 <cedk> I create my databases with: createdb db_name -E utf-8 | ||
| 2010-05-27 00:24 <ebanders> 8.4.4 | ||
| 2010-05-27 00:24 <cedk> ebanders: so it is new options | ||
| 2010-05-27 00:29 <ebanders> done. working. | ||
| 2010-05-27 00:29 <cedk> ebanders: what have you done? | ||
| 2010-05-27 00:30 <paepke> ebanders, how? i don't wanna die dumb. | ||
| 2010-05-27 00:30 <ebanders> The create database function in the client doesn't seem to work, but the -i option of trytond worked and I can get the client to connect. | ||
| 2010-05-27 00:31 <ebanders> specifying the locale via createdb -l en_US.UTF-8 did the trick to create the database. | ||
| 2010-05-27 00:31 <ebanders> (using --template template0 per the web page that you linked to, paepke) | ||
| 2010-05-27 00:33 <ebanders> I still don't understand the nature of template0 | ||
| 2010-05-27 00:34 <paepke> re-init that database did not work? | ||
| 2010-05-27 00:35 <paepke> purging postgres and reinstalling would do the trick, too ;-) | ||
| 2010-05-27 00:36 <ebanders> paepke: you mean re-initing template1? | ||
| 2010-05-27 00:36 <yangoon_rm> ebanders: hi | ||
| 2010-05-27 00:36 <paepke> ebanders: /usr/lib/postgresql/8.3/bin/initdb -D <postgres data directory> | ||
| 2010-05-27 00:37 <paepke> yes, template1 | ||
| 2010-05-27 00:37 <ebanders> yangoon: Hi :-) | ||
| 2010-05-27 00:37 <yangoon_rm> ebanders: could you login with psql and do 'SHOW server_encoding;' | ||
| 2010-05-27 00:38 <ebanders> yangoon: LATIN1 | ||
| 2010-05-27 00:38 <yangoon_rm> ebanders: thats it, your cluster was initialized with LATIN | ||
| 2010-05-27 00:39 <yangoon_rm> ebanders: thats why you have to declare diffenrent encoding for the database if you want it to be different from initdb | ||
| 2010-05-27 00:39 <yangoon_rm> ebanders: if you want avoid that you should reinit your cluster | ||
| 2010-05-27 00:39 <ebanders> it looks like I can specify an encoding with initdb | ||
| 2010-05-27 00:40 <yangoon_rm> ebanders: http://www.postgresql.org/docs/8.3/interactive/creating-cluster.html | ||
| 2010-05-27 00:40 <yangoon_rm> ebanders: yes | ||
| 2010-05-27 00:40 <yangoon_rm> ebanders: is this a default debian install? | ||
| 2010-05-27 00:41 <ebanders> yangoon: yes/upgraded from lenny | ||
| 2010-05-27 00:46 <ebanders> the data directory must be empty, so should I wipe out the existing data directory and re-create the tryton database after calling initdb? | ||
| 2010-05-27 00:47 <ebanders> (of course retaining the permissions of the original for the new empty directory) | ||
| 2010-05-27 00:47 <paepke> sorry, have to go. good night | ||
| 2010-05-27 00:47 <ebanders> paepke: thank you very very much. | ||
| 2010-05-27 00:47 <ebanders> darn. | ||
| 2010-05-27 00:48 <ebanders> cedk, yangoon: I do appreciate your help. | ||
| 2010-05-27 00:49 <yangoon_rm> ebanders: yes, now that you have installed utf8 locale, recreation of the cluster via initdb should take it automatically | ||
| 2010-05-27 00:50 <yangoon_rm> but to be sure you can also give it as apram | ||
| 2010-05-27 00:50 <yangoon_rm> param | ||
| 2010-05-27 00:50 <yangoon_rm> afterwards of course you have to recreate all databases of this cluster | ||
| 2010-05-27 00:51 <yangoon_rm> ebanders: so take care to make a backup of your databases, if necessary | ||
| 2010-05-27 00:54 <ebanders> this has been my introduction to postgres. a cluster is just a storage unit for postgres? | ||
| 2010-05-27 00:56 <ebanders> yangoon_rm: thanks for the help. I'm going to lurk for a while. | ||
| 2010-05-27 00:56 <yangoon_rm> ebanders: a cluster is the container for the dbs of one server | ||
| 2010-05-27 00:58 <yangoon_rm> ebanders: man pg_createcluster | ||
| 2010-05-27 01:00 <yangoon_rm> ebanders: http://paste.pocoo.org/show/218720/ | ||
| 2010-05-27 01:03 <yangoon_rm> ebanders: and have alook to the link paepke posted | ||
| 2010-05-27 01:03 <yangoon_rm> http://ashtech.net/~syntax/blog/archives/160-PostgreSQL-Upgrade-to-8.3-on-Debian-Encoding-Issues.html | ||
| 2010-05-27 01:04 <yangoon_rm> it is exactly about your problem | ||
| 2010-05-27 01:04 <yangoon_rm> seems that you can even re-init | ||
| 2010-05-27 01:52 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has left #tryton | ||
| 2010-05-27 02:10 -!- ebanders(~ebanders@c-66-41-121-0.hsd1.mn.comcast.net) has joined #tryton | ||
| 2010-05-27 02:10 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-27 02:10 -!- bellHead(~bell@41.174.15.51) has joined #tryton | ||
| 2010-05-27 02:10 -!- woakas(~woakas@190.26.105.211) has joined #tryton | ||
| 2010-05-27 02:10 -!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton | ||
| 2010-05-27 02:10 -!- yangoon(~mathiasb@p549F6BB2.dip.t-dialin.net) has joined #tryton | ||
| 2010-05-27 02:10 -!- dba(~daniel@static.88-198-196-34.clients.your-server.de) has joined #tryton | ||
| 2010-05-27 02:10 -!- saxa(~sasa@host242-95-static.223-217-b.business.telecomitalia.it) has joined #tryton | ||
| 2010-05-27 02:10 -!- tekoholic(~quassel@174-29-170-88.hlrn.qwest.net) has joined #tryton | ||
| 2010-05-27 02:10 -!- ready(~ready@tiu.ligno.com) has joined #tryton | ||
| 2010-05-27 02:10 -!- preC(~preCTWO@orkan.Informatik.Uni-Oldenburg.DE) has joined #tryton | ||
| 2010-05-27 02:10 -!- ChanServ(ChanServ@services.) has joined #tryton | ||
| 2010-05-27 02:11 -!- irclog(~irclog@tycho.b2ck.com) has joined #tryton | ||
| 2010-05-27 02:45 -!- ikks_(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-05-27 05:19 -!- yangoon(~mathiasb@p549F7125.dip.t-dialin.net) has joined #tryton | ||
| 2010-05-27 06:35 -!- mr_amit(~amit@117.254.179.93) has joined #tryton | ||
| 2010-05-27 07:22 -!- mr_amit(~amit@117.254.179.93) has joined #tryton | ||
| 2010-05-27 07:44 -!- oliver__(~oliver@port-92-196-83-48.dynamic.qsc.de) has joined #tryton | ||
| 2010-05-27 07:45 <oliver__> Hi there. | ||
| 2010-05-27 07:46 <oliver__> Can anybody help me? I just downloaded Tryton 1.6 and installed is. works fine so far. after unpacking all the modules in the modules dir, i tried to install them using the client. This does not work..... | ||
| 2010-05-27 07:48 <oliver__> i.e. when i install the module currency, I get that the field model on modell access is missing :( | ||
| 2010-05-27 07:53 <cedk> oliver__: how did you create the database ? | ||
| 2010-05-27 07:55 -!- sharkcz(~dan@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton | ||
| 2010-05-27 07:58 <oliver__> with the tryton "create database" on a new postgres database | ||
| 2010-05-27 07:59 <cedk> oliver__: from the client ? | ||
| 2010-05-27 08:00 <oliver__> i started the trytond then tryton .... i closed the login window and went to file->DATABASE->create db | ||
| 2010-05-27 08:02 <cedk> oliver__: could you put a link of copy/paste of the server log | ||
| 2010-05-27 08:02 <oliver__> ok... moment | ||
| 2010-05-27 08:08 <oliver__> http://globalisierung.de/log.txt | ||
| 2010-05-27 08:11 <oliver__> does that help? | ||
| 2010-05-27 08:11 -!- eLBati(~elbati@94.163.102.191) has joined #tryton | ||
| 2010-05-27 08:12 <cedk> oliver__: you have leave the module version in the directory modules | ||
| 2010-05-27 08:13 <cedk> oliver__: per example, the module currency directory must be named "currency" and not "currency-1.6.0" | ||
| 2010-05-27 08:14 <oliver__> ok. good hint. i will try to correct it.... | ||
| 2010-05-27 08:14 <oliver__> btw great software!!! | ||
| 2010-05-27 08:33 <oliver__> cool! works! Thank you very much. | ||
| 2010-05-27 08:34 <oliver__> Do you know, where i can find the module mrp2 ? | ||
| 2010-05-27 08:36 <cedk> oliver__: there is no mrp2 module that I know | ||
| 2010-05-27 08:39 <oliver__> hmmm. I saw an information on wiki - http://code.google.com/p/tryton/wiki/TrytonMRPIntegration | ||
| 2010-05-27 08:40 <oliver__> perhaps it is still under work ... | ||
| 2010-05-27 08:41 <cedk> oliver__: yes nothing is working | ||
| 2010-05-27 09:13 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-27 09:42 -!- udono(~udono@dynamic-unidsl-85-197-22-84.westend.de) has joined #tryton | ||
| 2010-05-27 09:46 -!- bechamel(~user@chimie-prtx11.scf.fundp.ac.be) has joined #tryton | ||
| 2010-05-27 10:05 -!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton | ||
| 2010-05-27 11:20 -!- tekknokrat(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-27 12:21 -!- paepke(~paepke@p4FEB2106.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-05-27 13:41 -!- ikks_(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-05-27 14:35 -!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton | ||
| 2010-05-27 14:59 -!- woakas(~woakas@190.26.105.211) has joined #tryton | ||
| 2010-05-27 15:20 -!- eLBati(~elbati@93.37.65.5) has joined #tryton | ||
| 2010-05-27 16:26 -!- Red15(~red15@unaffiliated/red15) has joined #tryton | ||
| 2010-05-27 17:29 -!- zodman(~zodman@67.223.236.231) has joined #tryton | ||
| 2010-05-27 18:06 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has joined #tryton | ||
| 2010-05-27 18:54 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-05-27 18:57 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has left #tryton | ||
| 2010-05-27 19:49 -!- eLBati(~elbati@94.163.64.249) has joined #tryton | ||
| 2010-05-27 20:03 -!- paepke(~paepke@p4FEB2106.dip0.t-ipconnect.de) has left #tryton | ||
| 2010-05-27 20:08 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has joined #tryton | ||
| 2010-05-27 20:46 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton | ||
| 2010-05-27 20:49 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton | ||
| 2010-05-27 20:50 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has left #tryton | ||
| 2010-05-27 21:48 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has joined #tryton | ||
| 2010-05-27 22:25 -!- woakas(~woakas@190.26.105.211) has joined #tryton | ||
| 2010-05-27 22:29 -!- tekknokr1t(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-05-27 22:50 -!- woakas(~woakas@190.26.105.211) has joined #tryton | ||
| 2010-05-27 23:01 -!- paepke(~paepke@p5B32E12A.dip.t-dialin.net) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!