alexlai@hc4Noble:~/scripts$ sudo snap run nextcloud.mysql-client
2024/05/03 07:55:30.127856 cmd_run.go:1072: WARNING: cannot create user data directory: failed to verify SELinux context of /root/snap: exec: "matchpathcon": executable file not found in $PATH
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1223
Server version: 8.0.36 Source distribution
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM oc_users;
ERROR 1046 (3D000): No database selected
mysql> USE nextcloud;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT * FROM oc_users;
+----------------+-------------+-----------------------------------------------------------------------------------------------------+----------------+
| uid | displayname | password | uid_lower |
+----------------+-------------+-----------------------------------------------------------------------------------------------------+----------------+
| nextCloudAdmin | NULL | 3|$argon2id$v=19$m=65536,t=4,p=1$MmZDSDJocFZCSXZOeXVrVg$r2PCi3/NxLQTCtFVnt/bIzHWw63XZAUP3/4uVhl+Gh8 | nextcloudadmin |
+----------------+-------------+-----------------------------------------------------------------------------------------------------+----------------+
1 row in set (0.00 sec)
mysql> SELECT email FROM oc_users WHERE uid = 'nextCloudAdmin';
ERROR 1054 (42S22): Unknown column 'email' in 'field list'
mysql> DESCRIBE oc_users;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| uid | varchar(64) | NO | PRI | | |
| displayname | varchar(64) | YES | | NULL | |
| password | varchar(255) | NO | | | |
| uid_lower | varchar(64) | YES | MUL | | |
+-------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> SELECT email FROM oc_accounts WHERE user_id = (SELECT uid FROM oc_users WHERE uid = 'nextCloudAdmin');
ERROR 1054 (42S22): Unknown column 'email' in 'field list'
mysql> mysql> SHOW TABLES;
+-----------------------------+
| Tables_in_nextcloud |
+-----------------------------+
| oc_accounts |
| oc_accounts_data |
| oc_activity |
| oc_activity_mq |
| oc_addressbookchanges |
| oc_addressbooks |
| oc_appconfig |
| oc_authorized_groups |
| oc_authtoken |
| oc_bruteforce_attempts |
| oc_calendar_invitations |
| oc_calendar_reminders |
| oc_calendar_resources |
| oc_calendar_resources_md |
| oc_calendar_rooms |
| oc_calendar_rooms_md |
| oc_calendarchanges |
| oc_calendarobjects |
| oc_calendarobjects_props |
| oc_calendars |
| oc_calendarsubscriptions |
| oc_cards |
| oc_cards_properties |
| oc_circles_circle |
| oc_circles_event |
| oc_circles_member |
| oc_circles_membership |
| oc_circles_mount |
| oc_circles_mountpoint |
| oc_circles_remote |
| oc_circles_share_lock |
| oc_circles_token |
| oc_collres_accesscache |
| oc_collres_collections |
| oc_collres_resources |
| oc_comments |
| oc_comments_read_markers |
| oc_dav_cal_proxy |
| oc_dav_shares |
| oc_direct_edit |
| oc_directlink |
| oc_federated_reshares |
| oc_file_locks |
| oc_file_metadata |
| oc_filecache |
| oc_filecache_extended |
| oc_files_reminders |
| oc_files_trash |
| oc_files_versions |
| oc_flow_checks |
| oc_flow_operations |
| oc_flow_operations_scope |
| oc_group_admin |
| oc_group_user |
| oc_groups |
| oc_jobs |
| oc_known_users |
| oc_login_flow_v2 |
| oc_mail_accounts |
| oc_mail_aliases |
| oc_mail_attachments |
| oc_mail_classifiers |
| oc_mail_coll_addresses |
| oc_mail_local_messages |
| oc_mail_mailboxes |
| oc_mail_message_tags |
| oc_mail_messages |
| oc_mail_messages_retention |
| oc_mail_messages_snoozed |
| oc_mail_provisionings |
| oc_mail_recipients |
| oc_mail_smime_certificates |
| oc_mail_tags |
| oc_mail_trusted_senders |
| oc_migrations |
| oc_mimetypes |
| oc_mounts |
| oc_notifications |
| oc_notifications_pushhash |
| oc_notifications_settings |
| oc_oauth2_access_tokens |
| oc_oauth2_clients |
| oc_open_local_editor |
| oc_photos_albums |
| oc_photos_albums_collabs |
| oc_photos_albums_files |
| oc_preferences |
| oc_privacy_admins |
| oc_profile_config |
| oc_properties |
| oc_ratelimit_entries |
| oc_reactions |
| oc_recent_contact |
| oc_schedulingobjects |
| oc_share |
| oc_share_external |
| oc_storages |
| oc_storages_credentials |
| oc_systemtag |
| oc_systemtag_group |
| oc_systemtag_object_mapping |
| oc_text_documents |
| oc_text_sessions |
| oc_text_steps |
| oc_textprocessing_tasks |
| oc_trusted_servers |
| oc_twofactor_backupcodes |
| oc_twofactor_providers |
| oc_user_status |
| oc_user_transfer_owner |
| oc_users |
| oc_vcategory |
| oc_vcategory_to_object |
| oc_webauthn |
| oc_whats_new |
+-----------------------------+
115 rows in set (0.00 sec)
mysql> select * from oc_mail_accounts;
+----+----------------+----------------+-------------------------+-----------------------+--------------+------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+---------------+-------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------------------+-------------+-------+----------------------+--------------------+-------------------+-----------------+------------------+---------------+------------+------------+----------------+------------+----------------+-----------------+-----------------------+----------------+-------------+--------------------+---------------------+-----------------+--------------------+----------------------+-----------------+------------------+----------------------+-------------------+-------------+--------------------+
| id | user_id | name | email | inbound_host | inbound_port | inbound_ssl_mode | inbound_user | inbound_password | outbound_host | outbound_port | outbound_ssl_mode | outbound_user | outbound_password | signature | last_mailbox_sync | editor_mode | order | show_subscribed_only | personal_namespace | drafts_mailbox_id | sent_mailbox_id | trash_mailbox_id | sieve_enabled | sieve_host | sieve_port | sieve_ssl_mode | sieve_user | sieve_password | provisioning_id | signature_above_quote | signature_mode | auth_method | archive_mailbox_id | oauth_refresh_token | oauth_token_ttl | oauth_access_token | smime_certificate_id | junk_mailbox_id | quota_percentage | trash_retention_days | snooze_mailbox_id | search_body | ooo_follows_system |
+----+----------------+----------------+-------------------------+-----------------------+--------------+------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+---------------+-------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------------------+-------------+-------+----------------------+--------------------+-------------------+-----------------+------------------+---------------+------------+------------+----------------+------------+----------------+-----------------+-----------------------+----------------+-------------+--------------------+---------------------+-----------------+--------------------+----------------------+-----------------+------------------+----------------------+-------------------+-------------+--------------------+
| 2 | nextCloudAdmin | nextCloudAdmin | sousuke.rai@hotmail.com | outlook.office365.com | 993 | ssl | sousuke.rai@hotmail.com | 93bbc0895a65f053275682fa2c0892359de456b1f8ea6b49d899c650d9f0e90e|9c787723f96041def94657ba5f09c7b4|fd2e5021e9718c3f0c4e4acfa51a40ce359e63003ac78226fb773e05369948cc3d636b43114cfd75fb5e11e9f2691a67caa4a734c6fee7f350cd23a9694ea170|3 | smtp.office365.com | 587 | tls | sousuke.rai@hotmail.com | a0945223bc382a77f6e1e64e31ad21d38ee2708f11993ea10955d1b35b43178e|b2fe55a5e5e3ff0997666088de710283|bf79c46991e4c52cd35f2eb3ae7c2526e426a296e0597da61bb59578c031ca93a4b1835ecf4339e9545cdcd781a5e825186a78e9f9ba8e6522b272a4d37d4133|3 | NULL | 1714691573 | plaintext | 1 | 0 | NULL | 5 | 10 | 4 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | password | 3 | NULL | NULL | NULL | NULL | 7 | NULL | NULL | NULL | 0 | 0 |
+----+----------------+----------------+-------------------------+-----------------------+--------------+------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+---------------+-------------------+-------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------------------+-------------+-------+----------------------+--------------------+-------------------+-----------------+------------------+---------------+------------+------------+----------------+------------+----------------+-----------------+-----------------------+----------------+-------------+--------------------+---------------------+-----------------+--------------------+----------------------+-----------------+------------------+----------------------+-------------------+-------------+--------------------+
1 row in set (0.00 sec)
mysql> select outbound_host from oc_mail_accounts;
+--------------------+
| outbound_host |
+--------------------+
| smtp.office365.com |
+--------------------+
1 row in set (0.00 sec)
mysql> select inbound_host from oc_mail_accounts;
+-----------------------+
| inbound_host |
+-----------------------+
| outlook.office365.com |
+-----------------------+
1 row in set (0.00 sec)