Page 1 of 1
Password recovery
Posted:
Mon Jun 28, 2021 11:57 am
by Joss2103
How are you,
Excuse me, can someone tell me how I can recover the password of a user in vicidial please?
Thanks !!
Re: Password recovery
Posted:
Mon Jun 28, 2021 12:03 pm
by carpenox
mysql asterisk -u cron -p1234 -e "select user,pass,active from vicidial_users where user_level='9'"
this will show you level 9 passwords
if you need another level just change the 9 to whatever level the user is
Re: Password recovery
Posted:
Mon Jun 28, 2021 10:48 pm
by Joss2103
Thank you very much, I managed to recover the password, now I have a worse detail, and that is that when entering the user I can not see anything, it tells me that I do not have permissions to see this page, I tried to access from base and create suarios with nevel 9 and by giving permissions To see everything, it saves and then when wanting to edit other settings, even the users happened the same thing, that I don't have permissions, this has happened to them, I don't know if you understand me.
Thanks!!
Re: Password recovery
Posted:
Tue Jun 29, 2021 1:50 am
by dhijrwn
Joss2103 wrote:Thank you very much, I managed to recover the password, now I have a worse detail, and that is that when entering the user I can not see anything, it tells me that I do not have permissions to see this page, I tried to access from base and create suarios with nevel 9 and by giving permissions To see everything, it saves and then when wanting to edit other settings, even the users happened the same thing, that I don't have permissions, this has happened to them, I don't know if you understand me.
Thanks!!
You need to edit the user
Admin Interface Options settings, set it all from 0 to 1.
Re: Password recovery
Posted:
Tue Jun 29, 2021 7:31 am
by carpenox
change your my.cnf to add sql_mode="No_ENGINE_SUBSTITUTION"
Re: Password recovery
Posted:
Tue Jun 29, 2021 10:48 am
by Joss2103
Yes, from the frint I give permissions to everything, leaving it at 1 but when saving changes everything is disabled again and I can not do anything, I already found the my.cnf file at the end of everything you have add the line you comment but nothing happens or I don't know if I have to modify or do something else?
[mysql.server]
user = mysql
#basedir = /var/lib
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
datadir = /var/lib/mysql
#tmpdir = /home/mysql_tmp
socket = /var/lib/mysql/mysql.sock
user = mysql
old_passwords = 0
ft_min_word_len = 3
max_connections = 800
max_allowed_packet = 32M
skip-external-locking
log-error = /var/log/mysqld/mysqld.log
query-cache-type = 1
query-cache-size = 32M
long_query_time = 1
#slow_query_log = 1
#slow_query_log_file = /var/log/mysqld/slow-queries.log
tmp_table_size = 128M
table_cache = 1024
join_buffer_size = 1M
key_buffer = 512M
sort_buffer_size = 6M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
max_tmp_tables = 64
thread_cache_size = 8
thread_concurrency = 8
# If using replication, uncomment log-bin below
#log-bin = mysql-bin
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
#log-error = /var/log/mysqld/mysqld.log
#pid-file = /var/run/mysqld/mysqld.pid
sql_mode = No_ENGINE_SUBSTITUTION
Re: Password recovery
Posted:
Tue Jun 29, 2021 2:24 pm
by carpenox
put it just like i have it, with quotes and all caps