[ale] Zimbra - OT SugarCRM

Wed Aug 13 16:31:56 EDT 2014

It sounds like you are working on my team! :)  
I love how vendors ship these magical "virtual appliances" for Windows admins who can't spell Linux.  The only problem is they usually have sshd on, no firewall, and no updates being applied.  When that becomes a problem, suddenly it becomes an issue for the Linux team...
I really laughed when one of the field engineer/sales drones for one of those companies was  smugly telling them how by them not providing the root password, no one could ever get access and log into their appliance.  Yeah...  he turned all sorts of shades of pale when I booted up with a Finnix disk and cleared the root password. :D
Allen B.
--
Allen Beddingfield
Systems Engineer
The University of Alabama

________________________________________
From: ale-bounces at ale.org [ale-bounces at ale.org] on behalf of Lightner, Jeff [JLightner at dsservices.com]
Sent: Wednesday, August 13, 2014 3:15 PM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] Zimbra - OT SugarCRM

Sorry - as noted the only involvement I've had so far was the DNS record.   Whether they allow SQL queries from here to there or are using them if they do I couldn't say.

Here there are certain things they think we don't need to know until they break at which point it suddenly becomes a  "Linux issue" and becomes our problem.   Our first VMWare server was like that.   It had only MS Windows guests so we weren't involved on the install or virtual setups until a simple reboot didn't fix whatever issue they were having 2 years after install at which point the MS team said it was "Linux" server that we needed to address.   The irony of having to ask MS Admins for root password on a Linux system seemed lost on them.   We've also run into it for other systems/appliances with embedded Linux run by Telecom and Network groups but usually those at least were more along the lines of assisting them than suddenly taking ownership.

-----Original Message-----
From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Chris Fowler
Sent: Wednesday, August 13, 2014 3:36 PM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] Zimbra - OT SugarCRM

On 08/11/2014 08:36 AM, Lightner, Jeff wrote:
> Back in January we apparently began using a company for SugarCRM instead of ACT!:
>
> www.atcoresystems - number on their site is 770-466-0722
>
> they gave us a hosted Ubuntu system and we had to point our CRM domain to that.  I do NOT have to administer either the Ubuntu or the Sugar CRM even though my team does all the UNIX/Linux here.
>

Do you have SQL access?  I have some programs written in Perl that allows me to generate reports, assign accounts, etc.

I assign accounts via Perl.  I provide it the user and the account. It will comb the database looking for calls, meetings, notes, etc. Anything that has to do with the account and then assign it to the user.  It then sends out an email to the user telling them they have been assigned that account.

When the sales guys send me leads from shows in XLS format I run a program I wrote that uses SQL access to create leads, emails, etc from that list.

Most of my interactions with Sugar is outside of the web interface.

_______________________________________________
Ale mailing list
Ale at ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo

Athena(r), Created for the Cause(tm)
Making a Difference in the Fight Against Breast Cancer

__________________________________________________________
CONFIDENTIALITY NOTICE: This e-mail may contain privileged

or confidential information and is for the sole use of the intended

recipient(s). If you are not the intended recipient, any disclosure,

copying, distribution, or use of the contents of this information

is prohibited and may be unlawful. If you have received this electronic

transmission in error, please reply immediately to the sender that

you have received the message in error, and delete it. Thank you

_______________________________________________
Ale mailing list
Ale at ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo