[Xerte] Re: Problem with XOT 1.9
Tom Reijnders
reijnders at tor.nl
Tue Mar 19 07:45:40 GMT 2013
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
More information about the Xerte
mailing list