API tools faq
paste
Advertisement
Gaiolero

Untitled

Gaiolero
Aug 24th, 2018
688
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.06 KB | None | 0 0
raw download clone embed print report
  1. MariaDB [asterisk]> select user,user_group,pass,pass_hash from vicidial_users;
  2. +----------+------------+------------+---------------------------------+
  3. | user | user_group | pass | pass_hash |
  4. +----------+------------+------------+---------------------------------+
  5. | VDAD | ADMIN | donotedit | |
  6. | admin | ADMIN | goautodial | |
  7. | agent001 | AGENTS | goautodial | |
  8. | agent002 | AGENTS | goautodial | |
  9. | agent003 | AGENTS | goautodial | |
  10. | agent004 | AGENTS | goautodial | |
  11. | agent005 | AGENTS | goautodial | |
  12. | agent006 | AGENTS | goautodial | |
  13. | agent007 | AGENTS | goautodial | |
  14. | agent008 | AGENTS | goautodial | |
  15. | agent009 | AGENTS | goautodial | |
  16. | agent010 | AGENTS | goautodial | |
  17. | agent011 | AGENTS | goautodial | |
  18. | agent012 | AGENTS | goautodial | |
  19. | agent013 | AGENTS | goautodial | |
  20. | agent014 | AGENTS | goautodial | |
  21. | agent015 | AGENTS | goautodial | |
  22. | agent016 | AGENTS | goautodial | |
  23. | agent017 | AGENTS | goautodial | |
  24. | agent018 | AGENTS | goautodial | |
  25. | agent019 | AGENTS | goautodial | |
  26. | agent020 | AGENTS | goautodial | |
  27. | VDCL | ADMIN | donotedit | |
  28. | goAPI | ADMIN | | EORxUHT6Ju2kLOOB4g3X3GxJcQ9RGGS |
  29. | goadmin | ADMIN | | h0CAwQ/of1y0YFKgut1hVcqNl1SMSNu |
  30. +----------+------------+------------+---------------------------------+
  31. 25 rows in set (0.00 sec)
  32.  
  33.  
  34.  
  35.  
  36.  
  37. MariaDB [asterisk]> select user_group, group_name from vicidial_user_groups;
  38. +------------+-------------------------+
  39. | user_group | group_name |
  40. +------------+-------------------------+
  41. | ADMIN | VICIDIAL ADMINISTRATORS |
  42. | AGENTS | VICIDIAL AGENTS |
  43. +------------+-------------------------+
  44. 2 rows in set (0.00 sec)
  45.  
  46.  
  47.  
  48.  
  49. MariaDB [goautodial]> select * from user_access_group\G;
  50. *************************** 1. row ***************************
  51. id: 1
  52. user_group: ADMIN
  53. permissions: {"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"U","user_delete":"D"},"campaign":{"campaign_create":"C","campaign_read":"R","campaign_update":"U","campaign_delete":"D"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"D"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"D"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"D"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"D","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"D"},"loadleads":{"loadleads_read":"R"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"D"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"D"},"voicefiles":{"voicefiles_upload":"C","voicefiles_delete":"D"},"reportsanalytics":{"reportsanalytics_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"Y","tenant_display":"Y","tenant_update":"Y","tenant_delete":"Y","tenant_logs":"Y","tenant_calltimes":"Y","tenant_phones":"Y","tenant_voicemails":"Y"}}
  54. group_level: 9
  55. date_create: 2013-06-05 00:42:17
  56. allowed_campaigns: NULL
  57. group_list_id: NULL
  58. *************************** 2. row ***************************
  59. id: 2
  60. user_group: AGENTS
  61. permissions: {"dashboard":{"dashboard_display":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"disposition":{"disposition_create":"N","disposition_update":"N","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"N","pausecodes_read":"N","pausecodes_update":"N","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"N","hotkeys_read":"N","hotkeys_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N","list_upload":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefiles_upload":"N","voicefiles_delete":"N"},"reportsanalytics":{"reportsanalytics_display":"N"},"recordings":{"recordings_display":"N"},"support":{"support_display":"N"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"}}
  62. group_level: 1
  63. date_create: 2013-06-05 00:49:21
  64. allowed_campaigns: NULL
  65. group_list_id: NULL
  66. *************************** 3. row ***************************
  67. id: 3
  68. user_group: SUPERVISOR
  69. permissions: {"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"R","campaign_update":"U","campaign_delete":"N"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"N"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"N","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"N"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"N"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"N"},"ivr":{"ivr_create":"C","ivr_read":"R","ivr_update":"U","ivr_delete":"N"},"did":{"did_create":"C","did_read":"R","did_update":"U","did_delete":"N"},"voicefiles":{"voicefiles_upload":"C","voicefiles_play":"Y","voicefiles_download":"Y"},"moh":{"moh_create":"C","moh_read":"R","moh_update":"U","moh_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_display":"Y","reportsanalytics_agent_time_display":"Y","reportsanalytics_agent_performance_display":"Y","reportsanalytics_dial_status_display":"Y","reportsanalytics_agent_sales_display":"Y","reportsanalytics_sales_tracker_display":"Y","reportsanalytics_inbound_call_display":"Y","reportsanalytics_export_call_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"},"chat":{"chat_create":"C","chat_read":"R","chat_update":"U","chat_delete":"D"},"osticket":{"osticket_create":"C","osticket_read":"R","osticket_update":"U","osticket_delete":"D"}}
  70. group_level: 8
  71. date_create: 2018-08-11 18:24:38
  72. allowed_campaigns: NULL
  73. group_list_id: NULL
  74. *************************** 4. row ***************************
  75. id: 4
  76. user_group: TENANT
  77. permissions: {"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"R","campaign_update":"U","campaign_delete":"N"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"N"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"N","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"N"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"N"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"N"},"ivr":{"ivr_create":"C","ivr_read":"R","ivr_update":"U","ivr_delete":"N"},"did":{"did_create":"C","did_read":"R","did_update":"U","did_delete":"N"},"voicefiles":{"voicefiles_upload":"C","voicefiles_play":"Y","voicefiles_download":"Y"},"moh":{"moh_create":"C","moh_read":"R","moh_update":"U","moh_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_display":"Y","reportsanalytics_agent_time_display":"Y","reportsanalytics_agent_performance_display":"Y","reportsanalytics_dial_status_display":"Y","reportsanalytics_agent_sales_display":"Y","reportsanalytics_sales_tracker_display":"Y","reportsanalytics_inbound_call_display":"Y","reportsanalytics_export_call_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"},"chat":{"chat_create":"C","chat_read":"R","chat_update":"U","chat_delete":"D"},"osticket":{"osticket_create":"C","osticket_read":"R","osticket_update":"U","osticket_delete":"D"}}
  78. group_level: 8
  79. date_create: 2018-08-11 18:25:07
  80. allowed_campaigns: NULL
  81. group_list_id: NULL
  82. 4 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!