[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