LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-10-2014, 08:50 AM   #1
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Rep: Reputation: Disabled
Urgent! Need back in our crm!


OS: Centos 5.9 i686

I have a very customized version of vTiger installed on this server. I have forever said we need to migrate this CRM to a virtual box for sand boxing, etc.

In my infinite wisdom, because we rarely use the CRM, I decided to install FreePBX on the same box. ***STUPID***

Here is the guide I followed: http://wiki.freepbx.org/display/HTGS...ialSystemSetup

Somehow in all this, I can now only get to the login screen for vTiger and no matter what I enter it just goes back to the same login screen, over and over. Its like there is some kind of permission issue between http and mysql?

Im thinking that in following these instructions, I somehow screwed up the permissions somewhere? Looking for guidance and also how to move this installation to a virtual box so that I can put the hardware its on now, to better use.
I really need to get back in to the CRM... any help is greatly appreciated!

Doug
 
Old 01-10-2014, 09:04 AM   #2
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
restore from backups?
 
Old 01-10-2014, 09:27 AM   #3
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Habitual View Post
restore from backups?
Id love to do that, I have everything backed up... Im just not able to restore from there... When I tried to import the data, mysql fails and gives errors... I installed a fresh version of vtiger 5.2.1 in a virtualbox... the default layout or whatever is not jiving with the sql database and files I have backed up... Really, at the end of the day, I tried to install Freepbx on the same machine as the vtiger crm...the trouble seems to have started when I entered these commands:
adduser asterisk -M -c "Asterisk User"
chown asterisk. /var/run/asterisk
chown -R asterisk. /etc/asterisk
chown -R asterisk. /var/{lib,log,spool}/asterisk
chown -R asterisk. /usr/lib/asterisk
mkdir /var/www/html
chown -R asterisk. /var/www/
 
Old 01-10-2014, 09:41 AM   #4
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
Quote:
Originally Posted by bradshaw79 View Post
Id love to do that, I have everything backed up... Im just not able to restore from there... When I tried to import the data, mysql fails and gives errors... I installed a fresh version of vtiger 5.2.1 in a virtualbox... the default layout or whatever is not jiving with the sql database and files I have backed up... Really, at the end of the day, I tried to install Freepbx on the same machine as the vtiger crm...the trouble seems to have started when I entered these commands:
adduser asterisk -M -c "Asterisk User"
chown asterisk. /var/run/asterisk
chown -R asterisk. /etc/asterisk
chown -R asterisk. /var/{lib,log,spool}/asterisk
chown -R asterisk. /usr/lib/asterisk
mkdir /var/www/html
chown -R asterisk. /var/www/
If you're sure it's a permissions (file?) issue then why are you re-importing the data into mysql?
"mysql fails and gives errors...", "not jiving with the sql database and files" and "not able to restore from there"
are rather vague statements.
What does
Code:
grep -i tiger /var/log/* -R
show is happening?

The only issue I see outright is the
Code:
chown -R asterisk. /var/www/
screw up, Yes, I did go there.
That can be fixed easily enough.
What directory is vtiger installed in? Let's see the perms there,
Code:
ls -ld /path/to/vtiger/directory
Are you trying to fix the broken install at this time or install and restore from backup into a VM?
You're all over the map. Slow down. Breathe...

Last edited by Habitual; 01-10-2014 at 01:51 PM.
 
Old 01-10-2014, 10:52 AM   #5
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
https://wiki.vtiger.com/index.php/In...le_Permissions

from those instructions, it appears it should be in /var/www/html/vtigercrm
Read and Write permissions should be enabled for user/group who owns webserver process (like www-data or httpd or apache).
Apache on my CentOS 6.4 host owns /var/www/html/sitename/
Yours is probably the same owner, even on CentOS 5.9

Code:
grep -E "apache|www" /etc/passwd
Let us know where you get stuck with adequate details.
 
Old 01-10-2014, 02:32 PM   #6
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Habitual View Post
If you're sure it's a permissions (file?) issue then why are you re-importing the data into mysql?
"mysql fails and gives errors...", "not jiving with the sql database and files" and "not able to restore from there"
are rather vague statements.
What does
Code:
grep -i tiger /var/log/* -R
show is happening?
I cant really tell you, its alot...miles of code.

The only issue I see outright is the
Code:
chown -R asterisk. /var/www/
screw up, Yes, I did go there.
That can be fixed easily enough.
What directory is vtiger installed in? Let's see the perms there,
Code:
ls -ld /path/to/vtiger/directory
A couple years ago we had a contractor build this for us, so its a weird path: /var/jegas/code/git/carsonroselive/crm
[root@vTiger crm]# ls -ld /var/jegas/code/git/carsonroselive/crm
drwxrwxrwx 33 apache asterisk 4096 Jan 8 16:01 /var/jegas/code/git/carsonroselive/crm

Are you trying to fix the broken install at this time or install and restore from backup into a VM?
You're all over the map. Slow down. Breathe...
I need to fix the current, then move it to a virtualbox
 
Old 01-10-2014, 02:35 PM   #7
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
stranded...

Quote:
Originally Posted by bradshaw79 View Post
I need to fix the current, then move it to a virtualbox
[root@vTiger crm]# ls -ld /var/jegas/code/git/carsonroselive/crm
drwxrwxrwx 33 apache asterisk 4096 Jan 8 16:01 /var/jegas/code/git/carsonroselive/crm

I cant really tell you, its alot...miles of code. grep -i tiger /var/log/* -R

A couple years ago we had a contractor build this for us, so its a weird path: /var/jegas/code/git/carsonroselive/crm
[root@vTiger crm]# ls -ld /var/jegas/code/git/carsonroselive/crm
drwxrwxrwx 33 apache asterisk 4096 Jan 8 16:01 /var/jegas/code/git/carsonroselive/crm
 
Old 01-10-2014, 03:12 PM   #8
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
Quote:
Originally Posted by bradshaw79 View Post
drwxrwxrwx 33 apache asterisk 4096 Jan 8 16:01 /var/jegas/code/git/carsonroselive/crm
That should be ok, but don't hold me to it. How the hell asterisk got group perms on that directory is a mystery but since you said the vtiger screen just flashes at you trying to login, you probably just have a password issue.

do a
Code:
ls -al /var/jegas/code/git/carsonroselive/crm/* -R | less
and scroll the output of files for any file not owned by apache and let us know...

What version of vtiger crm is installed?
What OS? What Platform/architecture?

Casually reading the wiki, it seems that this product has an integrated version of mysql built-in, or does it use a (pre-)existing database?
If it's internal to the crm, then
Code:
less /var/jegas/code/git/carsonroselive/crm/config.inc.php
should have some clues about the environment.
If it doesn't use an internal database, then do this, as root:
Code:
mysql -e "show databases" -Ns
and report the output please.
 
Old 01-10-2014, 04:58 PM   #9
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
I think there may be a symbolic link in /var/www/ taht is "/crm/" that links back to the jegas/code/git/..... when this was entered "chown -R asterisk. /var/www/" it probably just bled over to the "/crm/".


ls -al /var/jegas/code/git/carsonroselive/crm/* -R | less resulted in all files being owned by apache.

What version of vtiger crm is installed? --> 5.2.1

What OS? What Platform/architecture?
[root@vTiger crm]# uname -a
Linux vTiger 2.6.18-371.3.1.el5.centos.plusxen #1 SMP Fri Dec 6 00:16:22 EST 2013 i686 i686 i386 GNU/Linux


mysql -e "show databases" -Ns --> had to modify "-p" for password... output is :
[root@vTiger crm]# mysql -p -e "show databases" -Ns
Enter password:
information_schema
asterisk
asteriskcdrdb
atmail
crasuppo_crmdavidk
crasuppo_crmlive <--- is the one i need to work
crasuppo_crmtest
crasuppo_crmtest2
crasuppo_vt521
mysql
test
wordpress
 
Old 01-10-2014, 05:43 PM   #10
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
Quote:
Originally Posted by bradshaw79 View Post
I think there may be a symbolic link in /var/www/ taht is "/crm/" that links back to the jegas/code/git/..... when this was entered "chown -R asterisk. /var/www/" it probably just bled over to the "/crm/".
That may explain it.

Quote:
ls -al /var/jegas/code/git/carsonroselive/crm/* -R | less resulted in all files being owned by apache.
That's good news too.

Quote:
5.2.1
Thanks.

What OS? What Platform/architecture?
Quote:
Linux vTiger 2.6.18-371.3.1.el5.centos.plusxen #1 SMP Fri Dec 6 00:16:22 EST 2013 i686 i686 i386 GNU/Linux[/COLOR][/B]
Quote:
[root@vTiger crm]# mysql -p -e "show databases" -Ns
Enter password:
...
crasuppo_crmlive <--- is the one i need to work
...
Great Progress.

Now let's examine two more things, the contents (tables in) crasuppo_crmlive and the file contents of /var/jegas/code/git/carsonroselive/crm/config.inc.php

for now, open terminal and issue this command:
Code:
mysql -p -e "use crasuppo_crmlive; show tables" -Ns
One of those has to have the credentials (better not be plain text, but if it is, you are lucky now but have work to do if it is)
Show me the output of the "show tables" command and tell me the login name of the user that you are trying to login as (the default is admin/admin, did you, or are you trying that account?)

One of the tables in the output has to have the account settings, and if you can identify that one for me, it's a great step.
If not, just show me the output.

Great work up til now, you must have relaxed a bit?
 
Old 01-10-2014, 06:05 PM   #11
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
I dont know how to view whats in the table

One of the tables in the output has to have the account settings, and if you can identify that one for me, it's a great step.
If not, just show me the output.

Great work up til now, you must have relaxed a bit? [/QUOTE]

Trying to Here is the output:

Code:
[root@vTiger vtigercrm]# mysql -p -e "use crasuppo_crmlive; show tables" -Ns
Enter password:
com_vtiger_workflow_activatedonce
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtemplates
com_vtiger_workflowtemplates_seq
vtiger_account
vtiger_accountbillads
vtiger_accountdepstatus
vtiger_accounting
vtiger_accounting_payments
vtiger_accountingcategory
vtiger_accountingcategory_seq
vtiger_accountingcf
vtiger_accountingconfig
vtiger_accountingstate
vtiger_accountingstate_seq
vtiger_accountingtransmethods
vtiger_accountingtype
vtiger_accountingtype_seq
vtiger_accountownership
vtiger_accountrating
vtiger_accountregion
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activsubtype
vtiger_announcement
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_audit_trial_seq
vtiger_axfax
vtiger_axfaxcf
vtiger_axfaxconfig
vtiger_axfaxconfig_activemod
vtiger_blocks
vtiger_blocks_seq
vtiger_businesstype
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_625
vtiger_cf_625_seq
vtiger_cf_627
vtiger_cf_627_seq
vtiger_cf_637_seq
vtiger_cf_640_seq
vtiger_cf_666
vtiger_cf_666_seq
vtiger_cf_667
vtiger_cf_667_seq
vtiger_cf_671
vtiger_cf_671_seq
vtiger_cf_672
vtiger_cf_672_seq
vtiger_cf_677
vtiger_cf_677_seq
vtiger_cf_688
vtiger_cf_688_seq
vtiger_cf_707
vtiger_cf_707_seq
vtiger_cf_709
vtiger_cf_709_seq
vtiger_chat_msg
vtiger_chat_pchat
vtiger_chat_pvchat
vtiger_chat_users
vtiger_cntactivityrel
vtiger_cobropago
vtiger_cobropagocf
vtiger_competitor
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contacttype
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_crmentity
vtiger_crmentity_seq
vtiger_crmentitynotesrel
vtiger_crmentityrel
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_info
vtiger_currency_info_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_tabs
vtiger_customview
vtiger_customview_seq
vtiger_cvadvfilter
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_module_rel_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dealintimation
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_defaultcv
vtiger_downloadpurpose
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_durationhrs
vtiger_durationmins
vtiger_email_access
vtiger_email_track
vtiger_emaildetails
vtiger_emailtemplates
vtiger_emailtemplates_ignorepicklistvalues
vtiger_emailtemplates_productbloc_tpl
vtiger_emailtemplates_seq
vtiger_emailtemplates_settings
vtiger_emakertemplates
vtiger_emakertemplates_attch
vtiger_emakertemplates_default_from
vtiger_emakertemplates_delay
vtiger_emakertemplates_documents
vtiger_emakertemplates_drip_groups
vtiger_emakertemplates_drip_groups_seq
vtiger_emakertemplates_drip_tpls
vtiger_emakertemplates_drip_tpls_seq
vtiger_emakertemplates_drips
vtiger_emakertemplates_drips_seq
vtiger_emakertemplates_emails
vtiger_emakertemplates_ignorepicklistvalues
vtiger_emakertemplates_license
vtiger_emakertemplates_picklists
vtiger_emakertemplates_productbloc_tpl
vtiger_emakertemplates_profilespermissions
vtiger_emakertemplates_relblockcol
vtiger_emakertemplates_relblockcriteria
vtiger_emakertemplates_relblockcriteria_g
vtiger_emakertemplates_relblockdatefilter
vtiger_emakertemplates_relblocks
vtiger_emakertemplates_relblocks_seq
vtiger_emakertemplates_sent
vtiger_emakertemplates_seq
vtiger_emakertemplates_settings
vtiger_emakertemplates_sharing
vtiger_emakertemplates_sharing_drip
vtiger_emakertemplates_userstatus
vtiger_emakertemplates_version
vtiger_entityname
vtiger_evaluationstatus
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_field
vtiger_field_seq
vtiger_fieldformulas
vtiger_fieldformulas_seq
vtiger_fieldmodulerel
vtiger_files
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_headers
vtiger_home_layout
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_import_maps
vtiger_industry
vtiger_industry_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_invitees
vtiger_invoice
vtiger_invoice_recurring_info
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatus_seq
vtiger_invoicestatushistory
vtiger_language
vtiger_language_seq
vtiger_lar
vtiger_lead_view
vtiger_lead_view_seq
vtiger_leadacctrel
vtiger_leadaddress
vtiger_leadcontrel
vtiger_leaddetails
vtiger_leadpotrel
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_licencekeystatus
vtiger_links
vtiger_links_seq
vtiger_listview_colors
vtiger_listviewcolors_license
vtiger_loginhistory
vtiger_mail_accounts
vtiger_mail_accounts_seq
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_moduleowners
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_opportunitystage
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_organizationdetails
vtiger_ownernotify
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_paymentcategory
vtiger_paymentcategory_seq
vtiger_paymentmode
vtiger_paymentmode_seq
vtiger_pbxmanager
vtiger_pdfmaker
vtiger_pdfmaker_breakline
vtiger_pdfmaker_ignorepicklistvalues
vtiger_pdfmaker_images
vtiger_pdfmaker_label_keys
vtiger_pdfmaker_label_vals
vtiger_pdfmaker_license
vtiger_pdfmaker_productbloc_tpl
vtiger_pdfmaker_profilespermissions
vtiger_pdfmaker_relblockcol
vtiger_pdfmaker_relblockcriteria
vtiger_pdfmaker_relblockcriteria_g
vtiger_pdfmaker_relblockdatefilter
vtiger_pdfmaker_relblocks
vtiger_pdfmaker_releases
vtiger_pdfmaker_seq
vtiger_pdfmaker_settings
vtiger_pdfmaker_sharing
vtiger_pdfmaker_usersettings
vtiger_pdfmaker_userstatus
vtiger_pdfmaker_version
vtiger_picklist
vtiger_picklist_seq
vtiger_picklistvalues_seq
vtiger_pobillads
vtiger_portal
vtiger_portal_seq
vtiger_portalinfo
vtiger_portalinfo_acc
vtiger_poshipads
vtiger_postatus
vtiger_postatus_seq
vtiger_postatushistory
vtiger_potcompetitorrel
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcollaterals
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projectteam
vtiger_projectteamcf
vtiger_projectteamfunction
vtiger_projectteamfunction_seq
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_quickview
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestage_seq
vtiger_quotestagehistory
vtiger_rating
vtiger_rating_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_revenuetype
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rss
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_smsnotifier
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_smsnotifiercf
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatus_seq
vtiger_sostatushistory
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_systems_seq
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticketstracktime
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_user_module_preferences
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_usertype
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_wordtemplates
vtiger_wordtemplates_seq
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
 
Old 01-10-2014, 06:39 PM   #12
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
Users name is "daily" but it doesnt matter what user I try to use... it just blinks and goes back to a reset login screen, as if I had never entered in any uname or pword at all...
 
Old 01-11-2014, 08:03 AM   #13
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
Have a look at vtiger_users using
Code:
mysql -p -e "use crasuppo_crmlive; desc vtiger_users;" -Ns
and post the output. IF it appears to have 'sensitive' login data, then don't. We will
have found our target.

Can you identify if there seems to be a vtiger-specific log file using
Code:
grep -i tiger /var/log/* -Rl | grep -i log
please? This will show you just the file names that contain vtiger and log

This 'flashing' upon attempted login has to be logged somewhere, if it's not in /var/log/something/ then quite possibly under
/var/jegas/code/git/carsonroselive/crm/, so examine
Code:
grep -i tiger /var/jegas/code/git/carsonroselive/crm/* -Rl | grep -i log
output
for signs of the obvious "log" filename please.

vtiger_loginhistory is interesting.

We'll examine that table next after you look for the logging file. I'm outa here until Monday, Jan 13th.
I'm East of you by an hour so I start early.

Is this vtiger v.5.2.1 crm accessed over the internet, or it is restricted in some way?
Have a good weekend.
 
Old 01-11-2014, 10:03 AM   #14
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,258
Blog Entries: 11

Rep: Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290Reputation: 2290
Doug:

grep'ing for vtiger-related log files is not efficient.
Use this instead:
Code:
find `pwd` /var -iname "*vtiger*.*log*"
should be 1.), faster and 2.) more efficient searching.

Please report the output,
Thank you.

John
 
Old 01-11-2014, 01:01 PM   #15
bradshaw79
LQ Newbie
 
Registered: Jan 2014
Location: Plano, TX
Distribution: Centos
Posts: 26

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Habitual View Post
Doug:

grep'ing for vtiger-related log files is not efficient.
Use this instead:
Code:
find `pwd` /var -iname "*vtiger*.*log*"
should be 1.), faster and 2.) more efficient searching.

Please report the output,
Thank you.

John
Here is what "mysql -p -e "use crasuppo_crmlive; desc vtiger_users;" -Ns" output:

Code:
[root@vTiger ~]# mysql -p -e "use crasuppo_crmlive; desc vtiger_users;" -Ns
Enter password:
id      int(11) NO      PRI     NULL    auto_increment
user_name       varchar(255)    YES     MUL     NULL
user_password   varchar(128)    YES     MUL     NULL
user_hash       varchar(32)     YES             NULL
cal_color       varchar(25)     YES             #E6FAD8
first_name      varchar(30)     YES             NULL
last_name       varchar(30)     YES             NULL
reports_to_id   varchar(36)     YES             NULL
is_admin        varchar(3)      YES             0
currency_id     int(19) NO              1
description     text    YES             NULL
date_entered    timestamp       NO              CURRENT_TIMESTAMP
date_modified   timestamp       NO              0000-00-00 00:00:00
modified_user_id        varchar(36)     YES             NULL
title   varchar(50)     YES             NULL
department      varchar(50)     YES             NULL
phone_home      varchar(50)     YES             NULL
phone_mobile    varchar(50)     YES             NULL
phone_work      varchar(50)     YES             NULL
phone_other     varchar(50)     YES             NULL
phone_fax       varchar(50)     YES             NULL
email1  varchar(100)    YES             NULL
email2  varchar(100)    YES             NULL
yahoo_id        varchar(100)    YES             NULL
status  varchar(25)     YES             NULL
signature       varchar(250)    YES             NULL
address_street  varchar(150)    YES             NULL
address_city    varchar(100)    YES             NULL
address_state   varchar(100)    YES             NULL
address_country varchar(25)     YES             NULL
address_postalcode      varchar(9)      YES             NULL
user_preferences        text    YES             NULL
tz      varchar(30)     YES             NULL
holidays        varchar(60)     YES             NULL
namedays        varchar(60)     YES             NULL
workdays        varchar(30)     YES             NULL
weekstart       int(11) YES             NULL
date_format     varchar(200)    YES             NULL
hour_format     varchar(30)     YES             am/pm
start_hour      varchar(30)     YES             10:00
end_hour        varchar(30)     YES             23:00
activity_view   varchar(200)    YES             Today
lead_view       varchar(200)    YES             Today
imagename       varchar(250)    YES             NULL
deleted int(1)  NO              0
confirm_password        varchar(30)     YES             NULL
internal_mailer varchar(3)      NO              1
reminder_interval       varchar(100)    YES             NULL
reminder_next_time      varchar(100)    YES             NULL
crypt_type      varchar(20)     NO              MD5
accesskey       varchar(36)     YES             NULL
gcaluser        varchar(51)     YES             NULL
gcalpass        varchar(51)     YES             NULL
Here is what find `pwd` /var -iname "*vtiger*.*log*" output:

Code:
[root@vTiger ~]# find `pwd` /var -iname "*vtiger*.*log*"
/root/BACKUPJEGAS/code/git/carsonrosetest/crm/logs/vtigercrm.log
/var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log
I did notice that "carsonroselive" directory/database was not listed, only carsonrosetest?

Our vTiger CRM is accessed via browser on our local network... You could access it via web, if I forwarded the ports. We have used it in this way before, when we had remote reps. The goal is to again access it via internet for the remote reps, but I think it would be better to put this installation in a virtualbox so I can reclaim the hardware its currently on.

Last edited by bradshaw79; 01-11-2014 at 01:03 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
RAID1: Urgent.. Two disks out of sync... how to get them back in sync? tkalfaoglu Linux - Server 1 10-18-2013 03:42 AM
Urgent Help for bounce back tracking : Postfix/Amavisd-new/Mysql with Vitual domains jyotirtest Linux - Server 1 03-03-2011 04:57 AM
LXer: Open source CRM meets SaaS CRM LXer Syndicated Linux News 0 10-05-2006 10:54 AM
Back up tape drive urgent spilotro47 Linux - Hardware 17 06-06-2005 07:56 AM


All times are GMT -5. The time now is 05:23 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration