bar top left
bar top right
left curve
right curve
Welcome, Guest
Go to bottom
Post Reply
Post New Topic
Page: 123
TOPIC: Elastix MySQL password change
#20643
Elastix MySQL password change 3 Years, 1 Month ago Karma: 0
Hi All,

It has been a pleasure to use Elastix for all our requirements. things are working excellent until recently someone changed mysql password

Is there any way to change elastix mysql installation. As all admin/root passwords are public, anyone can do modifications to setup and ruin the system. Is there any way to change these default passwords? Specially MySQL password. I believe same password is hardcoded in number of places in elastix code. Please help.

Regards,
-Hema
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
hema
Fresh Boarder
Posts: 27
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#20652
Re:Elastix MySQL password change 3 Years, 1 Month ago Karma: 39
The mysql password is a security issue if you allow more users to ssh the server or if you have something like phpmyadmin public available for the world. You can change the password, but a lot of things could break up so you have to be sure, what are you using the pbx for adn check that everything works fine.

regards,


rafael
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
rafael
Free Software is all about freedom
Developer
Posts: 1458
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Elastix Location: Ecuador Birthday: 10/11
Reply Quote
 
#20695
Re:Elastix MySQL password change 3 Years, 1 Month ago Karma: 0
Thanks Rafael for your suggestion. Is there any guideline/checklist what all / where all changes are required if mysql password is changed? I believe this password is hardcoded in places in php code. Pointers to such files will be really helpful to everyone working with Elastix installation.

Regards,
Hema
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
hema
Fresh Boarder
Posts: 27
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#20736
Re:Elastix MySQL password change 3 Years, 1 Month ago Karma: 109
Hello,

I have found the password on the following files:

/var/www/html/vtigercrmWrapper.php
/var/www/html/libs/paloSantoInstaller.class.php
/var/www/html/sugarcrmWrapper.php
/var/www/html/modules/backup_restore/index.php
/var/www/html/modules/conference/index.php
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
jgutierrez
Moderator
Posts: 3544
graphgraph
User Offline Click here to see the profile of this user
Gender: Male jgutierr_007@hotmail.com Location: Santiago de Guayaquil - Ecuador Birthday: 08/07
Do you want a fast response service?
Do you want more help?
Try our Official Elastix Paid Support Service(English/Español):
support.palosanto.com/elastixChatServer.php

Get your support tickets from:
store.palosanto.com


Soporte Elastix Palosanto Solutions
Santiago de Guayaquil
Reply Quote
 
#21174
Re:Elastix MySQL password change 3 Years ago Karma: 0
Thanks a lot for your reply. I made the changes and things are working fine so far. Will update the group if i will come across any other file where changes are required. Thanks again.

Regards,
-Hema
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
hema
Fresh Boarder
Posts: 27
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#21265
Re:Elastix MySQL password change 3 Years ago Karma: 109
Excellent! good news, please kepp us updated about it, we would like to know more about it
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
jgutierrez
Moderator
Posts: 3544
graphgraph
User Offline Click here to see the profile of this user
Gender: Male jgutierr_007@hotmail.com Location: Santiago de Guayaquil - Ecuador Birthday: 08/07
Do you want a fast response service?
Do you want more help?
Try our Official Elastix Paid Support Service(English/Español):
support.palosanto.com/elastixChatServer.php

Get your support tickets from:
store.palosanto.com


Soporte Elastix Palosanto Solutions
Santiago de Guayaquil
Reply Quote
 
#36880
Re:Elastix MySQL password change 2 Years, 7 Months ago Karma: 1
I changed the default password from "eLaStIx.2oo7" to something else.

All the following files have been updated with the new password and work great;

/var/www/html/vtigercrmWrapper.php
/var/www/html/libs/paloSantoInstaller.class.php
/var/www/html/sugarcrmWrapper.php
/var/www/html/modules/backup_restore/index.php
/var/www/html/modules/conference/index.php

EXCEPT application;

OpenFire

I try to login in but the login page doesn't show up. Do you know where I can find this file?

Thanks!
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loanrefi
Fresh Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#36892
Re:Elastix MySQL password change 2 Years, 7 Months ago Karma: 109
You may execute the following command:

grep -r "eLaStIx" /var/www/html/*

It will reveal you, where you haven't change yet the password
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
jgutierrez
Moderator
Posts: 3544
graphgraph
User Offline Click here to see the profile of this user
Gender: Male jgutierr_007@hotmail.com Location: Santiago de Guayaquil - Ecuador Birthday: 08/07
Do you want a fast response service?
Do you want more help?
Try our Official Elastix Paid Support Service(English/Español):
support.palosanto.com/elastixChatServer.php

Get your support tickets from:
store.palosanto.com


Soporte Elastix Palosanto Solutions
Santiago de Guayaquil
Reply Quote
 
#36894
Re:Elastix MySQL password change 2 Years, 7 Months ago Karma: 1
Thanks for the reply!

I just tried your command and it doesn't show me anything, just hangs.....
[root@elastix ~]# grep -r "eLaStIx" /var/www/html/*
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loanrefi
Fresh Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#36897
Re:Elastix MySQL password change 2 Years, 7 Months ago Karma: 1
This file I'm looking for must be located some where else. I tried the command one folder up and this is the output;

[root@elastix ~]# grep -r "eLaStIx" /var/www/*
/var/www/html/schema.meetme:IDENTIFIED BY 'eLaStIx.asteriskuser.2oo7';
/var/www/html/modules/graphic_report/libs/grafic_queue.php:$dsnAsteriskCdr = "mysql://asteriskuser:eLaStIx.asteriskuser.2oo7@localhost/asteriskcdrdb";
/var/www/html/modules/graphic_report/libs/grafic_queue.php:$dsnAsteriskDev = "mysql://asteriskuser:eLaStIx.asteriskuser.2oo7@localhost/asterisk";
/var/www/html/modules/graphic_report/libs/grafic_trunk2.php:$dsnAsteriskCdr = "mysql://asteriskuser:eLaStIx.asteriskuser.2oo7@localhost/asteriskcdrdb";
/var/www/html/modules/graphic_report/libs/grafic_trunk.php:$dsnAsteriskCdr = "mysql://asteriskuser:eLaStIx.asteriskuser.2oo7@localhost/asteriskcdrdb";
/var/www/html/modules/report_call/configs/default.conf.php: $arrConfModule['dsn_conn_database'] = 'mysql://asteriskuser:eLaStIx.asteriskuser.2oo7@localhost/asteriskcdrdb';
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loanrefi
Fresh Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 123
Moderators: Bob, jgutierrez
Protected by Spam Fighter