Additional Information | [root@sogo-srv ~]# su - postgres -s /bin/sh -c psql
psql (14.5)
Введите "help", чтобы получить справку.
postgres=# \c sogo
Вы подключены к базе данных "sogo" как пользователь "postgres".
sogo=# \d sogo_sessions_folder
Таблица "public.sogo_sessions_folder"
Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию
----------------+------------------------+--------------------+-------------------+--------------
c_id | character varying(255) | | not null |
c_value | character varying(255) | | not null |
c_creationdate | integer | | not null |
c_lastseen | integer | | not null |
Индексы:
"sogo_sessions_folder_pkey" PRIMARY KEY, btree (c_id)
sogo=# select * from sogo_sessions_folder where c_id = 'domainuser1';
c_id | c_value | c_creationdate | c_lastseen
------+---------+----------------+------------
(0 строк)
sogo=# select * from sogo_user_profile where c_uid = 'domainuser1';
..<skipped>...
..<skipped>...
domainuser1 | {"SOGoCalendarCategoriesColors":{"Идеи":"#32CCBC","Конкуренты":"#6018DC","Поставщики":"#9708CC","Подарки":"#736EFE","Избранное":"#EA5455","Деловые":"#FA016D","Госуд
арственный праздник":"#E80505","Встречи":"#7367F0","День рождения":"#28C76F","Проекты":"#8C1BAB","Клиенты":"#E96D71","Потребители":"#F8D800","Годовщина":"#9F44D3","Проблемы":"0000367
7FF","Отпуск":"#623AA2","Разное":"#F6416C","Праздники":"#0E197D","Звонки":"#0396FF","Статус":"0002661","Вслед за":"#D939CD","Персональное":"#DE4313","Путешествия":"#F55555"},"SOGo
GravatarEnabled":1,"LocaleCode":"ru","SOGoMailComposeFontSize":0,"SOGoMailReceiptNonRecipientAction":"ignore","SOGoDayStartTime":"08:00","SOGoAlternateAvatar":"monsterid","SOGoLog
inModule":"Mail","SOGoLDAPGroupExpansionEnabled":0,"SOGoCalendarCategories":["Потребители", "Звонки", "Избранное", "Встречи", "Идеи", "Разное", "День рождения", "Годовщина", "Отпу
ск", "Путешествия", "Проекты", "Поставщики", "Подарки", "Клиенты", "Проблемы", "Деловые", "Праздники", "Персональное", "Статус", "Конкуренты", "Вслед за", "Государственный праздни
к"],"SOGoTOTPEnabled":0,"emailSeparatorKeys":[9, 13],"SOGoDayEndTime":"18:00","SOGoMailComposeMessageType":"html","SOGoCalendarWeekdays":["SU", "MO", "TU", "WE", "TH", "FR", "SA"]
,"hasActiveExternalSieveScripts":0,"SOGoShortDateFormat":"%d-%b-%y","SOGoMailSignaturePlacement":"below","SOGoMailMessageForwarding":"inline","ckLocaleCode":"ru","SOGoDesktopNotif
ications":0,"SOGoMailReceiptOutsideDomainAction":"ignore","SOGoTimeZone":"Asia/Yekaterinburg","SOGoMailReceiptAllow":"0","UserTimeZoneSecondsFromGMT":0,"SOGoTimeFormat":"%H:%M","V
acation":{"daysBetweenResponse":7,"autoReplyEmailAddresses":["domainuser1@test.alt"],"days":[]},"SOGoRememberLastModule":0,"SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoP
asswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":"every_minute","SOGoCalendarDefaultReminder":"NONE","SOGoMailLabelsColors":{"$label2":["Работа", "#FF9900"],"$label5":["Позж
е", "#993399"],"$label1":["Важно", "#FF0000"],"$label4":["К исполнению", "#3333FF"],"$mdnsent":["Уведомление о вручении отправлено", "#006600"],"$label3":["Личное", "#009900"]},"S
OGoMailAutoSave":5,"SOGoLongDateFormat":"%A, %B %d, %Y","SOGoMailReceiptAnyAction":"ignore","SOGoMailAutoMarkAsReadDelay":0,"SOGoDefaultCalendar":"selected","SOGoMailReplyPlacemen
t":"below","SOGoAppointmentSendEMailNotifications":0,"SOGoFirstWeekOfYear":"January1","SOGoSelectedAddressBook":"collected","SOGoCalendarEventsDefaultClassification":"PUBLIC","SOG
oAnimationMode":"normal","SOGoPasswordRecoveryQuestion":"SecretQuestion1","SOGoMailAddOutgoingAddresses":0,"AuxiliaryMailAccounts":[],"SOGoFirstDayOfWeek":1,"SOGoLanguage":"Russia
n","SOGoContactsCategories":["Друг", "Клиент", "Коллега", "Конкурент", "Партнер", "Поставщик", "Пресса", "Член семьи", "VIP"],"SOGoMailIdentities":[{"email":"domainuser1@test.alt"
,"isDefault":1,"fullName":"domainuser1"}],"SOGoMailDisplayRemoteInlineImages":"never"} | {"Contact":{"SortingState":["c_cn", "1"]},"Calendar":{"SelectedList":"tasksListView","Fold
ersOrder":["personal"],"PreventInvitationsWhitelist":{},"EventsFilterState":"view_next7","TasksFilterState":"view_incomplete","TasksSortingState":["status", "1"],"InactiveFolders"
:[],"EventsSortingState":["start", "1"],"View":"weekview"},"ShowCompletedTasks":"0","Mail":{"ExpandedFolders":["/0", "/0/folderINBOX"]}}
(1 строка)
sogo=# |
---|