[Demelerlab] Canada databases

[Borries Demeler]

Yup, you are correct. The problem was that the database still had the NRCH
hostname (localhost) set for Optima1 and Optima2. Now that our server is
running again, I had to change it back to demeler5.uleth.ca. I did that and
it works again, can you please try again?
-Borries

On Sat, Oct 25, 2025 at 5:36 PM Bird, Sophia <sophia.bird at uleth.ca> wrote:

> I am back on the cch database; however, this error appears when I open
> data acquisition.
>
> -Sophia
> ------------------------------
> *From:* Demelerlab <demelerlab-bounces at biophysics.uleth.ca> on behalf of
> Alexey Savelyev via Demelerlab <demelerlab at biophysics.uleth.ca>
> *Sent:* 25 October 2025 14:48
> *To:* Emre Brookes <emre.brookes at mso.umt.edu>; Borries Demeler <
> demeler at gmail.com>; demelerlab at biophysics.uleth.ca <
> demelerlab at biophysics.uleth.ca>
> *Subject:* Re: [Demelerlab] Canada databases
>
> Yes, that change is required for the dataDisk Pseudoabsorbance type to
> operate via GMP framework..
>
> There is a PR#20 for SQL repo.
>
> Alexey
>
> On 10/25/25 13:54, Emre Brookes wrote:
> > CCH and AUCCANADA have been moved back to demeler9.
> > Users should be able to resume normal work, albeit on the correct
> > servers now.
> >
> > Alexey - noted a sql difference on CCH on NRCH.
> > uslims3_CCH : differences dataSource enum in in autoflow &
> > autoflowHistory
> > <   `dataSource`
> > enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL
> > DEFAULT 'INSTRUMENT',
> > ---
> > >   `dataSource`
> >
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
>
> > NOT NULL DEFAULT 'INSTRUMENT',
> >
> > I made the equivalent uncommitted local change on
> > demeler9:~us3/lims/database/sql
> > $ git diff
> > diff --git a/us3.sql b/us3.sql
> > index 4706095..1f8be0a 100644
> > --- a/us3.sql
> > +++ b/us3.sql
> > @@ -117,7 +117,7 @@ CREATE  TABLE IF NOT EXISTS autoflow (
> >    devRecord   enum('NO', 'YES', 'Processed') NOT NULL,
> >    gmpReviewID int(11) NULL,
> >    expType enum('VELOCITY','ABDE') NOT NULL,
> > -  dataSource enum
> > ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT
> > 'INSTRUMENT',
> > +  dataSource enum
> >
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
>
> > NOT NULL DEFAULT 'INSTRUMENT',
> >    opticsFailedType varchar(300) NULL,
> >
> >    PRIMARY KEY (ID) )
> > @@ -159,7 +159,7 @@ CREATE  TABLE IF NOT EXISTS autoflowHistory (
> >    devRecord   enum('NO', 'YES', 'Processed') NOT NULL,
> >    gmpReviewID int(11) NULL,
> >    expType enum('VELOCITY','ABDE') NOT NULL,
> > -  dataSource enum
> > ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT
> > 'INSTRUMENT',
> > +  dataSource enum
> >
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
>
> > NOT NULL DEFAULT 'INSTRUMENT',
> >    opticsFailedType varchar(300) NULL,
> >
> >    PRIMARY KEY (ID) )
> >
> >
> >
> >
> > Borries Demeler wrote:
> >> Everyone:
> >> Now that we have our server back online thanks to Saeed's tireless
> >> efforts, I want to move the databases back to our server in Canada
> >> and disable the CCH and AUCCANADA databases on the NRCH server, so we
> >> can move them  back to the demeler9 server. I asked Emre to do that,
> >> and perhaps send us a short notice when he plans to do it. During
> >> this time please do not use the server on either server until we have
> >> the green light from Emre to use the server back in Canada again.
> >> Thanks! -Borries
> >
> _______________________________________________
> Demelerlab mailing list
> Demelerlab at biophysics.uleth.ca
> https://www.biophysics.uleth.ca/mailman/listinfo/demelerlab
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.biophysics.uleth.ca/pipermail/demelerlab/attachments/20251025/02404afa/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 131452 bytes
Desc: not available
URL: <http://www.biophysics.uleth.ca/pipermail/demelerlab/attachments/20251025/02404afa/attachment-0001.png>