Difference between revisions of "Mor user password change HOW-TO"

From Kolmisoft Wiki
Jump to navigationJump to search
(Page ready for public)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
== Before performing any actions with password changes, please read whole topic and make sure you understand everything, cause its very important. ==
[[Change default passwords]]
 
 
1. Update MySQL password:
 
Login to http://your.mor.server.or.ip.address.where.mor.is.installed/phpmyadmin/ using default userpass (use mor as a login and mor as a password).
 
Then press Query Window
 
[[Image:Sql.jpg]]
 
Enter fallowing code SET password=password("'''YourNewPasswordGoesHere'''"); into newly appeared window and press Go.
 
Example: If I want change my password to 12345 I will enter: SET password=password("12345");
 
 
2. Update system configuration files:
 
Login via ssh to your server and modify following configuration files:
 
 
== /home/mor/config/database.yml ==
 
  development:
  adapter: mysql
  database: mor
  username: mor
  password: '''YourNewPassword'''
  host: localhost
  port: 3306
  test:
  adapter: mysql
  database: morcallc_test
  username: root
  password:
  host: localhost
  production:
  adapter: mysql
  database: mor
  username: mor
  password:
  host: localhost
  port: 3306
 
 
 
== /etc/asterisk/mor.conf ==
 
  [global]
  hostname=localhost
  dbname=mor
  user=mor
  password='''YourNewPassword'''
  port=3306
  ;sock=/tmp/mysql.sock
 
 
 
== /etc/asterisk/res_mysql.conf ==
 
  [general]
  dbhost = 127.0.0.1
  dbname = mor
  dbuser = mor
  dbpass = '''YourNewPassword'''
  dbport = 3306
  ;dbsock = /tmp/mysql.sock
 
 
 
Then perform following commands:
  /etc/init.d/apache2 restart if you are running on Debian
  /etc/init.d/httpd restart if your Operating System is CentOS
  /etc/init.d/asterisk reload
 
Then double check if system is working correctly by using
  'rasterisk vvvR'
and entering
  'realtime mysql status'
debian2*CLI> realtime mysql status
Connected to mor@127.0.0.1, port 3306 with username mor for 4 seconds.
 
If you see something similiar, that means configuration files has been updated successfully. If you still get any errors, let us know by opening new support ticket.

Latest revision as of 09:21, 17 February 2010