Колдонуучу:OBM

Credentials

Time4VPS Credentials: ip: 212.24.105.57 password: ltY7-3r3JG

[email protected]
password: nomad80
password Bcrypt: $2y$10$ffasPys/pAdN/L238u8qR.BRefIkjfSzbr7g7SqeFVVcj.z1bU5.m

Hadad_Kyrgyzstan_2023_admin wtqpo6l9hue HadadKG2023_admin rtloa9p2pk hadad_kg_2023_admin ko1mr6f50yq ko1mr6f50yq

supervisor:$apr1$hiSqvlzO$dJ58.6Fh6iM0CaP9Q4vIr0

u6FlT45ntxF8DPfQ1AQG19pk3t12nbiX

Iv2EzvMDuN2fGUp-Tdx2KLH2262saWzd
BIOMAPS_POSTGRES_PASSWORD=dZVye8oV1IsOGLUzDQJ_MWo4_6bmBzHK
GISDATA_POSTGRES_PASSWORD=dZVye8oV1IsOGLUzDQJ_MWo4_6bmBzHK

server (container) openbiomaps_biomaps_db_1;
db_name = biomaps
db_user = biomapsadmin
BIOMAPS_DB_PASSWORD=5Al9DAG6yZY4mVJSluvzauMlysJ5k-ZP

MAINPAGE_ADMIN_PASSWORD=AtOn1WM7375J_-G65pGp6GvLSIwqWLdR
SABLON_ADMIN_PASSWORD=RALAyWa7FbztB7uNmDPGmhpHJdP6_SUl
SABLON_HASH=J5AE2l-3 ~

Create new project's logs

hadad_kg_2023 admin already exists! Skipping. SQL: Create taxon list function done. SQL: Create taxon name update function done. SQL: Create history function done. SQL: Create data table done. SQL: Create data-exports table done. SQL: Create data-rules table done. SQL: Create data-history table done. SQL: Create default data headers done. SQL: Create project admin done. SQL: Create taxon name table done. Creating project folder: done Creating project config file: done Creating project folders: js ok css ok includes ok images ok jobs ok jobs/run ok local ok local/includes ok local/mapserver ok local/attached_files ok oauth ok pds ok local/uploads ok local/uploads/datafiles ok styles ok Copying root files: Copying app-style files: done Copying js files: done Copying css files: done Copying image files: done Copying includes (libs) files: done Copying authentication layer files: done Copying API layer files: done Copying JOB files: 1 error Copying template files: Configuring .htaccess file...done. The base path can vary depending on the global settings, if the AJAX is not reachable you need to modify the base path in .htaccess file. 13 files copied Configuring mapserver: Update your map files! Registering default modules: Modules error: ERROR: column "new_params" of relation "modules" does not exist LINE 1: ...ct_table, path, module_name, enabled, main_table, new_params... ^

The project is accessible, however some more basic settings needed after you logged in first time. Follow this link to leave this database and login to your new database:

   hadad_kg_2023

Create new project's logs

SQL: 'hadad_kg_2023_admin' created with password 'ko1mr6f50yq' done. This user can connect to the PostgreSQL database. Save this account informations. SQL: Create taxon list function done. SQL: Create taxon name update function done. SQL: Create history function done. SQL error: ERROR: syntax error at or near "&" LINE 19: date&time timestamp without time zone, ^ SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = public, pg_catalog; SET default_tablespace = ; SET default_with_oids = false; CREATE TABLE hadad_kg_2023 ( obm_id integer NOT NULL, obm_geometry geometry, obm_datum timestamp with time zone, obm_uploading_id integer, obm_validation numeric, obm_comments text[], obm_modifier_id integer, obm_files_id character varying(32), species text, date&time timestamp without time zone, Individual ID text, observer full name(s) text, Team ID text, Oblast (Province) text, Place name text, GPS Coordinate N numeric, GPS Coordinate E numeric, Place Altitude numeric, Individual's Gender text, Individual's Age numeric, Individual's Direction (azimuth) numeric, Individual's Porches Quantity integer, Individual's Partner ID text, Nest ID text, Nest Status text, Nest altitude numeric, Nest material text, Nest Level text, Nest exposure text, Nest slope degree integer, Nest size text, Nest eggs quantity integer, Nest chicks quantity integer, Nest Prey Leftovers text, Nest comments text, Weather Status text, Weather Percipitation text, Weather Wind Direction text, Photo-Video Link text, Other Findings text, Summary text, CONSTRAINT enforce_dims_obm_geometry CHECK ((st_ndims(obm_geometry) = 2)), CONSTRAINT enforce_geotype_obm_geometry CHECK (((geometrytype(obm_geometry) = 'POINT'::text) OR (geometrytype(obm_geometry) = 'LINE'::text) OR (geometrytype(obm_geometry) = 'POLYGON'::text) OR (obm_geometry IS NULL))), CONSTRAINT enforce_srid_obm_geometry CHECK ((st_srid(obm_geometry) = 4326)) ); COMMENT ON TABLE hadad_kg_2023 IS 'user defined table:Valaki Valahol'; COMMENT ON COLUMN hadad_kg_2023.Individual's Direction (azimuth) IS 'An azimuth is the direction measured in degrees clockwise from north on an azimuth circle. An azimuth circle consists of 360 degrees. Ninety degrees corresponds to east, 180 degrees is south, 270 degrees is west, and 360 degrees and 0 degrees mark north.'; COMMENT ON COLUMN hadad_kg_2023.Individual's Partner ID IS 'Partners occur usually in pair for reproduction.'; COMMENT ON COLUMN hadad_kg_2023.Nest Level IS 'Upper, middle, lower position relatively to nest holding object such as rock, tree, etc'; COMMENT ON COLUMN hadad_kg_2023.Nest size IS 'may be approximate'; CREATE SEQUENCE hadad_kg_2023_obm_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE hadad_kg_2023_obm_id_seq OWNED BY hadad_kg_2023.obm_id; ALTER TABLE ONLY hadad_kg_2023 ALTER COLUMN obm_id SET DEFAULT nextval('hadad_kg_2023_obm_id_seq'::regclass); ALTER TABLE ONLY hadad_kg_2023 ALTER COLUMN obm_datum SET DEFAULT now(); ALTER TABLE ONLY hadad_kg_2023 ADD CONSTRAINT hadad_kg_2023_pkey PRIMARY KEY (obm_id); CREATE INDEX hadad_kg_2023_obm_geometry_idx ON hadad_kg_2023 USING gist (obm_geometry); CREATE INDEX hadad_kg_2023_obm_uploading_id_idx ON hadad_kg_2023 USING btree (obm_geometry); DROP TRIGGER IF EXISTS history_update_hadad_kg_2023 ON public.hadad_kg_2023; CREATE TRIGGER history_update_hadad_kg_2023 AFTER DELETE OR UPDATE ON hadad_kg_2023 FOR EACH ROW EXECUTE PROCEDURE history_hadad_kg_2023(); ALTER TABLE hadad_kg_2023 DISABLE TRIGGER history_update_hadad_kg_2023; DROP TRIGGER IF EXISTS taxon_update_hadad_kg_2023 ON public.hadad_kg_2023; CREATE TRIGGER taxon_update_hadad_kg_2023 BEFORE INSERT ON hadad_kg_2023 FOR EACH ROW EXECUTE PROCEDURE update_hadad_kg_2023_taxonlist(); ALTER TABLE hadad_kg_2023 DISABLE TRIGGER taxon_update_hadad_kg_2023; CREATE TRIGGER file_connection AFTER INSERT ON hadad_kg_2023 FOR EACH ROW EXECUTE PROCEDURE file_connect_status_update(); ALTER TABLE hadad_kg_2023 DISABLE TRIGGER file_connection; ALTER TABLE ONLY hadad_kg_2023 ADD CONSTRAINT obm_uploading_id FOREIGN KEY (obm_uploading_id) REFERENCES system.uploadings(id); ALTER TABLE public.hadad_kg_2023 OWNER TO hadad_kg_2023_admin;