[00:19] arildb In Tiki, is it possible to close a whole tracker, so that it doesn't accept any more entries?
[00:21] fabricius you could change its category
[00:21] fabricius (category permissions)
[00:22] arildb fabricius: yes, that's an idea. Thanks
[00:47]  arildb_ joined #tikiwiki
[01:01] refizul bad news about webserver detection: probably it is not possible to detect any detail of the environment in any situation completely
[02:44]  goj joined #tikiwiki
[04:00] Tiki-KGB tikiwiki 03fmg-sf r43716 10branches/10.x/ 10permissioncheck/create_new_htaccess.php 10prepare_permissioncheck.sh 03permissioncheck/list-of-files.txt
[04:00] Tiki-KGB tikiwiki [ENH] prepare convenient configuration for additional test cases - not active yet
[04:50] Tiki-KGB tikiwiki 03fmg-sf r43717 10branches/10.x/ 10(6 files in 2 dirs)
[04:50] Tiki-KGB tikiwiki [ENH] prepare environment for automatic PHP testing
[05:09]  goj joined #tikiwiki
[08:42] Tiki-KGB tikiwiki 03eromneg r43718 10branches/9.x/templates/tiki-plugins.tpl
[08:42] Tiki-KGB tikiwiki [FIX] [bp43708] jonny's fix to move close cell and row inside foreach loop
[09:00]  changi joined #tikiwiki
[09:31]  redflo joined #tikiwiki
[09:58]  himanshu joined #tikiwiki
[09:58] Tiki|bot Recent Bug: Tracker item: #4323 - - Report doesn't show open items in trackers while PluginTrackerList does  - http://dev.tiki.org/item4323
[10:01] himanshu plz help me how to make watched item field in tikiwiki profile page
[10:14] himanshu plz help me how to make dynamic template in tikiwiki
[10:18] Tiki|bot Recent Bug: Tracker item: #4324 - - Report shows html code in spreadsheet cells  - http://dev.tiki.org/item4324
[10:40]  arildb joined #tikiwiki
[11:18]  ravi_ joined #tikiwiki
[11:27]  vmachine1 joined #tikiwiki
[11:38] Tiki|bot Recent Bug: Tracker item: #4325 - - Report doesn't filter by date  - http://dev.tiki.org/item4325
[11:39]  rodrigoprimo joined #tikiwiki
[11:43]  ricks99 joined #tikiwiki
[12:04]  changi joined #tikiwiki
[12:11]  vmachine1 left #tikiwiki
[12:39]  ravi_ joined #tikiwiki
[12:41] ravi_ my speradsheet is not working when click on it...........
[13:04]  j0n3 joined #tikiwiki
[13:20]  sandroandrade joined #tikiwiki
[13:30]  ravi_ joined #tikiwiki
[13:31] ravi_ when i click on speradsheet..........whole page blank.?
[13:31] ravi_ what is problem?
[13:34] ravi_ anyone have knowlege of spreadsheet?
[13:36]  rahul_ joined #tikiwiki
[13:36] arildb ravi_: sorry, I don't know spreadsheets well. I suggest you try back later, or try an email to the tiki-devel mailing list. Mention the Tiki version you are using, and how to replicate (the steps)
[13:37] ravi_ arildb:-ok thanks
[13:52] Tiki-KGB tikiwiki 03robertplummer r43719 10branches/10.x/lib/core/JisonParser/Wiki/Handler.js
[13:52] Tiki-KGB tikiwiki [FIX] Added reset & parserDepth, removed formatContent
[13:52] RobertPlummer polom
[13:53] ricks99 polom RobertPlummer
[13:55] RobertPlummer ricks99: What types of projects you up to recently?
[13:56] ricks99 trying trying trying to updated/publish my books :(
[14:00]  marclaporte joined #tikiwiki
[14:05] RobertPlummer ricks99: I look forward to it!
[14:09] ricks99 thx
[14:18]  fabricius joined #tikiwiki
[14:22]  lindonb joined #tikiwiki
[14:26]  dhazel joined #tikiwiki
[14:32] Tiki-KGB tikiwiki 03robertplummer r43720 10branches/9.x/ 10lib/codemirror_tiki/codemirror_tiki.js 10tiki-setup.php
[14:32] Tiki-KGB tikiwiki [FIX] Codemirror searchcursor is now in it's own util, needed for find and find & replace
[14:33]  ravi_ joined #tikiwiki
[14:35] ravi_ anyone have knowledge of spreadsheet?
[14:36] Tiki-KGB tikiwiki 03robertplummer r43721 10branches/10.x/ 10tiki-setup.php 10lib/codemirror_tiki/codemirror_tiki.js
[14:36] Tiki-KGB tikiwiki [fp/43720][FIX] Codemirror searchcursor is now in it's own util, needed for find and find & replace
[14:47] marclaporte ravi_:  RobertPlummer is the spreadsheet wizard!
[14:47] RobertPlummer ravi_: What do you want to do?  I've committed a fix last week for it that needs backported to 9.x
[14:47] RobertPlummer ravi_: I created the current spreadsheet.
[15:01]  Zeno joined #tikiwiki
[15:02] Zeno hi there?
[15:02]  ravi_ joined #tikiwiki
[15:04]  fabricius joined #tikiwiki
[15:05] Zeno anyone can help with an LDAP setup?
[15:07] Zeno <.<
[15:07] Zeno >.>
[15:22] Tiki-KGB tikiwiki 03robertplummer r43722 10branches/10.x/lib/core/ 04WikiPlugin/forwardlinkbutton.php 10Feed/ForwardLink.php 03WikiPlugin/textlinkbutton.php
[15:22] Tiki-KGB tikiwiki [ENH] Changed a few strings and 1 filename/class to better fit needed application
[15:30] RobertPlummer Zeno, I've work with LDAP in ^.x+
[15:30] RobertPlummer 6.x+
[15:30] Zeno hey
[15:31] Zeno I was trying in 9.2.,,, not sure it should work or not
[15:35] Zeno RoberPlummer, 9.2 is the recommended version, isn't it?
[15:40] Tiki-KGB tikiwiki 03robertplummer r43723 10branches/9.x/ 10tiki-sheets.php 10tiki-view_sheets.php 10lib/sheet/grid.php 10lib/sheet/sheetlib.php
[15:40] Tiki-KGB tikiwiki [bp/43625][FIX] parsing and other values on and off
[15:42] RobertPlummer Zeno: yes.
[15:42] RobertPlummer changi: Is a 9.3 scheduled?
[15:42] Zeno well
[15:42] Zeno I think my problem is with php-ldap module
[15:44] Zeno but not sure though, I never used php-ldap or tiki before
[15:50] Tiki|bot Recent Bug: Tracker item: #4326 - - Tracker view item history doesn't display anything after an admin edited one field of one item  - http://dev.tiki.org/item4326
[15:52] Zeno just tried the php-ldap module with a simple script... it works in anonymous mode, but not with a valid user
[16:07] RobertPlummer Zeno I found that to be the case in our situation as well.  The resolve was to use shorter categories.
[16:07] RobertPlummer Zeno: I forget what they call it in windows, maybe user descriptor?
[16:25]  marclaporte joined #tikiwiki
[16:25] arildb Zeno: LDAP works in Tiki. I haven't tried the LDAP groups, but a simple login works
[16:29] fabricius ah RobertPlummer apropos spreadsheet: any joy with the tracker as spreadsheet'?
[16:29] changi RobertPlummer: not for the moment. Why ?
[16:29] RobertPlummer fabricius: Alas, I have not had time to look into it.
[16:29] RobertPlummer changi: Check out the dev list email.
[16:29] fabricius RobertPlummer: ok
[16:30] RobertPlummer fabricius: I might have time today.
[16:30] changi RobertPlummer: 9.2.1 ?
[16:31] RobertPlummer changi: Ah, yes, possible soon?
[16:31] Zeno RobertPlummer, do you mean objectCategory of the user? If so, that's my company ldap settings, obviously I can't change those :(
[16:31] RobertPlummer Zeno: Yes, but if they are really long, you can truncate them.
[16:31] changi RobertPlummer: if the release manager is ok for that => on thursday
[16:31] Zeno arildb, I guess so
[16:32] fabricius RobertPlummer: that would be awesome ... but I would not nail you on it
[16:32] Zeno RobertPlummer, well not really... 30 or 40 chars long, not more
[16:32] RobertPlummer Jyhem_laptop: 9.2.1 out?
[16:32] RobertPlummer Zeno: Then that is probably not the issue, can you try and find the exception or the reason it isn't connecting?
[16:33] RobertPlummer Zeno: I had to go through it line by line, took some time, but the fix really helped us.
[16:34]  dennmans joined #tikiwiki
[16:34] Zeno RobertPlummer I guet two errors: a bind error (wrong credentials) and a search fail (Search failed: LDAP_OPERATIONS_ERROR )
[16:34] RobertPlummer Zeno, have you checked the credentials ;)
[16:34] RobertPlummer Zeno: I know, I know.
[16:34] RobertPlummer But you gotta ask.
[16:34] Zeno hehe
[16:35] Zeno I have checked them
[16:35] Zeno actually I can go through a php-ldap script with anonymous user
[16:36] Zeno but tiki won't work either in anonimous mode
[16:36] Jyhem_laptop RobertPlummer: what is the question ? I'm just passing in front of the laptop (need to go out)
[16:36] arildb Zeno: There is the apache directory studio (I think it's called). It's a good to to check out LDAP connectivity. Have you tried that?
[16:36] RobertPlummer Jyhem_laptop: 9.2.1 sound good?  I just backported a spreadsheet fix from 10.x
[16:37] Zeno arildb, no, I haven't. If it can help, I may take a look at it... is it a difficult thing to setup (you know, I'm a win-dummy)
[16:38] arildb he he...so, am I
[16:38] arildb works fine on windows, too
[16:38] Jyhem_laptop Hmmm, battling custom search at home (unending turning gif), and it works in demo.t.o. But I guess that is no reason to delay
[16:38] arildb Zeno: It may help you check if your PC can actually connect to the LDAP server
[16:38] Zeno oh, yes it can
[16:39] * Jyhem_laptop back in an hour
[16:39] Zeno I've tried with a custom php script directly from the server and it connects properly
[16:39] arildb ok, I still recommend trying the tool
[16:40] Zeno arildb the script works when I connect without user/pass (anonymous), but fails if I use non-admin user
[16:40] Zeno also, I'm using alterra LDAP browser, which works too
[16:40] Zeno softerra, sorry :P
[16:42] Zeno arildb, btw, just a stupid question... I don't need to use anything on "LDAP Admin" fields, do I?  I guess that's for creating stuff in the directory, which I don't want to...
[16:42] arildb Zeno: yes, I think so. It works without using the admin fields
[16:42] Zeno good
[16:47]  marclaporte joined #tikiwiki
[16:51] Zeno arildb by order, I've managed to see at tiki-logs that first of all there's a search failure, then a bind fail...
[16:52] arildb I don't know the softerra LDAP browser, but I think the apache directory studio will let you test these things.
[16:53] Zeno so 1) anonymous bind ok, 2) search 3) search error 4) bind with user 5) bind error
[17:01] Tiki|bot Recent Bug: Tracker item: #4327 - - Reports in 9x: Fatal error: Maximum execution time of 300 seconds exceeded in smarty_internal_data.php  - http://dev.tiki.org/item4327
[17:07] Zeno arildb apache studio doesn't tell me anything I didn't know :(
[17:08] arildb ok, too bad
[17:08] Zeno so I'm stuck in admin can bind, my user can't bind, anonymous bind works
[17:09] Zeno but tiki will say invalid password no matter the settings I use
[17:09] Zeno probably the problem is in the search method
[17:09] Zeno but I don't have a clue on how to fix that
[17:12] arildb Zeno: what kind of LDAP server are you targeting?
[17:15] arildb I tried OpenLDAP, and think I had to shift the params a bit between Base DN and User DN to get it working
[17:15] arildb I used Search Scope: Base Object
[17:16] Zeno it's the AD in my company
[17:17] Zeno that's why I can't change stuff inside :(
[17:17] arildb Zeno: If you are using SSL, I assume you have the php_openssl.php activated
[17:18] arildb on windows I don't think it properly notifies about such errors
[17:20] Zeno no SSL
[17:21] Zeno and everything in LAN
[17:22] Zeno I guess won't make a difference, but no WAN involved
[17:25]  dennmans joined #tikiwiki
[17:26] Tiki-KGB tikiwiki 03fmg-sf r43724 10branches/10.x/permissioncheck/ 10index.php 10functions.inc.php
[17:26] Tiki-KGB tikiwiki [ENH] read/write CSS colors, r/w check preparations
[17:26] arildb Zeno: on the page http://doc.tiki.org/LDAP+authentication you can find some debugging code. Maybe you can try that
[17:31] Zeno arildb thanks, but that's what I'm using to know where the failure is...
[17:32] Zeno I get those debug messages into tiki logs
[17:32] arildb Zeno: did you get an extended error?
[17:36] Zeno what does "extended" mean?
[17:36] arildb Zeno: See the ldap connect test code on http://doc.tiki.org/LDAP+authentication
[17:36] arildb /* Uncomment this section to (attempt to) get the extended error ....
[17:44] ravi_ any one have knowledge of profile page?
[17:44]  redflo joined #tikiwiki
[17:44]  redflo left #tikiwiki
[17:50] fabricius hi ravi_ a little bit, but busy now - maybe chat later?
[17:51] ravi_ ok
[17:51] Zeno arildb got an extended error
[17:51] ravi_ thanks for replay
[17:52] arildb Zeno: any new information?
[17:52] Zeno arildb, must be in an ancient language or something >.<
[17:53] Zeno invalid credentials...
[17:53] Zeno and... Error binding to ldap: 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece
[17:54] Zeno arildb, any idea?
[17:54] arildb well, here you have some error code and fancy words, than can form the basis for some goggling
[17:55] arildb s/googling/googling
[17:55] Zeno buuut
[17:55] Zeno if I use standard AD syntax (aka admin@domain.com) it works
[17:56] Zeno but that works only for domain admin user
[17:56] Zeno which is no good :(
[17:57] arildb use are using the email as username for your other user too, or?
[17:57] arildb you are...ah-h spelling
[17:58]  dennmans1 joined #tikiwiki
[17:59] Zeno yes I do
[18:00] arildb I assume the AD server runs on a different computer. Is it possible taht AD requires the Tiki server to have "delegated" authentication rights?
[18:01] arildb but if other LDAP programs on the Tiki server work, I assume there is no such problem
[18:03] Zeno mmm
[18:03] Zeno might be
[18:03] Zeno anyway, I'll have to research it tomorrow
[18:03] arildb good luck
[18:03] Zeno luckily for me, it's time to go home :)
[18:03] Zeno thank you
[18:04] Zeno and thanks very much for your help, arildb
[18:04] arildb nop
[18:04] Zeno thank you too, RobertPlummer
[18:04] RobertPlummer np
[18:29]  fabricius joined #tikiwiki
[18:31]  sandroandrade joined #tikiwiki
[19:12] Tiki|bot New Forum Posts: Random images - Carousel? galleriffic? - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=45514
[19:21]  bob___ joined #tikiwiki
[19:34] Tiki-KGB tikiwiki 03fmg-sf r43725 10branches/10.x/permissioncheck/ 10index.php 10functions.inc.php
[19:34] Tiki-KGB tikiwiki [ENH] permission table: caption inserted
[20:16] Tiki-KGB tikiwiki 03fmg-sf r43726 10branches/10.x/permissioncheck/ 10(8 files in 4 dirs)
[20:16] Tiki-KGB tikiwiki [ENH] added worry, moreworry and morepain
[20:23]  arildb joined #tikiwiki
[20:26] fabricius looool refizul you are funny
[20:31]  fabricius joined #tikiwiki
[20:33]  arildb_ joined #tikiwiki
[20:34]  arildb__ joined #tikiwiki
[20:39]  changi joined #tikiwiki
[20:48]  ricks99 left #tikiwiki
[20:58] Tiki-KGB tikiwiki 03fmg-sf r43727 10branches/10.x/permissioncheck/ 10(10 files in 9 dirs)
[20:58] Tiki-KGB tikiwiki [ENH] summarized output per permission mode whether the model works or not
[21:11] RobertPlummer anybody in the mood to help out with a major slowdown in comments lib?
[21:11] RobertPlummer all^
[21:14] arildb RobertPlummer: What's the problem with comments lib? which versions experiences the slowdown?
[21:14] RobertPlummer arildb: 6-9 it looks like.
[21:15] RobertPlummer arildb: This is the built query -
[21:15] RobertPlummer select a.`threadId`,a.`object`,a.`objectType`,a.`parentId`,
[21:15] RobertPlummer a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`,
[21:15] RobertPlummer a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`,
[21:15] arildb version 6?
[21:15] RobertPlummer a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`,a.`locked`,  COALESCE(a.`archived`, 'n')  as `archived`, COALESCE(max(b.`commentDate`), a.`commentDate`)  as `lastPost`, COALESCE(a.`type`='s', false)  as `sticky`, count(distinct b.`threadId`) as `replies` , count(distinct(tfa.`attId`)) as nb_attachments
[21:15] RobertPlummer from `tiki_comments` a left join `tiki_comments` b
[21:15] RobertPlummer on b.`parentId`=a.`threadId` left join `tiki_comments` tca on (tca.`parentId`=a.`threadId` or (tca.`parentId`=0 and tca.`threadId`=a.`threadId`))left join `tiki_forum_attachments` tfa on (tfa.`threadId`=tca.`threadId`)
[21:15] RobertPlummer where a.`object`=? and (a.`archived` is null or a.`archived`=?) and a.`objectType` = 'forum'
[21:15] RobertPlummer and a.`parentId` = ?  group by a.`threadId`order by `sticky` desc, `lastPost` desc, `threadId`Array
[21:15] RobertPlummer arildb: Yes
[21:15] arildb ok
[21:15] RobertPlummer arildb: It runs fine a couple times, then when I visit a forum thread, this query won't complete.
[21:16] RobertPlummer I've traced it all the way down to the call of get_forum_topics in commentslib.php
[21:16] arildb ok
[21:16] RobertPlummer arildb: It does on fetchAll(
[21:16] RobertPlummer dies
[21:16] RobertPlummer arildb: Any pointes?
[21:16] RobertPlummer pointers, grr this keyboard!
[21:16] arildb let me have a quick look
[21:16] RobertPlummer arildb: Seems really over the top for a simple query.
[21:20] RobertPlummer arildb: can't even get a print_r
[21:21] arildb RobertPlummer: a lot of comment or forum attachments in the database?
[21:22] RobertPlummer arildb: Yes
[21:22] arildb ok
[21:22] RobertPlummer arildb: But they are not stored in the database from what I can tell.
[21:22] arildb do you mean the forum attachments?
[21:23] RobertPlummer arildb: right
[21:25] RobertPlummer arildb: Everyone can attach, but they attachments are 2 meg and are sized at max of 2 meg.
[21:26] arildb RobertPlummer: did you try to run an explain on the sql
[21:28]  changi joined #tikiwiki
[21:28] RobertPlummer arildb: No
[21:29] RobertPlummer arildb: But I can say this, I think it has something to do with cookies or cache, even though it comes to that one query and dies.
[21:29] RobertPlummer If I have 2 browsers open, 1 will be fine, the other will act like it is dying right when it goes to query.
[21:29] RobertPlummer If I wait about 10 minutes, I can navigate fine until I visit a forum thread, and then the situation repeats.
[21:30] RobertPlummer arildb: A real mind bender!
[21:31] arildb RobertPlummer: Try to check in MySQL Administrator (or similar) ..check connections...and see if the query is hanging or not...when the problem occurs
[21:34] arildb RobertPlummer: Also try to determine the problem input parameters. Try rerunning the problem SQL in a query browser, i.e. outside Tiki
[21:35] arildb then run explain <sql>
[21:39] arildb Note this query has 2(!!) count statements in it. Not good news for InnoDB users, like myself. count is a light operation with MyISAM, but can be heavy in InnoDB
[21:50]  redflo joined #tikiwiki
[21:56] RobertPlummer arildb: Is InnoDB the older of the 2?
[21:56] arildb no, I think MyISAM is older
[21:56] arildb Tiki 6 uses MyISAM
[21:58]  redflo left #tikiwiki
[22:06]  PrezKennedy joined #tikiwiki
[22:06]  _qP joined #tikiwiki
[22:07] fabricius innodb was implemented later
[22:08] fabricius RobertPlummer
[22:13] RobertPlummer here
[22:19]  Chaarles joined #tikiwiki
[22:19] Chaarles Hi everyone
[22:38] fabricius hi changi
[22:39] fabricius RobertPlummer: I just meant, that innodb was implemented later
[22:42] Tiki-KGB tikiwiki 03fmg-sf r43728 10branches/10.x/permissioncheck/ 10(11 files in 9 dirs)
[22:42] Tiki-KGB tikiwiki [FIX] summarized output per permission must be checked external via HTTP request
[22:44] refizul time to party - a big one is done
[22:51] * refizul is dancing...
[22:51] fabricius refizul: when we can check on demo or so?
[22:54] refizul as soon it is updated
[22:55] refizul demo 10 should work
[23:02]  PrezKennedy joined #tikiwiki
[23:03]  Bsfez joined #tikiwiki
[23:10] Tiki-KGB tikiwiki 03fmg-sf r43729 10branches/10.x/permissioncheck/ 10index.php 03pain 03pain/check.php
[23:10] Tiki-KGB tikiwiki [FIX] check output of HTTP request for warnings or errors
[23:13] refizul Yeah - party: http://demo.tiki.org/10x/permissioncheck/