Page MenuHomeDevCentral
Feed All Stories

Sat, Feb 7

dereckson committed rOPS0dfc69538776: Build fbsql with BSD make (authored by dereckson).
Build fbsql with BSD make
Sat, Feb 7, 13:45
dereckson accepted D3912: Build fbsql with BSD make.
Sat, Feb 7, 13:41
dereckson added a comment to D3912: Build fbsql with BSD make.
Complector
$ salt windriver state.apply roles/viperserv/fbsql
windriver:                                                                                                                                                                                                                                     
----------                                                                                                                                                                                                                                     
          ID: fbsql_repo                                                                                                                                                                                                                       
    Function: file.directory                                                                                                                                                                                                                   
        Name: /opt/fbsql                                                                                                                                                                                                                       
      Result: True                                                                                                                                                                                                                             
     Comment: The directory /opt/fbsql is in the correct state                                                                                                                                                                                 
     Started: 13:38:21.046436                                                                                                                                                                                                                  
    Duration: 19.35 ms                                                                                                                                                                                                                         
     Changes:                                                                                                                                                                                                                                  
----------                                                                                                                                                                                                                                     
          ID: fbsql_repo                                                                                                                                                                                                                       
    Function: git.latest                                                                                                                                                                                                                       
        Name: https://devcentral.nasqueron.org/source/fbsql.git
      Result: True                                                                                                                                                                                                                             
     Comment: https://devcentral.nasqueron.org/source/fbsql.git was fetched, resulting in updated refs. Repository was fast-forwarded to remote HEAD (fda64dc).
     Started: 13:38:21.094531
    Duration: 2715.47 ms
     Changes:                                
              ----------                                   
              revision:     
                  ----------
                  new:                                                                                                 
                      fda64dc4e58ad764fb1b1900a69071ab8506e109
                  old:                                                                                                 
                      33ab3b29e9cb19871c7e69b342bcef0b8f2121cc
----------               
          ID: fbsql_build                      
    Function: cmd.run                                      
        Name: make                                                                                                     
      Result: True              
     Comment: Command "make" run
     Started: 13:38:23.813914
    Duration: 3066.909 ms             
     Changes:                                
              ----------                      
              pid:                                                                                                     
                  87837                                                                                                
              retcode:                                                                                                 
                  0                               
              stderr:                                                                                                                                                                                                                          
                  fbsql.c:556:19: warning: cast to smaller integer type 'int' from 'ClientData' (aka 'void *') [-Wvoid-pointer-to-int-cast]
                    556 |         int sql_number = (int)sql_word;                                                      
                        |                          ^~~~~~~~~~~~~                                                                                                                                                                               
                  fbsql.c:599:1: warning: a function definition without a prototype is deprecated in all versions of C and is not supported in C23 [-Wdeprecated-non-prototype]
                    599 | WaitVariableProc(clientData, interp, name1, name2, flags)
                        | ^                                                                                                                                                                                                                    
                  fbsql.c:610:5: warning: a function definition without a prototype is deprecated in all versions of C and is not supported in C23 [-Wdeprecated-non-prototype]
                    610 | int fbWaitCmd(clientData, interp, argc, argv)
                        |     ^                                                                                                                                                                                                                
                  fbsql.c:680:53: warning: cast to 'ClientData' (aka 'void *') from smaller integer type 'int' [-Wint-to-void-pointer-cast]                                                                                                    
                    680 |                         Tcl_CreateCommand (interp, command_name, SqlCmd, (ClientData) i, (Tcl_CmdDeleteProc*) NULL);
                        |                                                                          ^~~~~~~~~~~~~~
                  4 warnings generated.                    
              stdout:                                                                                                                                                                                                                          
                  cc  -O2 -pipe -Wall -fPIC -I/usr/local/include/mysql -I/usr/local/include/mysql/mysql -I/usr/local/include/tcl8.6 -c fbsql.c -o fbsql.o
                  ld -o fbsql.so    -lz -shared -L/usr/local/lib/mysql/ -lmariadb -L /usr/lib -L /usr/local/lib
----------
          ID: /srv/viperserv/lib/fbsql.so
    Function: file.symlink
      Result: True
     Comment: Symlink /srv/viperserv/lib/fbsql.so is present and owned by viperserv:nasqueron-irc
     Started: 13:38:26.881347
    Duration: 3.204 ms
     Changes:   
Sat, Feb 7, 13:40
dereckson requested review of D3912: Build fbsql with BSD make.
Sat, Feb 7, 13:36
dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Dev on the good-first-issue board.
Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson moved T2213: Ensure fbsql still compile with C23 standard from Working on to Debt on the Dæghrefn board.
Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to General bug & features on the C board.
Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson updated the task description for T2213: Ensure fbsql still compile with C23 standard.
Sat, Feb 7, 12:57 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson placed T2213: Ensure fbsql still compile with C23 standard up for grabs.

The extension now compiles, links and works fine with D3910 and D3911.

Sat, Feb 7, 12:54 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson committed rFBSQLfda64dc4e58a: Allow make to build on FreeBSD natively (authored by dereckson).
Allow make to build on FreeBSD natively
Sat, Feb 7, 12:46
dereckson closed D3911: Allow make to build on FreeBSD natively.
Sat, Feb 7, 12:46
dereckson committed rFBSQLdb879ca2ffe4: Avoid const char** to char** now invalid pointer convert (authored by dereckson).
Avoid const char** to char** now invalid pointer convert
Sat, Feb 7, 12:46
dereckson closed D3910: Avoid const char** to char** now invalid pointer convert.
Sat, Feb 7, 12:46
dereckson accepted D3911: Allow make to build on FreeBSD natively.

Note we don't have an error handling if mysql_config fails, but that would mainly mean MySQL client library isn't installed (or the -dev/-devel package on Linux distros).

Sat, Feb 7, 12:44
dereckson accepted D3910: Avoid const char** to char** now invalid pointer convert.
Sat, Feb 7, 12:43
dereckson requested review of D3911: Allow make to build on FreeBSD natively.
Sat, Feb 7, 12:36
dereckson added a revision to T2213: Ensure fbsql still compile with C23 standard: D3910: Avoid const char** to char** now invalid pointer convert.
Sat, Feb 7, 12:27 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson requested review of D3910: Avoid const char** to char** now invalid pointer convert.
Sat, Feb 7, 12:27
dereckson renamed T2213: Ensure fbsql still compile with C23 standard from Ensure fbsql still compile for TCL 8.6.17 to Ensure fbsql still compile with C23 standard.
Sat, Feb 7, 12:23 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson added a comment to T2213: Ensure fbsql still compile with C23 standard.

Submitted the fbsql.c and compilation log to Claude Sonnet 4.5

Sat, Feb 7, 12:22 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson awarded T2213: Ensure fbsql still compile with C23 standard a Y So Serious token.
Sat, Feb 7, 11:45 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson moved T2212: Move eggdrops from Ysul to WindRiver from Backlog to Working on on the Dæghrefn board.

Vault credentials provisioned, eggdrop installed

Sat, Feb 7, 11:44 · Operations sprints (Echoes in the Void), Salt, IRC, Dæghrefn, Servers
dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Services / Features on the DBA board.
Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Eggdrop dev on the IRC board.
Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson moved T2213: Ensure fbsql still compile with C23 standard from Backlog to Working on on the Dæghrefn board.
Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson triaged T2213: Ensure fbsql still compile with C23 standard as High priority.
Sat, Feb 7, 11:40 · good-first-issue, C, DBA, IRC, Dæghrefn
dereckson updated the task description for T2212: Move eggdrops from Ysul to WindRiver.
Sat, Feb 7, 11:25 · Operations sprints (Echoes in the Void), Salt, IRC, Dæghrefn, Servers
dereckson added a comment to T2212: Move eggdrops from Ysul to WindRiver.

Unit account done, next step: Vault credentials

Sat, Feb 7, 11:11 · Operations sprints (Echoes in the Void), Salt, IRC, Dæghrefn, Servers
dereckson updated the task description for T2212: Move eggdrops from Ysul to WindRiver.
Sat, Feb 7, 11:11 · Operations sprints (Echoes in the Void), Salt, IRC, Dæghrefn, Servers
dereckson triaged T2212: Move eggdrops from Ysul to WindRiver as Normal priority.
Sat, Feb 7, 10:50 · Operations sprints (Echoes in the Void), Salt, IRC, Dæghrefn, Servers

Fri, Feb 6

dereckson committed rOPSf05718f676d0: Split Postfix configuration (authored by DorianWinty).
Split Postfix configuration
Fri, Feb 6, 18:24
dereckson closed D3630: Split Postfix configuration.
Fri, Feb 6, 18:24
dereckson updated the diff for D3630: Split Postfix configuration.

Rebased against origin/main. Removed extraneous white lines.

Fri, Feb 6, 18:23
dereckson updated the diff for D3897: Always enable route to 172.27.27.0/24.

Document service variavbles

Fri, Feb 6, 18:19
dereckson updated the diff for D3897: Always enable route to 172.27.27.0/24.

Rebased against origin/main. Whiteline issues.

Fri, Feb 6, 18:15
dereckson committed rOPSc9df49a3cecc: Static UID and GID (authored by Duranzed).
Static UID and GID
Fri, Feb 6, 18:12
dereckson closed D3903: Static UID and GID.
Fri, Feb 6, 18:12
dereckson accepted D3903: Static UID and GID.
Fri, Feb 6, 18:12
dereckson abandoned D3900: Create user Yousra.

Superseded by D3902.

Fri, Feb 6, 18:11
dereckson added a comment to D3896: Add user ptdradmin to nasqueron-dev-docker group.

For future reference, write access to the repository requires to use SSH.
In your local rOPS copy, edit .git/config and swap URL from https://devcentral.nasqueron.org/source/operations.git to ssh://vcs@devcentral.nasqueron.org:5022/source/operations.git

Fri, Feb 6, 18:09
dereckson committed rOPSb4f505d19a77: Add user ptdradmin to nasqueron-dev-docker group (authored by ptdradmin).
Add user ptdradmin to nasqueron-dev-docker group
Fri, Feb 6, 18:06
dereckson closed D3896: Add user ptdradmin to nasqueron-dev-docker group.
Fri, Feb 6, 18:06
dereckson closed D3909: Fix typo.
Fri, Feb 6, 18:06
dereckson committed rOPS186cc088a02f: Fix typo (authored by dereckson).
Fix typo
Fri, Feb 6, 18:06
dereckson accepted D3909: Fix typo.
Fri, Feb 6, 18:05
dereckson requested review of D3909: Fix typo.
Fri, Feb 6, 18:05
ptdradmin updated the diff for D3908: Deploy Anubis for DevCentral.

Summary: Refactored Anubis deployment according to review feedback.

  • Moved to roles/paas-docker/anubis/init.sls
  • Fixed pillar indentation and schema
  • Added dynamic port detection from docker_containers
  • Switched metrics to UNIX socket
  • Simplified provisioning script for Vault only
  • Cleaned up bot policies

.

  • Refactor Anubis deployment based on review feedback. Highlights: fixed pillar indentation, moved to init.sls, added dynamic port detection, and configured metrics socket.
Fri, Feb 6, 17:50
dereckson awarded D3908: Deploy Anubis for DevCentral a Y So Serious token.
Fri, Feb 6, 17:44
dereckson added a revision to T2193: Investigate Anubis: D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 17:44 · Servers, Operations sprints (Echoes in the Void), Product evaluation, Alkane, DevCentral
dereckson updated the summary of D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 17:44
dereckson moved T2193: Investigate Anubis from Backlog to To watch on the Alkane board.
Fri, Feb 6, 17:41 · Servers, Operations sprints (Echoes in the Void), Product evaluation, Alkane, DevCentral
dereckson moved T2193: Investigate Anubis from Backlog to Working on on the Operations sprints (Echoes in the Void) board.
Fri, Feb 6, 17:41 · Servers, Operations sprints (Echoes in the Void), Product evaluation, Alkane, DevCentral
dereckson assigned T2193: Investigate Anubis to ptdradmin.
Fri, Feb 6, 17:41 · Servers, Operations sprints (Echoes in the Void), Product evaluation, Alkane, DevCentral
dereckson requested changes to D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 17:32
ptdradmin reclaimed D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 17:05
ptdradmin added a comment to D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 17:04
ptdradmin abandoned D3908: Deploy Anubis for DevCentral.

Doublon de D3908

Fri, Feb 6, 17:04
ptdradmin abandoned D3907: Deploy Anubis for DevCentral Summary: Integrated Anubis as a WAF/Reverse Proxy for DevCentral to secure traffic and challenge AI scrapers. Added Salt states, templates, and documentation. Test Plan: Verified on dwellers.nasqueron.drake: - Service....

Doublon de D3908

Fri, Feb 6, 17:03
ptdradmin added a comment to D3896: Add user ptdradmin to nasqueron-dev-docker group.

@Derekson J'ai essayé de faire un arc land mais je reçois une erreur 403 (Permission refusée). pouvez-vous 'lander' cette révision pour moi ? Merci !

Fri, Feb 6, 16:59
ptdradmin added a comment to D3896: Add user ptdradmin to nasqueron-dev-docker group.
Fri, Feb 6, 16:58
ptdradmin updated the diff for D3908: Deploy Anubis for DevCentral.

\

Fri, Feb 6, 16:38
ptdradmin updated the diff for D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 16:36
ptdradmin requested review of D3908: Deploy Anubis for DevCentral.
Fri, Feb 6, 16:32
ptdradmin requested review of D3907: Deploy Anubis for DevCentral Summary: Integrated Anubis as a WAF/Reverse Proxy for DevCentral to secure traffic and challenge AI scrapers. Added Salt states, templates, and documentation. Test Plan: Verified on dwellers.nasqueron.drake: - Service....
Fri, Feb 6, 16:11
Duranzed updated subscribers of T2208: Installation and configuration Quagga .
Fri, Feb 6, 11:59 · Secure HA tunnels
Duranzed renamed T2208: Installation and configuration Quagga from install and config Quagga to Install and config Quagga .
Fri, Feb 6, 11:59 · Secure HA tunnels
Duranzed edited the content of Project conventions.
Fri, Feb 6, 11:58
Duranzed set the icon for Secure HA tunnels to Infrastructure.
Fri, Feb 6, 11:40
Duranzed renamed Secure HA tunnels from Network to Secure HA tunnels.
Fri, Feb 6, 11:39
Duranzed renamed T2202: Pick solution for IPsec from Pick solution for IPSEC to Pick solution for IPsec.
Fri, Feb 6, 11:16 · documentation, Product evaluation, Secure HA tunnels
Duranzed renamed T2202: Pick solution for IPsec from Pick solution for tunnel to Pick solution for IPSEC.
Fri, Feb 6, 11:15 · documentation, Product evaluation, Secure HA tunnels
Duranzed renamed T2208: Installation and configuration Quagga from install and config Quaga to install and config Quagga .
Fri, Feb 6, 11:15 · Secure HA tunnels
Duranzed renamed T2207: Configure CARP for the main gateway from Configure CARP for the main gateway to Configure CARP for the main gateway and for GRE tunnel.
Fri, Feb 6, 11:13 · Secure HA tunnels
Duranzed renamed T2205: Authorize CARP on all routers from Autoriser CARP sur les routeurs to Authorize CARP on all routers .
Fri, Feb 6, 11:11 · Secure HA tunnels
Duranzed renamed T2209: Test trafic tcp/upd from Test trafic tce/upd to Test trafic tcp/upd.
Fri, Feb 6, 11:06 · Secure HA tunnels
Duranzed renamed T2206: Test for CARP Taffic from test for CARP Taffic to Test for CARP Taffic.
Fri, Feb 6, 11:03 · Secure HA tunnels
Duranzed renamed T2208: Installation and configuration Quagga from install ouaga and configure OSPF to install and config Quaga .
Fri, Feb 6, 11:01 · Secure HA tunnels
Duranzed updated the task description for T2204: Configure a CARP VHID for the shared virtual IP .
Fri, Feb 6, 10:56 · Secure HA tunnels
Duranzed updated the task description for T2203: Define IP range.
Fri, Feb 6, 08:18 · Secure HA tunnels
Duranzed updated the task description for T2202: Pick solution for IPsec.
Fri, Feb 6, 08:13 · documentation, Product evaluation, Secure HA tunnels
Duranzed updated the task description for T2201: GRE tunnel creation .
Fri, Feb 6, 08:12 · Secure HA tunnels

Thu, Feb 5

dereckson added a comment to T2175: Update mw to launch maintenance/run.php.

@Duranzed next step: run the final deployment on Complector (without the fix to deploy it under a temporary name)

Thu, Feb 5, 23:41 · good-first-issue, Mediawiki SaaS
dereckson moved T2196: Reload of dovecot and postfix when certif renew from Backlog to Ops on the good-first-issue board.
Thu, Feb 5, 23:39 · Restricted Project, good-first-issue, Nasqueron Operations Squad, Mail
dereckson moved T2211: Create a dark theme CSS for Agora from Backlog to Design on the good-first-issue board.
Thu, Feb 5, 23:39 · good-first-issue, design, Agora
dereckson updated the task description for T2196: Reload of dovecot and postfix when certif renew.
Thu, Feb 5, 23:38 · Restricted Project, good-first-issue, Nasqueron Operations Squad, Mail
dereckson placed T2196: Reload of dovecot and postfix when certif renew up for grabs.

With D3906, there is a way to do this easily, by adding the command to the certificate_options pillar in https://devcentral.nasqueron.org/source/operations/browse/main/pillar/core/certificates/hervil.sls$13

Thu, Feb 5, 23:36 · Restricted Project, good-first-issue, Nasqueron Operations Squad, Mail
dereckson triaged T2196: Reload of dovecot and postfix when certif renew as High priority.
Thu, Feb 5, 23:31 · Restricted Project, good-first-issue, Nasqueron Operations Squad, Mail
dereckson edited the content of Credits.
Thu, Feb 5, 23:29
dereckson added a comment to F23665567: profile.

Generated with Leonardo.

Thu, Feb 5, 23:29
dereckson set the image for Secure HA tunnels to F23665567: profile.
Thu, Feb 5, 23:27
dereckson added a comment to T2199: Unable to receive e-mail verification.

2025-02-05 ops office hours take:

  • Mailgun could be used as fallback for certificates issue
  • We need to update payment info at Mailgun to reactivate service in that case, as our account isn't active anymore
Thu, Feb 5, 23:21 · DevCentral, Mail
dereckson closed D3906: Automate acme.sh install-cert cmd.
Thu, Feb 5, 22:53
dereckson committed rOPSc9cb237e5e18: Automate acme.sh install-cert cmd (authored by DorianWinty).
Automate acme.sh install-cert cmd
Thu, Feb 5, 22:53
dereckson closed T2210: fullchain.pem isn't automatically generated by acme.sh as Resolved by committing rOPSc9cb237e5e18: Automate acme.sh install-cert cmd.
Thu, Feb 5, 22:53 · security, Mail
dereckson updated the summary of D3906: Automate acme.sh install-cert cmd.
Thu, Feb 5, 22:49
dereckson accepted D3906: Automate acme.sh install-cert cmd.
Thu, Feb 5, 22:35
dereckson added a comment to D3906: Automate acme.sh install-cert cmd.

Deployed to Hervil, we see we now have fullchain generated everywhere.

Thu, Feb 5, 22:35
dereckson updated the diff for D3906: Automate acme.sh install-cert cmd.

Fix spacing issues for jinja templating logic ; run under acme user ; use reloadcmd as parameter, not reload.

Thu, Feb 5, 22:33
DorianWinty requested review of D3906: Automate acme.sh install-cert cmd.
Thu, Feb 5, 22:04
DorianWinty added a revision to T2210: fullchain.pem isn't automatically generated by acme.sh: D3906: Automate acme.sh install-cert cmd.
Thu, Feb 5, 22:04 · security, Mail