[Xerte] Re: Problem with XOT 1.9

Guy Footring Guy at Footring.net
Tue Mar 19 22:35:04 GMT 2013


Hi Pat, Tom,
I've figured it out now and I'm up and running.

As I mentioned before, I'm not a php developer and I didn't realise that 
if I changed settings in a php.ini file that I'd need to replicate that 
to every subdirectory under my install :(
I contacted my hosting support to see if there was a way to avoid the 
replication and they gave me the appropriate magic incarnation to put 
into my .htaccess file to get the php in all subdirectories to reference 
the single php.ini file I'd configured.

In case it is of help to anyone else, here is my current php.ini and 
.htaccess file content

=================
php.ini:
register_globals = true
session.save_path = '/home/xerte/xerte_session'
session.save_hander = files
=================
.htacess:
# Use PHP 5.3
AddHandler application/x-httpd-php53 .php

suPHP_ConfigPath /home/xerte/public_html/
<Files php.ini>
order allow,deny
deny from all
</Files>
=================

Thanks again for the all the support
Guy

On 19/03/2013 08:35, Pat @ Pgogy wrote:
> Ok
>
> Are the domains the same between login and index? You don't switch to https?
>
> If not - what does the print_r show now?
>
> Pgogy Webstuff - http://www.pgogywebstuff.com
> Makers of web things of a fair to middling quality
>
> On 19 Mar 2013, at 07:45, Tom Reijnders <reijnders at tor.nl> wrote:
>
>> This is a bit of a wild guess, but what kind of permissions does the mysql user have?
>>
>> It looks like XOT can connect to mysql, but it can't write/insert records.
>>
>> Also, you're on Linux right? Could you try and switch on 'developer' mode in config.php by setting '$development=true' around line 26?
>>
>> Hopefully you see an error message immediately, or after inspecting the /tmp/debug.log file.
>>
>> Regards,
>>
>> Tom
>>
>>
>> Op 19-3-2013 0:46, Guy Footring schreef:
>>> Below are my current session settings, don't know if you can spot anything suspicious.
>>> It looks like my default settings might have had a bad save_path which I've now adjusted. My php.ini file now contains:
>>> register_globals = true
>>> session.save_path = /home/xerte/xerte_session
>>> session.save_hander = files
>>>
>>> Now I get the user propagated to the workspace properties screen, but I still get the "Invalid template_id (could not find in DB)" when I try to create a project and the creator_id is still null for the new templatedetails table row.
>>> ===================
>>> session
>>> Session Support     enabled
>>> Registered save handlers     files user mm
>>> Registered serializer handlers     php php_binary wddx
>>>
>>> Directive    Local Value    Master Value
>>> session.auto_start    Off    Off
>>> session.bug_compat_42    On    On
>>> session.bug_compat_warn    On    On
>>> session.cache_expire    180    180
>>> session.cache_limiter    nocache    nocache
>>> session.cookie_domain    no value    no value
>>> session.cookie_httponly    Off    Off
>>> session.cookie_lifetime    0    0
>>> session.cookie_path    /    /
>>> session.cookie_secure    Off    Off
>>> session.entropy_file    no value    no value
>>> session.entropy_length    0    0
>>> session.gc_divisor    100    100
>>> session.gc_maxlifetime    1440    1440
>>> session.gc_probability    1    1
>>> session.hash_bits_per_character    4    4
>>> session.hash_function    0    0
>>> session.name    PHPSESSID    PHPSESSID
>>> session.referer_check    no value    no value
>>> session.save_handler    files    files
>>> session.save_path    /home/xerte/xerte_session /home/xerte/xerte_session
>>> session.serialize_handler    php    php
>>> session.use_cookies    On    On
>>> session.use_only_cookies    Off    Off
>>> session.use_trans_sid    0    0
>>> ===================
>>>
>>> Regards
>>> Guy
>>>
>>> On 18/03/2013 07:58, Pat @ Pgogy wrote:
>>>> No, ignore integration.txt
>>>>
>>>> It sounds like something is wiping the session - wondering if it is a php setting?
>>>>
>>>> Pgogy Webstuff - http://www.pgogywebstuff.com
>>>> Makers of web things of a fair to middling quality
>>>>
>>>> On 17 Mar 2013, at 22:27, Guy Footring <Guy at Footring.net> wrote:
>>>>
>>>>> Whilst demo.txt and switch.txt are no longer present, integration.txt is still there.
>>>>> Am I expected to rename that to integration.php and do something with it to enable the connection to the static.php authentication?
>>>>>
>>>>> When I put the print_r($_SESSION) in to the workspaceproperties.php the only session variable that is set is the language (no user stuff at all).
>>>>>
>>>>> Guy
>>>>>
>>>>>
>>>>> On 17/03/2013 09:30, Pat @ Pgogy wrote:
>>>>>> Hi Guy,
>>>>>>
>>>>>> A print won't fix, but it helps diagnose.
>>>>>>
>>>>>> Try adding a print near the top of edit.php which is also in the root.
>>>>>>
>>>>>> Pgogy Webstuff - http://www.pgogywebstuff.com
>>>>>> Makers of web things of a fair to middling quality
>>>>>>
>>>>>> On 16 Mar 2013, at 21:54, Guy Footring <Guy at Footring.net> wrote:
>>>>>>
>>>>>>> Hi Pat,
>>>>>>> Here's what I get with print_r($_SESSION):
>>>>>>>
>>>>>>> Array
>>>>>>> (
>>>>>>>     [toolkits_language] => en-GB
>>>>>>>     [toolkits_firstname] => Guy
>>>>>>>     [toolkits_surname] => Footring
>>>>>>>     [toolkits_logon_username] => guy
>>>>>>>     [toolkits_logon_id] => 4
>>>>>>> )
>>>>>>>
>>>>>>> If you can point me at the right file I can try printing this in the editor screen to see if it has propagated correctly.  I don't know php, but I can code and I can google stuff (e.g. to find the php.ini settings and how to print_r the session), but it would take me a while to figure out where to put the print_r to get it to show in the edit window...
>>>>>>> Any alternative suggestions also welcomed :)
>>>>>>>
>>>>>>> Thanks for responding so quickly.
>>>>>>>
>>>>>>> --
>>>>>>> Regards
>>>>>>> Guy
>>>>>>>
>>>>>>> On 16/03/2013 21:04, Pat @ Pgogy wrote:
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> Two NULL suggest the session isn't starting correctly.
>>>>>>>>
>>>>>>>> Try adding a php print_r session in index.php somewhere to see what is set
>>>>>>>>
>>>>>>>> Pgogy Webstuff - http://www.pgogywebstuff.com
>>>>>>>> Makers of web things of a fair to middling quality
>>>>>>>>
>>>>>>>> On 16 Mar 2013, at 20:35, Guy Footring <Guy at Footring.net> wrote:
>>>>>>>>
>>>>>>>>> I downloaded the xot 1.9 zipfile this morning and installed to a hosted web-server using the cpanel interface.
>>>>>>>>>
>>>>>>>>> I found I needed to create a php.ini file with register_globals = true in order to get anywhere with xot.  Having made that change, together with changing auth to use static.php, I'm now able to login and get the next screen, but I'm unable to create projects.
>>>>>>>>>
>>>>>>>>> Attempting to create a project brings up the edit screen with the URL http://myhost.fqdn/xerte/edit.php?template_id=2 and the error message:
>>>>>>>>> Invalid template_id (could not find in DB)
>>>>>>>>>
>>>>>>>>> (template_id increments by one on each attempt to create).
>>>>>>>>>
>>>>>>>>> If I display the Workspace properties, under the My Details tab I just get the fixed display strings but no values:
>>>>>>>>> My Details
>>>>>>>>>
>>>>>>>>> My name on the system is
>>>>>>>>>
>>>>>>>>> My last login was on
>>>>>>>>>
>>>>>>>>> My username is
>>>>>>>>>
>>>>>>>>> There are some entries in the database with the relevant id:
>>>>>>>>>
>>>>>>>>> templatedetails
>>>>>>>>>
>>>>>>>>> template_id    creator_id    template_type_id template_name    date_created date_modified date_accessed    number_of_uses    access_to_whom
>>>>>>>>>     1    NULL    5    MyProject    2013-03-16 2013-03-16    NULL    NULL    Private
>>>>>>>>>
>>>>>>>>> templaterights
>>>>>>>>>
>>>>>>>>> template_id    user_id    role    folder    notes
>>>>>>>>>     1    NULL    creator    0    NULL
>>>>>>>>>
>>>>>>>>> It looks odd that creator_id and user_id are NULL, so wondering if it is a problem with the authentication or logged-in-ID-tracking (would perhaps tie in with no details being displayed for the workspace properties). I get the same problem if I use the guest authentication method.
>>>>>>>>>
>>>>>>>>> Logging in to the management.php screen I don't get any functionality available - the screen appears OK with the standard options but text area just displays "the feature is for administrators only".
>>>>>>>>>
>>>>>>>>> Any suggestions as to how to fix the problem or next steps in further diagnosing it would be much appreciated.
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Regards
>>>>>>>>> Guy
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Xerte mailing list
>>>>>>>>> Xerte at lists.nottingham.ac.uk
>>>>>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>>>>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>>>>>>>
>>>>>>>>> This message has been checked for viruses but the contents of an attachment
>>>>>>>>> may still contain software viruses which could damage your computer system:
>>>>>>>>> you are advised to perform your own checks. Email communications with the
>>>>>>>>> University of Nottingham may be monitored as permitted by UK legislation.
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Xerte mailing list
>>>>>>>> Xerte at lists.nottingham.ac.uk
>>>>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>>>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>>>>>>
>>>>>>>> This message has been checked for viruses but the contents of an attachment
>>>>>>>> may still contain software viruses which could damage your computer system:
>>>>>>>> you are advised to perform your own checks. Email communications with the
>>>>>>>> University of Nottingham may be monitored as permitted by UK legislation.
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Xerte mailing list
>>>>>>> Xerte at lists.nottingham.ac.uk
>>>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>>>>>
>>>>>>> This message has been checked for viruses but the contents of an attachment
>>>>>>> may still contain software viruses which could damage your computer system:
>>>>>>> you are advised to perform your own checks. Email communications with the
>>>>>>> University of Nottingham may be monitored as permitted by UK legislation.
>>>>>>
>>>>>> _______________________________________________
>>>>>> Xerte mailing list
>>>>>> Xerte at lists.nottingham.ac.uk
>>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>>>>
>>>>>> This message has been checked for viruses but the contents of an attachment
>>>>>> may still contain software viruses which could damage your computer system:
>>>>>> you are advised to perform your own checks. Email communications with the
>>>>>> University of Nottingham may be monitored as permitted by UK legislation.
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Xerte mailing list
>>>>> Xerte at lists.nottingham.ac.uk
>>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>>>
>>>>> This message has been checked for viruses but the contents of an attachment
>>>>> may still contain software viruses which could damage your computer system:
>>>>> you are advised to perform your own checks. Email communications with the
>>>>> University of Nottingham may be monitored as permitted by UK legislation.
>>>>
>>>> _______________________________________________
>>>> Xerte mailing list
>>>> Xerte at lists.nottingham.ac.uk
>>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>>
>>>> This message has been checked for viruses but the contents of an attachment
>>>> may still contain software viruses which could damage your computer system:
>>>> you are advised to perform your own checks. Email communications with the
>>>> University of Nottingham may be monitored as permitted by UK legislation.
>>>
>>>
>>>
>>> _______________________________________________
>>> Xerte mailing list
>>> Xerte at lists.nottingham.ac.uk
>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>>
>>> This message has been checked for viruses but the contents of an attachment
>>> may still contain software viruses which could damage your computer system:
>>> you are advised to perform your own checks. Email communications with the
>>> University of Nottingham may be monitored as permitted by UK legislation.
>>
>> --
>> --
>>
>> Tom Reijnders
>> TOR Informatica
>> Chopinlaan 27
>> 5242HM Rosmalen
>> Tel: 073 5226191
>> Fax: 073 5226196
>>
>>
>> _______________________________________________
>> Xerte mailing list
>> Xerte at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>>
>> This message has been checked for viruses but the contents of an attachment
>> may still contain software viruses which could damage your computer system:
>> you are advised to perform your own checks. Email communications with the
>> University of Nottingham may be monitored as permitted by UK legislation.
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>
> This message has been checked for viruses but the contents of an attachment
> may still contain software viruses which could damage your computer system:
> you are advised to perform your own checks. Email communications with the
> University of Nottingham may be monitored as permitted by UK legislation.
>





More information about the Xerte mailing list