[Nix-dev] HYDRA_DATA

[Marco Maggesi]

Hi Rob,

I added

 environment.shellInit = ''
   export HYDRA_DATA=/home/hydra/data
   export HYDRA_DBI="dbi:Pg:dbname=hydra;host=localhost;user=hydra;";
 '';

and it seems to work perfectly.

Thank you,
Marco


2012/6/9 Rob Vermaas <rob.vermaas at gmail.com>:
> Hi Marco,
>
>> I just updated my hydra server with
>>  nix-channel --update
>>  nix-env --always -u \*
>>  nixos-rebuild switch
>>
>> If I run hydra-update-gc-roots I get the following error
>>
>> [hydra at o0dom0:/root]$ hydra-update-gc-roots
>> The HYDRA_DATA directory (/var/lib/hydra) does not exist!
>> Compilation failed in require at
>> /nix/store/lrmjyz3lbv54ym3fbbrb01isq3yzm1hr-hydra-0.1pre1059-ab4f091/libexec/hydra/lib/Hydra/Helper/Nix.pm
>> line 8.
>> BEGIN failed--compilation aborted at
>> /nix/store/lrmjyz3lbv54ym3fbbrb01isq3yzm1hr-hydra-0.1pre1059-ab4f091/libexec/hydra/lib/Hydra/Helper/Nix.pm
>> line 8.
>> Compilation failed in require at
>> /nix/store/lrmjyz3lbv54ym3fbbrb01isq3yzm1hr-hydra-0.1pre1059-ab4f091/bin/.hydra-update-gc-roots-wrapped
>> line 8.
>> BEGIN failed--compilation aborted at
>> /nix/store/lrmjyz3lbv54ym3fbbrb01isq3yzm1hr-hydra-0.1pre1059-ab4f091/bin/.hydra-update-gc-roots-wrapped
>> line 8.
>>
>> I'm pretty sure that it worked without errors before the update.
>> Hydra is configured through the nixos module as follows:
>>
>>  services.hydra = {
>>    enable = true;
>>    hydra = /nix/store/2a49h1zc3cydy97dyrv3ycfia087wwcy-hydra-0.1pre1058-fdf441a;
>>    hydraURL = "http://o0dom0.math.unifi.it/";ww
>>    notificationSender = "maggesi at math.unifi.it";
>>    user = "hydra";
>>    baseDir = "/home/hydra";
>>    dbi = "dbi:Pg:dbname=hydra;host=localhost;user=hydra;";
>>    minimumDiskFree = 3;
>>    minimumDiskFreeEvaluator = 1;
>>    #tracker = "<div>Dipartimento di Matematica Ulisse Dini</div>";
>>    autoStart = true;
>>  };
>>
>> (I manually set the exact path to the hydra derivation, i.e.,
>> /nix/store/2a49h1zc3cydy97dyrv3ycfia087wwcy-hydra-0.1pre1058-fdf441a
>> by looking at the installed default user environment after nix-env
>> --always -u \* )
>>
>> I tried to define HYDRA_DATA but then I got another error
>>
>> [hydra at o0dom0:~]$ export HYDRA_DATA=/home/hydra/data/
>>
>> [hydra at o0dom0:~]$ hydra-update-gc-roots
>> *** reading current roots...
>> *** looking for release members
>> DBIx::Class::ResultSet::search_literal(): DBI Exception:
>> DBD::SQLite::db prepare_cached failed: no such table: Builds [for
>> Statement "SELECT me.id, me.finished, me.timestamp, me.project,
>> me.jobset, me.job, me.nixname, me.description, me.drvpath, me.outpath,
>> me.system, me.longdescription, me.license, me.homepage,
>> me.maintainers, me.maxsilent, me.timeout, me.iscurrent,
>> me.nixexprinput, me.nixexprpath, me.priority, me.busy, me.locker,
>> me.logfile, me.disabled, me.starttime, me.stoptime, me.iscachedbuild,
>> me.buildstatus, me.errormsg, me.logsize, me.size, me.closuresize,
>> me.releasename, me.keep FROM Builds me WHERE ( exists (select 1 from
>> releasemembers where build = me.id) ) ORDER BY project, jobset, job,
>> id"] at /nix/store/lrmjyz3lbv54ym3fbbrb01isq3yzm1hr-hydra-0.1pre1059-ab4f091/bin/.hydra-update-gc-roots-wrapped
>> line 59
>>
>> Can you help me understand?
>
> It looks like the environment variables for the hydra login are not
> set properly in the nixos module. I can see this, as it is trying to
> use sqlite, which is the default database backend when no HYDRA_DBI is
> provided. The upstart jobs and cronjob shoudl get the appropriate
> environment variables. I haven't tested this, but you can probably
> use:
>
>  environment.shellInit = env;
>
> in the  hydra-module.nix that is part of hydra. Let me know if this
> works for you, then we can add it to the module.
>
> Cheers,
> Rob
>
>
> --
> Rob Vermaas
>
> [email] rob.vermaas at gmail.com