Disappointed with support available

[2bears]

I'm disappointed at the response I've got using this forum. We like using SugarCRM Open Source edition, but I'm disappointed at the lack of replies. In February I asked for help on entering an SQL command to obtain data. I'm sure it ought to be a simple answer but only one person replied. We needed more help to get up and running and I don't feel that it was a difficult question. It's a shame the community support is not better.

Maybe I should try posing the question another way? Essentially, the requirement is to be able to look at raw data in the database, using mySql commands. The platform is Ubuntu Linux and it was a stack installation from which I installed the system. Hope to get a bit more help if some kind person can oblige. Thanks.

[mikesolomon]

You can use a tool like phpmyadmin to view your mysql data

alternatively have a look at heidisql http://www.heidisql.com/ or mysql workbench http://wb.mysql.com/

[2bears]

You can use a tool like phpmyadmin to view your mysql datahttp://wb.mysql.com/

Many thanks Mike, it's good to get a reply. I will go for phpadmin as you say, and make a more concerted effort to get it to work, however my initial test was actually to issue SQL commands from the Ubuntu platform on which SugarCRM is running...

cd /opt/sugarcrm-6.0.3/mysql/bin
./mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[cactusJoe]

Your issue does not really look like a problem with SugarCRM, but rather how to use MySQL in general.

I cannot give you an introduction to MySQL here, but as a starting point, if you were to try to connect a to MySQL from the command line, you would use a command something like

mysql -u <username> -p <database>

If you used a GUI client, you would also have to supply the user database name, the password and the actual database.

Sorry - but you really cannot blame the SugarCRM community for the lack of help with MySQL - you should rather get that at the database community at http://dev.mysql.com/doc/index-topic.html

[2bears]

...you would use a command something like
mysql -u <username> -p <database>

Yes, I understand. In my post some weeks ago, I asked for help on using precisely this command, within the Stack installation of Sugar. There were no replies which addressed the inability to use mysql from the installation. It is at http://apps.sugarcrm.com/forums/showthread.php?t=69322

Sorry - but you really cannot blame the SugarCRM community for the lack of help with MySQL

Sorry but I didn't blame the Community but merely expressed disappointment, which I believe is justified; a look at many posters' requests for help remain there with no replies. Please take a look for yourself. Many of them show large counts of views, but no replies.

I don't see that it matters significantly whether the command on which I seek help with is mysql-related or a question of pure SugarCRM. Instead I think it's reasonable to expect that some others will have wanted to do something similar, in addition to which, the SugarCRM Stack includes mysql.

If the Stack installation does not include a working mysql command-line client, which perhaps is the reason I couldn't enter mysql commands at the Linux shell, then I'd reasonably expect that simple information to be conveyed. If not, then the Community forum isn't fulfilling a basic purpose.

[Angel]

I don't see that it matters significantly whether the command on which I seek help with is mysql-related or a question of pure SugarCRM. Instead I think it's reasonable to expect that some others will have wanted to do something similar, in addition to which, the SugarCRM Stack includes mysql.

I would agree with you that your expectation is not unreasonable, however, you should bear in mind that the vast majority of those replying to messages on this forum aren't obligated to do so. We are all volunteers and are here because we want to help others.

By the same token, 99% of us have jobs or tasks we need to tend to that are a higher priority than ensuring everyone gets a reply. Criticizing people's volunteered time [or lack thereof] doesn't really serve as a motivator. There are plenty of paid for support providers available world wide. If your need is immediate, consider paying someone to provide the level of service you seek.

With regards to your issue, as cactusJoe indicates, your issue is more a MySQL issue. It seems as though it is not configured to listen on TCP/IP or perhaps it is not even running. It is hard to give you a definitive answer. In that example, I would say it is a bit unreasonable to expect us to know the exact source of your problem with the limited amount of information that we know about your setup. Likewise, expecting the community to help you address every issue you find along the way to getting a working Sugar system on your server is also more than a bit unreasonable. Suppose you encounter some networking problem that prevents other users from connecting, expecting us to resolve that problem for you (beyond the basics or providing general advice) is unreasonable in my opinion.