§2024-11-30

1. mongoDB database

alexlai@n2Bookworm:~/Downloads$ mongosh mongodb://ysmongov801.yushei.com.tw:27017,ysmongov802.yushei.com.tw:27017,ysmongov803.yushei.com.tw:27017/
Current Mongosh Log ID:	674a57b3480d92e7a0f7c613
Connecting to:		mongodb://ysmongov801.yushei.com.tw:27017,ysmongov802.yushei.com.tw:27017,ysmongov803.yushei.com.tw:27017/?appName=mongosh+2.3.3
Using MongoDB:		8.0.3
Using Mongosh:		2.3.3
mongosh 2.3.4 is available for download: https://www.mongodb.com/try/download/shell

For mongosh info see: https://www.mongodb.com/docs/mongodb-shell/

ys20241107 [primary] test> use admin
switched to db admin
ys20241107 [primary] admin> db.auth("siteRootAdmin", "b23258585")
{ ok: 1 }
ys20241107 [primary] admin> show dbs
Dragonfly28        2.59 GiB
Dragonfly28V803    3.62 MiB
LaiKos           173.05 MiB
YuSheiDB         178.36 MiB
YuSheiWildduck    16.42 MiB
admin            220.00 KiB
config           292.00 KiB
local             11.64 GiB
zone-mta          80.00 KiB
ys20241107 [primary] admin> use Dragonfly28V803
switched to db Dragonfly28V803
ys20241107 [primary] Dragonfly28V803> show tables
_queue
_raix_push_app_tokens
instances
meteor_accounts_loginServiceConfiguration
meteor_oauth_pendingCredentials
meteor_oauth_pendingRequestTokens
migrations
omnichannel_auto_close_on_hold_scheduler
omnichannel_queue_inactivity_monitor
omnichannel_scheduler
pbx_events
rocketchat__trash
rocketchat_analytics
rocketchat_apps_persistence
rocketchat_apps_scheduler
rocketchat_avatars
rocketchat_avatars.chunks
rocketchat_avatars.files
rocketchat_banner
rocketchat_banner_dismiss
rocketchat_calendar_event
rocketchat_credential_tokens
rocketchat_cron
rocketchat_cron_history
rocketchat_custom_emoji
rocketchat_custom_sounds
rocketchat_custom_user_status
rocketchat_email_inbox
rocketchat_email_message_history
rocketchat_export_operations
rocketchat_federation_keys
rocketchat_federation_room_events
rocketchat_federation_servers
rocketchat_import
rocketchat_import_data
rocketchat_integration_history
rocketchat_integrations
rocketchat_livechat_agent_activity
rocketchat_livechat_business_hours
rocketchat_livechat_contact
rocketchat_livechat_custom_field
rocketchat_livechat_department
rocketchat_livechat_department_agents
rocketchat_livechat_inquiry
rocketchat_livechat_priority
rocketchat_livechat_trigger
rocketchat_livechat_visitor
rocketchat_matrix_bridged_rooms
rocketchat_matrix_bridged_users
rocketchat_message
rocketchat_message_reads
rocketchat_notification_queue
rocketchat_nps
rocketchat_nps_vote
rocketchat_oauth_access_tokens
rocketchat_oauth_apps
rocketchat_oauth_auth_codes
rocketchat_oauth_refresh_tokens
rocketchat_oembed_cache
rocketchat_omnichannel_service_level_agreements
rocketchat_permissions
rocketchat_read_receipts
rocketchat_roles
rocketchat_room
rocketchat_server_events
rocketchat_sessions
rocketchat_settings
rocketchat_statistics
rocketchat_subscription
rocketchat_team
rocketchat_team_member
rocketchat_uploads
rocketchat_user_data_files
rocketchat_video_conference
rocketchat_webdav_accounts
rocketchat_workspace_credentials
users
ys20241107 [primary] Dragonfly28V803> db.users.count()
DeprecationWarning: Collection.count() is deprecated. Use countDocuments or estimatedDocumentCount.
2
ys20241107 [primary] Dragonfly28V803> db.users.find()
[
  {
    _id: 'rocket.cat',
    createdAt: ISODate('2024-11-29T22:06:04.355Z'),
    avatarOrigin: 'local',
    name: 'Rocket.Cat',
    username: 'rocket.cat',
    status: 'online',
    statusDefault: 'online',
    utcOffset: 0,
    active: true,
    type: 'bot',
    _updatedAt: ISODate('2024-11-29T22:06:04.946Z'),
    roles: [ 'bot' ],
    avatarETag: 'PZ333gLgyDqSFtNjv'
  },
  {
    _id: '674a3acd2b64a36313c332d6',
    createdAt: ISODate('2024-11-29T22:06:05.015Z'),
    avatarOrigin: 'none',
    name: 'Administrator',
    username: 'DragonFly28Admin',
    status: 'offline',
    statusDefault: 'online',
    utcOffset: 0,
    active: true,
    emails: [ { address: 'rai.sousuke@mac.com', verified: false } ],
    type: 'user',
    _updatedAt: ISODate('2024-11-29T22:06:05.202Z'),
    services: {
      password: {
        bcrypt: '$2b$10$Ti.KBpMvaNuFuXFC/JGWbe62Ue1fVzHM6bsjEaqebgZ0ndzQhbHgS'
      }
    },
    roles: [ 'admin' ]
  }
]
ys20241107 [primary] Dragonfly28V803> 

2. First startup

• The mail Environment="MAIL_URL=smtp://alexlai:alex1765@yushei.net:25/" set up in RocketChatDragonfly28-v8.0.3.service does not work!