Password recovery

[Joss2103]

How are you,

Excuse me, can someone tell me how I can recover the password of a user in vicidial please?

Thanks !!

[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

[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!!

[dhijrwn]

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.

[carpenox]

change your my.cnf to add sql_mode="No_ENGINE_SUBSTITUTION"

[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

[carpenox]

put it just like i have it, with quotes and all caps