util  Diff

Differences From Artifact [5c0a7396a9]:

• File wgsync/src/wgsync.c — part of check-in [a1d7d9de5e] at 2025-04-15 10:28:43 on branch trunk — fix idiot typo (user: lexi, size: 12670) [annotate] [blame] [check-ins using]

To Artifact [1052d70b26]:

• File wgsync/src/wgsync.c — part of check-in [ba636ffe3d] at 2026-05-22 11:58:06 on branch trunk — fix bugs found by qwen3.6-35a3b (user: lexi, size: 12711) [annotate] [blame] [check-ins using]

   451    451   	char* connstr = getenv("wgsync_conn");
   452    452   	if(connstr == null) _fatal("no connection string supplied");
   453    453   	PGconn* db = PQconnectdb(connstr);
   454    454   	if(PQstatus(db) != CONNECTION_OK) 
   455    455   		_fatal(PQerrorMessage(db));
   456    456   
   457    457   	PGresult* q_get_hosts = PQprepare(db, "get_hosts",
   458         -		"select h.ref, array_remove("
          458  +		"select h.ref, h.public_key, h.preshared_key, array_remove("
   459    459   		/* "select h.ref, array_remove(array_agg(wgv4::inet) ||" */
   460    460   		                        "array_agg(wgv6::inet), null)"
   461    461   			"from ns, hostref h "
   462         -			"where ns.host = h.host and kind = 'pubkey' "
          462  +			"where ns.host = h.host and kind in ('pubkey', 'psk') "
   463    463   			" group by h.host, h.ref;", 0, null);
   464    464   		/*"select ns.wgv4::inet, ns.wgv6::inet, h.ref from ns "
   465    465   			"right join hostref h "
   466    466   				"on h.host = ns.host "
   467    467   			"where h.kind = 'pubkey';"*/
   468    468   	if(!(q_get_hosts && PQresultStatus(q_get_hosts) == PGRES_COMMAND_OK))
   469    469   		_fatal(PQerrorMessage(db));