[Demelerlab] Canada databases

[Borries Demeler]

Thanks for everything, Emre! Glad to see our server back in production.
-Borries

On Sat, Oct 25, 2025 at 12:56 PM Emre Brookes <emre.brookes at mso.umt.edu>
wrote:

> Note demeler9 was also updated to the latest 'main' branch.
>
> -e.
>
>
> 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
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.biophysics.uleth.ca/pipermail/demelerlab/attachments/20251025/12c39af0/attachment.html>