[Tiki-devel] Possible Permissions Problem? templates?

classic Classic list List threaded Threaded
18 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jonny Bradley-4
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?



> On 29 Jul 2017, at 14:06, Jay Williston <[hidden email]> wrote:
>
> Hello,
>
> I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.
>
> But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!
>
> I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!
>
> Any help would be appreciated.
>
> -Jay
>
> Here's the code for the page.. pretty basic:
>
> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
>       {list max="500"}
>       {filter field="tracker_id" content="15"}
>       {sort mode="tracker_field_genusVirusGroup_asc"}
>     {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
> {CUSTOMSEARCH}
>
>
>
>
>
> --
> Jay Williston
> IRN Internet Services
> 71 Overlook Ave.
> Fitchburg, MA  01420
> 617-417-5749
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!

July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Dr. Sassafras
Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?

Do you have any errors in MySQL logs, apache logs or php logs? 

Brendan

On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]> wrote:

Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and
upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that
be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I
have an index table that is from last May.. but nothing recent shows up

-Jay







> Dr. Sassafras <mailto:[hidden email]>
> July 31, 2017 at 6:42 PM
> Are you using InnoDB or MyISAM? Did you change this setting when
> upgrading, if so, what is your MySQL version number?
>
> Do you have any errors in MySQL logs, apache logs or php logs?
>
> Brendan
>
> On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>> Hello everyone....
>>
>> I seem to have either, A) broken my search, B) misconfigured
>> something, or C) overlooked some setting when I recently upgraded
>> from 12 to 16.
>>
>> I've tried resetting things to default.. following the documentation
>> religiously.. Still nothing seems to be indexing.  The
>> "temp/Search_Indexer.log" is not showing up when I index. (checked
>> and double checked permissions.. even ran the installer again)
>>
>> Site is https://my.absa.org/Riskgroups
>>
>> It worked (more or less) post-upgrade for the last few weeks.. until
>> I rebuilt the index today.. then nothing.
>>
>> I'm using MySQL full-text search.  Is this the problem?  I'm running
>> a very large site.  I've set my Mem limit to 1000M and Time limit to
>> 10000.  I'm getting no feedback at all when I rebuild and since the
>> interface is different than I'm used to under 12 I'm not sure if it's
>> me or the configuration (or some combination of both!)..
>>
>> Any help would be greatly appreciated.
>>
>> -Jay
>>
>>> Jay Williston <mailto:[hidden email]>
>>> July 31, 2017 at 10:01 AM
>>> Jonny,
>>>
>>> Thanks for your help... unfortunately it didn't help.. the tracker
>>> was not using any categories.. I tried to set them to Anonymous,
>>> Registered, Members, then rebuilt the search index.. and.. still
>>> nothing.. then I took all categories off again.. rebuilt the search
>>> index.. and.. now it doesn't even show up for Anonymous!
>>>
>>> I'm worse than before!
>>>
>>> /tiki_p_view_trackers  is set to anonymous (and therefore everyone
>>> because my permission inheritance works)/
>>>
>>> I've rebuilt the search index again.. I've check tiki-check and
>>> tiki-phpinfo.. nothing seems too weird..
>>>
>>> At this point even ADMIN can't get search results!
>>>
>>> I'm wondering if it's indexing.. I don't see the
>>> temp/Search_Indexer.log file.
>>>
>>> Suggestions?
>>>
>>> -Jay
>>> p.s. Happy Monday!
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>> http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> Jonny Bradley <mailto:[hidden email]>
>>> July 29, 2017 at 9:41 AM
>>> Hi Jay
>>>
>>> There was a change in the category permissions checking somewhere
>>> between 12 and 16 (i think) which sounds like it could be
>>> responsible for this weirdness. Might that be involved here? Is the
>>> tracker categorised, and might that be affecting visibility on the
>>> items?
>>>
>>> We added an option (by default) to tracker category fields to
>>> inherit the categories from the tracker, so maybe this is having
>>> unintended changes to the permissions?
>>>
>>> Note, that when you change permissions, especially category based
>>> ones, you will need to re-index the search for them to take effect.
>>>
>>> Does that give you enough of a clue where to look i wonder?
>>>
>>> Hope so!
>>>
>>> jonny
>>>
>>> p.s. You might want to add a {filter type=trackeritem} to that so
>>> fields and comments etc don't appear in the results?
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>> http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> Jay Williston <mailto:[hidden email]>
>>> July 29, 2017 at 9:06 AM
>>> Hello,
>>>
>>> I have a strange problem since I upgraded from 12 to 16. (currently
>>> running 16.2)  I'm using CUSTOMSEARCH in a wiki page.
>>> (https://my.absa.org/Riskgroups)  As you can see all is working
>>> well.  As far as I can see my permissions are set correctly so that
>>> Anonymous can see the page and search.
>>>
>>> But here's the problem.. Anonymous and Admin users have no problems
>>> running the search, however Registered users get "No results for
>>> query."  This worked fine in tiki12..  It's a strange problem to
>>> allow anonymous and disallow registered users!
>>>
>>> I can find nothing out of the ordinary.  I have double checked
>>> permissions on the tracker.. Nothing seems to make sense.  The only
>>> permission that works to make registered users get results is
>>> checking "Administrator can manage users, groups and permissions and
>>> all features /(tiki_p_admin)" for registered users.. and, of course,
>>> don't want to do that!/
>>>
>>> Any help would be appreciated.
>>>
>>> -Jay
>>>
>>> Here's the code for the page.. pretty basic:
>>>
>>> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg"
>>> recalllastsearch="1" searchonload="1" requireinput="0")}
>>>       {list max="500"}
>>>       {filter field="tracker_id" content="15"}
>>>       {sort mode="tracker_field_genusVirusGroup_asc"}
>>>     {output
>>> template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl
>>> <http://my.absa.org/httpdocs/templates/riskgroup_search_output.tpl>"
>>> pagination="n"}
>>> {CUSTOMSEARCH}
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>> http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>> http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> <mailto:[hidden email]>
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> Jay Williston <mailto:[hidden email]>
> July 31, 2017 at 5:16 PM
> Hello everyone....
>
> I seem to have either, A) broken my search, B) misconfigured
> something, or C) overlooked some setting when I recently upgraded from
> 12 to 16.
>
> I've tried resetting things to default.. following the documentation
> religiously.. Still nothing seems to be indexing.  The
> "temp/Search_Indexer.log" is not showing up when I index. (checked and
> double checked permissions.. even ran the installer again)
>
> Site is https://my.absa.org/Riskgroups
>
> It worked (more or less) post-upgrade for the last few weeks.. until I
> rebuilt the index today.. then nothing.
>
> I'm using MySQL full-text search.  Is this the problem?  I'm running a
> very large site.  I've set my Mem limit to 1000M and Time limit to
> 10000.  I'm getting no feedback at all when I rebuild and since the
> interface is different than I'm used to under 12 I'm not sure if it's
> me or the configuration (or some combination of both!)..
>
> Any help would be greatly appreciated.
>
> -Jay
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> Jay Williston <mailto:[hidden email]>
> July 31, 2017 at 10:01 AM
> Jonny,
>
> Thanks for your help... unfortunately it didn't help.. the tracker was
> not using any categories.. I tried to set them to Anonymous,
> Registered, Members, then rebuilt the search index.. and.. still
> nothing.. then I took all categories off again.. rebuilt the search
> index.. and.. now it doesn't even show up for Anonymous!
>
> I'm worse than before!
>
> /tiki_p_view_trackers  is set to anonymous (and therefore everyone
> because my permission inheritance works)/
>
> I've rebuilt the search index again.. I've check tiki-check and
> tiki-phpinfo.. nothing seems too weird..
>
> At this point even ADMIN can't get search results!
>
> I'm wondering if it's indexing.. I don't see the
> temp/Search_Indexer.log file.
>
> Suggestions?
>
> -Jay
> p.s. Happy Monday!
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> Jonny Bradley <mailto:[hidden email]>
> July 29, 2017 at 9:41 AM
> Hi Jay
>
> There was a change in the category permissions checking somewhere
> between 12 and 16 (i think) which sounds like it could be responsible
> for this weirdness. Might that be involved here? Is the tracker
> categorised, and might that be affecting visibility on the items?
>
> We added an option (by default) to tracker category fields to inherit
> the categories from the tracker, so maybe this is having unintended
> changes to the permissions?
>
> Note, that when you change permissions, especially category based
> ones, you will need to re-index the search for them to take effect.
>
> Does that give you enough of a clue where to look i wonder?
>
> Hope so!
>
> jonny
>
> p.s. You might want to add a {filter type=trackeritem} to that so
> fields and comments etc don't appear in the results?
>
>
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
> Jay Williston <mailto:[hidden email]>
> July 29, 2017 at 9:06 AM
> Hello,
>
> I have a strange problem since I upgraded from 12 to 16. (currently
> running 16.2)  I'm using CUSTOMSEARCH in a wiki page.
> (https://my.absa.org/Riskgroups)  As you can see all is working well.  
> As far as I can see my permissions are set correctly so that Anonymous
> can see the page and search.
>
> But here's the problem.. Anonymous and Admin users have no problems
> running the search, however Registered users get "No results for
> query."  This worked fine in tiki12..  It's a strange problem to allow
> anonymous and disallow registered users!
>
> I can find nothing out of the ordinary.  I have double checked
> permissions on the tracker.. Nothing seems to make sense.  The only
> permission that works to make registered users get results is checking
> "Administrator can manage users, groups and permissions and all
> features /(tiki_p_admin)" for registered users.. and, of course, don't
> want to do that!/
>
> Any help would be appreciated.
>
> -Jay
>
> Here's the code for the page.. pretty basic:
>
> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1"
> searchonload="1" requireinput="0")}
>       {list max="500"}
>       {filter field="tracker_id" content="15"}
>       {sort mode="tracker_field_genusVirusGroup_asc"}
>     {output
> template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl"
> pagination="n"}
> {CUSTOMSEARCH}
>
>
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Dr. Sassafras
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan



On Aug 1, 2017, at 12:24 AM, Jay Williston <[hidden email]> wrote:

Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up

-Jay







Dr. Sassafras <[hidden email]>
July 31, 2017 at 6:42 PM
Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?

Do you have any errors in MySQL logs, apache logs or php logs?

Brendan

On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email] <[hidden email]>> wrote:

Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

Jay Williston <[hidden email]>
July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

/tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)/

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Jonny Bradley <mailto:[hidden email]>
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Jay Williston <mailto:[hidden email]>
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features /(tiki_p_admin)" for registered users.. and, of course, don't want to do that!/

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
     {list max="500"}
     {filter field="tracker_id" content="15"}
     {sort mode="tracker_field_genusVirusGroup_asc"}
   {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl <http://my.absa.org/httpdocs/templates/riskgroup_search_output.tpl>" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email] <[hidden email]>
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Jay Williston <mailto:[hidden email]>
July 31, 2017 at 5:16 PM
Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Jay Williston <mailto:[hidden email]>
July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

/tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)/

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Jonny Bradley <mailto:[hidden email]>
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Jay Williston <mailto:[hidden email]>
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features /(tiki_p_admin)" for registered users.. and, of course, don't want to do that!/

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
     {list max="500"}
     {filter field="tracker_id" content="15"}
     {sort mode="tracker_field_genusVirusGroup_asc"}
   {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Victor Emanouilov
In reply to this post by Jay Williston
Hi Jay,

Can you also check tiki_preferences table, pref
name=unified_mysql_index_current - what is its value? It should be in
format index_UNIQID. Do you have such MyISAM table in the database? If
so, do you see indexed content there?

Also, can you try running the index rebuild command via console:

php console.php i:r

and paste here the output?

Regards,
Victor


On 08/01/2017 07:24 AM, Jay Williston wrote:

> Thanks Brendan,
>
> I am using InnoDB..  not sure what it was before I migrated site and
> upgraded.. sorry.. I do know it was also MariaDB
>
> Yes.. I migrated the site AND upgraded it at the same time.. could
> that be it?
>
> Server type: MariaDB
> Server version: 5.5.52 MariaDB - MariaDB Server
> Protocol version: 10
> Server charset: UTF-8 Unicode (utf8)
> PHP version: 5.6.30
>
> nothing shows up in of the three logs and I just attempted rebuild.I
> have an index table that is from last May.. but nothing recent shows up
>
> -Jay
>
>
>
>
>
>
>
>> Dr. Sassafras <mailto:[hidden email]>
>> July 31, 2017 at 6:42 PM
>> Are you using InnoDB or MyISAM? Did you change this setting when
>> upgrading, if so, what is your MySQL version number?
>>
>> Do you have any errors in MySQL logs, apache logs or php logs?
>>
>> Brendan
>>
>> On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]
>> <mailto:[hidden email]>> wrote:
>>
>>> Hello everyone....
>>>
>>> I seem to have either, A) broken my search, B) misconfigured
>>> something, or C) overlooked some setting when I recently upgraded
>>> from 12 to 16.
>>>
>>> I've tried resetting things to default.. following the documentation
>>> religiously.. Still nothing seems to be indexing.  The
>>> "temp/Search_Indexer.log" is not showing up when I index. (checked
>>> and double checked permissions.. even ran the installer again)
>>>
>>> Site is https://my.absa.org/Riskgroups
>>>
>>> It worked (more or less) post-upgrade for the last few weeks.. until
>>> I rebuilt the index today.. then nothing.
>>>
>>> I'm using MySQL full-text search.  Is this the problem?  I'm running
>>> a very large site.  I've set my Mem limit to 1000M and Time limit to
>>> 10000.  I'm getting no feedback at all when I rebuild and since the
>>> interface is different than I'm used to under 12 I'm not sure if
>>> it's me or the configuration (or some combination of both!)..
>>>
>>> Any help would be greatly appreciated.
>>>
>>> -Jay
>>>
>>>> Jay Williston <mailto:[hidden email]>
>>>> July 31, 2017 at 10:01 AM
>>>> Jonny,
>>>>
>>>> Thanks for your help... unfortunately it didn't help.. the tracker
>>>> was not using any categories.. I tried to set them to Anonymous,
>>>> Registered, Members, then rebuilt the search index.. and.. still
>>>> nothing.. then I took all categories off again.. rebuilt the search
>>>> index.. and.. now it doesn't even show up for Anonymous!
>>>>
>>>> I'm worse than before!
>>>>
>>>> /tiki_p_view_trackers  is set to anonymous (and therefore everyone
>>>> because my permission inheritance works)/
>>>>
>>>> I've rebuilt the search index again.. I've check tiki-check and
>>>> tiki-phpinfo.. nothing seems too weird..
>>>>
>>>> At this point even ADMIN can't get search results!
>>>>
>>>> I'm wondering if it's indexing.. I don't see the
>>>> temp/Search_Indexer.log file.
>>>>
>>>> Suggestions?
>>>>
>>>> -Jay
>>>> p.s. Happy Monday!
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>>
>>>> Check out the vibrant tech community on one of the world's most
>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>>> http://sdm.link/slashdot
>>>> _______________________________________________
>>>> TikiWiki-devel mailing list
>>>> [hidden email]
>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>> Jonny Bradley <mailto:[hidden email]>
>>>> July 29, 2017 at 9:41 AM
>>>> Hi Jay
>>>>
>>>> There was a change in the category permissions checking somewhere
>>>> between 12 and 16 (i think) which sounds like it could be
>>>> responsible for this weirdness. Might that be involved here? Is the
>>>> tracker categorised, and might that be affecting visibility on the
>>>> items?
>>>>
>>>> We added an option (by default) to tracker category fields to
>>>> inherit the categories from the tracker, so maybe this is having
>>>> unintended changes to the permissions?
>>>>
>>>> Note, that when you change permissions, especially category based
>>>> ones, you will need to re-index the search for them to take effect.
>>>>
>>>> Does that give you enough of a clue where to look i wonder?
>>>>
>>>> Hope so!
>>>>
>>>> jonny
>>>>
>>>> p.s. You might want to add a {filter type=trackeritem} to that so
>>>> fields and comments etc don't appear in the results?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>>
>>>> Check out the vibrant tech community on one of the world's most
>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>>> http://sdm.link/slashdot
>>>> _______________________________________________
>>>> TikiWiki-devel mailing list
>>>> [hidden email]
>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>> Jay Williston <mailto:[hidden email]>
>>>> July 29, 2017 at 9:06 AM
>>>> Hello,
>>>>
>>>> I have a strange problem since I upgraded from 12 to 16. (currently
>>>> running 16.2)  I'm using CUSTOMSEARCH in a wiki page.
>>>> (https://my.absa.org/Riskgroups)  As you can see all is working
>>>> well.  As far as I can see my permissions are set correctly so that
>>>> Anonymous can see the page and search.
>>>>
>>>> But here's the problem.. Anonymous and Admin users have no problems
>>>> running the search, however Registered users get "No results for
>>>> query."  This worked fine in tiki12..  It's a strange problem to
>>>> allow anonymous and disallow registered users!
>>>>
>>>> I can find nothing out of the ordinary.  I have double checked
>>>> permissions on the tracker.. Nothing seems to make sense.  The only
>>>> permission that works to make registered users get results is
>>>> checking "Administrator can manage users, groups and permissions
>>>> and all features /(tiki_p_admin)" for registered users.. and, of
>>>> course, don't want to do that!/
>>>>
>>>> Any help would be appreciated.
>>>>
>>>> -Jay
>>>>
>>>> Here's the code for the page.. pretty basic:
>>>>
>>>> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg"
>>>> recalllastsearch="1" searchonload="1" requireinput="0")}
>>>>       {list max="500"}
>>>>       {filter field="tracker_id" content="15"}
>>>>       {sort mode="tracker_field_genusVirusGroup_asc"}
>>>>     {output
>>>> template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl
>>>> <http://my.absa.org/httpdocs/templates/riskgroup_search_output.tpl>"
>>>> pagination="n"}
>>>> {CUSTOMSEARCH}
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>>
>>>> Check out the vibrant tech community on one of the world's most
>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>>> http://sdm.link/slashdot
>>>> _______________________________________________
>>>> TikiWiki-devel mailing list
>>>> [hidden email]
>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>
>>> ------------------------------------------------------------------------------
>>>
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org <http://Slashdot.org>!
>>> http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> <mailto:[hidden email]>
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>> ------------------------------------------------------------------------------
>>
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>> Jay Williston <mailto:[hidden email]>
>> July 31, 2017 at 5:16 PM
>> Hello everyone....
>>
>> I seem to have either, A) broken my search, B) misconfigured
>> something, or C) overlooked some setting when I recently upgraded
>> from 12 to 16.
>>
>> I've tried resetting things to default.. following the documentation
>> religiously.. Still nothing seems to be indexing. The
>> "temp/Search_Indexer.log" is not showing up when I index. (checked
>> and double checked permissions.. even ran the installer again)
>>
>> Site is https://my.absa.org/Riskgroups
>>
>> It worked (more or less) post-upgrade for the last few weeks.. until
>> I rebuilt the index today.. then nothing.
>>
>> I'm using MySQL full-text search.  Is this the problem?  I'm running
>> a very large site.  I've set my Mem limit to 1000M and Time limit to
>> 10000.  I'm getting no feedback at all when I rebuild and since the
>> interface is different than I'm used to under 12 I'm not sure if it's
>> me or the configuration (or some combination of both!)..
>>
>> Any help would be greatly appreciated.
>>
>> -Jay
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>> Jay Williston <mailto:[hidden email]>
>> July 31, 2017 at 10:01 AM
>> Jonny,
>>
>> Thanks for your help... unfortunately it didn't help.. the tracker
>> was not using any categories.. I tried to set them to Anonymous,
>> Registered, Members, then rebuilt the search index.. and.. still
>> nothing.. then I took all categories off again.. rebuilt the search
>> index.. and.. now it doesn't even show up for Anonymous!
>>
>> I'm worse than before!
>>
>> /tiki_p_view_trackers  is set to anonymous (and therefore everyone
>> because my permission inheritance works)/
>>
>> I've rebuilt the search index again.. I've check tiki-check and
>> tiki-phpinfo.. nothing seems too weird..
>>
>> At this point even ADMIN can't get search results!
>>
>> I'm wondering if it's indexing.. I don't see the
>> temp/Search_Indexer.log file.
>>
>> Suggestions?
>>
>> -Jay
>> p.s. Happy Monday!
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>> Jonny Bradley <mailto:[hidden email]>
>> July 29, 2017 at 9:41 AM
>> Hi Jay
>>
>> There was a change in the category permissions checking somewhere
>> between 12 and 16 (i think) which sounds like it could be responsible
>> for this weirdness. Might that be involved here? Is the tracker
>> categorised, and might that be affecting visibility on the items?
>>
>> We added an option (by default) to tracker category fields to inherit
>> the categories from the tracker, so maybe this is having unintended
>> changes to the permissions?
>>
>> Note, that when you change permissions, especially category based
>> ones, you will need to re-index the search for them to take effect.
>>
>> Does that give you enough of a clue where to look i wonder?
>>
>> Hope so!
>>
>> jonny
>>
>> p.s. You might want to add a {filter type=trackeritem} to that so
>> fields and comments etc don't appear in the results?
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>> Jay Williston <mailto:[hidden email]>
>> July 29, 2017 at 9:06 AM
>> Hello,
>>
>> I have a strange problem since I upgraded from 12 to 16. (currently
>> running 16.2)  I'm using CUSTOMSEARCH in a wiki page.
>> (https://my.absa.org/Riskgroups)  As you can see all is working
>> well.  As far as I can see my permissions are set correctly so that
>> Anonymous can see the page and search.
>>
>> But here's the problem.. Anonymous and Admin users have no problems
>> running the search, however Registered users get "No results for
>> query."  This worked fine in tiki12..  It's a strange problem to
>> allow anonymous and disallow registered users!
>>
>> I can find nothing out of the ordinary.  I have double checked
>> permissions on the tracker.. Nothing seems to make sense.  The only
>> permission that works to make registered users get results is
>> checking "Administrator can manage users, groups and permissions and
>> all features /(tiki_p_admin)" for registered users.. and, of course,
>> don't want to do that!/
>>
>> Any help would be appreciated.
>>
>> -Jay
>>
>> Here's the code for the page.. pretty basic:
>>
>> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1"
>> searchonload="1" requireinput="0")}
>>       {list max="500"}
>>       {filter field="tracker_id" content="15"}
>>       {sort mode="tracker_field_genusVirusGroup_asc"}
>>     {output
>> template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl"
>> pagination="n"}
>> {CUSTOMSEARCH}
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jonny Bradley-4
In reply to this post by Dr. Sassafras
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)



> On 1 Aug 2017, at 06:08, Brendan Ferguson <[hidden email]> wrote:
>
> I would really like to see those logs, its super hard to say for sure whats going on without an actual error message.
>
> Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.
>
> Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.
>
> https://dev.mysql.com/doc/refman/5.6/en/fulltext-restrictions.html
> https://dev.mysql.com/doc/refman/5.5/en/fulltext-restrictions.html
>
> So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.
>
> If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern.
>
> I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.
>
> Lets hope the issue is as simple as converting the database :)
>
> Brendan
>
>
>
>> On Aug 1, 2017, at 12:24 AM, Jay Williston <[hidden email]> wrote:
>>
>> Thanks Brendan,
>>
>> I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB
>>
>> Yes.. I migrated the site AND upgraded it at the same time.. could that be it?
>>
>> Server type: MariaDB
>> Server version: 5.5.52 MariaDB - MariaDB Server
>> Protocol version: 10
>> Server charset: UTF-8 Unicode (utf8)
>> PHP version: 5.6.30
>>
>> nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up
>>
>> -Jay
>>
>>
>>
>>
>>
>>
>>
>>> Dr. Sassafras <mailto:[hidden email]>
>>> July 31, 2017 at 6:42 PM
>>> Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?
>>>
>>> Do you have any errors in MySQL logs, apache logs or php logs?
>>>
>>> Brendan
>>>
>>> On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email] <mailto:[hidden email]>> wrote:
>>>
>>>> Hello everyone....
>>>>
>>>> I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.
>>>>
>>>> I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)
>>>>
>>>> Site is https://my.absa.org/Riskgroups
>>>>
>>>> It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.
>>>>
>>>> I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..
>>>>
>>>> Any help would be greatly appreciated.
>>>>
>>>> -Jay
>>>>
>>>>> Jay Williston <mailto:[hidden email]>
>>>>> July 31, 2017 at 10:01 AM
>>>>> Jonny,
>>>>>
>>>>> Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!
>>>>>
>>>>> I'm worse than before!
>>>>>
>>>>> /tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)/
>>>>>
>>>>> I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..
>>>>>
>>>>> At this point even ADMIN can't get search results!
>>>>>
>>>>> I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.
>>>>>
>>>>> Suggestions?
>>>>>
>>>>> -Jay
>>>>> p.s. Happy Monday!
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Check out the vibrant tech community on one of the world's most
>>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
>>>>> _______________________________________________
>>>>> TikiWiki-devel mailing list
>>>>> [hidden email]
>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>> Jonny Bradley <mailto:[hidden email]>
>>>>> July 29, 2017 at 9:41 AM
>>>>> Hi Jay
>>>>>
>>>>> There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?
>>>>>
>>>>> We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?
>>>>>
>>>>> Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.
>>>>>
>>>>> Does that give you enough of a clue where to look i wonder?
>>>>>
>>>>> Hope so!
>>>>>
>>>>> jonny
>>>>>
>>>>> p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Check out the vibrant tech community on one of the world's most
>>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
>>>>> _______________________________________________
>>>>> TikiWiki-devel mailing list
>>>>> [hidden email]
>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>> Jay Williston <mailto:[hidden email]>
>>>>> July 29, 2017 at 9:06 AM
>>>>> Hello,
>>>>>
>>>>> I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.
>>>>>
>>>>> But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!
>>>>>
>>>>> I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features /(tiki_p_admin)" for registered users.. and, of course, don't want to do that!/
>>>>>
>>>>> Any help would be appreciated.
>>>>>
>>>>> -Jay
>>>>>
>>>>> Here's the code for the page.. pretty basic:
>>>>>
>>>>> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
>>>>>      {list max="500"}
>>>>>      {filter field="tracker_id" content="15"}
>>>>>      {sort mode="tracker_field_genusVirusGroup_asc"}
>>>>>    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl <http://my.absa.org/httpdocs/templates/riskgroup_search_output.tpl>" pagination="n"}
>>>>> {CUSTOMSEARCH}
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Check out the vibrant tech community on one of the world's most
>>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
>>>>> _______________________________________________
>>>>> TikiWiki-devel mailing list
>>>>> [hidden email]
>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Check out the vibrant tech community on one of the world's most
>>>> engaging tech sites, Slashdot.org <http://Slashdot.org>! http://sdm.link/slashdot
>>>> _______________________________________________
>>>> TikiWiki-devel mailing list
>>>> [hidden email] <mailto:[hidden email]>
>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> Jay Williston <mailto:[hidden email]>
>>> July 31, 2017 at 5:16 PM
>>> Hello everyone....
>>>
>>> I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.
>>>
>>> I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)
>>>
>>> Site is https://my.absa.org/Riskgroups
>>>
>>> It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.
>>>
>>> I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..
>>>
>>> Any help would be greatly appreciated.
>>>
>>> -Jay
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> Jay Williston <mailto:[hidden email]>
>>> July 31, 2017 at 10:01 AM
>>> Jonny,
>>>
>>> Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!
>>>
>>> I'm worse than before!
>>>
>>> /tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)/
>>>
>>> I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..
>>>
>>> At this point even ADMIN can't get search results!
>>>
>>> I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.
>>>
>>> Suggestions?
>>>
>>> -Jay
>>> p.s. Happy Monday!
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> Jonny Bradley <mailto:[hidden email]>
>>> July 29, 2017 at 9:41 AM
>>> Hi Jay
>>>
>>> There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?
>>>
>>> We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?
>>>
>>> Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.
>>>
>>> Does that give you enough of a clue where to look i wonder?
>>>
>>> Hope so!
>>>
>>> jonny
>>>
>>> p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>> Jay Williston <mailto:[hidden email]>
>>> July 29, 2017 at 9:06 AM
>>> Hello,
>>>
>>> I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.
>>>
>>> But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!
>>>
>>> I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features /(tiki_p_admin)" for registered users.. and, of course, don't want to do that!/
>>>
>>> Any help would be appreciated.
>>>
>>> -Jay
>>>
>>> Here's the code for the page.. pretty basic:
>>>
>>> {CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
>>>      {list max="500"}
>>>      {filter field="tracker_id" content="15"}
>>>      {sort mode="tracker_field_genusVirusGroup_asc"}
>>>    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
>>> {CUSTOMSEARCH}
>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> TikiWiki-devel mailing list
>>> [hidden email]
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>
>> --
>> Jay Williston
>> IRN Internet Services
>> 71 Overlook Ave.
>> Fitchburg, MA  01420
>> 617-417-5749
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> TikiWiki-devel mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
> TikiWiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Thanks for your help.. I do appreciate it!

I think Jonny is right.. I don't think I indexed after I moved everything over.. I was waiting to get my handlers installed (pstotext, etc.).  That fell off the radar.. and since everything was working, in theory, I left it alone.  So.. the permission problems were probably from the old index file.. and then when I rebuilt the index it all went to hell.



SEARCH:
Ok.. Sounds like I should just install Elastic search.. I can work on doing that today.  I have root access.. and just enough knowledge of linux to hang myself.. or, with help from friends, accomplish most things.. I'll get them involved. :-)



PHP:
Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?

PHP 7 is not supported by tikiwiki.. right?



LOGS:
Logs attached.. might as well..  "Your index was last fully rebuilt on Tuesday, August 01, 2017 10:33:30 CDT."  I downloaded all of these logs 10 min later..

I also check my Tiki Logs.. finally found something useful:

at 10:33 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_597ff956d5210` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

then at 10:47 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_59809f4ae32e5` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

There is now a index_59809f4ae32e5 table but it is empty.. 0 rows

unified_mysql_index_current now reads "index_59809f4ae32e5"



DATABASE:

how does one convert Innodb to MyISAM and should I?   Or.. should I "upgrade the database software to something more modern"?

Suggestions?  This is running on a dedicated server (managed.. in theory.. so I do have some help.. in theory..)

I guess what I'm asking.. is what would be the perfect combination of search and database.. Elastic.. and.. ?



Again.. thanks for all the help!

-Jay


August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 1:08 AM
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:24 AM
Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up

-Jay








July 31, 2017 at 6:42 PM
Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?

Do you have any errors in MySQL logs, apache logs or php logs? 

Brendan

On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]> wrote:

Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 31, 2017 at 5:16 PM
Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

error_log (1M) Download Attachment
php56error.log (12K) Download Attachment
mariadb.log (6K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
In reply to this post by Jonny Bradley-4
oops.. sorry about that.. my log files put my email in "moderator approval" jail.. can someone spring it free??  :-)

August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 1:08 AM
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:24 AM
Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up

-Jay








July 31, 2017 at 6:42 PM
Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?

Do you have any errors in MySQL logs, apache logs or php logs? 

Brendan

On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]> wrote:

Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 31, 2017 at 5:16 PM
Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jonny Bradley-4

> On 1 Aug 2017, at 17:14, Jay Williston <[hidden email]> wrote:
>
> oops.. sorry about that.. my log files put my email in "moderator approval" jail.. can someone spring it free??  :-)


Done, should be on it's way soon (hopefully :)

jb



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
In reply to this post by Jay Williston
Here is my email.. just an update.. I installed Elastic Search.. woo hoo! :-)

August 1, 2017 at 12:08 PM
Thanks for your help.. I do appreciate it!

I think Jonny is right.. I don't think I indexed after I moved everything over.. I was waiting to get my handlers installed (pstotext, etc.).  That fell off the radar.. and since everything was working, in theory, I left it alone.  So.. the permission problems were probably from the old index file.. and then when I rebuilt the index it all went to hell.



SEARCH:
Ok.. Sounds like I should just install Elastic search.. I can work on doing that today.  I have root access.. and just enough knowledge of linux to hang myself.. or, with help from friends, accomplish most things.. I'll get them involved. :-)



PHP:
Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?

PHP 7 is not supported by tikiwiki.. right?



LOGS:
Logs attached.. might as well..  "Your index was last fully rebuilt on Tuesday, August 01, 2017 10:33:30 CDT."  I downloaded all of these logs 10 min later..

I also check my Tiki Logs.. finally found something useful:

at 10:33 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_597ff956d5210` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

then at 10:47 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_59809f4ae32e5` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

There is now a index_59809f4ae32e5 table but it is empty.. 0 rows

unified_mysql_index_current now reads "index_59809f4ae32e5"



DATABASE:

how does one convert Innodb to MyISAM and should I?   Or.. should I "upgrade the database software to something more modern"?

Suggestions?  This is running on a dedicated server (managed.. in theory.. so I do have some help.. in theory..)

I guess what I'm asking.. is what would be the perfect combination of search and database.. Elastic.. and.. ?



Again.. thanks for all the help!

-Jay



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 1:08 AM
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:24 AM
Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up

-Jay








July 31, 2017 at 6:42 PM
Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?

Do you have any errors in MySQL logs, apache logs or php logs? 

Brendan

On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]> wrote:

Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Dr. Sassafras
Great! Did it fix the issue? 

Brendan

On Aug 1, 2017, at 3:11 PM, Jay Williston <[hidden email]> wrote:

Here is my email.. just an update.. I installed Elastic Search.. woo hoo! :-)

August 1, 2017 at 12:08 PM
Thanks for your help.. I do appreciate it!

I think Jonny is right.. I don't think I indexed after I moved everything over.. I was waiting to get my handlers installed (pstotext, etc.).  That fell off the radar.. and since everything was working, in theory, I left it alone.  So.. the permission problems were probably from the old index file.. and then when I rebuilt the index it all went to hell.



SEARCH:
Ok.. Sounds like I should just install Elastic search.. I can work on doing that today.  I have root access.. and just enough knowledge of linux to hang myself.. or, with help from friends, accomplish most things.. I'll get them involved. :-)



PHP:
Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?

PHP 7 is not supported by tikiwiki.. right?



LOGS:
Logs attached.. might as well..  "Your index was last fully rebuilt on Tuesday, August 01, 2017 10:33:30 CDT."  I downloaded all of these logs 10 min later..

I also check my Tiki Logs.. finally found something useful:

at 10:33 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_597ff956d5210` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

then at 10:47 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_59809f4ae32e5` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

There is now a index_59809f4ae32e5 table but it is empty.. 0 rows

unified_mysql_index_current now reads "index_59809f4ae32e5"



DATABASE:

how does one convert Innodb to MyISAM and should I?   Or.. should I "upgrade the database software to something more modern"?

Suggestions?  This is running on a dedicated server (managed.. in theory.. so I do have some help.. in theory..)

I guess what I'm asking.. is what would be the perfect combination of search and database.. Elastic.. and.. ?



Again.. thanks for all the help!

-Jay



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 1:08 AM
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:24 AM
Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up

-Jay








July 31, 2017 at 6:42 PM
Are you using InnoDB or MyISAM? Did you change this setting when upgrading, if so, what is your MySQL version number?

Do you have any errors in MySQL logs, apache logs or php logs? 

Brendan

On Jul 31, 2017, at 5:16 PM, Jay Williston <[hidden email]> wrote:

Hello everyone....

I seem to have either, A) broken my search, B) misconfigured something, or C) overlooked some setting when I recently upgraded from 12 to 16.

I've tried resetting things to default.. following the documentation religiously.. Still nothing seems to be indexing.  The "temp/Search_Indexer.log" is not showing up when I index. (checked and double checked permissions.. even ran the installer again)

Site is https://my.absa.org/Riskgroups

It worked (more or less) post-upgrade for the last few weeks.. until I rebuilt the index today.. then nothing.

I'm using MySQL full-text search.  Is this the problem?  I'm running a very large site.  I've set my Mem limit to 1000M and Time limit to 10000.  I'm getting no feedback at all when I rebuild and since the interface is different than I'm used to under 12 I'm not sure if it's me or the configuration (or some combination of both!)..

Any help would be greatly appreciated.

-Jay

July 31, 2017 at 10:01 AM
Jonny,

Thanks for your help... unfortunately it didn't help.. the tracker was not using any categories.. I tried to set them to Anonymous, Registered, Members, then rebuilt the search index.. and.. still nothing.. then I took all categories off again.. rebuilt the search index.. and.. now it doesn't even show up for Anonymous!

I'm worse than before!

tiki_p_view_trackers  is set to anonymous (and therefore everyone because my permission inheritance works)

I've rebuilt the search index again.. I've check tiki-check and tiki-phpinfo.. nothing seems too weird..

At this point even ADMIN can't get search results!

I'm wondering if it's indexing.. I don't see the temp/Search_Indexer.log file.

Suggestions?

-Jay
p.s. Happy Monday!


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:41 AM
Hi Jay

There was a change in the category permissions checking somewhere between 12 and 16 (i think) which sounds like it could be responsible for this weirdness. Might that be involved here? Is the tracker categorised, and might that be affecting visibility on the items?

We added an option (by default) to tracker category fields to inherit the categories from the tracker, so maybe this is having unintended changes to the permissions?

Note, that when you change permissions, especially category based ones, you will need to re-index the search for them to take effect.

Does that give you enough of a clue where to look i wonder?

Hope so!

jonny

p.s. You might want to add a {filter type=trackeritem} to that so fields and comments etc don't appear in the results?





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
July 29, 2017 at 9:06 AM
Hello,

I have a strange problem since I upgraded from 12 to 16. (currently running 16.2)  I'm using CUSTOMSEARCH in a wiki page. (https://my.absa.org/Riskgroups)  As you can see all is working well.  As far as I can see my permissions are set correctly so that Anonymous can see the page and search.

But here's the problem.. Anonymous and Admin users have no problems running the search, however Registered users get "No results for query."  This worked fine in tiki12..  It's a strange problem to allow anonymous and disallow registered users!

I can find nothing out of the ordinary.  I have double checked permissions on the tracker.. Nothing seems to make sense.  The only permission that works to make registered users get results is checking "Administrator can manage users, groups and permissions and all features (tiki_p_admin)" for registered users.. and, of course, don't want to do that!

Any help would be appreciated.

-Jay

Here's the code for the page.. pretty basic:

{CUSTOMSEARCH(tpl="riskgroup_search.tpl" id="rg" recalllastsearch="1" searchonload="1" requireinput="0")}
      {list max="500"}
      {filter field="tracker_id" content="15"}
      {sort mode="tracker_field_genusVirusGroup_asc"}
    {output template="/var/www/vhosts/my.absa.org/httpdocs/templates/riskgroup_search_output.tpl" pagination="n"}
{CUSTOMSEARCH}





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jonny Bradley-4
In reply to this post by Jay Williston

Hi Jay

Glad you got your issues sorted out, elastic search is much more fun than the other engines, check out the facet search for a start! :)

Re the PHP version

> On 1 Aug 2017, at 17:08, Jay Williston <[hidden email]> wrote:
>
> PHP:
> Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?
>
> PHP 7 is not supported by tikiwiki.. right?

I think Tiki 16 is happy on php 7.0 (and Tiki 15 maybe? But possibly not so 100%) and Tiki 17+ is ok on php 7.1 apart from one or two minor failures (such as html mode diff, and some of the antiquated spreadsheet import/export functions). Also we still have an unsolved issue with intertiki on php 7 on the Tiki sites (not forgotten Oliver ;)

I would strongly recommend you move to tiki 17.x (via svn if you can) and update to php 7.1 as it runs significantly faster and uses less ram than 5.x ever did.

Also i would consider upgrading your mariadb, just to keep up with latest patches etc.

jonny



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Thanks..

I installed Elasticsearch to it's default settings
I upgraded MariaDB
I set unified search engine to Elasticsearch.  It now says:
  • Client Node: Melissa Gold
  • Elasticsearch Version: 1.7.3
  • Lucene Version: 4.10.4
  • Cluster Name: elasticsearch
  • Cluster Status: green
  • Cluster Node Count: 1
  • Node Melissa Gold: Using 51,692,216 bytes, since 2017-08-02 07:49:02
I rebuilt the index but.. search is still not working.. do I need to give it some time?  Or.. is there something I'm missing?  Sorry to be so clueless here.. :-(

I downloaded 17.x via SVN

Question:  Should I try to get the search to work before I install 17?  Should I switch to PHP7 before or after I upgrade to 17?

-Jay
p.s. who is Melissa Gold?  :-)



August 2, 2017 at 6:57 AM
Hi Jay

Glad you got your issues sorted out, elastic search is much more fun than the other engines, check out the facet search for a start! :)

Re the PHP version


I think Tiki 16 is happy on php 7.0 (and Tiki 15 maybe? But possibly not so 100%) and Tiki 17+ is ok on php 7.1 apart from one or two minor failures (such as html mode diff, and some of the antiquated spreadsheet import/export functions). Also we still have an unsolved issue with intertiki on php 7 on the Tiki sites (not forgotten Oliver ;)

I would strongly recommend you move to tiki 17.x (via svn if you can) and update to php 7.1 as it runs significantly faster and uses less ram than 5.x ever did.

Also i would consider upgrading your mariadb, just to keep up with latest patches etc.

jonny



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:08 PM
Thanks for your help.. I do appreciate it!

I think Jonny is right.. I don't think I indexed after I moved everything over.. I was waiting to get my handlers installed (pstotext, etc.).  That fell off the radar.. and since everything was working, in theory, I left it alone.  So.. the permission problems were probably from the old index file.. and then when I rebuilt the index it all went to hell.



SEARCH:
Ok.. Sounds like I should just install Elastic search.. I can work on doing that today.  I have root access.. and just enough knowledge of linux to hang myself.. or, with help from friends, accomplish most things.. I'll get them involved. :-)



PHP:
Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?

PHP 7 is not supported by tikiwiki.. right?



LOGS:
Logs attached.. might as well..  "Your index was last fully rebuilt on Tuesday, August 01, 2017 10:33:30 CDT."  I downloaded all of these logs 10 min later..

I also check my Tiki Logs.. finally found something useful:

at 10:33 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_597ff956d5210` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

then at 10:47 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_59809f4ae32e5` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

There is now a index_59809f4ae32e5 table but it is empty.. 0 rows

unified_mysql_index_current now reads "index_59809f4ae32e5"



DATABASE:

how does one convert Innodb to MyISAM and should I?   Or.. should I "upgrade the database software to something more modern"?

Suggestions?  This is running on a dedicated server (managed.. in theory.. so I do have some help.. in theory..)

I guess what I'm asking.. is what would be the perfect combination of search and database.. Elastic.. and.. ?



Again.. thanks for all the help!

-Jay



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 1:08 AM
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:24 AM
Thanks Brendan,

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB

Yes.. I migrated the site AND upgraded it at the same time.. could that be it?

Server type: MariaDB
Server version: 5.5.52 MariaDB - MariaDB Server
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
PHP version: 5.6.30

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up

-Jay









--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jonny Bradley-4
Hi Jay

Hmm, that's a very old version of elasticsearch, and i haven't tried recent Tikis on version 1.x es, most people are on 2.x (2.4 i think was that last) and the current stable is 5.x (they skipped some numbers to sync up with their other products) which seems to work fine with 16 and 17 afaik.

Are there any php errors while you rebuild? You might get more info out of it if you use the command line tool (php console.php index:rebuild), maybe with verbose options like -vvv added?

I would install elastic 2.4 latest and get it all working on 16.x as it should be, then upgrade Tiki to 17.x (you can use svn switch if your 16.x was installed by svn), and then update php. then (maybe) upgrade ES to 5.x if you're feeling keen!

The node names used to be fun random words, like Melissa Gold, sadly 5.3 here just says it's client node is called "k8xS-me" :(

Pop in on IRC if you're stuck - there are usually a few of us there who can answer questions on the spot...

jonny





On 2 Aug 2017, at 13:58, Jay Williston <[hidden email]> wrote:

Thanks.. 

I installed Elasticsearch to it's default settings
I upgraded MariaDB
I set unified search engine to Elasticsearch.  It now says:
  • Client Node: Melissa Gold
  • Elasticsearch Version: 1.7.3
  • Lucene Version: 4.10.4
  • Cluster Name: elasticsearch
  • Cluster Status: green
  • Cluster Node Count: 1
  • Node Melissa Gold: Using 51,692,216 bytes, since 2017-08-02 07:49:02
I rebuilt the index but.. search is still not working.. do I need to give it some time?  Or.. is there something I'm missing?  Sorry to be so clueless here.. :-(

I downloaded 17.x via SVN

Question:  Should I try to get the search to work before I install 17?  Should I switch to PHP7 before or after I upgrade to 17?

-Jay
p.s. who is Melissa Gold?  :-)



 
August 2, 2017 at 6:57 AM
Hi Jay

Glad you got your issues sorted out, elastic search is much more fun than the other engines, check out the facet search for a start! :)

Re the PHP version


I think Tiki 16 is happy on php 7.0 (and Tiki 15 maybe? But possibly not so 100%) and Tiki 17+ is ok on php 7.1 apart from one or two minor failures (such as html mode diff, and some of the antiquated spreadsheet import/export functions). Also we still have an unsolved issue with intertiki on php 7 on the Tiki sites (not forgotten Oliver ;)

I would strongly recommend you move to tiki 17.x (via svn if you can) and update to php 7.1 as it runs significantly faster and uses less ram than 5.x ever did.

Also i would consider upgrading your mariadb, just to keep up with latest patches etc.

jonny



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
 
August 1, 2017 at 12:08 PM
Thanks for your help.. I do appreciate it!

I think Jonny is right.. I don't think I indexed after I moved everything over.. I was waiting to get my handlers installed (pstotext, etc.).  That fell off the radar.. and since everything was working, in theory, I left it alone.  So.. the permission problems were probably from the old index file.. and then when I rebuilt the index it all went to hell.



SEARCH:
Ok.. Sounds like I should just install Elastic search.. I can work on doing that today.  I have root access.. and just enough knowledge of linux to hang myself.. or, with help from friends, accomplish most things.. I'll get them involved. :-)



PHP:
Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?

PHP 7 is not supported by tikiwiki.. right?



LOGS:
Logs attached.. might as well..  "Your index was last fully rebuilt on Tuesday, August 01, 2017 10:33:30 CDT."  I downloaded all of these logs 10 min later.. 

I also check my Tiki Logs.. finally found something useful:

at 10:33 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_597ff956d5210` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

then at 10:47 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_59809f4ae32e5` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

There is now a index_59809f4ae32e5 table but it is empty.. 0 rows

unified_mysql_index_current now reads "index_59809f4ae32e5"



DATABASE:

how does one convert Innodb to MyISAM and should I?   Or.. should I "upgrade the database software to something more modern"?

Suggestions?  This is running on a dedicated server (managed.. in theory.. so I do have some help.. in theory..)

I guess what I'm asking.. is what would be the perfect combination of search and database.. Elastic.. and.. ?



Again.. thanks for all the help!

-Jay



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
 
August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
 
August 1, 2017 at 1:08 AM
I would really like to see those logs, its super hard to say for sure whats going on without an actual error message. 

Fulltext Support in Innodb isn’t able to index until mysql 5.6. Im guessing that is your issue.

Ive been trying to sort out, and create better guidelines in tiki for what mySQL versions are required. Its still a work in progress, but we will likely be making the minimum version  5.6.4 (released 2011) Now that were moving more toward InnoDB.


So it appears (based on the above documentation) that a minimum requirement of 5.6.4 would be a safe bet.

If this is wants happening, then the logs should have errors that support this. Assuming this is the issue, the solution would be to convert to MyISAM or upgrade the database software to something more modern. 

I guess MariaDB 10.0 line is equivalent to mysql 5.6, and MariaDB 10.1 & 10.2 are similar to mySQL 5.7. Ive always used mySQL, so I’m just looking at the online domination here.

Lets hope the issue is as simple as converting the database :)

Brendan




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
 
August 1, 2017 at 12:24 AM
Thanks Brendan, 

I am using InnoDB..  not sure what it was before I migrated site and upgraded.. sorry.. I do know it was also MariaDB 

Yes.. I migrated the site AND upgraded it at the same time.. could that be it? 

Server type: MariaDB 
Server version: 5.5.52 MariaDB - MariaDB Server 
Protocol version: 10 
Server charset: UTF-8 Unicode (utf8) 
PHP version: 5.6.30 

nothing shows up in of the three logs and I just attempted rebuild.I have an index table that is from last May.. but nothing recent shows up 

-Jay 









-- 
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Tiki-devel] Possible Permissions Problem? templates?

Jay Williston
Thanks Jonny this sounds like a good plan..

And, of course, the most important part of a good plan is its execution.. I seemed to have failed the first step... sorta.

HELP!!  :-)

In upgrading elasticsearch to 2.4 I seemed to have upgraded it to 5.5.1 instead!! 

So.. it looks like I'll try to get it to work on 5.5.1..

Here's what Tiki is telling me on the search control panel:

  • Client Node: S2VaBGo
  • Elasticsearch Version: 5.5.1
  • Lucene Version: 6.6.0
  • Cluster Name: elasticsearch
  • Cluster Status: green
  • Cluster Node Count: 1
  • Node S2VaBGo: Using 541,456,456 bytes, since 2017-08-02 14:03:22
my current index is: tiki_main_59821fa678aa5

However.. I don't see this index anywhere on the server "find .

When I rebuild via ssh "php console.php index:rebuild -vvv"

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Tiki database connection lost</title>
    <link href="favicon.png" rel="icon">
    <link rel="stylesheet" href="themes/base_files/css/tiki_base.css" type="text/css">
    <link rel="stylesheet" href="themes/default/css/default.css" type="text/css">
</head>
<body>
<div id="middle" class="container">
    <div>
        <div id="col1" style="margin: 4em; text-align: center;">
            <p><img src="img/tiki/tikilogo.png"/></p>
            <h1>Lost Tiki database connection</h1>
            <article id="top">
                <p>
                    Sorry but there seems to be a problem connecting to the system's database </p>
                <p></p>
                <p>
                    This may only be a temporary problem, so please wait a while and click
                    <a href="./" class="btn btn-default btn-link">retry</a> to try and go back to the home page </p>
                <p>
                    If it persists you should contact your system administrator </p>
            </article>
        </div>
    </div>
</div>
</body>
</html>


Suggestions?

-Jay
August 2, 2017 at 10:06 AM
Hi Jay

Hmm, that's a very old version of elasticsearch, and i haven't tried recent Tikis on version 1.x es, most people are on 2.x (2.4 i think was that last) and the current stable is 5.x (they skipped some numbers to sync up with their other products) which seems to work fine with 16 and 17 afaik.

Are there any php errors while you rebuild? You might get more info out of it if you use the command line tool (php console.php index:rebuild), maybe with verbose options like -vvv added?

I would install elastic 2.4 latest and get it all working on 16.x as it should be, then upgrade Tiki to 17.x (you can use svn switch if your 16.x was installed by svn), and then update php. then (maybe) upgrade ES to 5.x if you're feeling keen!

The node names used to be fun random words, like Melissa Gold, sadly 5.3 here just says it's client node is called "k8xS-me" :(

Pop in on IRC if you're stuck - there are usually a few of us there who can answer questions on the spot...

jonny






------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 2, 2017 at 8:58 AM
Thanks..

I installed Elasticsearch to it's default settings
I upgraded MariaDB
I set unified search engine to Elasticsearch.  It now says:
  • Client Node: Melissa Gold
  • Elasticsearch Version: 1.7.3
  • Lucene Version: 4.10.4
  • Cluster Name: elasticsearch
  • Cluster Status: green
  • Cluster Node Count: 1
  • Node Melissa Gold: Using 51,692,216 bytes, since 2017-08-02 07:49:02
I rebuilt the index but.. search is still not working.. do I need to give it some time?  Or.. is there something I'm missing?  Sorry to be so clueless here.. :-(

I downloaded 17.x via SVN

Question:  Should I try to get the search to work before I install 17?  Should I switch to PHP7 before or after I upgrade to 17?

-Jay
p.s. who is Melissa Gold?  :-)




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 2, 2017 at 6:57 AM
Hi Jay

Glad you got your issues sorted out, elastic search is much more fun than the other engines, check out the facet search for a start! :)

Re the PHP version


I think Tiki 16 is happy on php 7.0 (and Tiki 15 maybe? But possibly not so 100%) and Tiki 17+ is ok on php 7.1 apart from one or two minor failures (such as html mode diff, and some of the antiquated spreadsheet import/export functions). Also we still have an unsolved issue with intertiki on php 7 on the Tiki sites (not forgotten Oliver ;)

I would strongly recommend you move to tiki 17.x (via svn if you can) and update to php 7.1 as it runs significantly faster and uses less ram than 5.x ever did.

Also i would consider upgrading your mariadb, just to keep up with latest patches etc.

jonny



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 12:08 PM
Thanks for your help.. I do appreciate it!

I think Jonny is right.. I don't think I indexed after I moved everything over.. I was waiting to get my handlers installed (pstotext, etc.).  That fell off the radar.. and since everything was working, in theory, I left it alone.  So.. the permission problems were probably from the old index file.. and then when I rebuilt the index it all went to hell.



SEARCH:
Ok.. Sounds like I should just install Elastic search.. I can work on doing that today.  I have root access.. and just enough knowledge of linux to hang myself.. or, with help from friends, accomplish most things.. I'll get them involved. :-)



PHP:
Question: I'm at PHP 5.6.31.. which is (according to php) the last stable release of 5..  should I upgrade to 5.6.4?

PHP 7 is not supported by tikiwiki.. right?



LOGS:
Logs attached.. might as well..  "Your index was last fully rebuilt on Tuesday, August 01, 2017 10:33:30 CDT."  I downloaded all of these logs 10 min later..

I also check my Tiki Logs.. finally found something useful:

at 10:33 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_597ff956d5210` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

then at 10:47 db error Unknown column 'title' in 'order clause' - SELECT * FROM `index_59809f4ae32e5` WHERE 1=1 AND `object_type` = 'category' ORDER BY `title` asc

There is now a index_59809f4ae32e5 table but it is empty.. 0 rows

unified_mysql_index_current now reads "index_59809f4ae32e5"



DATABASE:

how does one convert Innodb to MyISAM and should I?   Or.. should I "upgrade the database software to something more modern"?

Suggestions?  This is running on a dedicated server (managed.. in theory.. so I do have some help.. in theory..)

I guess what I'm asking.. is what would be the perfect combination of search and database.. Elastic.. and.. ?



Again.. thanks for all the help!

-Jay



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
August 1, 2017 at 5:23 AM
Hi all

I think you may have nailed it Brendan - and maybe it was still using the old index from before the upgrade and migration which was partially working, but due to structural changes since 12.x this odd permissions effect was produced. Then when re-indexing (failed as Brendan says) no one can find anything now.

Another option, Jay would be to try the other engines Tiki search supports. Elastic search is the best one but need installing (it's not hard but you need root access), or the PHP Lucene which is still in there and not well maintained (Zend seem to have stopped supporting it) but might be better than nothing while you get your database upgraded (or switch back to using MyISAM tables).

The search control panel should really warn about this, along with the minimum word length limit (but i don't think it does still).

jonny

p.s. Yes, migrating and upgrading at the same time is not ideal, one (small) step at a time is generally best! :)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

--
Jay Williston
IRN Internet Services
71 Overlook Ave.
Fitchburg, MA  01420
617-417-5749


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
TikiWiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
Loading...