| 03:38.44 | *** join/#flyspray _judas_iscariote (n=cristian@200.7.26.48) |
| 03:38.44 | *** mode/#flyspray [+o _judas_iscariote] by ChanServ |
| 05:43.48 | *** join/#flyspray floele (n=Miranda@p3EE27EA7.dip.t-dialin.net) |
| 05:43.48 | *** mode/#flyspray [+o floele] by ChanServ |
| 05:49.17 | floele | DragonWize? |
| 05:49.30 | DragonWize | yes |
| 05:49.37 | floele | I sent you a mail ;) |
| 05:49.43 | floele | your patch still contains conflicts |
| 05:49.45 | DragonWize | back so soon |
| 05:50.07 | floele | yep |
| 05:51.08 | DragonWize | yeah, notice that after I sent it but you were out already, I'll send another |
| 05:51.25 | floele | and make sure that it contains all your changes |
| 05:51.29 | floele | not just what is new |
| 05:51.58 | floele | it won't work if I apply all your four patches in a row ;) |
| 05:53.40 | DragonWize | um, new as in diffed from svn? hmmm |
| 05:55.14 | DragonWize | can you take it dcc? |
| 05:57.33 | floele | dcc? |
| 05:59.21 | DragonWize | irc transfer, but I already sent it via email |
| 06:07.20 | DragonWize | where are the reports at? |
| 06:12.01 | floele | which reports? |
| 06:12.05 | floele | you mean the event log? |
| 06:13.00 | DragonWize | that reports.tpl belongs to |
| 06:13.22 | floele | yes, the event logs |
| 06:13.38 | floele | they were called reports before |
| 06:16.09 | floele | ok, this time it works better |
| 06:18.38 | floele | I think I can fix the roadmap myself, and then it should be perfect :) |
| 06:22.46 | _judas_iscariote | floele: good morning for u ;) |
| 06:27.37 | floele | ji |
| 06:27.39 | floele | hi |
| 06:27.49 | judas_iscariote | hi |
| 06:28.00 | floele | is there anything important? otherwise I'll be off again |
| 06:28.30 | judas_iscariote | floele: not atm, just submitted a tiny patch, nothing critical but for soem reason the svn server wont send the email yet. |
| 06:28.37 | judas_iscariote | floele: I think RC1 is done. |
| 06:28.45 | floele | almost ;) |
| 06:29.08 | floele | I'll complete the JS patch and then we are done I think |
| 06:29.33 | judas_iscariote | w00t :) |
| 06:30.39 | judas_iscariote | floele: yes the JS fix should be in good shape before release |
| 06:31.12 | floele | how many patches took it? 6 now? ^^ |
| 06:31.28 | judas_iscariote | ^^ |
| 06:31.29 | floele | whatever...cu later |
| 07:06.48 | *** join/#flyspray hamZta (n=fschlage@gateway.s.roteskreuz.at) |
| 07:07.53 | hamZta | Morning! |
| 07:33.20 | judas_iscariote | hamZta: hi |
| 07:33.28 | hamZta | Hi judas_iscariote |
| 07:34.40 | judas_iscariote | ;) |
| 07:35.45 | judas_iscariote | hamZta: RC1 very soon now. =) |
| 07:36.44 | hamZta | Cool :) |
| 07:36.49 | hamZta | sorry, afk! |
| 07:36.57 | judas_iscariote | ;) |
| 07:38.33 | hamZta | re |
| 07:41.02 | hamZta | judas_iscariote: How soon? |
| 07:41.20 | judas_iscariote | hamZta: inminent |
| 07:41.33 | judas_iscariote | this week most likely |
| 07:41.51 | hamZta | Super :) |
| 08:16.29 | *** join/#flyspray ivar (n=Miranda@195.149.154.2) |
| 09:16.07 | *** join/#flyspray TobiasFar (n=chatzill@ACAD4809.ipt.aol.com) |
| 10:13.41 | TobiasFar | how can i test whether xmpp notification works? |
| 10:15.38 | hamZta | Setup the notification and close a task |
| 10:16.07 | hamZta | Should work, AFAIK |
| 10:20.47 | hamZta | TobiasFar: Does it work? |
| 10:21.11 | TobiasFar | one moment |
| 10:21.14 | TobiasFar | i'll test it |
| 10:21.20 | hamZta | Okay |
| 10:39.06 | TobiasFar | Is the task close even notified? |
| 10:39.25 | TobiasFar | i meant closer. the one who closes the task |
| 10:41.20 | hamZta | I've never used xmpp-notification, but the closer normally gets an email |
| 10:41.38 | hamZta | judas_iscariote ? |
| 10:42.25 | TobiasFar | is there some log where problems like that would be showed? not able to send notifications |
| 10:45.40 | hamZta | I think judas_iscariote is sleeping ... Sorry, can't really help you, as I've never tried xmpp-notification |
| 10:50.59 | TobiasFar | i didn't get a message when closing the default sample task |
| 10:51.42 | hamZta | Did you activate notifications for your user? |
| 10:57.39 | TobiasFar | yeah |
| 12:39.22 | *** join/#flyspray ivar (n=Miranda@195.149.154.2) |
| 15:21.25 | *** join/#flyspray TobiasFar (n=chatzill@ACB082B7.ipt.aol.com) |
| 15:47.35 | *** join/#flyspray floele (n=Miranda@p3EE26903.dip.t-dialin.net) |
| 15:47.35 | *** mode/#flyspray [+o floele] by ChanServ |
| 16:13.12 | TobiasFar | hey floele, what could prevent flyspray of notifing me on some task changes? |
| 16:13.28 | floele | a lot could prevent that |
| 16:13.45 | floele | which version are we talking about? |
| 16:13.58 | TobiasFar | don't flyspray have a log for that kind of errors? |
| 16:14.35 | floele | it is not necessarily an error. and no, flyspray does not keep any logs |
| 16:14.40 | TobiasFar | Flyspray 0.9.9 dev |
| 16:14.49 | floele | latest? |
| 16:15.53 | TobiasFar | Revision: 973 |
| 16:16.18 | TobiasFar | checked out yesterday from http://svn.flyspray.org/flyspray/branches/0.9.9 |
| 16:16.34 | floele | email/jabber? |
| 16:16.45 | TobiasFar | jabber notifications |
| 16:16.58 | floele | which server? |
| 16:17.17 | TobiasFar | http server? |
| 16:17.23 | floele | jabber server |
| 16:17.28 | TobiasFar | myjabber.net |
| 16:17.32 | TobiasFar | running wildfire |
| 16:18.14 | TobiasFar | on that server is the account which is supposed to send the notifications |
| 16:18.48 | floele | does it require SSL? |
| 16:20.15 | TobiasFar | no...psi can login without ssl for instance |
| 16:21.31 | floele | what username did you enter in flyspray? |
| 16:22.08 | TobiasFar | issue.ayena.de |
| 16:22.46 | floele | okay...then we have to find the problem in a different way ;) |
| 16:24.34 | floele | http://flyspray.org/manual:jabber |
| 16:24.34 | floele | check the bottom |
| 16:24.34 | floele | oh btw, reminder is running? |
| 16:25.52 | TobiasFar | reminder? |
| 16:27.01 | floele | flyspray.conf.php |
| 16:27.08 | floele | check that reminder is activated |
| 16:27.41 | TobiasFar | reminder_daemon = "1" |
| 16:28.44 | floele | k |
| 16:29.06 | floele | if it's enabled, |
| 16:29.07 | floele | follow the instructions on the page ;) |
| 16:29.46 | TobiasFar | okqa |
| 16:29.48 | TobiasFar | okay |
| 16:50.30 | TobiasFar | $jabber = new Jabber('xyz@server.org', 'mypw', true); |
| 16:50.35 | TobiasFar | what does true stand for? |
| 16:50.37 | TobiasFar | ssl? |
| 16:52.05 | floele | yep |
| 16:52.19 | floele | but it will not be used if it can't be used |
| 16:52.38 | floele | would only cause problems if the server doesn't like it |
| 16:52.39 | TobiasFar | okay |
| 16:52.49 | TobiasFar | i turned it off |
| 16:52.52 | TobiasFar | to false |
| 16:53.11 | floele | got your message |
| 16:53.22 | floele | so your notifications are working |
| 16:54.26 | TobiasFar | so what switches do i have to turn on at all to get notified? |
| 16:54.57 | TobiasFar | on my own page i checked "Notify for own changes" |
| 16:54.57 | floele | notifs have to be enabled in the admin center |
| 16:55.09 | floele | they have to be enabled in your profile |
| 16:55.21 | floele | you have to be on a notification list |
| 16:55.46 | floele | and you may not be able to send messages to yourself with jabber |
| 16:57.07 | TobiasFar | why? flyspray is using issue.ayena.de@myjabber.net and my private jabber account is tobiasfar@jabber.org |
| 16:57.55 | TobiasFar | i changed procent complete of some task where i am on the notification list..still don't get anything |
| 16:58.28 | floele | did you try using the testfile to send a message to your account? |
| 16:58.39 | TobiasFar | no..but i'll try |
| 17:00.40 | TobiasFar | i get the message using the small php test |
| 17:02.17 | floele | maybe the reminder does not work. could you check the notification tables in your database? |
| 17:02.33 | TobiasFar | yeah |
| 17:02.37 | floele | if it contains the messages you expected to get, then the reminder does not work for whatever reason |
| 17:04.16 | TobiasFar | flyspray_notification_messages has six messages |
| 17:07.12 | TobiasFar | so? what could i prove next ;) |
| 17:07.39 | floele | why the reminder is not running I think ;) |
| 17:07.48 | floele | maybe try to run it manually |
| 17:08.14 | floele | you'll have to remove the checks at the beginning of the file if you run flyspray on a rmote server |
| 17:11.29 | TobiasFar | i run it on a remote server |
| 17:11.33 | TobiasFar | and what's the reminder |
| 17:11.36 | TobiasFar | a c deamon |
| 17:11.38 | TobiasFar | ? |
| 17:12.00 | floele | schedule.php |
| 17:13.43 | TobiasFar | what checks do you mean? |
| 17:14.03 | floele | change |
| 17:14.04 | floele | if((isset($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] === |
| 17:14.08 | floele | to |
| 17:14.22 | floele | if(true || |
| 17:14.22 | floele | (isset($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] === |
| 17:15.18 | TobiasFar | like that: |
| 17:15.20 | TobiasFar | if(true || (isset($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] === '127.0.0.1') && |
| 17:15.22 | TobiasFar | <PROTECTED> |
| 17:16.04 | TobiasFar | okay...i'll test it again |
| 17:16.35 | floele | no |
| 17:16.42 | floele | you have to open it in your browser |
| 17:16.57 | floele | the check does not apply when flyspray starts the reminder itself |
| 17:18.03 | TobiasFar | okay..i got all remaining messages |
| 17:18.28 | TobiasFar | does that mean i have to run schedule.php myself to get the message? |
| 17:19.53 | floele | well...flyspray should be able to do that on its own if enabled in the config file |
| 17:20.17 | floele | now that you made it run, it will keep running forever unless the server does not permit it |
| 17:20.43 | floele | but the reason for the failue would be good to know |
| 17:21.03 | TobiasFar | yeah |
| 17:21.17 | TobiasFar | so i guess this process is running the deamon now: 88863 www 1 8 0 15896K 11968K nanslp 0:05 0.00% php |
| 17:21.26 | TobiasFar | what's with maximal script runtime? |
| 17:22.40 | floele | it's not limited unless limited in the php.ini |
| 17:23.49 | TobiasFar | wouldn't a crontab fit that kind of job better? |
| 17:24.32 | floele | yes, but not everyone has crons on his server available |
| 17:24.36 | floele | so we chose this method |
| 17:24.37 | macnewbold | I think we don't want to require crontab access |
| 17:25.36 | TobiasFar | why not sending if someone changes a tasK? :) |
| 17:26.53 | floele | maybe the scheduler can't be opened |
| 17:26.59 | floele | could have multiple reasons |
| 17:27.14 | floele | and btw, only sent every ten minutes |
| 17:32.57 | TobiasFar | the schedule script blocks my web server for my flyspray domain |
| 17:33.02 | TobiasFar | :( |
| 17:33.21 | floele | ? |
| 17:33.33 | TobiasFar | issue.ayena.de doesn't respond anymore |
| 17:33.35 | TobiasFar | ayena.de does |
| 17:33.38 | TobiasFar | :) |
| 17:33.58 | floele | maybe you need more processes or whatever |
| 17:34.08 | floele | I'm not the server config expert ;) |
| 17:34.22 | TobiasFar | i have 10 fastcgi processes |
| 17:34.28 | TobiasFar | that should be enough for now |
| 17:34.31 | TobiasFar | using lighty |
| 17:36.31 | floele | in any case it doesn't need a lot of cpu |
| 17:37.02 | TobiasFar | i don't care |
| 17:37.12 | TobiasFar | i can't kill the one php process anymore |
| 17:38.54 | TobiasFar | 88863 www 1 8 0 15896K 11992K nanslp 0:10 1.27% php <--- it remains that state |
| 17:40.50 | TobiasFar | now i killed it |
| 17:41.07 | TobiasFar | is there an alterantive way of sending those notifications? |
| 17:41.20 | floele | nope |
| 17:41.33 | floele | but you can make a non-loop scheduler |
| 17:41.40 | floele | do ... |
| 17:41.41 | floele | while(true) |
| 17:41.49 | floele | change true to false |
| 17:41.51 | TobiasFar | and run that via cron? |
| 17:41.54 | floele | then it will only run once |
| 17:41.55 | floele | yes |
| 17:41.58 | TobiasFar | okay |
| 17:42.19 | floele | brb |
| 17:42.58 | macnewbold | actually, while (false) { something(); } won't run something(); at all - it will never enter the loop |
| 17:43.20 | macnewbold | just leave it while true and add "break;" before the closing } |
| 17:44.44 | TobiasFar | macnewbold: it's a do while loop in schedule.php |
| 17:45.23 | TobiasFar | so it'll run at least one time |
| 17:45.29 | macnewbold | ah, okay |
| 17:52.10 | *** join/#flyspray netWolf_ (i=netWolf@ppp85-141-169-219.pppoe.mtu-net.ru) |
| 17:52.15 | netWolf_ | hola :) |
| 17:52.46 | netWolf_ | what's new? |
| 18:03.17 | floele | hi |
| 18:10.54 | netWolf_ | floele: any fascinating news? :) |
| 18:13.09 | TobiasFar | yeah...don't try to run reminder deamon when using lighty :) |
| 18:13.40 | *** join/#flyspray mwalling_ (n=mwalling@72.171.106.148) |
| 18:13.47 | floele | netWolf_: we might release the RC this week |
| 18:13.49 | floele | :) |
| 18:14.05 | netWolf_ | floele: excellent :) |
| 18:36.36 | judas_iscariote | TobiasFar: huh ? |
| 18:36.46 | TobiasFar | judas_iscariote: ? |
| 18:36.56 | judas_iscariote | TobiasFar: the reminder deamon creates more fastcgi process ?? |
| 18:37.13 | TobiasFar | no it blocks one |
| 18:37.41 | TobiasFar | and i dunno why lighty doesn't switch to another for that domain |
| 18:37.46 | TobiasFar | now i'll use cron |
| 18:37.55 | TobiasFar | a cleaner way |
| 18:37.56 | judas_iscariote | TobiasFar:what PHP version are you using ?? it is expected that it will use a process indefinately... |
| 18:38.18 | judas_iscariote | but should not block child process... |
| 18:38.20 | TobiasFar | in my opinion your php deamon is ugly ;) |
| 18:38.35 | judas_iscariote | TobiasFar: yes it is. I have never told you it is nice. |
| 18:38.58 | TobiasFar | PHP 5.1.6 (cgi-fcgi) |
| 18:39.35 | judas_iscariote | and if it does block child process then it is a bug in PHP.. |
| 18:47.27 | netWolf_ | floele: ergonomic suggestion: if it's not very hard then it would be better to set only one of "expand" "collapse" visible. With Collapse all, Expand all the current approach is almost ok |
| 18:48.34 | floele | I thought about that, but then it wouldn't be usable without JS (additional to more complex code) so I didn't implement it this way |
| 18:49.39 | netWolf_ | floele: confusing ;) Switching collapsed/expanded is more "common" |
| 18:50.07 | netWolf_ | floele: but it's all just my MHO :) |
| 18:50.18 | floele | patches welcome :-p |
| 18:50.31 | floele | no, i don't consider it too important |
| 18:50.56 | netWolf_ | floele: I'm not a php writer I'm an art critic (tonight) :) |
| 18:53.21 | floele | I'll think about it. now that I do, I probably did not realise that the showing/hiding stuff wouldn't work without JS anyway |
| 18:53.31 | floele | so I might do it for the links as well |
| 19:22.02 | netWolf_ | judas_iscariote: embromista :) |
| 19:22.21 | netWolf_ | judas_iscariote: I'm about langedit block :) |
| 19:22.34 | floele | :-p |
| 19:22.46 | floele | you will get it with RC1 ;) |
| 19:23.52 | netWolf_ | I'll modify ru.php tonight. Where to send the patch? |
| 19:25.10 | floele | ML, as always |
| 19:25.19 | netWolf_ | ok |
| 19:49.51 | judas_iscariote | ;P |
| 19:51.39 | judas_iscariote | " |
| 19:51.40 | judas_iscariote | Using a temporary MySQL server I've done some basic XSS, SQL Injection |
| 19:51.40 | judas_iscariote | and printf exploit tests, and none succeded :) |
| 19:51.42 | judas_iscariote | " |
| 19:51.54 | judas_iscariote | --> I know .. w00t :) |
| 20:05.34 | floele | nice ;) |
| 20:18.52 | judas_iscariote | floele: if there is any hole, We probably already know where it is. ( yes. class.tpl.php on line 114) I still suspect that may be exploitable in some tricky (unknown) way... |
| 20:19.41 | judas_iscariote | floele: in short, I think mantaining our nown template system is pretty pointeless since there are a lot of good,documented tempaltes systems out there. |
| 20:20.18 | floele | which one did you prefer? |
| 20:20.33 | floele | wasn't it a class used in php5 preferably? |
| 20:21.54 | judas_iscariote | floele: the most easier to adapt to flyspray seems to be savant2 , looks like the actual template system was inspired on it, shares very similar functionality, method numbers,.. except Savant 2 does not use eval() and has a tiny PHP parser and a plugin system to add the "templatefunctions" we use there. |
| 20:22.40 | judas_iscariote | argh.. I mean methods names.. *g* |
| 20:22.44 | *** join/#flyspray piz (i=paul@m21s26.vlinux.de) |
| 20:24.26 | judas_iscariote | floele: but to your question, I think PHPTAL is the best one I found doing reserach a while ago. |
| 20:25.06 | judas_iscariote | floele: in order to remove the evil in class.tpl we have two choices, 1 . find a regexp guru that can change the compile mehtod in such a way that.. |
| 20:25.08 | judas_iscariote | f.e |
| 20:26.01 | judas_iscariote | preg_replace( '/{!([^\s&][^{}]*)}(\n?)/', '<?php echo \1; ?>\2\2', $item); --> used for functions. be modified in such a way, that the regular expression returns 1. the function name 2. a variable-length array wih the function arguments... |
| 20:27.07 | judas_iscariote | and that regexp used in preg_replace_callback..where the callback returns call_user_func_array($matches[1], $matches['2]); |
| 20:28.31 | judas_iscariote | there matches[1] is the function name.. and matches[2] is an array with all function paramenters.. |
| 20:29.09 | floele | hm...could be possible, but then we should get a list of all string which would be parsed by the regxp then. doing it for L(...) and $va |
| 20:29.10 | floele | riables shouldn't be a big problem |
| 20:29.23 | floele | the question is what else we have in our code ;) |
| 20:30.53 | floele | but how would be execute foreach/if and so on? |
| 20:31.06 | judas_iscariote | I guess the most sensical way it is to replace it completely , or change eval() for include() a temporary file in the meanwhile, at least include is faster than eval. |
| 20:31.14 | judas_iscariote | floele: Savant handles that. |
| 20:31.44 | judas_iscariote | {foreach...} |
| 20:32.11 | judas_iscariote | it has a basic tiny parser that do that =) |
| 20:32.41 | floele | when looking at the "Quick Example" I don't like that they use <?php echo $var ?> |
| 20:32.46 | floele | it'd like {$var} ;) |
| 20:33.07 | judas_iscariote | you can use whatever you want. is configurable. |
| 20:33.22 | floele | I see |
| 20:35.26 | floele | we can certainly consider it for 1.0, but let's do the important stuff first ;) |
| 20:36.17 | judas_iscariote | floele: the issue is thatwill quire vast changes in the templates.. so might be worth looking first.. before actually writting more features or code. |
| 20:37.42 | judas_iscariote | blogbal variables are treated differently, there is no access to supergloabls.. fe.. it is a sandabox that allows only safe code to be executed inside... |
| 20:38.10 | floele | sounds good ;) |
| 20:39.38 | floele | well, why don't you look into it and see if we can easily switch to savant? |
| 20:39.59 | floele | we could also wait a while longer until we switch and then use phptal |
| 20:40.04 | floele | once we are php5 only |
| 20:40.09 | judas_iscariote | ok. i'll try something in my local trunk copy... |
| 20:41.02 | judas_iscariote | that sia nother possibility.. yes..;-p |
| 20:42.19 | floele | I don't like looking a lot into that stuff because we get very few in return if we switch. we *might* have a little more secure template class, but that's probably all we get for quite a lof of work |
| 20:42.51 | floele | especially when we might consider switching again on php5 ;) |
| 20:43.16 | judas_iscariote | ao I'll spend some time trying to maliciusoly subvert the current code to have a reason to :-P |
| 20:43.38 | floele | .-P |
| 20:56.09 | *** join/#flyspray netWolf_ (n=volkoff@ppp85-140-231-122.pppoe.mtu-net.ru) |
| 20:59.54 | judas_iscariote | netWolf_: translation patch added. ;P |
| 21:02.05 | judas_iscariote | done :-D |
| 21:02.13 | netWolf_ | thanks, man :) |
| 21:05.04 | floele | judas_iscariote: any findings for postgre yet? |
| 21:05.53 | judas_iscariote | floele: yes, but have not solved a problem I found.. seems I cant add a comment on a task@_@ |
| 21:06.17 | floele | in our bts? |
| 21:06.53 | judas_iscariote | floele: in my own local copy....with postgresql |
| 21:06.57 | netWolf_ | ahem... |
| 21:07.04 | judas_iscariote | can't reproduce it now... |
| 21:08.08 | judas_iscariote | hrmmm.. was somthing like "violation of unique constrain in... |
| 21:08.19 | judas_iscariote | but can reproduce it now. :( |
| 21:08.30 | netWolf_ | floele: still the problem with {prefs} |
| 21:08.32 | netWolf_ | Query {UPDATE "flyspray_prefs" SET pref_value = ? WHERE pref_name = ?} with params {,notify_registration} Failed! (ERROR: null value in column "pref_value" violates not-null constraint) |
| 21:08.47 | netWolf_ | should put something or DEFAULT |
| 21:08.49 | floele | not a big problem |
| 21:09.02 | netWolf_ | Admin toolbox, saving prefs |
| 21:09.27 | floele | netWolf_: already fixed in devel |
| 21:09.33 | floele | maybe try the upgrader |
| 21:09.37 | floele | then it should work |
| 21:09.39 | netWolf_ | just updated |
| 21:09.47 | netWolf_ | r978 |
| 21:10.22 | floele | so it does not after running the upgrader? |
| 21:10.34 | netWolf_ | upgrader has nothing to do with it ;) |
| 21:10.38 | floele | it has |
| 21:10.42 | netWolf_ | floele: the problem is in the query :) |
| 21:10.57 | netWolf_ | it tries to pass NULL in this field |
| 21:11.12 | floele | shouldn't postgre use the default value then? |
| 21:11.50 | netWolf_ | floele: judas_iscariote: SQL is pretty portable, just don't use weird constructions and don't use assumptions :) |
| 21:13.01 | judas_iscariote | netWolf_: sqlite wont like our queries either. |
| 21:13.45 | netWolf_ | judas_iscariote: look previous post ;))) I use MS SQL, SQLite and MSAccess :) |
| 21:14.06 | judas_iscariote | :P |
| 21:14.11 | netWolf_ | There are many differences, but it's pretty easy to avoid them :) |
| 21:14.56 | judas_iscariote | netWolf_: I would love to see sqlite issues fixesd, in tht case we can offer a self-contained bts with no database server dependency to users.. |
| 21:15.00 | netWolf_ | and MySQL is a very... eh... SQL-error-friendly :) It can made assumptions about what user wants:) Most of the other DBMS - not ;) |
| 21:15.30 | netWolf_ | (and it's good :)) |
| 21:16.04 | netWolf_ | judas_iscariote: I think I'll look into it in a couple of weeks. It's for 1.0 anyway |
| 21:16.14 | judas_iscariote | yup,. |
| 21:16.28 | netWolf_ | I can check queries for sqlite and mssql |
| 21:17.08 | floele | <PROTECTED> |
| 21:17.08 | floele | don't you want to become our database engineer? |
| 21:17.16 | judas_iscariote | netWolf_: conflicting stuff is in class.backend.php method get_task_list() |
| 21:17.59 | netWolf_ | judas_iscariote: I already took a glance at the class :) Just look :) |
| 21:18.09 | judas_iscariote | accroidng to as quick investigation .sqlite doe snot support SELECT COUNT(DISTINCT... |
| 21:18.10 | netWolf_ | floele: it would be an honour ;) |
| 21:18.38 | netWolf_ | judas_iscariote: it can support something pretty close ;) |
| 21:18.44 | judas_iscariote | it also does not support ALTER TABLE **g** |
| 21:18.57 | netWolf_ | judas_iscariote: what means **g**? |
| 21:19.21 | judas_iscariote | it is a expression like **argh** |
| 21:19.22 | judas_iscariote | xD |
| 21:19.33 | netWolf_ | ah :) you are mistaken |
| 21:19.48 | netWolf_ | http://sqlite.org/lang_altertable.html |
| 21:20.09 | netWolf_ | Not full support, but... |
| 21:20.17 | netWolf_ | it's a *lite ;) |
| 21:20.20 | floele | we don't need it anyway |
| 21:20.29 | floele | our code shouldn't use ALTER anywhere |
| 21:20.53 | floele | and **g** is a positive expression :-p |
| 21:20.55 | judas_iscariote | floele: exactly, now the xmlschema takes care of the differences I guess.. |
| 21:21.10 | floele | meaning g = grins (smile) |
| 21:21.13 | judas_iscariote | floele: ohh..yeah. |
| 21:21.51 | floele | netWolf_: I'd really appreciate if you'd help on a regular basis, so if you like you can officially join our team :) |
| 21:22.09 | floele | I guess judas_iscariote doesn't mind, right? ;) |
| 21:22.25 | judas_iscariote | we need a database geek, I have very lilte clue about that. |
| 21:22.28 | netWolf_ | judas_iscariote: anyway xml-schema can took care in some eh... walkaround way, as for autoincrementing |
| 21:23.05 | judas_iscariote | netWolf_: we can fix ( or better extend) the xml schema stuff if there is soemthing wrong.. |
| 21:23.09 | netWolf_ | what should I do to offically join? Take an oath? Blood-involved? :) |
| 21:23.28 | floele | netWolf_: a difficult question in fact ;) |
| 21:24.21 | netWolf_ | judas_iscariote: of course, but it would be better to left adodb development to adodb developers :) |
| 21:24.51 | judas_iscariote | netWolf_: adodb single developer you mean. |
| 21:25.04 | judas_iscariote | 1 person software. |
| 21:25.04 | netWolf_ | judas_iscariote: could be :) |
| 21:25.44 | judas_iscariote | netWolf_: well, if the problem found is clearly a bug, we send a patch if we need new features, then we extend it. |
| 21:25.55 | netWolf_ | judas_iscariote: ok |
| 21:26.30 | floele | well, to join you should be on the 'team' page, subscribed to the ML, have an account on the BTS, an email address @flyspray.org, ...hm |
| 21:26.42 | judas_iscariote | or better we move to creole/propel ;-P |
| 21:26.57 | *** join/#flyspray morhekil (n=morhekil@62.12.64.29) |
| 21:27.00 | floele | oh, and contribute regulary or otherwise tell us if you are not working on FS atm |
| 21:27.30 | netWolf_ | 2nd and 3rd is done ;) |
| 21:28.09 | macnewbold | I can help with database stuff from time to time, but I don't know much pgsql, though I have a coworker that does |
| 21:28.17 | netWolf_ | if contribute regulary means "regulary help flyspray to grow" it's ok :) |
| 21:28.20 | *** mode/#flyspray [+v netWolf_] by macnewbold |
| 21:28.39 | floele | what's voice status? |
| 21:28.57 | netWolf_ | floele: what is the voice status? |
| 21:29.31 | floele | I don't know |
| 21:29.39 | netWolf_ | so am I :) |
| 21:30.05 | netWolf_ | [00:29] *** macnewbold gives you the permission to talk. |
| 21:30.14 | netWolf_ | I don't knpw what this means |
| 21:30.31 | floele | I've no idea either |
| 21:30.33 | macnewbold | it's called "voice" in IRC |
| 21:30.46 | judas_iscariote | it works on moderated channels... |
| 21:30.48 | macnewbold | if the channel were moderated, you can't speak unless you have that permission |
| 21:30.59 | macnewbold | in ours, it mostly means you're cooler than normal people |
| 21:31.06 | netWolf_ | :)))) |
| 21:31.16 | macnewbold | and you generally get a cool icon next to your name in the nick list |
| 21:31.31 | macnewbold | official flyspray team members get /op usually to |
| 21:31.32 | macnewbold | too |
| 21:31.35 | *** mode/#flyspray [-o judas_iscariote] by judas_iscariote |
| 21:31.43 | *** mode/#flyspray [+o judas_iscariote] by macnewbold |
| 21:31.50 | judas_iscariote | :) |
| 21:32.01 | macnewbold | once you take off your op, you can't put it back on usually |
| 21:32.07 | macnewbold | but chanserv can help with that |
| 21:32.14 | judas_iscariote | macnewbold: I can.. |
| 21:32.19 | *** mode/#flyspray [-o judas_iscariote] by macnewbold |
| 21:32.21 | macnewbold | let's see |
| 21:32.47 | floele | judas_iscariote: can you create an email address? |
| 21:32.53 | judas_iscariote | floele: ok |
| 21:33.03 | judas_iscariote | netWolf_: what login/nick you want ? |
| 21:33.31 | floele | oh, and you might also need SVN access if you intend to supply patches |
| 21:33.52 | judas_iscariote | floele: yup, need to write Jon |
| 21:34.21 | netWolf_ | judas_iscariote: netwolf is all right to keep it all consistent :) |
| 21:34.46 | judas_iscariote | ( Im unable to spell his second name :P so. it s just Jon ) |
| 21:35.04 | floele | judas_iscariote: your second name isn't any better |
| 21:35.36 | judas_iscariote | :) |
| 21:36.21 | floele | I've no problems with it actually |
| 21:37.14 | judas_iscariote | netWolf_: what is your second name ?? |
| 21:38.12 | netWolf_ | Aleksandrovich (father's name Alexander) |
| 21:38.58 | floele | erm...now I am confused |
| 21:39.16 | judas_iscariote | netWolf_: is mindrats@list.ru the correct email to sent user credentials ? |
| 21:39.26 | netWolf_ | judas_iscariote: yes |
| 21:39.51 | judas_iscariote | netWolf_: check your mail ;-P |
| 21:41.44 | netWolf_ | judas_iscariote: got it. Flyspray.org has usual SMTP/POP3 daemons? |
| 21:41.58 | judas_iscariote | gmail interface and POP3. |
| 21:42.58 | judas_iscariote | unfortuantely google does not provide a proper email protocol like IMAP, that is why I use the web interface only. POp3 sucks ass. |
| 21:43.03 | netWolf_ | ok, I'll check what's gmail |
| 21:43.18 | judas_iscariote | http://webmail.flyspray.org/ |
| 21:44.58 | netWolf_ | already there |
| 21:45.28 | netWolf_ | personally don't like that sort of web solutions :) My mail is my mail :) |
| 21:47.15 | macnewbold | netWolf_: where are you located? |
| 21:47.22 | netWolf_ | Moscow, Russia |
| 21:47.25 | macnewbold | very nice |
| 21:47.43 | macnewbold | my wife really enjoyed it there when she visited. we hope to go back there someday (me for the first time) |
| 21:47.53 | macnewbold | she studied Russian for several years |
| 21:47.54 | judas_iscariote | netWolf_: I like it very much, I dont have to mantain a mailserver.. and that is the first and most important advantage. |
| 21:48.22 | netWolf_ | macnewbold: wow :) |
| 21:49.00 | macnewbold | she's taught me to say a few things, but I can't spell well |
| 21:49.06 | netWolf_ | judas_iscariote: I mean, I prefer offline clients :) |
| 21:49.08 | macnewbold | ochin harrosho, etc |
| 21:49.15 | netWolf_ | macnewbold: it's ok :) |
| 21:49.18 | macnewbold | I do much better in spanish though |
| 21:49.27 | floele | netWolf_: you can use gmail offline to |
| 21:49.29 | floele | o |
| 21:49.49 | netWolf_ | macnewbold: I started to learn it too (pretty bad at it though yet) |
| 21:49.53 | netWolf_ | floele: and how> |
| 21:50.04 | judas_iscariote | netWolf_: off line mail is the worst invention ever made, your mail is generally at the mercy of your computer. |
| 21:50.07 | floele | I'll be off now...don't forget to add yourself to the team page ;) |
| 21:50.19 | floele | http://mail.google.com/support/bin/topic.py?topic=1555 |
| 21:50.38 | netWolf_ | judas_iscariote: I trust it ;) Besides I do backups :) |
| 21:50.48 | netWolf_ | floele: ok, I'll try :) |
| 21:51.12 | floele | cya |
| 21:52.00 | judas_iscariote | floele: cya |
| 21:52.05 | judas_iscariote | netWolf_: https://www.google.com/support/a/bin/answer.py?answer=33384&topic=9205 |
| 21:52.23 | judas_iscariote | netWolf_: that is the correct instruction for gmail hosted pop3 access.. |
| 21:54.03 | judas_iscariote | netWolf_: web-based services has many advantages.. 1. I dont have to mantain a mailserver 2 .I dont have to mantain a mailserver :) 3. I dont have to mantain a mailserver with anti-spam control :-P 4. it is free |
| 21:54.06 | netWolf_ | judas_iscariote: ok, seems it has smtp too |
| 21:54.48 | judas_iscariote | I know how to mantain them, that is the reason why I dont want to ;-P |
| 21:54.49 | netWolf_ | judas_iscariote: ah.... you forget some liitle aspect :) It can be inaccessible or dead at all |
| 21:55.02 | *** join/#flyspray TobiasFar (n=chatzill@ACB082B7.ipt.aol.com) |
| 21:55.36 | judas_iscariote | netWolf_: yes, and you probably want to send mail via it's smpt server , otherwise some servers can mark your email as bogus. |
| 21:56.44 | netWolf_ | judas_iscariote: mine isn't :) |
| 21:57.27 | netWolf_ | well, ok. I'm on the team :) Welcome me. Hope I can do something useful |
| 21:57.31 | morhekil | Hello everyone. Playing with flyspray checked from svn yesterday found a bug in admin prefs - they can't be saved into Postgres when any of the checkboxes is unchecked. Problem is in the file includes/modify.inc.php, on line 491 first element of the array should be checked for emptiness |
| 21:57.38 | judas_iscariote | flyspray.org uses SPF records. mails coming from there, or from ou webserver is considered "valid" , mails from other servers will fail the SPF check amd may be either marked as spam or as bugus. |
| 21:58.14 | netWolf_ | morhekil: thanks, we found it already, didn't fixed yet |
| 21:58.38 | TobiasFar | why aren't xmpp notifications send directly after changing something of a task? |
| 21:58.40 | netWolf_ | judas_iscariote: ok |
| 22:01.34 | morhekil | netWolf_: ok, great. Did anyone have any problems with e-mail notifications? I'm starting to think that I'm dumb but I can't get them to work properly though in 0.9.8 there were no problems. I'm trying to get a notification on a new task to category owner, but flyspray sends only a email to task opener. Any ideas on what I've missed? |
| 22:02.20 | judas_iscariote | TobiasFar: reminder daemon task. |
| 22:02.43 | TobiasFar | that doesn't answer my question |
| 22:02.51 | netWolf_ | morhekil: correction: already fixed in rev 980 |
| 22:02.56 | judas_iscariote | TobiasFar: Im talking about the jabber notifications) |
| 22:03.06 | TobiasFar | i too.. |
| 22:03.33 | TobiasFar | i'm wondering why flyspray writes them into database and doesn't just send them away |
| 22:04.04 | netWolf_ | morhekil: I'm a new one here, so I'm not so competent as judas_iscariote or floele |
| 22:04.27 | judas_iscariote | morhekil: hrmmm |
| 22:04.37 | netWolf_ | TobiasFar: to speed up the work process |
| 22:04.55 | TobiasFar | i don't think that speeds up anything |
| 22:04.56 | netWolf_ | TobiasFar: it sends them in the background (afaik) |
| 22:04.56 | morhekil | judas_iscariote: sounds bad ;) |
| 22:05.33 | judas_iscariote | Auto-assign a task to the category owner does not help ? |
| 22:05.46 | morhekil | judas_iscariote: no |
| 22:06.24 | judas_iscariote | hrmmm... is category owner email correct ? ;-P |
| 22:06.56 | morhekil | judas_iscariote: huh, auto-assign, wait a bit, I'll test it. Email is correct, yes. |
| 22:08.46 | judas_iscariote | morhekil: and you can't make comparision with 0.9.8 Im sorry,, there is mostly nothing in common, 90% of the 0.9.8 code is gone. ;-P |
| 22:09.23 | judas_iscariote | :P |
| 22:10.03 | morhekil | judas_iscariote: ok, will never do it again ;) |
| 22:10.27 | morhekil | judas_iscariote: no, auto-assign didn't help. Actually there're some strange zero-sized emails from flyspray on my mail server |
| 22:11.34 | morhekil | judas_iscariote: after opening a task (anonymously), I can see three messages generated by flyspray in the mailserver - two of them are empty and the last one is the opener's own email |
| 22:11.45 | judas_iscariote | morhekil: zero sized ?? not even headers ?? |
| 22:11.47 | judas_iscariote | oO |
| 22:12.13 | judas_iscariote | oO weird. |
| 22:12.22 | morhekil | judas_iscariote: not sure about the headers - I can see only smtp log. Just a minute, I'll put them somewhere. |
| 22:13.34 | morhekil | judas_iscariote: http://pastebin.com/866560 |
| 22:17.16 | judas_iscariote | morhekil: let see |
| 22:17.31 | judas_iscariote | morhekil: can u use other paste |
| 22:17.36 | judas_iscariote | ~pastebin |
| 22:17.38 | jbot | hmm... pastebin is a place to paste your stuff without flooding the channel - try http://pastebin.ca, or http://channels.debian.net/paste, or http://rafb.net/paste/ |
| 22:17.47 | morhekil | judas_iscariote: sure, one sec |
| 22:18.28 | judas_iscariote | cmd: Message submitted [0] Failed No valid recipients |
| 22:18.42 | judas_iscariote | : SurgeSMTP 3.7b6-6 wth is that :P |
| 22:19.01 | morhekil | judas_iscariote: Netwin's Surgemail server |
| 22:19.05 | morhekil | judas_iscariote: http://pastebin.ca/327372 |
| 22:19.29 | morhekil | judas_iscariote: I think it has no recipients because of scmd: Data received 0 bytes 0k/sec Failed |
| 22:19.54 | judas_iscariote | ok.. you are using smtp mode i guess... |
| 22:19.59 | judas_iscariote | not local mail() .. |
| 22:20.50 | morhekil | judas_iscariote: do you mean in PHP or somewhere in flyspray? |
| 22:21.15 | judas_iscariote | morhekil: I mean. if you are using smtp mail deliver in the flyspray configuration ... |
| 22:21.35 | morhekil | judas_iscariote: yes, I've filled in smtp server details |
| 22:21.58 | morhekil | judas_iscariote: I can try to remove them if you want, mail() should also work here |
| 22:22.14 | judas_iscariote | morhekil: as a test only..yes. plz |
| 22:22.22 | morhekil | judas_iscariote: sure |
| 22:22.41 | judas_iscariote | morhekil: you really wnat to use smtp since it is more effecient with large amount of notifications. |
| 22:23.03 | judas_iscariote | mail() opens a new socket for every single mail() call. |
| 22:23.30 | morhekil | judas_iscariote: it's our internal bugtracker, so I don't care - I don't expect amount to be large enough to matter |
| 22:28.18 | morhekil | judas_iscariote: ok, did the upgrade to #980, cleared smtp settings and tried to open a task anonymously - still the same thing. Only one mail to the opener. |
| 22:29.11 | judas_iscariote | to the opener ?? |
| 22:29.15 | judas_iscariote | oO |
| 22:29.20 | morhekil | judas_iscariote: yes |
| 22:29.36 | morhekil | judas_iscariote: btw, in project prefs -> notification -> type everything is checked except "None" |
| 22:29.48 | morhekil | * checked = selected |
| 22:31.32 | judas_iscariote | morhekil: ok. I'll try to reproduce your problem later...ok.. you were using php 5.1.6 in fascgi-mode .-..and postgresql ? |
| 22:32.11 | judas_iscariote | morhekil: flyspray will never send an empty email.. never ever .. |
| 22:32.50 | morhekil | judas_iscariote: PHP5.0.4 as apache's module. And yes, Postgresql 8.0.3 |
| 22:33.32 | morhekil | judas_iscariote: I can't see empty emails now in the mail() mode. Maybe they just doesn't get through |
| 22:33.35 | judas_iscariote | morhekil: oO 5.0.4, should work, but I wont be suprised if ther eis a bug in your PHP |
| 22:33.53 | judas_iscariote | PHP 5.0.4 is not really for production. |
| 22:34.06 | morhekil | judas_iscariote: hm, bug that prevents only specific emails? %-\ |
| 22:34.21 | judas_iscariote | morhekil: Im not telling you it is a php bug. |
| 22:34.42 | judas_iscariote | morhekil: tell me..just curious it is 64 or 32 bit system ?? |
| 22:34.57 | morhekil | judas_iscariote: 32bit |
| 22:35.02 | judas_iscariote | ok. |
| 22:35.23 | morhekil | judas_iscariote: I'll try to reproduce it on my local workstation now to see how it works here |
| 22:36.07 | judas_iscariote | ok. |
| 22:57.46 | morhekil | judas_iscariote: got the same thing on my local box - Gentoo 32bit, php-5.1.6, postgresql 8.0.9 |
| 22:58.44 | *** join/#flyspray k-man__ (n=jason@ppp244-232.static.internode.on.net) |
| 22:58.47 | k-man__ | hello |
| 23:00.03 | k-man__ | is the upgrader safe to use? |
| 23:00.07 | k-man__ | or should i wait a bit longer? |
| 23:00.23 | judas_iscariote | k-man__: yes it is safe, to use, just backup your database as always. |
| 23:00.30 | judas_iscariote | in case something goes wrong |
| 23:00.31 | k-man__ | ok |
| 23:01.08 | k-man__ | i'll give it a go later |
| 23:01.08 | k-man__ | thanks |
| 23:01.30 | *** mode/#flyspray [+o judas_iscariote] by macnewbold |
| 23:14.51 | morhekil | Damn, even simple edit notifications doesn't work %-\ |
| 23:16.07 | morhekil | it tries to send something and I can see it in smtp log when smtp server is configured, but there're no recipients and the e-mail is empty |
| 23:22.40 | judas_iscariote | oO |
| 23:22.54 | judas_iscariote | morhekil: ther eis soemthing wrong there.. works fine here :S |
| 23:23.47 | morhekil | judas_iscariote: I'm trying to track down the bug. Found the empty recipients string in swift's mailer on line 349 where it tries to send an email, $this->to is empty |
| 23:25.31 | judas_iscariote | morhekil: you are looking the wrong place :P swiftmailer works,... |
| 23:25.46 | judas_iscariote | and unless there is a wrong query to bring uop the recipients... |
| 23:25.53 | judas_iscariote | ahhh.. |
| 23:25.56 | judas_iscariote | thats is OK.. |
| 23:25.57 | morhekil | judas_iscariote: I suppose so, just dumping all variables to see what's wrong |
| 23:26.03 | judas_iscariote | there is NO to. but only |
| 23:26.05 | judas_iscariote | BCC |
| 23:26.20 | judas_iscariote | all other smtp servers as well php mail works without to. |
| 23:26.42 | morhekil | yes, I have an array of recipients so there should be only bccs. Let's try to remove one. |
| 23:29.29 | morhekil | yeah, got it. Your comment there is wrong, and mailer's docs are right - you HAVE to specify TO address |
| 23:30.08 | morhekil | just added $mail->AddAddress after the bccs code and now it works |
| 23:35.27 | morhekil | judas_iscariote: why not just put the some dummy email address like flyspray@example.com? Or let users configure it |
| 23:36.02 | judas_iscariote | morhekil: that is the problem, unwanted mail traffic.. |
| 23:36.34 | judas_iscariote | morhekil: why the hell your server requires that ? I tried sendmail, postfix, qmail and all works. |
| 23:36.55 | judas_iscariote | even php mail() works. |
| 23:37.11 | judas_iscariote | ohh.. and exim too |
| 23:37.14 | judas_iscariote | :P |
| 23:37.30 | morhekil | judas_iscariote: I've no idea but it requires. Have you checked the RFC, what's said there? |
| 23:37.39 | judas_iscariote | our own server runnbed exim until I replaced it for postfix. |
| 23:38.22 | judas_iscariote | let see.. hav eto check what is the current RFC... |
| 23:38.29 | morhekil | but, like your comment says - "Unlike the docs say, it *does (appear to)* work with mail()". I think that doc's author had something in their minds writing this doc so SurgeMail maybe not the only one to require it. |
| 23:41.30 | judas_iscariote | morhekil: the comments are outdated |
| 23:41.45 | judas_iscariote | read : "The minimum required header is three fields: DATE, FROM, and either a TO field or a BCC field. " |
| 23:41.57 | judas_iscariote | code is correct. |
| 23:43.39 | morhekil | judas_iscariote: ok, it's up to you but the problems are here. I'll connect Netwin's support about that issue but it is possible that there're other servers around with the same "feature". |
| 23:45.11 | morhekil | lol. Did you check this code with MS Exchange? |
| 23:45.51 | judas_iscariote | morhekil: no, but other users certainly are. :P |
| 23:47.33 | judas_iscariote | morhekil: it was that way previusly, but generated complains. |
| 23:47.55 | judas_iscariote | and duplicated emails, and then we figured that we were permitted to include no TO |
| 23:49.11 | morhekil | judas_iscariote: I see. Ok, I'll patch my installation for now and send the bugreport, it seems that there's nothing more I can do about it. |
| 23:50.06 | judas_iscariote | morhekil: ok, anyway I 'll check what other smtp servers has this broken behaviuor, but at least the widely used ones behaves correctly (postfixc, qmail, sendmail, exim) |
| 23:50.35 | morhekil | judas_iscariote: thanks for your help and good luck |
| 23:50.52 | judas_iscariote | ;) |
| 23:55.46 | *** join/#flyspray _judas_iscariote (n=cristian@200.7.26.220) |
| 23:55.46 | *** mode/#flyspray [+o _judas_iscariote] by ChanServ |