Linux - NewbieThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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***
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!
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/
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...
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.
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
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
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:
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
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?
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]
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...
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
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.