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