[Xerte-dev] Re: 1.9 thinking

[Pat Lockley]

I don't know what plans are for a database - but everyone using it at
present is on MySQL, and if they've got limited rights accounts, or
set up with limited rights accounts then update (as is) won't work for
them.

I can't see a config table in

http://code.google.com/p/xerteonlinetoolkits/source/browse/trunk/setup/basic.sql

?

On Thu, Jul 5, 2012 at 10:02 AM, David Goodwin <david at palepurple.co.uk> wrote:
>
> On 5 Jul 2012, at 09:14, Pat Lockley wrote:
>
>> isn't it more secure to run with less rights?
>
>
> Yes
>
>
>>
>> Maybe when running update prompt for another password?
>>
>
> You could.
>
>
>> At Nottingham they wouldn't let web site accounts have certain rights full stop.
>>
>
>
> Is XOT moving to use SQLite ? If so, the issue of rights becomes a non-issue.
>
> David.
>
>
>> On Thu, Jul 5, 2012 at 9:09 AM, David Goodwin <david at palepurple.co.uk> wrote:
>>> It ought to be possible to catch that error, should it occur - and write something out to the user like :
>>>
>>> "As of XOT version x.y the database user $db_user needs CREATE and ALTER rights to the $db_name database."
>>>
>>> David.
>>>
>>>
>>> On 4 Jul 2012, at 23:18, Pat Lockley wrote:
>>>
>>>> Ok, this might cause a few curveballs as the documentation says the database.php account is select,insert,update,delete but no alter or create rights?
>>>>
>>>> On 4 Jul 2012, at 22:57, David Goodwin <david at palepurple.co.uk> wrote:
>>>>
>>>>>
>>>>> On 4 Jul 2012, at 22:30, Pat Lockley wrote:
>>>>>
>>>>>> How do i add something to it?
>>>>>
>>>>> Just add a new function at the bottom of 'upgrade.php' - increment the number each time -
>>>>>
>>>>> i.e. function upgrade_1(), function upgrade_2(), function upgrade_3() etc etc.
>>>>>
>>>>> The script checks the 'config' table each time it runs to know which was the last update applied.
>>>>>
>>>>> If there are any functions defined with a higher number (E.g. upgrade_4()) then it'll run them in order, and update the config table afterwards.
>>>>>
>>>>>>
>>>>>> Does site details need a "version" number?
>>>>>>
>>>>>
>>>>> It already exists - in the 'config' table, which upgrade.php will create if it doesn't already exist.
>>>>>
>>>>> thanks
>>>>>
>>>>> David.
>
> Pale Purple Ltd.  (Company No: 5580814)
> 'Business Web Application Development and Training in PHP'
>
> http://www.palepurple.co.uk
> Office: 0845 0046746     Mobile: 07792380669
>
> Follow us on Twitter: @PalePurpleLtd
>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>
> 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.
>