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

From Kolmisoft Wiki
Jump to navigationJump to search
(Page updated.)
(Page ready for public)
Line 22: Line 22:
== /home/mor/config/database.yml ==
== /home/mor/config/database.yml ==


 
  development:
 
development:
   adapter: mysql
   adapter: mysql
   database: mor
   database: mor
Line 31: Line 29:
   host: localhost
   host: localhost
   port: 3306
   port: 3306
 
  test:
test:
   adapter: mysql
   adapter: mysql
   database: morcallc_test
   database: morcallc_test
Line 38: Line 35:
   password:
   password:
   host: localhost
   host: localhost
 
  production:
 
production:
   adapter: mysql
   adapter: mysql
   database: mor
   database: mor
Line 51: Line 46:


== /etc/asterisk/mor.conf ==
== /etc/asterisk/mor.conf ==
[global]
 
hostname=localhost
  [global]
dbname=mor
  hostname=localhost
user=mor
  dbname=mor
password='''YourNewPassword'''
  user=mor
port=3306
  password='''YourNewPassword'''
;sock=/tmp/mysql.sock
  port=3306
  ;sock=/tmp/mysql.sock






== /etc/asterisk/res_mysql.conf ==
== /etc/asterisk/res_mysql.conf ==
[general]
 
dbhost = 127.0.0.1
  [general]
dbname = mor
  dbhost = 127.0.0.1
dbuser = mor
  dbname = mor
dbpass = '''YourNewPassword'''
  dbuser = mor
dbport = 3306
  dbpass = '''YourNewPassword'''
;dbsock = /tmp/mysql.sock
  dbport = 3306
  ;dbsock = /tmp/mysql.sock






Then perform following commands:
Then perform following commands:
/etc/init.d/apache2 restart if you are running on Debian
  /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/httpd restart if your Operating System is CentOS
/etc/init.d/asterisk reload
  /etc/init.d/asterisk reload


Then double check if system is working correctly by using 'rasterisk vvvR' and entering 'realtime mysql status'
Then double check if system is working correctly by using  
  'rasterisk vvvR'  
and entering  
  'realtime mysql status'
debian2*CLI> realtime mysql status
debian2*CLI> realtime mysql status
Connected to mor@127.0.0.1, port 3306 with username mor for 4 seconds.
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 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.

Revision as of 10:06, 23 October 2008

Before performing any actions with password changes, please read whole topic and make sure you understand everything, cause its very important.

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

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.