psdk
(PSDK)
August 28, 2018, 11:29am
1
Hi to all,
after yum update, I got this error:
Exception: SQLSTATE[28000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)::SQLSTATE[28000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES) in file /var/www/html/admin/libraries/utility.functions.php on line 204
Stack trace:
Exception->() /var/www/html/admin/libraries/utility.functions.php:204
die_freepbx() /var/www/html/admin/libraries/BMO/Database.class.php:142
PDOException->() /var/www/html/admin/libraries/BMO/Database.class.php:137
PDO->__construct() /var/www/html/admin/libraries/BMO/Database.class.php:137
FreePBX\Database->__construct() /var/www/html/admin/libraries/BMO/FreePBX.class.php:71
FreePBX->__construct() /var/www/html/admin/bootstrap.php:153
require_once() /etc/freepbx.conf:10
include_once() /var/lib/asterisk/bin/fwconsole:12
so I can’t do anything and UI also is not accessible.
How I can set the pass again from DB?
cynjut
(Dave Burgess)
August 28, 2018, 4:23pm
2
From the database server, you can do any commands you want as the ‘root’ database user (which shouldn’t have a password, but must be accessed from localhost).
Connect to the database server as ‘root’ and log into the UI for MySQL:
mysql -u root mysql
Once logged in, use a command like:
update user set password = password('thepasswordyouwanttouse') where user = 'freepbxuser';
The password is probably stored in one of the config files (I’m not sure which and my test machine is hosed right now, so I can’t look).
1 Like
psdk
(PSDK)
August 28, 2018, 5:34pm
4
Yes Its solved. But Asterisk doesnt start and it crashes.!
psdk
(PSDK)
September 1, 2018, 7:27am
6
[root@server ~]# *** Error in `/usr/sbin/asterisk’: free(): invalid pointer: 0x00000000029c11c8 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x81499)[0x7f5ca8ecb499]
/usr/lib64/libmyodbc5.so(MySQLGetPrivateProfileStringW+0x104)[0x7f5ca62fd434]
/usr/lib64/libmyodbc5.so(ds_lookup+0x5d)[0x7f5ca62fcd5d]
/usr/lib64/libmyodbc5.so(MySQLConnect+0xc6)[0x7f5ca62e0536]
/lib64/libodbc.so.2(SQLConnect+0xa63)[0x7f5ca69383b3]
/usr/lib64/asterisk/modules/res_odbc.so(+0x540e)[0x7f5ca6b9540e]
/usr/lib64/asterisk/modules/res_odbc.so(_ast_odbc_request_obj2+0x252)[0x7f5ca6b94bc6]
/usr/lib64/asterisk/modules/res_odbc.so(_ast_odbc_request_obj+0x45)[0x7f5ca6b94fd4]
/usr/lib64/asterisk/modules/res_odbc.so(+0x4576)[0x7f5ca6b94576]
/usr/lib64/asterisk/modules/res_odbc.so(+0x3fdb)[0x7f5ca6b93fdb]
/usr/lib64/asterisk/modules/res_odbc.so(+0x5929)[0x7f5ca6b95929]
/usr/sbin/asterisk[0x543a20]
/usr/sbin/asterisk[0x544832]
/usr/sbin/asterisk[0x544f79]
/usr/sbin/asterisk[0x45e49b]
/usr/sbin/asterisk[0x45db76]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f5ca8e6c445]
/usr/sbin/asterisk[0x436d9a]
======= Memory map: ========
00400000-007ae000 r-xp 00000000 fd:00 141783315 /usr/sbin/asterisk
009ad000-009c0000 r–p 003ad000 fd:00 141783315 /usr/sbin/asterisk
009c0000-009ea000 rw-p 003c0000 fd:00 141783315 /usr/sbin/asterisk
009ea000-00a02000 rw-p 00000000 00:00 0
01cdd000-029d8000 rw-p 00000000 00:00 0 [heap]
7f5c79ad7000-7f5c80000000 r–p 00000000 fd:00 134720642 /usr/lib/locale/locale-archive
7f5c80000000-7f5c80021000 rw-p 00000000 00:00 0
7f5c80021000-7f5c84000000 —p 00000000 00:00 0
7f5c88000000-7f5c88021000 rw-p 00000000 00:00 0
7f5c88021000-7f5c8c000000 —p 00000000 00:00 0
7f5c8c000000-7f5c8c021000 rw-p 00000000 00:00 0
7f5c8c021000-7f5c90000000 —p 00000000 00:00 0
7f5c90000000-7f5c90021000 rw-p 00000000 00:00 0
7f5c90021000-7f5c94000000 —p 00000000 00:00 0
7f5c94000000-7f5c94021000 rw-p 00000000 00:00 0
7f5c94021000-7f5c98000000 —p 00000000 00:00 0
7f5c98000000-7f5c98021000 rw-p 00000000 00:00 0
7f5c98021000-7f5c9c000000 —p 00000000 00:00 0
7f5c9c000000-7f5c9c021000 rw-p 00000000 00:00 0
7f5c9c021000-7f5ca0000000 —p 00000000 00:00 0
7f5ca0000000-7f5ca0021000 rw-p 00000000 00:00 0
7f5ca0021000-7f5ca4000000 —p 00000000 00:00 0
7f5ca5b10000-7f5ca5b20000 r-xp 00000000 fd:00 135580500 /usr/lib64/libodbcinst.so.2.0.0
7f5ca5b20000-7f5ca5d20000 —p 00010000 fd:00 135580500 /usr/lib64/libodbcinst.so.2.0.0
7f5ca5d20000-7f5ca5d21000 r–p 00010000 fd:00 135580500 /usr/lib64/libodbcinst.so.2.0.0
7f5ca5d21000-7f5ca5d22000 rw-p 00011000 fd:00 135580500 /usr/lib64/libodbcinst.so.2.0.0
7f5ca5d22000-7f5ca6042000 r-xp 00000000 fd:00 136711537 /usr/lib64/libmysqlclient.so.18.0.0
7f5ca6042000-7f5ca6241000 —p 00320000 fd:00 136711537 /usr/lib64/libmysqlclient.so.18.0.0
7f5ca6241000-7f5ca6249000 r–p 0031f000 fd:00 136711537 /usr/lib64/libmysqlclient.so.18.0.0
7f5ca6249000-7f5ca62bc000 rw-p 00327000 fd:00 136711537 /usr/lib64/libmysqlclient.so.18.0.0
7f5ca62bc000-7f5ca62c6000 rw-p 00000000 00:00 0
7f5ca62c6000-7f5ca630b000 r-xp 00000000 fd:00 136102409 /usr/lib64/libmyodbc5w.so
7f5ca630b000-7f5ca650a000 —p 00045000 fd:00 136102409 /usr/lib64/libmyodbc5w.so
7f5ca650a000-7f5ca650c000 r–p 00044000 fd:00 136102409 /usr/lib64/libmyodbc5w.so
7f5ca650c000-7f5ca651b000 rw-p 00046000 fd:00 136102409 /usr/lib64/libmyodbc5w.so
7f5ca651b000-7f5ca651d000 r-xp 00000000 fd:00 201426893 /usr/lib64/gconv/ISO8859-1.so
7f5ca651d000-7f5ca671c000 —p 00002000 fd:00 201426893 /usr/lib64/gconv/ISO8859-1.so
7f5ca671c000-7f5ca671d000 r–p 00001000 fd:00 201426893 /usr/lib64/gconv/ISO8859-1.so
7f5ca671d000-7f5ca671e000 rw-p 00002000 fd:00 201426893 /usr/lib64/gconv/ISO8859-1.so
7f5ca671e000-7f5ca6727000 r-xp 00000000 fd:00 135580482 /usr/lib64/libltdl.so.7.3.0
7f5ca6727000-7f5ca6926000 —p 00009000 fd:00 135580482 /usr/lib64/libltdl.so.7.3.0
7f5ca6926000-7f5ca6927000 r–p 00008000 fd:00 135580482 /usr/lib64/libltdl.so.7.3.0
7f5ca6927000-7f5ca6928000 rw-p 00009000 fd:00 135580482 /usr/lib64/libltdl.so.7.3.0
7f5ca6928000-7f5ca6988000 r-xp 00000000 fd:00 135580491 /usr/lib64/libodbc.so.2.0.0
7f5ca6988000-7f5ca6b87000 —p 00060000 fd:00 135580491 /usr/lib64/libodbc.so.2.0.0
7f5ca6b87000-7f5ca6b88000 r–p 0005f000 fd:00 135580491 /usr/lib64/libodbc.so.2.0.0
7f5ca6b88000-7f5ca6b8f000 rw-p 00060000 fd:00 135580491 /usr/lib64/libodbc.so.2.0.0
7f5ca6b8f000-7f5ca6b90000 rw-p 00000000 00:00 0
7f5ca6b90000-7f5ca6b97000 r-xp 00000000 fd:00 137147897 /usr/lib64/asterisk/modules/res_odbc.so
7f5ca6b97000-7f5ca6d96000 —p 00007000 fd:00 137147897 /usr/lib64/asterisk/modules/res_odbc.so
7f5ca6d96000-7f5ca6d97000 r–p 00006000 fd:00 137147897 /usr/lib64/asterisk/modules/res_odbc.so
7f5ca6d97000-7f5ca6d98000 rw-p 00007000 fd:00 137147897 /usr/lib64/asterisk/modules/res_odbc.so
and it will continue till reboot the server.
system
(system)
Closed
September 8, 2018, 7:27am
7
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.