Det kan se ut til ? v?re steder hvor sm? og store bokstaver behandles feil...

Vi la inn "SINT" i org.txt og som "drifter" i nettel.txt, server.txt og prefiks.txt.

Vi fikk da ikke opp noen bokser som vi kunne f? varslig fra eller sette "p? service". Vi pr?vde da f?rst med en boks og satte "drifter" til "sint", og da kom denne boksen med. Etterp? satte vi alle bokser med "drifter" lik "sint", og da kom alle bokser bortsett fra de i server.txt som har kategori lik "REST". Disse har ikke endret "Orgid", men har fremdeles store bokstaver.

Dette gjorde vi p? nav.uio.no, hvor "driftsversjonen" av NAV n? g?r. (Noen retter kanskje opp pekeren i metanav.ntnu.no/NAVlinks/ ?)

Vi pr?vde ogs? ? forandre "org" og "drifter" p? slange.uio.no (som n? er tenkt ? brukes til testing...) Her forandret vi org og drifter fra 333500 til sint, og ogs? her skiftet "drifter" fra 333500 til sint p? alle bokser bortsett fra de med kategori "REST". De har fremdeles 333500 som "Orgid". Her kom det imidlertid opp to valg n?r vi definerte brukerprofil, nemlig b?de 333500 og SINT, og n?r vi velger begge f?r vi med alle boksene.

P? nav.uio.no kom det ikke opp noe nytt valg n?r vi skiftet fra SINT til sint, der st?r det fremdeles bare SINT med store bokstaver.

Er dette noe som kan fikses? B?de dette med behandling av sm? og store bokstaver, og at vi f?r skiftet "Orgid" p? de boksene som har kategori "REST" i server.txt.

Dette siste kan kanskje ha noe med det problemet som Kjetil rapporterte tidligere, nemlig at vi f?r feilmelding ved datbaseoppdatering av samtlige "REST"-bokser. De er ikke dobbeltdefinert, og har heller ikke flere ip-adresser i DNS.

mvh <reierr>

PS. Etterf?gende utsnitt er fra loggen p? slange f?r vi forandret org fra 333500 til sint. Vi fikk ingen logg-melding n?r vi kj?rte kilde2db.pl manuelt. Kanskje det kommer andre meldinger i natt...

On Fri, 16 May 2003, Cron Daemon wrote:

Date: Fri, 16 May 2003 04:05:05 +0200 From: Cron Daemon root@slange.uio.no To: nav-log@usit.uio.no Subject: Cron navcron@slange $CDIR/fyll_db.pl

Fri May 16 04:05:03 2003 fyll_db.pl %RUN-7-START: Started running program "tekstfiler". Fri May 16 04:05:05 2003 fyll_db.pl %RUN-7-END: Ended running program "tekstfiler". Fri May 16 04:05:05 2003 fyll_db.pl %RUN-7-START: Started running program "bokser". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.162,aak-hf1.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.163,aak-hf2.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.200.56,otter,nullrom,333500,REST,testboks,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.20,aak-blv9.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.66,ull-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.67,ull-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.66,aak-sentrmidt.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.67,aak-sentrbibl.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.202,aak-observ.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.30,bli-rad,nullrom,333500,REST,ipmux,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.114,toy-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.34,sen-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.115,toy-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.36,sen-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.170,aak-sv.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.74,u22-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.75,u22-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.178,aak-ullevterr.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.34,aak-zeb.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.35,aak-fys.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.37,aak-ramme.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.210,aak-kino.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.122,obs-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.123,obs-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.2,aak-admin.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.3,aak-ub1.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.4,aak-ub2.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.82,s70-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.5,aak-sioblind.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.36.20,f3-ak01,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.83,s70-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.6,aak-drift.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.36.21,f3-ak02,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.36.22,f3-ak03,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.4,inf-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.36.23,f3-ak04,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.6,pre-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.186,aak-pre.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.8,pre-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.32.242,zoomus-ak,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.32.243,botmus-ak,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.10,fbu-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.11,fbu-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.13,fbu-rad,nullrom,333500,REST,ipmux,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.50,gmv-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.18,bli-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.51,gmv-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.90,b09-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.91,b09-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.59,fv3-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.194,aak-odont.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.18,aak-abel.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.50,aak-inf.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.19,aak-bio.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:05 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.51,aak-s70.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.178,arb-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.98,vik-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.52,aak-fp.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.179,arb-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.53,aak-cn.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.99,vik-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.20,bli-xyplex0,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.21,bli-xyplex1,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.199.98,aak-geo.ua,nullrom,333500,REST,ak-panel,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.106,stp-pabx,nullrom,333500,REST,PABX,public)". Fri May 16 04:05:06 2003 bokser.pl %DATABASE-3-ALREADY: Database record already exists. Could not "INSERT INTO boks (ip,sysname,romid,orgid,kat,kat2,ro) VALUES (129.240.101.107,stp-xyplex,nullrom,333500,REST,xyplex,public)". Fri May 16 04:05:07 2003 bokser.pl %DEVICE-7-COLLECT: Collecting data for "uio-gw7". Fri May 16 04:05:07 2003 bokser.pl %DEVICE-7-COLLECT: Collecting data for "uio-gw8".

<osv>