Freepbxuser access denied

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:

  1. Exception->() /var/www/html/admin/libraries/utility.functions.php:204
  2. die_freepbx() /var/www/html/admin/libraries/BMO/Database.class.php:142
  3. PDOException->() /var/www/html/admin/libraries/BMO/Database.class.php:137
  4. PDO->__construct() /var/www/html/admin/libraries/BMO/Database.class.php:137
  5. FreePBX\Database->__construct() /var/www/html/admin/libraries/BMO/FreePBX.class.php:71
  6. FreePBX->__construct() /var/www/html/admin/bootstrap.php:153
  7. require_once() /etc/freepbx.conf:10
  8. 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?

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
/etc/freepbx.conf
2 Likes

Yes Its solved. But Asterisk doesnt start and it crashes.!

What error do you get?

[[email protected] ~]# *** 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.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.