[Xerte] Re: moving database servers

[Pat Lockley]

Guessing this might be a bug.

At the bottom of confit.php is a block of code to handle sessions being put into the database. If you are using single sign on for noodle you don't need it.

So try taking it out.

On 17 Sep 2011, at 11:28, Dan Attwood <danattwood at gmail.com> wrote:

> Hi I have moodle and xerte running together with integrated sign on. It was set up with apache and mysql on the same windows 2008 server. I have now had to move the database to a separate server due to performance issues with moodle.
> 
> I've changed the settings in database.php to point to the new mysql server and confirmed it works by altering the password to lock it out. I'm getting the following error though:
> 
> Sorry, the system cannot connect to the database at present. The mysql error is
> Session Replace: Table 'xerte.mdl_sessions2' doesn't exist
> 
> the mdl_session2 table does exist on the moodle database though which is where is should be.
> 
> Any idea on how to resolve this?
> 
> 
> 
> 
> 
> 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.
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20110917/08ec13fc/attachment.html>