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/