Urgent! Need back in our crm!

bradshaw79 · 01-11-2014, 01:06 PM

Quote:

Originally Posted by Habitual

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.

I forgot to post this information earlier:

Code:

[root@vTiger ~]# grep -E "apache|www" /etc/passwd
apache:x:48:48:Apache:/var/www:/sbin/nologin
webalizer:x:67:67:Webalizer:/var/www/usage:/sbin/nologin

bradshaw79 · 01-11-2014, 01:09 PM

Quote:

Originally Posted by Habitual

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.

Wondering if ASTERISK being listed here is a problem?

Code:

[root@vTiger /]# ls -ld /var/jegas/code/git/carsonroselive/crm/
drwxrwxrwx 33 apache asterisk 4096 Jan  8 16:01 /var/jegas/code/git/carsonroselive/crm/

Habitual · 01-11-2014, 03:47 PM

Quote:

Originally Posted by bradshaw79

Wondering if ASTERISK being listed here is a problem?

Code:

[root@vTiger /]# ls -ld /var/jegas/code/git/carsonroselive/crm/
drwxrwxrwx 33 apache asterisk 4096 Jan  8 16:01 /var/jegas/code/git/carsonroselive/crm/

It may very well be the problem.

Is there a vtiger user on the system as well?
check with

Code:

grep tiger /etc/passwd

and let me know.

bradshaw79 · 01-11-2014, 03:50 PM

That didnt output anything...

[root@vTiger /]# grep tiger /etc/passwd
[root@vTiger /]#

bradshaw79 · 01-11-2014, 03:56 PM

Quote:

Originally Posted by Habitual

It may very well be the problem.

Is there a vtiger user on the system as well?
check with

Code:

grep tiger /etc/passwd

and let me know.

Is there a way to list all users on a server? I thought originally that chown put the owner as Asteriskuser...so I tried to chown -R apache, vtiger, root.. all kinds of things from different posts across the internet... no change. The funny thing is I can change the directory that I go into and access different "versions" of our installation and none of them will let me past the login screen. I am wondering if the commands used to affect mysql are also part of the culprit... (I swear, I will *NEVER* experiment with what I THINK I know on a working server again!!! Lesson learned!!

Here is what Im talking about from the guide. I basically cut-n-paste these commands when I was originally screwing everything up:

A few small modifications to Apache.

Code:

sed -i 's/\(^upload_max_filesize = \).*/\120M/' /etc/php.ini
cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf_orig
sed -i 's/^\(User\|Group\).*/\1 asterisk/' /etc/httpd/conf/httpd.conf
service httpd restart

Configure Asterisk database in MYSQL.

Code:

cd /usr/src/freepbx
export ASTERISK_DB_PW=amp109 
mysqladmin -u root create asterisk 
mysqladmin -u root create asteriskcdrdb 
mysql -u root asterisk < SQL/newinstall.sql 
mysql -u root asteriskcdrdb < SQL/cdr_mysql_table.sql

Set permissions on MYSQL database.

Code:

mysql -u root -e "GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY '${ASTERISK_DB_PW}';"
mysql -u root -e "GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost IDENTIFIED BY '${ASTERISK_DB_PW}';"
mysql -u root -e "flush privileges;"

Habitual · 01-12-2014, 08:39 AM

Quote:

Originally Posted by bradshaw79

That didnt output anything...

[root@vTiger /]# grep tiger /etc/passwd
[root@vTiger /]#

OK. let's cut to the chase, I believe that the group permissions to be incorrect (apache:asterisk) on the /var/jegas/code/git/carsonroselive/crm/ directory, so let's change that with

Code:

cp -pr /var/jegas/code/git/carsonroselive/crm/ /var/jegas/code/git/carsonroselive/crm.save
chmod apache:apache -R /var/jegas/code/git/carsonroselive/crm/

and try to login to the crm again. If that fails again, do this:

Code:

ls -ltr /var/jegas/code/git/carsonrosetest/crm/logs

and report the last 2 files at the bottom of the output.
This command lists files in reverse as they are written. One of those logs files should have more information about the
login failure. Hopefully, one of those will be /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log,
if so, you may wish to have a look at the contents of /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log using

Code:

tail -100 /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log

this will give you the last 100 lines of that file and should be useful in
the debugging process. This would be moot if the chmod "fixes" the site for you.

crasuppo_crmlive has what I'd guess is the login/password for the crm portal.

Please let us know...

ericson007 · 01-12-2014, 08:48 AM

So is this the one you cloned? Please close your other thread, they are the same case.

bradshaw79 · 01-12-2014, 11:27 AM

Quote:

Originally Posted by ericson007

So is this the one you cloned? Please close your other thread, they are the same case.

NO... this is the one I WANT to clone, after this is fixed. Its two different issues.

bradshaw79 · 01-12-2014, 11:31 AM

Quote:

Originally Posted by Habitual

OK. let's cut to the chase, I believe that the group permissions to be incorrect (apache:asterisk) on the /var/jegas/code/git/carsonroselive/crm/ directory, so let's change that with

Code:

cp -pr /var/jegas/code/git/carsonroselive/crm/ /var/jegas/code/git/carsonroselive/crm.save
chmod apache:apache -R /var/jegas/code/git/carsonroselive/crm/

and try to login to the crm again. If that fails again, do this:

Code:

ls -ltr /var/jegas/code/git/carsonrosetest/crm/logs

and report the last 2 files at the bottom of the output.
This command lists files in reverse as they are written. One of those logs files should have more information about the
login failure. Hopefully, one of those will be /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log,
if so, you may wish to have a look at the contents of /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log using

Code:

tail -100 /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log

this will give you the last 100 lines of that file and should be useful in
the debugging process. This would be moot if the chmod "fixes" the site for you.

crasuppo_crmlive has what I'd guess is the login/password for the crm portal.

Please let us know...

This is what happened:

Code:

[root@vTiger ~]# chmod apache:apache -R /var/jegas/code/git/carsonroselive/crm/
chmod: invalid mode: `apache:apache'
Try `chmod --help' for more information.
[root@vTiger ~]#

Habitual · 01-12-2014, 03:37 PM

My bad, that should be

Code:

chown apache:apache -R /var/jegas/code/git/carsonroselive/crm/

Sorry, (good thing we made a copy.save)

bradshaw79 · 01-13-2014, 07:27 AM

Quote:

Originally Posted by Habitual

My bad, that should be

Code:

chown apache:apache -R /var/jegas/code/git/carsonroselive/crm/

Sorry, (good thing we made a copy.save)

Still nothing

bradshaw79 · 01-13-2014, 07:37 AM

Quote:

Originally Posted by bradshaw79

This is what happened:

Code:

[root@vTiger ~]# chmod apache:apache -R /var/jegas/code/git/carsonroselive/crm/
chmod: invalid mode: `apache:apache'
Try `chmod --help' for more information.
[root@vTiger ~]#

Code:

[root@vTiger ~]# ls -ltr /var/jegas/code/git/carsonrosetest/crm/logs
total 120
-rwxrwxrw- 1 root   asterisk      0 Nov 15  2010 todel.txt.txt
-rwxrwxrw- 1 root   asterisk 109578 Feb 25  2011 migration.log
-rw-rw-rw- 1 apache asterisk      0 Mar 17  2011 vtigercrm.log

[root@vTiger ~]# vi /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log <--- shows an empty file.

When i try to look at the log:

Code:

[root@vTiger ~]# tail -100 /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log
[root@vTiger ~]# tail -100 /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log
[root@vTiger ~]# tail -100 /var/jegas/code/git/carsonrosetest/crm/logs/vtigercrm.log
[root@vTiger ~]#

I noticed also that we are using "carsonrosetest" and I think i SHOULD be using "carsonroselive"...however:

Code:

[root@vTiger ~]# tail -100 /var/jegas/code/git/carsonroselive/crm/logs/vtigercrm.log
tail: cannot open `/var/jegas/code/git/carsonroselive/crm/logs/vtigercrm.log' for reading: No such file or directory
[root@vTiger ~]#

Also:

Code:

[root@vTiger ~]# ls -ltr /var/jegas/code/git/carsonroselive/crm/logs
total 112
-rwxrwxrw- 1 apache apache      0 May 18  2012 todel.txt.txt
-rwxrwxrw- 1 apache apache 109578 May 18  2012 migration.log

bradshaw79 · 01-13-2014, 07:47 AM

Is there somewhere I can put a "bounty" on this? I really have to get this working today...

I cant believe I screwed this up so bad!!

Habitual · 01-13-2014, 08:03 AM

http://www.linuxquestions.org/questi...8/#post5068976

bradshaw79 · 01-13-2014, 08:28 AM

Quote:

Originally Posted by Habitual

http://www.linuxquestions.org/questi...8/#post5068976

Jeez... thats expensive just to post it...