| 1 | 20:40:01.979 | | info | yii\db\Connection::open | Opening DB connection: pgsql:host=139.82.9.37;port=5432;dbname=zoom_audit_db |
| 2 | 20:40:02.006 | | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
COALESCE(td.typname, tb.typname, t.typname) AS data_type,
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
ELSE NULL
END AS enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey,
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
AND c.relname = 'audit_entry'
AND d.nspname = 'public'
ORDER BY
a.attnum; |
| 3 | 20:40:02.019 | | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='audit_entry'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum |
| 4 | 20:40:02.058 | | info | yii\db\Connection::open | Opening DB connection: pgsql:host=139.82.9.37;port=5432;dbname=zoom_db |
| 5 | 20:40:02.084 | | info | yii\db\Command::query | SELECT EXISTS(SELECT "meeting"."id" AS "id", "meeting"."start" AS "start", "meeting"."end" AS "end", "meeting"."recording" AS "recording", "meeting"."created_by" AS "created_by", "host"."id" AS "host_id", "meeting"."zoom_host_id" AS "zoom_host_id" FROM "meeting" LEFT JOIN "host" ON "meeting"."host_id" = "host"."id" WHERE "meeting"."status"='In Progress') |
| 6 | 20:40:02.089 | | info | yii\db\Command::query | SELECT "meeting"."id" AS "id", "meeting"."start" AS "start", "meeting"."end" AS "end", "meeting"."recording" AS "recording", "meeting"."created_by" AS "created_by", "host"."id" AS "host_id", "meeting"."zoom_host_id" AS "zoom_host_id" FROM "meeting" LEFT JOIN "host" ON "meeting"."host_id" = "host"."id" WHERE "meeting"."status"='In Progress' |
| 7 | 20:40:02.097 | | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
COALESCE(td.typname, tb.typname, t.typname) AS data_type,
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
ELSE NULL
END AS enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey,
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
AND c.relname = 'meeting'
AND d.nspname = 'public'
ORDER BY
a.attnum; |
| 8 | 20:40:02.119 | | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='meeting'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum |
| 9 | 20:40:02.136 | | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
COALESCE(td.typname, tb.typname, t.typname) AS data_type,
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
ELSE NULL
END AS enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey,
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
AND c.relname = 'user'
AND d.nspname = 'public'
ORDER BY
a.attnum; |
| 10 | 20:40:02.145 | | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='user'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum |
| 11 | 20:40:02.149 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 12 | 20:40:02.160 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 13 | 20:40:02.164 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 14 | 20:40:02.445 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/BTBf-rAGSM6MnERtdfFS8Q
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6IjUzMzQzZmYxLTk5ZWUtNDc5OC1iYzUwLTNkZjA3YmQ4YWFlZCJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDIsImNvZGUiOiJkWkVCc1Iza1NoR1AtTWZwVVFZYU1BTllXcjNQVVkxcWEiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODAyLCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDIsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.-ybXxtq7GVb2BZO7zjsmcoMUUcrU8jv9bOELwsumEXrTi82HtPDB39f6YUA2nQIQZIJSDi3UiNUdhKAMzWq2xw
{"type":2} |
| 15 | 20:40:02.852 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2699 |
| 16 | 20:40:02.859 | | info | yii\db\Command::query | INSERT INTO "audit_entry" ("route", "request_method", "created") VALUES ('zoom/add-licensed', 'CLI', '2024-11-28 20:40:02') RETURNING "id" |
| 17 | 20:40:02.864 | | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
COALESCE(td.typname, tb.typname, t.typname) AS data_type,
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
ELSE NULL
END AS enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey,
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
AND c.relname = 'audit_trail'
AND d.nspname = 'public'
ORDER BY
a.attnum; |
| 18 | 20:40:02.876 | | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='audit_trail'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum |
| 19 | 20:40:02.883 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2699', 'licensed', '2024-11-28 20:40:02'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2699', 'basic', '2024-11-28 20:40:02') |
| 20 | 20:40:02.887 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 21 | 20:40:02.890 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 22 | 20:40:02.893 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 23 | 20:40:03.490 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/KvTrF7CdTlyPSHTupsl-zg
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6IjcyOTc1NWRjLTZkZTktNGMxOC1hMDYyLWEyNTdhNzc0NzJjMSJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDMsImNvZGUiOiJub1dFT2FqcVE1R2luNTdUWk5wOXNRWWpBOFdGMzZ0dFQiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODAzLCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDMsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.LBsvmuBC0wXlxZqcVayac-kyWeXczvOB9mruE6eEkPHsqcUUUu8wFZ4Pp_xYWaB34m6UP9zk65hu0SMRxSPsdQ
{"type":2} |
| 24 | 20:40:04.198 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2698 |
| 25 | 20:40:04.203 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2698', 'licensed', '2024-11-28 20:40:04'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2698', 'basic', '2024-11-28 20:40:04') |
| 26 | 20:40:04.210 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 27 | 20:40:04.212 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 28 | 20:40:04.215 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 29 | 20:40:04.487 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/-xXOWIVLThKfKib8adW_GQ
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6IjU5MWJhMzE3LTU1YzQtNGZkMS04NWJiLWUzMzQ2MzNjY2ZhNCJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDQsImNvZGUiOiJxSlhrbW1ralRXU0Z1UnlxalRrX3BBS0VnNXU5OGpreVEiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA0LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDQsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.JeNtQ9KCh6EIhJfQVWF1hx9L2CqisWy7mAG6sHdBoHyPNJavXUrMpJdO2n683JhzmYvMFI9QGVOq77s6eF5yCQ
{"type":2} |
| 30 | 20:40:04.844 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2694 |
| 31 | 20:40:04.850 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2694', 'licensed', '2024-11-28 20:40:04'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2694', 'basic', '2024-11-28 20:40:04') |
| 32 | 20:40:04.855 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 33 | 20:40:04.859 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 34 | 20:40:04.864 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 35 | 20:40:05.133 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/zc9vWEmAQTmoJrmd0R9yww
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6ImE1Y2FiMDI1LTU1N2YtNGQwMS05NDQ0LTcxMDNlZGQ4MjgyZSJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDUsImNvZGUiOiJMY01FNk9uNFRpS2NxM0xoU25jMEx3UmhXcHQ4Qkl6MUwiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA1LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDUsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.W_4gmKxyBrQiJ_jQmsOLvhTOt0NEIThPVKBOfxV-q3axYZrxqM8iNvhgfnMGJgcrrfq88Zio_EygzfQXE9NNGA
{"type":2} |
| 36 | 20:40:05.510 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2697 |
| 37 | 20:40:05.515 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2697', 'licensed', '2024-11-28 20:40:05'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2697', 'basic', '2024-11-28 20:40:05') |
| 38 | 20:40:05.521 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 39 | 20:40:05.524 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 40 | 20:40:05.528 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 41 | 20:40:05.813 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/IeqnIHZpRHeOxRO0IU4eYg
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6ImI4ZmI1ODc5LTJmZTYtNDU2Yy05OWRkLWU2YmUwODZjNTY5MCJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDUsImNvZGUiOiJBSGJ1eU9mY1IyZW5IQUU1b3JnSnlnM0xHbmtrZGRSM3UiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA1LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDUsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.MPNGPU94pqNvKkYHtdP9m1uGhuk2a5kt64q0ZsVQ9P2HyxTv0dmXJ8K7n64TRwU7Ssf_Xy6gm60L-UZKnoG-ag
{"type":2} |
| 42 | 20:40:06.231 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2693 |
| 43 | 20:40:06.237 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2693', 'licensed', '2024-11-28 20:40:06'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2693', 'basic', '2024-11-28 20:40:06') |
| 44 | 20:40:06.242 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 45 | 20:40:06.244 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 46 | 20:40:06.248 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 47 | 20:40:06.528 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/v9UYp0eJRISyyNZWzCULHw
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6Ijg3NDU4MzA0LTRlNTAtNDQ1MS04Mjk4LWRiNGEyM2JkYTE1ZiJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDYsImNvZGUiOiJ3ZGE4b2lDZ1NCS0xXd3FOaENTRFVBRndZako2OFJ5TjkiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA2LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDYsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.pRGk2OhiIypmD2VLoMx9-x3Ikj1W5t6ueT0p8h8sXawAX7S-jA4xxQz3PUc7YQMhUQFZQIzlp5JnVpswTzb8bA
{"type":2} |
| 48 | 20:40:06.882 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2692 |
| 49 | 20:40:06.887 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2692', 'licensed', '2024-11-28 20:40:06'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2692', 'basic', '2024-11-28 20:40:06') |
| 50 | 20:40:06.891 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 51 | 20:40:06.894 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 52 | 20:40:06.898 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 53 | 20:40:07.175 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/ssNqKpNFSYyfpgwhVMYhXg
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6IjEyZmVkMjJiLTZhYzYtNGM5NC04YWFhLWY0ZjBjYzY3M2Q0OCJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDcsImNvZGUiOiJBdGRPdXZpaFRWYWFXSDRVUWVMT19Bc2FKSHVVSmM0ODMiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA3LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDcsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.8NOEmn6ICdegUemgkP2wYfqsoy2Fz8fcHp6VDOZeDKlttgK1XH2Qf1NxpR4OhcVkOvfwBlMo-SgHYTOxExr8cw
{"type":2} |
| 54 | 20:40:07.540 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2696 |
| 55 | 20:40:07.546 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2696', 'licensed', '2024-11-28 20:40:07'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2696', 'basic', '2024-11-28 20:40:07') |
| 56 | 20:40:07.550 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 57 | 20:40:07.554 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 58 | 20:40:07.558 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 59 | 20:40:07.846 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/CAmqmtpSTzey0zXSXjoqAw
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6IjE3MzQ4MjlhLWJiZDYtNDkzNi05NjEzLTAyZTkwODNlNmU3YSJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDcsImNvZGUiOiJmSUNqZ01VaFNSbW1DaWF2Y3pJRVdBVDB4dDYxVDVmUVIiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA3LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDcsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.G-Cts6k4LBbxXyahvtWBMrY12mrLuDgjlWOldbQ5Bc_YuwGmkiY9S8jBtLOWMko9i9uQ2ejZv1KEkycK3-vQ_w
{"type":2} |
| 60 | 20:40:08.212 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2700 |
| 61 | 20:40:08.217 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2700', 'licensed', '2024-11-28 20:40:08'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2700', 'basic', '2024-11-28 20:40:08') |
| 62 | 20:40:08.222 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "id"=4 |
| 63 | 20:40:08.226 | | info | yii\db\Command::query | SELECT * FROM "user" WHERE "crontab_ip"=0 |
| 64 | 20:40:08.229 | | info | yii\httpclient\StreamTransport::send | POST https://zoom.us/oauth/token
Host: zoom.us
Authorization: Basic UnRpM01COWdROFduTW03QVV5RUtCZzpEcW5ocGNSRXNDa014aWZQeFZLODB6cGU2ZUI0UjI3SQ==
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
grant_type=account_credentials&account_id=tlFjyDPZSOqMAv7HVd-Ddg |
| 65 | 20:40:08.506 | | info | yii\httpclient\StreamTransport::send | PATCH https://api.zoom.us/v2/users/xKF4p-ISStWUkQJuUXbwgQ
Content-Type: application/json; charset=UTF-8
Authorization: Bearer eyJzdiI6IjAwMDAwMiIsImFsZyI6IkhTNTEyIiwidiI6IjIuMCIsImtpZCI6IjI2ZTU4ZjE4LWE1OTQtNDkxZS1hMTdjLWFmMWUwNGUxZTI4MyJ9.eyJhdWQiOiJodHRwczovL29hdXRoLnpvb20udXMiLCJ1aWQiOiI3dzNpR0FCd1F4bWtLTTMtaGFjY0tBIiwidmVyIjoxMCwiYXVpZCI6IjFjY2FiN2YwOTQ4MDkwZmM1ZmUxNGFhMWVjM2I5YWJjNGQ2YzY2NGVhYTExNjkxODRmY2VmZWQxZWI1OTI0MTIiLCJuYmYiOjE3MzI4MzcyMDgsImNvZGUiOiI3U1JqVmF1UFNzR1QyUmJaMzNiM1VRZDJ4bmM0alBFS0YiLCJpc3MiOiJ6bTpjaWQ6UnRpM01COWdROFduTW03QVV5RUtCZyIsImdubyI6MCwiZXhwIjoxNzMyODQwODA4LCJ0eXBlIjozLCJpYXQiOjE3MzI4MzcyMDgsImFpZCI6InRsRmp5RFBaU09xTUF2N0hWZC1EZGcifQ.sK95jr15Xv5cG0GNFKE8ws43pAGrlxzMXDlSvxMJkMeF0XT51PSkIjfEtyvUxNEw977Wx42iEiWyrztvIBMBtg
{"type":2} |
| 66 | 20:40:08.886 | | info | yii\db\Command::execute | UPDATE "meeting" SET "basic"=0, "licensed"=1, "updated_by"=NULL, "updated_at"=1732837202 WHERE "id"=2695 |
| 67 | 20:40:08.891 | | info | yii\db\Command::execute | INSERT INTO "audit_trail" ("entry_id", "user_id", "old_value", "new_value", "action", "model", "model_id", "field", "created") VALUES (250112, NULL, '', '1', 'UPDATE', 'app\modules\v1\models\Meeting', '2695', 'licensed', '2024-11-28 20:40:08'), (250112, NULL, '', '0', 'UPDATE', 'app\modules\v1\models\Meeting', '2695', 'basic', '2024-11-28 20:40:08') |
| 68 | 20:40:08.895 | | info | yii\db\Command::execute | UPDATE "audit_entry" SET "duration"=6.9440438747406, "memory_max"=2578768 WHERE "id"=250112 |