Where in FreePBX GUI possible to change mysql user and password for res_odbc_additional.conf











up vote
0
down vote

favorite












I use CDR records to MySQL.
MySQL located on different machine.
If I change these settings directly in res_odbc_additional.conf



It working ok, until FreePBX will rewrite configuration again.



And I didn't found any GUI page to change it in FreePBX panel :(



Could anybody help me?



Thanks.










share|improve this question


























    up vote
    0
    down vote

    favorite












    I use CDR records to MySQL.
    MySQL located on different machine.
    If I change these settings directly in res_odbc_additional.conf



    It working ok, until FreePBX will rewrite configuration again.



    And I didn't found any GUI page to change it in FreePBX panel :(



    Could anybody help me?



    Thanks.










    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I use CDR records to MySQL.
      MySQL located on different machine.
      If I change these settings directly in res_odbc_additional.conf



      It working ok, until FreePBX will rewrite configuration again.



      And I didn't found any GUI page to change it in FreePBX panel :(



      Could anybody help me?



      Thanks.










      share|improve this question













      I use CDR records to MySQL.
      MySQL located on different machine.
      If I change these settings directly in res_odbc_additional.conf



      It working ok, until FreePBX will rewrite configuration again.



      And I didn't found any GUI page to change it in FreePBX panel :(



      Could anybody help me?



      Thanks.







      asterisk






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Jun 29 '14 at 12:57









      Andrey

      12117




      12117






















          2 Answers
          2






          active

          oldest

          votes

















          up vote
          0
          down vote













          Change the credentials in /etc/amportal.conf and /etc/freepbx.conf or /etc/asterisk/freepbx.conf.



          p.s not forget install fail2ban, or you will be hacked.






          share|improve this answer






























            up vote
            0
            down vote













            mysql
            use asterisk;
            select value from freepbx_settings where keyword = 'CDRDBPASS';
            update freepbx_settings set value = 'newpass' where keyword = 'CDRDBPASS';
            q






            share|improve this answer





















              Your Answer








              StackExchange.ready(function() {
              var channelOptions = {
              tags: "".split(" "),
              id: "3"
              };
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function() {
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled) {
              StackExchange.using("snippets", function() {
              createEditor();
              });
              }
              else {
              createEditor();
              }
              });

              function createEditor() {
              StackExchange.prepareEditor({
              heartbeatType: 'answer',
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f774750%2fwhere-in-freepbx-gui-possible-to-change-mysql-user-and-password-for-res-odbc-add%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes








              up vote
              0
              down vote













              Change the credentials in /etc/amportal.conf and /etc/freepbx.conf or /etc/asterisk/freepbx.conf.



              p.s not forget install fail2ban, or you will be hacked.






              share|improve this answer



























                up vote
                0
                down vote













                Change the credentials in /etc/amportal.conf and /etc/freepbx.conf or /etc/asterisk/freepbx.conf.



                p.s not forget install fail2ban, or you will be hacked.






                share|improve this answer

























                  up vote
                  0
                  down vote










                  up vote
                  0
                  down vote









                  Change the credentials in /etc/amportal.conf and /etc/freepbx.conf or /etc/asterisk/freepbx.conf.



                  p.s not forget install fail2ban, or you will be hacked.






                  share|improve this answer














                  Change the credentials in /etc/amportal.conf and /etc/freepbx.conf or /etc/asterisk/freepbx.conf.



                  p.s not forget install fail2ban, or you will be hacked.







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Jun 29 '14 at 16:42









                  Jens Erat

                  12.3k114457




                  12.3k114457










                  answered Jun 29 '14 at 16:24









                  arheops

                  6352716




                  6352716
























                      up vote
                      0
                      down vote













                      mysql
                      use asterisk;
                      select value from freepbx_settings where keyword = 'CDRDBPASS';
                      update freepbx_settings set value = 'newpass' where keyword = 'CDRDBPASS';
                      q






                      share|improve this answer

























                        up vote
                        0
                        down vote













                        mysql
                        use asterisk;
                        select value from freepbx_settings where keyword = 'CDRDBPASS';
                        update freepbx_settings set value = 'newpass' where keyword = 'CDRDBPASS';
                        q






                        share|improve this answer























                          up vote
                          0
                          down vote










                          up vote
                          0
                          down vote









                          mysql
                          use asterisk;
                          select value from freepbx_settings where keyword = 'CDRDBPASS';
                          update freepbx_settings set value = 'newpass' where keyword = 'CDRDBPASS';
                          q






                          share|improve this answer












                          mysql
                          use asterisk;
                          select value from freepbx_settings where keyword = 'CDRDBPASS';
                          update freepbx_settings set value = 'newpass' where keyword = 'CDRDBPASS';
                          q







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Jul 12 '16 at 2:05









                          Russ Purinton

                          1




                          1






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Super User!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.





                              Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                              Please pay close attention to the following guidance:


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f774750%2fwhere-in-freepbx-gui-possible-to-change-mysql-user-and-password-for-res-odbc-add%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Plaza Victoria

                              In PowerPoint, is there a keyboard shortcut for bulleted / numbered list?

                              How to put 3 figures in Latex with 2 figures side by side and 1 below these side by side images but in...