TurnKey Linux Virtual Appliance Library

Turnkey SugarCRM mysql database and adding .sql

I have sugarCRM Version 6.5.2 running on proxmox 2.1-1.  I've gotten the module loader in sugarCRM to install the select service desk module, and the instructions tell me to installed stored function in the data base. Does anyone have a clue if I'm supposed to add it to the SugarCRM tables? And if so, what is the name of the database installed by turnkey sugarcrm? 

And just to be clear, once I know the name of the database, from the mysql> i can just type \. procedura.sql  ? 

 

Thanks for any mysql gurus out there; I've only worked with mssql from 2008 server thus far.

Jeremy's picture

I'm not sure

Perhaps the best place to get specific SugarCRM advice is via their forums. As for the TKL SugarCRM DB, I suggest that you have a look with phpMyAdmin (https://<appliance-IP-or-FQDN>:12322 - use username root and your MySQL root password to login). I suspect that you will need to load the .sql file you have into the SugarCRM DB, but you should be able to do that within phpMyAdmin.

**SOLVED**

Thank you! I wasn't getting any help from that forum. MyphpAdmin worked out perfectly by selecting the database (sugarcrm) from the databases tab then going to the SQL tab and pasting the contents of procedura.sql into the inputbox and changing the delimeter to | per the installation instructions.

For posterity's sake, anyone else trying to install this module, the next step is to change the emailnotifications/config.php file to

    define("SMTP_USER",  "USER");
    define("SMTP_USER_PASSWORD", "PASSWORD");
    define("REPLY_TO_EMAIL", "ADRES EMAIL ZWROTNY");
    define("SENDER_NAME", "NAZWA NADAWCY");
    define("SMTP_URL" ,'SMT_URL');

 

by logging into root

cd /var/www/sugarcrm/include/emailnotification/

vi config.php and edit (or use nano if you're not into the vim editor)

Thanks alot Jeremy, your posts in other threads has helped imensely with all the errors that I've had, and now this. I really appreciate all your work and contributions to the community.

Jeremy's picture

Glad you got it sorted

Thanks for posting back and thanks for the kudos! :)

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)