| ../irclogs/#mantishelp.2009-04-09.log | ||
| --- scribe started --- | 00:00 | |
| mantisbot | New bug: Bug 10308 - dhx - open - new | 04:23 |
|---|---|---|
| mantisbot | New bug: Need ability to specify MySQL administrator username/password to install plugins - http://www.mantisbt.org/bugs/view.php?id=10308 | 04:23 |
| dhx_m | nuclear_eclipse: when you are about, let me know, as I had a few things/ideas I wanted to mention to you about the Timecard plugin :) | 04:24 |
| dhx_m | and I wasn't sure which category on the official Mantis bug tracker they'd fall under | 04:24 |
| mantisbot | New bug: Bug 10309 - mcheck - open - new | 04:53 |
| mantisbot | New bug: Need to see assigned project when viewing issue - http://www.mantisbt.org/bugs/view.php?id=10309 | 04:53 |
| mantisbot | New bug: Bug 10310 - mcheck - open - new | 05:08 |
| mantisbot | New bug: 'Hide Inactive' filter on Manage Users page produces SQL error - http://www.mantisbt.org/bugs/view.php?id=10310 | 05:08 |
| mantisbot | New bug: Bug 10311 - Sonal - open - new | 10:40 |
| mantisbot | New bug: djhjhdj - http://www.mantisbt.org/bugs/view.php?id=10311 | 10:40 |
| giallu | sigh... is it _that_ hard to tell apart a demo instance from a real one? | 10:43 |
| paulr | yes | 10:43 |
| Sonal | hi | 10:53 |
| [KK]Kirill | paul, delete this bug 10311 | 10:59 |
| mantisbot | Bug 10311 - Sonal - open - new | 10:59 |
| mantisbot | djhjhdj - http://www.mantisbt.org/bugs/view.php?id=10311 | 10:59 |
| paulr | giallu:can you create projects/categories and stuff? | 11:35 |
| paulr | lo dhx_m | 12:16 |
| dhx_m | hi | 12:17 |
| dhx_m | half of freenode just dropped out ;) | 12:17 |
| paulr | irc :) | 12:18 |
| paulr | yea, a server split | 12:18 |
| * paulr wonders when nuclear_eclipse gets out of bed | 12:19 | |
| dhx_m | yep | 12:22 |
| dhx_m | I was wanting to ask a few questions about the timecard plugin :D | 12:22 |
| dhx_m | was thinking of doing some work to it | 12:22 |
| * paulr wonders how fast/slow reflection is in php | 12:25 | |
| [KK]Kirill | paulr: I test phpmailer 5.0. For 3 mail, which I recive - very well | 12:29 |
| paulr | it's more the encoding type issues you/others have had | 12:29 |
| paulr | e.g. emails with russian subjects/body | 12:29 |
| [KK]Kirill | yes | 12:29 |
| [KK]Kirill | http://www.mantisbt.org/bugs/ on last trunk ? | 12:30 |
| paulr | yes | 12:31 |
| [KK]Kirill | one sec. I change lank to russian | 12:32 |
| [KK]Kirill | lang* | 12:33 |
| eNTi | hi guys. is it possible to localize mantis entries oneself? like creating a new category for two different language settings? | 12:33 |
| paulr | i think the answer is yes | 12:34 |
| eNTi | neado...and how do i do that? :) | 12:34 |
| paulr | that's the part i'm not so sure about | 12:35 |
| paulr | iirc | 12:35 |
| paulr | lets see | 12:35 |
| paulr | what *exactly* are you trying to do? | 12:35 |
| dhx_m | it pulls those settings from the config files | 12:35 |
| dhx_m | if I understand his problem correctly | 12:35 |
| eNTi | let me explain | 12:35 |
| dhx_m | it sounds like he wants to translate enum fields | 12:36 |
| dhx_m | and project categories? | 12:36 |
| eNTi | i'm using mantis with the default localization (english) but my mates are not as solid in the english language and use the german localization settings... | 12:36 |
| eNTi | dhx_m: yeah... something like that | 12:36 |
| eNTi | if i create a category it will be in one of those two languages | 12:37 |
| dhx_m | I don't think it is possible? | 12:37 |
| eNTi | same for custom fields | 12:37 |
| eNTi | so i can't create one custom field with different translations, that use the localization setting? | 12:38 |
| dhx_m | I'm not sure I'm the best person to ask | 12:39 |
| dhx_m | actually | 12:39 |
| dhx_m | it should be possible... let me check | 12:39 |
| paulr | I think there was a blog post on this | 12:40 |
| paulr | I'm pretty sure the answer is yes | 12:40 |
| paulr | in that | 12:40 |
| paulr | i know you can have custom language files | 12:40 |
| paulr | and iirc, at some point, we try a lang_get on the custom name ithink | 12:40 |
| dhx_m | you normally place those strings in custom_strings_inc.php I gather | 12:40 |
| dhx_m | although I'm not sure how the locale relates to custom_strings_inc.php | 12:41 |
| paulr | there's some OLD hints at http://www.futureware.biz/blog/index.php?title=customising_localised_strings_in_mantis&more=1&c=1&tb=1&pb=1 | 12:43 |
| dhx_m | aha yep | 12:43 |
| dhx_m | it is in the docbook manual too | 12:43 |
| dhx_m | basically you'd split your custom_strings_inc.php into one section for each locale | 12:43 |
| dhx_m | similar to: | 12:43 |
| dhx_m | if ( lang_get_current() == 'german' ) { | 12:44 |
| dhx_m | $s_my_start_date = 'Start Date XX'; // German translation of Start Date | 12:44 |
| dhx_m | } else { | 12:44 |
| dhx_m | # Default (use your preferred language as the default) | 12:44 |
| dhx_m | $s_my_start_date = 'Start Date'; | 12:44 |
| dhx_m | } | 12:44 |
| dhx_m | it'd probably be neater if you included a separate per-language custom strings file | 12:44 |
| dhx_m | from custom_strings_inc.php | 12:44 |
| dhx_m | or you could throw it all in custom_strings_inc.php | 12:45 |
| mantisbot | New bug: Bug 10312 - tarun - open - new | 12:45 |
| mantisbot | New bug: how can i make active directory on mantis so that i can use it according to my requiernment - http://www.mantisbt.org/bugs/view.php?id=10312 | 12:45 |
| eNTi | that would mean i've to hack into the php code, right? :) | 12:47 |
| eNTi | i'm not sure i wanna do this | 12:47 |
| eNTi | sounds like breaking things | 12:47 |
| dhx_m | you can tell bad bug reports just by the title hah :P | 12:47 |
| dhx_m | eNTi: no, not really | 12:47 |
| dhx_m | eNTi: you'd only need a single if / else if / else block as I demonstrated above | 12:48 |
| dhx_m | and then you can overwrite each string on a per-language basis | 12:48 |
| dhx_m | categories might not work though, as they're stored in the database | 12:48 |
| dhx_m | maybe there is another fix for that... maybe not | 12:48 |
| dhx_m | at least you can translate statuses, resolutions, etc | 12:49 |
| eNTi | ok. thank you | 12:49 |
| dhx_m | just make all your modifications to custom_strings_inc.php | 12:50 |
| dhx_m | there is more information on how this all works in the manual | 12:50 |
| dhx_m | which is where I took the example from | 12:51 |
| [KK]Kirill | paulr: http://easycaptures.com/4522804843 | 12:54 |
| [KK]Kirill | In my mantisbt - all fine, but in official mantisbt i recive this email, when set russian lang | 12:54 |
| [KK]Kirill | I must use english lang | 12:55 |
| [KK]Kirill | to read messages | 12:55 |
| giallu | paulr, I think I can create categories, not usre about projects | 13:02 |
| nuclear_eclipse | dhx_m: here new, but I'm in class | 13:12 |
| nuclear_eclipse | now* | 13:12 |
| dhx_m | no problems, I'm limited for time too, so may ask later :) | 13:12 |
| [KK]Kirill | nuclear_eclipse: hi | 13:13 |
| [KK]Kirill | pail: did you see? | 13:28 |
| [KK]Kirill | paulr: : Did you see? | 13:28 |
| mantisbot | New bug: Bug 10313 - dhx - open - new | 13:31 |
| mantisbot | New bug: Ability for per-user control over whether to notify of changes made by self - http://www.mantisbt.org/bugs/view.php?id=10313 | 13:31 |
| giallu | dhx_m, are you going to work on 10313? | 13:40 |
| dhx_m | if no one else does... yep :) | 13:40 |
| mantisbot | New bug: Bug 10314 - alinmance - open - new | 13:41 |
| mantisbot | New bug: blabla - http://www.mantisbt.org/bugs/view.php?id=10314 | 13:41 |
| giallu | looks like something low hanging. | 13:41 |
| dhx_m | what do you think of the idea? | 13:41 |
| giallu | of course, you will hit complains about "breaking old behavior" | 13:41 |
| dhx_m | you can still maintain old behaviour (global override) | 13:41 |
| giallu | but I think it would be fine | 13:41 |
| dhx_m | although I don't see the point in having a global override | 13:42 |
| * giallu favours removing global configuration variables... | 13:42 | |
| dhx_m | maybe what is needed is a "default state" setting | 13:42 |
| dhx_m | however that is best done by creating a "default" template user | 13:42 |
| dhx_m | that is copied to create a new user | 13:43 |
| giallu | looks like a "class User"... | 13:43 |
| giallu | or better | 13:43 |
| giallu | class Mantis_User | 13:43 |
| dhx_m | what would be really neat is something like that | 13:44 |
| dhx_m | where plugins can add their own user-specific data | 13:44 |
| dhx_m | and settings | 13:44 |
| paulr | giallu: I got bored this morning! | 13:46 |
| giallu | paulr, lucky you... | 13:46 |
| * daryn_away is away: Gone away for now | 14:32 | |
| * daryn is back. | 14:40 | |
| paulr | lo | 14:42 |
| daryn | greetings | 14:42 |
| mantisbot | New bug: Bug 10315 - fedchyk - open - new | 14:51 |
| mantisbot | New bug: Add date/time to Changelog - http://www.mantisbt.org/bugs/view.php?id=10315 | 14:51 |
| paulr | nuclear_eclipse: up yet? ) | 15:21 |
| paulr | daryn: I want some feedback on an idea | 15:22 |
| daryn | ok | 15:22 |
| daryn | terrible | 15:23 |
| daryn | what's the idea? | 15:23 |
| paulr | (: | 15:23 |
| paulr | sec | 15:24 |
| paulr | right | 16:03 |
| paulr | lets see | 16:03 |
| paulr | daryn: whats your view on the changes in :http://mantis.pastebin.com/d7bac8aa | 16:06 |
| paulr | . | 16:08 |
| paulr | **-*//*+8/+ | 16:08 |
| paulr | ] | 16:08 |
| paulr | ] | 16:08 |
| paulr | p987op0['#:@Po54345/; k2123467u8i9765 | 16:08 |
| paulr | 2890p-9 | 16:08 |
| daryn | what? | 16:09 |
| paulr | sorry, was hoovering desk | 16:09 |
| paulr | http://mantis.pastebin.com/d7bac8aa | 16:09 |
| paulr | in that | 16:09 |
| daryn | do you have a diff? | 16:09 |
| daryn | would be easier to see the changes | 16:10 |
| paulr | i could make abranch if you told me how | 16:10 |
| paulr | or more push a branch to a mantisforge fork | 16:10 |
| daryn | ah | 16:10 |
| daryn | git push <remotename> <localbranch>:<remotebranch> | 16:11 |
| daryn | remotename is whatever you've named the mantisforge repo in your local config | 16:11 |
| paulr | daryn: is there for joomla an auto update plugin? | 16:18 |
| daryn | not that i know of | 16:19 |
| paulr | -r-xr-xr-x 1 mantisweb mantisweb 13537 Sep 11 2008 template.css | 16:19 |
| paulr | epic permissions | 16:19 |
| daryn | a plugin would not really work for auto updating because of permissions issues | 16:21 |
| daryn | probably need a local script running with special permissions. | 16:22 |
| daryn | did you get a branch pushed? | 16:22 |
| paulr | I got distracted | 16:22 |
| daryn | stop that! | 16:22 |
| paulr | right, i've made it+ssh://git.mantisforge.org/srv/git/mantisbt/paul.git. | 16:28 |
| paulr | now, do i need to push my master first ? | 16:28 |
| daryn | nah | 16:29 |
| daryn | your master doesn't matter | 16:29 |
| paulr | try now | 16:32 |
| daryn | there we go.. | 16:33 |
| daryn | that doesn't look related to the pastebin code... | 16:36 |
| paulr | oops, hadn't commited | 16:36 |
| paulr | try now | 16:36 |
| daryn | that's better | 16:37 |
| daryn | why are you using __ for a public function? | 16:40 |
| paulr | overloading methods have to be defined as public? | 16:41 |
| daryn | hm..is that the magic functions | 16:41 |
| paulr | yes | 16:42 |
| daryn | it's been awhile... | 16:42 |
| daryn | you've changed the BugData properties to protected but then are setting them directly...have I missed something? | 16:45 |
| daryn | and getting them actually... | 16:46 |
| * paulr ndos | 16:46 | |
| paulr | that's what __get overrides | 16:46 |
| daryn | uhm...i don't think so...i think you still have to call getParamName as a function...you just don't have to define it. | 16:47 |
| daryn | unless i've completely misunderstood how magic functions work | 16:47 |
| paulr | if I call ->foo | 16:48 |
| paulr | that'll go through __get on the way | 16:48 |
| daryn | hm...ok. i'll take your word for it...for the moment. :) | 16:49 |
| daryn | in general i like the idea | 16:51 |
| paulr | i'll carryu on then | 16:53 |
| daryn | i'd like to see us define an interface and more thoroughly overhaul the bug object | 16:54 |
| daryn | ok...so i misunderstood it | 16:57 |
| paulr | so erm | 17:04 |
| paulr | I see what you mean | 17:04 |
| paulr | about interface | 17:04 |
| daryn | i started trying to do interfaces for my view, filters, and custom fields...it's a long process | 17:04 |
| daryn | but useful | 17:05 |
| paulr | if I carried on with what i'm doing atm | 17:06 |
| paulr | can we then easily change it? | 17:06 |
| paulr | i.e. is it a 'help' or a hinderance | 17:06 |
| daryn | sure. an interface can be added later but it would probably provide more direction in development to start with one in mind | 17:07 |
| daryn | i think a broader discussion of how we want to use classes would be beneficial. | 17:08 |
| daryn | i started filters and custom fields on an idea and as i've gotten into it i realize the class structure needs more thought | 17:08 |
| paulr | the problem is where stuff interlinks | 17:19 |
| daryn | yes, we need to decouple as much as possible | 17:20 |
| * daryn is back. | 18:25 | |
| paulr | daryn: hmm | 18:34 |
| paulr | is mantisbt.org down? | 18:34 |
| daryn | kinda looks that way | 18:35 |
| paulr | right, how to get some proper feedback on bug stuff | 18:37 |
| * paulr ponders | 18:37 | |
| paulr | first instance, wait for john I guess | 18:37 |
| daryn | yeah... | 18:37 |
| daryn | dhx_m seems to be fairly familiar with oo stuff too | 18:37 |
| paulr | from what I can tell, think it'll speed stuff up | 18:38 |
| daryn | i believe so if we properly design it | 18:38 |
| paulr | even without | 18:38 |
| paulr | atm we call string_display_line on stuff that can only be an int | 18:38 |
| paulr | :) | 18:38 |
| daryn | there are a lot of places where function calls are made several times throughout code that could be called once and reused | 18:38 |
| paulr | string_display_line means | 18:38 |
| paulr | we call plugin api | 18:38 |
| paulr | then we get plugin config | 18:38 |
| paulr | then we apply string_strip_hrefs and the rest | 18:39 |
| paulr | and then we conclude that 1 is still 1 | 18:39 |
| daryn | right...I wondered what all that was | 18:39 |
| daryn | never looked into it | 18:39 |
| paulr | and if we conclude that 1 isn't 1 | 18:39 |
| daryn | but...what if 1 is NOT 1? :) | 18:39 |
| paulr | because a plugin changes any occurence of 1 to A | 18:39 |
| paulr | we then break everything | 18:39 |
| daryn | fun | 18:40 |
| paulr | as category_get_name ($bugdata->category) expects to get 1 not A | 18:40 |
| paulr | what I can't decide is atm | 18:40 |
| paulr | I have lets take summary | 18:40 |
| paulr | ->display('summary') | 18:40 |
| paulr | ->summary | 18:40 |
| paulr | ->edit('summary') | 18:40 |
| paulr | I'm not sure I like that | 18:41 |
| paulr | i'd rather have ->raw('summary') | 18:41 |
| paulr | or at least block ->summary and say "sry, you need to call display or edit for stirng fields" | 18:41 |
| paulr | i.e. you can do ->reporter_id but not ->description as description could be XSS | 18:42 |
| daryn | you could...not use magic functions at all | 18:42 |
| paulr | We've got a whole bunch of code that deals with changing string(1) to int(1) | 18:43 |
| paulr | at various random places | 18:43 |
| paulr | the idea of the magic functions was basically to ensure that we know it's int(1) as class will only store/set/send int(1) | 18:43 |
| daryn | you can do that by explicitly defining the get/sets though...maybe a pain but clearer and you're certain what happens | 18:44 |
| paulr | load average: 190.48, 194.50, 195.8 | 19:21 |
| paulr | ;/ | 19:21 |
| aptituz | nice | 19:24 |
| paulr | it's giallu fault I bet | 19:31 |
| giallu | surely | 19:32 |
| paulr | giallu: well, you picked centos :) | 19:33 |
| giallu | and? | 19:33 |
| paulr | [20:21:09] <paulr> load average: 190.48, 194.50, 195.8 | 19:33 |
| paulr | [20:21:11] <paulr> ;/ | 19:33 |
| paulr | [20:24:58] <aptituz> nice | 19:33 |
| paulr | [20:25:54] * giallu (n=giallu@fedora/giallu) has joined #mantishelp | 19:33 |
| giallu | nice | 19:34 |
| giallu | hardly a CentOS fault I bet... | 19:34 |
| * giallu checking | 19:35 | |
| daryn | pretty good bet I'd say | 19:35 |
| paulr | giallu: do you keep the box up to date? | 19:35 |
| paulr | btw | 19:35 |
| paulr | for security issues etc | 19:35 |
| paulr | or does victor? | 19:36 |
| giallu | I insisted to have all packaged stuff for that reason | 19:36 |
| paulr | when was it last updated? | 19:36 |
| giallu | checking | 19:37 |
| daryn | would it be possible to linkify bug id's referenced on the mantweet page? | 19:37 |
| daryn | btw...i hate that name | 19:37 |
| giallu | oh | 19:37 |
| giallu | centos 5.3 is out... | 19:37 |
| giallu | so 139 Mb of updates to pull | 19:38 |
| paulr | how do you do updates on centos? | 19:38 |
| daryn | install yum | 19:38 |
| giallu | yum update | 19:38 |
| paulr | may I? | 19:38 |
| giallu | I'm doing that | 19:39 |
| daryn | i forgot...centos comes with yum | 19:39 |
| paulr | what does this box run? | 19:39 |
| giallu | cat /etc/issue | 19:40 |
| giallu | CentOS release 5.2 (Final) | 19:40 |
| paulr | futureware.biz, + mantis: forums,www,blog,bugs? | 19:40 |
| giallu | not usre about futureware, all the rest yes | 19:40 |
| paulr | if you look at /etc/httpd/conf/httpd.conf | 19:41 |
| paulr | for the LoadModule stuff | 19:41 |
| paulr | which modules do you know we need ? | 19:41 |
| giallu | I don't really know. is that an issue | 19:43 |
| giallu | ? | 19:43 |
| paulr | 20:33 - Paul: 5257 apache 20 0 390m 47m 28m S 28 4.6 0:00.96 httpd | 19:44 |
| paulr | 5254 apache 20 0 379m 30m 22m S 16 3.0 0:00.26 httpd | 19:44 |
| paulr | 20:33 - Paul: isn't that a bit large? | 19:44 |
| paulr | 20:33 - Paul: for ram | 19:44 |
| paulr | 20:33 - shroud: 390? | 19:44 |
| paulr | 20:33 - shroud: a bit | 19:44 |
| giallu | tbh, the main problem with the server is that we are running 64 bit exevutalbes in a small memory env | 19:44 |
| giallu | and that wastes lots of ram | 19:44 |
| paulr | yea, that doesn't help | 19:45 |
| paulr | why's it running 64bit? | 19:45 |
| giallu | beacuse victor installed it that way | 19:45 |
| giallu | now I'm not sure how easy would be to convert to 32 bit | 19:45 |
| paulr | presumably because victor idnd't know any different/better | 19:45 |
| giallu | possibly | 19:45 |
| paulr | then again, my mantisforge xen's are 64bit ;/ | 19:46 |
| giallu | xen ok, but userspace? | 19:46 |
| paulr | mysql is setup to restart daily? | 19:47 |
| paulr | nm, I can't read logs | 19:47 |
| mantisbot | New bug: Bug 10316 - jhcruvinel - open - new | 19:51 |
| mantisbot | New bug: The option for language portuguese brazil is "portugese_brazil" while must be "portuguese_brazil" in config_defaults_inc.php - http://www.mantisbt.org/bugs/view.php?id=10316 | 19:51 |
| paulr | giallu: yum finished? | 19:58 |
| paulr | giallu: how can i see packages installed via yum ? | 20:01 |
| giallu | uhm | 20:02 |
| giallu | what ever happened? | 20:02 |
| giallu | cat /var/log/yum.log | 20:02 |
| nuclear_eclipse | I switched from SliceHost to Linode.com specifically because Linode runs 32-bit VPS systems... | 20:04 |
| nuclear_eclipse | and you get more memory/bandwidth for the same monthly cost | 20:05 |
| giallu | nuclear_eclipse, I think it was an option? | 20:05 |
| nuclear_eclipse | not with Slicehost | 20:05 |
| giallu | oh | 20:05 |
| giallu | very handy... | 20:05 |
| nuclear_eclipse | http://www.linode.com/?r=ebecdda24dde08d94025bbfe10e9994718d398be | 20:05 |
| CIA-18 | Mantisbt: s.mazeland * rfb158f714ff2 /lang/strings_english.txt: Use consistent parameter notation, please. | 20:08 |
| nuclear_eclipse | lol, those strings were put in place long before we ever started putting an order to language parameters... :P | 20:09 |
| paulr | wtf does that mean | 20:10 |
| nuclear_eclipse | eg, in case some language wanted to say "%2$s aoeu %1$s" | 20:11 |
| paulr | ahh | 20:11 |
| paulr | nuclear_eclipse: whats your view on the bug api stuff thne ? | 20:11 |
| siebrand | why am I getting "git diff" results, even after I did "git reset --hard" on phpmailer? | 20:11 |
| nuclear_eclipse | but I wrote that feature before we ever started implementing that sort of thing in Mantis | 20:12 |
| nuclear_eclipse | paulr: I don't have much of a view, really, other than preferring the simplest way of doing things | 20:13 |
| paulr | shall I carry on and see where i end up then ? | 20:13 |
| nuclear_eclipse | perhaps | 20:14 |
| paulr | i'd like to merge create/update | 20:14 |
| nuclear_eclipse | you might be interested to see how I did that for my source integration API; I did what you suggested, ie create()+update() -> save() | 20:15 |
| * paulr ndos | 20:16 | |
| paulr | i'm trying to work out how to do that with the fact we do history | 20:16 |
| nuclear_eclipse | but my API is also completely class-based | 20:16 |
| paulr | what file am i looking at | 20:17 |
| nuclear_eclipse | http://git.mantisforge.org/w/source-integration.git?a=blob;f=Source/Source.API.php;h=00bc399569491a0228199a8fc880c2eab1a4c44c;hb=HEAD | 20:17 |
| paulr | ya | 20:17 |
| paulr | I just need to think of a way to do it with bugs | 20:17 |
| nuclear_eclipse | but I think if we're going to change bug_api, that should probably wait til after 1.2.x | 20:17 |
| * paulr shrugs :) | 20:18 | |
| nuclear_eclipse | so is there anything remaining for 1.2.x that you can work on in the next week or so that you have off? | 20:18 |
| nuclear_eclipse | eg, fixing date handling? | 20:18 |
| siebrand | nuclear_eclipse: I host with http://netcup.de/. Pretty compative pricing compare with linode. | 20:18 |
| nuclear_eclipse | siebrand: german hosts don't work well for americans :P | 20:18 |
| siebrand | nuclear_eclipse: helps if you read German... ;0 | 20:19 |
| paulr | i'm confused with date handling | 20:19 |
| paulr | in fact | 20:19 |
| paulr | it was thinking about date handling | 20:19 |
| paulr | that lead to me to pull out this code in the first place ;p | 20:19 |
| paulr | in terms of date handling | 20:20 |
| paulr | how do we want to do it | 20:20 |
| paulr | starting with | 20:22 |
| paulr | do we want to | 20:22 |
| paulr | a) carry on with timestamps in db | 20:22 |
| paulr | b) story ints in db | 20:22 |
| nuclear_eclipse | we need to a) store dates in a stable, GMT format, b) convert from user/server timezone when getting input, and c) convert from GMT to user/server timezone for display | 20:22 |
| paulr | does a === int | 20:23 |
| nuclear_eclipse | I don't care how it's actually stored in the database, as long as it's GMT time that we can deterministically convert to/from when handling local timezones | 20:23 |
| nuclear_eclipse | perhaps we need to pull from a third party tzdata-like library | 20:24 |
| paulr | to approach it a different way: | 20:24 |
| paulr | we know that 1 == 1970/1/1 00:00:01 UTC or whatever right? | 20:24 |
| paulr | if someone has mysql in america | 20:24 |
| paulr | where timezone is set to -8hours | 20:24 |
| paulr | whats '1' | 20:25 |
| nuclear_eclipse | I don't know how that all works, and honestly, I really don't *want* to know, which is likely why we should use an external library | 20:25 |
| paulr | could it be 1969/31/12 16:0:0 | 20:25 |
| paulr | well, php updated timezone stuff | 20:25 |
| paulr | where I got confused is working out what db stores | 20:25 |
| giallu | I vote for useing a 3rd party class/lib | 20:26 |
| giallu | anyway, yum update finished | 20:26 |
| * giallu notes ez components has no datetime stuff | 20:27 | |
| paulr | ok, if i look at: | 20:27 |
| paulr | http://www.mantisbt.org/bugs/view.php?id=1 | 20:27 |
| paulr | that says: 2001-02-03 14:16 for date_submitted | 20:28 |
| paulr | if i run mysql select on old copy of mantis db i've restored here from when victor used to generate a sanitised version: | 20:28 |
| paulr | 2001-02-03 14:16:12 | 20:28 |
| paulr | now mantis server has never been in europe so | 20:28 |
| paulr | giallu: http://uk3.php.net/manual/en/class.datetime.php | 20:29 |
| giallu | yeah looking at that now | 20:29 |
| paulr | but the problem is 'simple' in the sense that: | 20:30 |
| giallu | anyway paul, since we want to support multiple dbs | 20:30 |
| paulr | I know that int(1) = 01/01/1970 | 20:30 |
| paulr | once you put 01/01/1970 into mysql/postgres in -8,0,+8 hours locations accross the world | 20:31 |
| paulr | i'm not sure I know what int(1) means | 20:31 |
| giallu | paulr, the point is | 20:31 |
| paulr | or even if I still get int(1) back from the db for that date | 20:31 |
| giallu | you don't need to | 20:31 |
| giallu | you want to ask something: look, I'm from GMT+1, now is 22.31, tell me how much is this in unixtimestamp | 20:32 |
| giallu | then john can ask the same thing: | 20:32 |
| paulr | well, we can localise unixtimestamp int in php easily | 20:33 |
| giallu | paulr I have this unix time stamp: what time was in GMT-8? | 20:33 |
| giallu | paulr, yes | 20:33 |
| nuclear_eclipse | don't ask me; I won't know :P | 20:33 |
| giallu | and that very portable across DBs | 20:33 |
| paulr | the point is: | 20:33 |
| paulr | atm | 20:33 |
| paulr | we store datetime in db | 20:33 |
| paulr | we then convert datetime to an int in php | 20:33 |
| paulr | and then we convert into to a RFCdate for display | 20:34 |
| paulr | if we then localise the date for each user | 20:34 |
| giallu | we want to go int in the DB | 20:34 |
| paulr | i'm not sure we need the first part | 20:34 |
| giallu | and just localise | 20:34 |
| paulr | right so datetime->int conversion in db? :) | 20:34 |
| nuclear_eclipse | how appropriately do databases handle converting datetime columns to int? | 20:34 |
| paulr | nuclear_eclipse: with adodb? | 20:34 |
| giallu | nuclear_eclipse, we do it in php | 20:34 |
| giallu | _before_ saving int he db | 20:35 |
| paulr | nuclear_eclipse: fucking badly probably | 20:35 |
| giallu | the problem is: existing data | 20:35 |
| nuclear_eclipse | I meant more, how do we convert from existing datetime db entries to int entries via table altering... | 20:35 |
| giallu | yeah, that... | 20:35 |
| giallu | it's not possible | 20:35 |
| giallu | or better | 20:35 |
| giallu | it's not possible to have a correct conversion without knowing the timezone that generated the event | 20:36 |
| paulr | that's irrelevant | 20:36 |
| paulr | should work itself out in the wash | 20:36 |
| paulr | john's issue is more the important one | 20:36 |
| paulr | can we do: | 20:37 |
| paulr | ALTER TABLE DATETIME TO INT | 20:37 |
| nuclear_eclipse | right | 20:37 |
| paulr | what we can do | 20:37 |
| paulr | is | 20:37 |
| paulr | ADD COLUMN submitted_timestamp | 20:37 |
| paulr | migrate data | 20:37 |
| paulr | DROP column date_submitted | 20:37 |
| nuclear_eclipse | I think it should be acceptable to just assume all time entries were made according to the server's localtime | 20:37 |
| paulr | exactly | 20:37 |
| paulr | so | 20:37 |
| giallu | acceptable, but not correct | 20:38 |
| paulr | correct | 20:38 |
| paulr | it must be the localtime atm | 20:38 |
| paulr | anyway | 20:38 |
| paulr | add ; migrate ; drop | 20:38 |
| paulr | OR | 20:38 |
| paulr | in fact, we need to do that | 20:38 |
| paulr | nuclear_eclipse: do i need to checkout master then create a new branch ? | 20:38 |
| giallu | I think add migrate drop is more portable | 20:38 |
| nuclear_eclipse | paulr: yes | 20:39 |
| giallu | paulr, no | 20:39 |
| giallu | :P | 20:39 |
| nuclear_eclipse | well, yes/no :P | 20:39 |
| giallu | it's easier if you're on master | 20:39 |
| nuclear_eclipse | either `git co master; git co -b new-branch` or `git branch master new-branch; git co new-branch` :P | 20:39 |
| paulr | so lets see | 20:39 |
| paulr | we have: | 20:40 |
| paulr | tokens_table -> timestamp --> irrelevant - leave as is? | 20:40 |
| nuclear_eclipse | right | 20:40 |
| paulr | bug_Table -> due_date -> yes | 20:40 |
| nuclear_eclipse | I gotta run though | 20:40 |
| paulr | file_table -> date_added -> yes | 20:40 |
| nuclear_eclipse | I'll catch you all later | 20:40 |
| paulr | bug_table -> date_submitted | 20:40 |
| paulr | bug_table -> last_updated | 20:41 |
| paulr | bugnote -> date_submitted ,last_modified | 20:41 |
| paulr | news_table -> date_posted, last_modified | 20:41 |
| paulr | project_file_table date_added | 20:41 |
| paulr | project_version_table -> date_order | 20:41 |
| paulr | sponsorship_table -> date_submitted, last_modified | 20:42 |
| paulr | user_table -> date_craeted, last_visit | 20:42 |
| paulr | email_Tabl -> least as is | 20:42 |
| * giallu is amazed by the number of mantis users in brazil/portugal | 20:54 | |
| Roa | hi | 21:18 |
| Roa | one question what is default pass | 21:18 |
| Roa | of the mantis before install? | 21:18 |
| daryn | type 'default mantis password' in google and see what comes up...especially check the first link | 21:19 |
| Roa | ok | 21:20 |
| Roa | other question | 21:21 |
| Roa | i have conect mantis to my AD(Actived Directory) well.. what user name taking of administrator of mantis? | 21:21 |
| daryn | hm....paulr? | 21:22 |
| daryn | nuclear_eclipse? | 21:22 |
| daryn | sorry Roa...i don't know that one. | 21:22 |
| Roa | ok | 21:23 |
| Roa | not problem | 21:23 |
| paulr | lo | 21:46 |
| daryn | paulr can you answer Roa's question? | 21:47 |
| paulr | whatever default admin username is, or you login via ad then login without ad and change someone to admi | 21:48 |
| Roa | for example my user name whith login via ad is | 21:48 |
| Roa | jroa and pass is 1234 | 21:49 |
| Roa | but not working :S | 21:49 |
| bartik | Seems like mantis needs something similar to this http://mantis.phplist.com/view.php?id=9816 | 21:51 |
| bartik | Roa: When you authenticate via remote_user then this user is autocreated with the default_new_account_access_level | 21:52 |
| Roa | ok | 21:53 |
| Roa | one question more.. mantis have import user from AD ? | 21:54 |
| bartik | so one of your options would probably be to set this to ADMINISTRATOR then login as yourself and donīt forget to set it back to the REPORTER or anybody else logging in would be created as an administrator too | 21:54 |
| bartik | in other words in your config_inc.php have the line $g_default_new_account_access_level = ADMINISTRATOR; | 21:55 |
| bartik | YOu don't need to import all users. they will be autocreated as they login for the first time so the short answer is no. | 21:56 |
| paulr | bartik: is that yours? | 21:56 |
| bartik | what ? | 21:57 |
| paulr | phplist | 21:57 |
| bartik | no. | 21:57 |
| bartik | itīs a patch for phplist but a similar proceeding would be fit for mantis I suppose. | 21:57 |
| bartik | not the patch itself. the idea I mean. | 21:58 |
| bartik | Inbetwwen I have found this http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=274748 seems like it is not possible to specify a password for root still... | 22:00 |
| bartik | erm. administrator | 22:00 |
| paulr | daryn: gone? | 22:01 |
| nuclear_eclipse | dhx_m: still about? | 22:58 |
| paulr | nuclear_eclipse: can you review a patch | 23:07 |
| nuclear_eclipse | perhaps | 23:08 |
| paulr | to install.php :) | 23:08 |
| paulr | also | 23:08 |
| paulr | have we ever done a rename column yet? | 23:08 |
| nuclear_eclipse | not that I can think of | 23:08 |
| paulr | http://mantis.pastebin.com/m4824a068 | 23:09 |
| paulr | can i commit that | 23:09 |
| paulr | wow | 23:24 |
| * paulr sighs | 23:24 | |
| * daryn_away is away: Gone away for now | 23:27 | |
Generated by irclog2html.py