vtiger from aur - post installation help

senorsmile · 2012-01-05 01:24:14

I would like to try out vtiger crm. There's a package for it in the AUR. I installed it using the trusty packer.

There were a few caveats. I had to manually install libjpeg, since its dependency name is different than its actual install name:

packer -S libjpeg-turbo
packer -S vtigercrm

I then started mysql and apache

cd /etc/rc.d
./mysqld start
./httpd start

I tried navigating to the site served up by apache but neither the index nor the install php files come up properly. It just shows the source of those files. I assume there are some other steps that much be done, but I am not sure what. I have looked through the documentation on vtiger's site for installation on Linux, but can't seem to figure out what needs to come next

Last edited by senorsmile (2012-01-05 01:24:36)

Trilby · 2012-01-05 01:30:25

I'm not familiar with vtiger, but I assume you have been through the Arch LAMP wiki, and set up the host(s) in httpd.conf to allow vtiger scripting, right?

senorsmile · 2012-01-05 01:41:34

Trilby wrote:

I'm not familiar with vtiger, but I assume you have been through the Arch LAMP wiki, and set up the host(s) in httpd.conf to allow vtiger scripting, right?

Thanks for the heads up. I hadn't done that yet!

I did

vim /etc/httpd/conf/httpd.conf

found

# Virtual hosts
#Include conf/extra/httpd-vhosts.conf

and added after that

Include /etc/httpd/conf/extra/httpd-vtigercrm.conf

The contents of /etc/httpd/conf/extra/httpd-vtigercrm.conf were:

Alias /vtigercrm /srv/http/vtigercrm

<Directory "/srv/http/vtigercrm">
   AllowOverride FileInfo
   Deny from all
</Directory>

I changed the deny to allow to allow other machines on my network to try it out:

Alias /vtigercrm /srv/http/vtigercrm

<Directory "/srv/http/vtigercrm">
   AllowOverride FileInfo
   Allow from all
</Directory>

However, if I go to either http://vtiger-ipaddress/vtigercrm/install.php or http://vtiger-ipaddress/vtigercrm/index.php I still just see the source of the PHP. It doesn't seem to be processing the PHP.

Last edited by senorsmile (2012-01-05 01:42:12)

Trilby · 2012-01-05 01:48:00

did you restart all the services again after the edit? The one way to be sure is to reboot.

senorsmile · 2012-01-05 05:03:55

Trilby wrote:

did you restart all the services again after the edit? The one way to be sure is to reboot.

I did. I have left the office for today where I installed it in a VM. I will go through the page on setting up a LAMP again and see where I went wrong.

beatboxchad · 2012-02-16 06:01:47

I got it set up. Here is my best summary of each roadblock I ran into and how I got around it:

Starting with the problem you're having - my /etc/httpd/conf/extra/httpd-vtigercrm.conf looks like this:

AllowOverride All
AddHandler cgi-script .cgi .pl
Options ExecCGI Includes FollowSymlinks
Order Allow,Deny
Allow from All

I stole these lines from the corresponding conf file for sql-ledger which I hacked together a few weeks ago. I don't know what these lines do, I'm still learning what the hell I'm doing

That opened up the dialogue when I pointed my browser at the proper address. After that I had some trouble with the fields there - here's a screenshot and some explanation of what worked:

http://forums.vtiger.com/vtiger/demo/wi … -Step5.JPG

I ended up using localhost:port like this example because that, of course, was where mysql was for me. Pretty self-explanatory, but I was using the hostname of the server for awhile and it wasn't working, so hey. I got a little confused with the redundancy of the sql username fields on the left - if you check the Create Database field, it opens up a seemingly-redundant set of fields. Anyway, using the root username and password for mysql in both sets of fields worked for me. The User Configuration on the right is for logging into vtiger for the first time once it's set up.*

After that, I thought I was on a roll.. .then I got the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=InnoDB' at line 7Error: Tables partially created. Table creation failed.

I found out that this has to do with the fact that vtiger isn't compatible with the latest versions of mysql or php. Specifically, it uses a depreciated command to create the databases. I was able to fix it with some manual editing:

First I edited /etc/mysql/my.cnf and followed the commented instructions to enable InnoDB databases.

Not-exactly-following the instructions at http://mayoorathen.blogspot.com/2011/04 … ation.html, I edited schema/DatabaseSchema.xml and replaced all instances of Type with ENGINE. If you have vim, it's easy. Navigate to the schema directory and:

vim DatabaseSchema.xml

Then type : to get a command prompt-ey thing, and enter

%s/\<Type\>/ENGINE/g

Save with :w and quit with :q. Gotta hit enter after each. Probably preaching to the choir here, but I thought I'd be thorough.

I also did the same operation to 503_to_504rc.php under modules/Migration/DBChanges/ - just open it in vim and use the same command. I figured this would be a good idea in case I ever needed to, uh, migrate things. Or something...

After that it installed without a hitch. I'll post if it turns out I broke anything. If you see anything in blatantly poor practice, please enlighten me!

*I probably didn't have to do this, but I'm including it as a possible last-resort: before this step was completed I ended up accessing mysql in an ssh session and manually creating the database, then granting permission to any user from my other machine to mess with it. If you don't know your way around that stuff already, this is what walked me through it: http://www.cyberciti.biz/tips/how-do-i- … erver.html

Moderator edit: The included image ist too big. See our policy.

Last edited by bernarcher (2012-02-16 08:49:54)

Arch Linux

#1 2012-01-05 01:24:14

vtiger from aur - post installation help

#2 2012-01-05 01:30:25

Re: vtiger from aur - post installation help

#3 2012-01-05 01:41:34

Re: vtiger from aur - post installation help

#4 2012-01-05 01:48:00

Re: vtiger from aur - post installation help

#5 2012-01-05 05:03:55

Re: vtiger from aur - post installation help

#6 2012-02-16 06:01:47

Re: vtiger from aur - post installation help

Board footer