Topic: vtiger on 6.0.1-01

[mhiggins]

I need to deploy vtiger in a production environment so my challenge is to make vtiger run on SME 6.0.1-01.

I'm 99% there (well i think i am) but something is not quite right;

I ran the update script SME 6.0.1 update script http://no.longer.valid/phpwiki/index.php/SME6.0.1Contribs

In addition to adding just about all of the functionality that you would want in SME server that isn't there in the standard build (spam filter, antivirus etc), this brings most things up to date and as in line with the vtiger requirements as possible, only sticking point is apache is still 1.3.33-2 not 2.0.40 or higher, though i am told that vtiger will still work without any issues.

firstly i created an i bay called ... vtiger_i & set permissions to allow execution of dynamic content, i set the group to everyone &  have allowed public web access

Then i downloaded vtiger_CRM_4_0_1_Source.zip
to the ibays files directory & extracted vtiger_CRM_4_0_1_Source.zip to the vtiger_i ibays html directory.

called;
http://serverip/vtiger_i/install.php

in firefox & worked through the questions;

There were issues with being able to write to some but not all of these files/ sub directories which I fixed with chmod

config.php   Writeable Cache Directory (cache/)   Writeable Mail Merge Template Directory (test/wordtemplatedownload/)   Writeable Uploads Directory (test/upload/)   Writeable
Email Templates Directory (modules/Emails/templates/)   Writeable

The only configurable field that i changed was to enter a admin user password (i entered the SME server admin password here though I think it could have been any password)

the next step 5 is the first indication that it will fail;

Host 'xyz.myserver.yi.org' is not allowed to connect to this MySQL serverTables Successfully created The database tables are now set up.

But the same page does say;

Your system is now installed and configured for use. You will need to log in for the first time using the "admin" userid and the password you entered in step 2.

It the proceeds to the login screen, i entered the admin password but get the following error;

Error: You must specify a valid username and password.

At this point i guess/assume this is a mysql problem. Well i haven't set up a database so off i go to a term on the box;

mysql_setpermission

######################################################################
## Welcome to the permission setter 1.3 for MySQL.
## made by Luuk de Boer
######################################################################
What would you like to do:
  1. Set password for an existing user.
  2. Create a database + user privilege for that database
     and host combination (user can only do SELECT)
  3. Create/append user privilege for an existing database
     and host combination (user can only do SELECT)
  4. Create/append broader user privileges for an existing
     database and host combination
     (user can do SELECT,INSERT,UPDATE,DELETE)
  5. Create/append quite extended user privileges for an
     existing database and host combination (user can do
     SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
     LOCK TABLES,CREATE TEMPORARY TABLES)
  6. Create/append database administrative privileges for an
     existing database and host combination (user can do
     SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,
     CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS)
  7. Create/append full privileges for an existing database
     and host combination (user has FULL privilege)
  8. Remove all privileges for for an existing database and
     host combination.
     (user will have all permission fields set to N)
  0. exit this program


Make your choice [1,2,3,4,5,6,7,0]: 7


Which database from existing databases would you like to select:
You can choose from:
  - horde
  - mysql
  - pmadb
  - test
  - vtigercrm4_0_1
Which database will it be (case sensitive). Type * for any:
vtigercrm4_0_1
The database vtigercrm4_0_1 will be used.

What username is to be created: admin
Username = admin
Would you like to set a password for admin [y/n]: y
What password do you want to specify for admin:
Type the password again:
We now need to know from what host(s) the user will connect.
Keep in mind that % means 'from any host' ...
The host please: %
Would you like to add another host [yes/no]: no
Okay we keep it with this ...
The following host(s) will be used: %.
######################################################################

That was it ... here is an overview of what you gave to me:
The database name       : vtigercrm4_0_1
The username            : admin
The host(s)             : %
######################################################################

Are you pretty sure you would like to implement this [yes/no]:yes



to be on the safe side i restarted mysql /etc/rc.d/init.d/mysqld restart

Still can't login at
http://10.0.0.1/vtiger_i/index.php

Same error Error: You must specify a valid username and password

So the next logical step (well to me) is to rerun the install
http://10.0.0.1/vtiger_i/install.php


I still get the same error at step 5

Access denied for user: 'MYSQLUSERNAME@xyz.myserver.yi.org' (Using password: YES)Tables Successfully created The database tables are now set up.

& the same error when i try to login.

Does anyone have any thoughts on what i am doing wrong? Or what I need to do to get this working?

[boss_hog]

Hey mhiggins,
what i have done to get around this problem is to hand config the "install" info in the config.php file.
Input the db_name, db_user, db_password, etc..
After this re-run the install, all the fields should be filled with the info you just put in. Scroll down and set the admin password, now it should allow you to login.
One thing more, setup the mysql database first with a db_user and db_name etc.. I didn't have any luck letting Vtiger create the db. My very limited 2 cents!

Also this thread might be of some help:
http://forums.contribs.org/index.php?topic=26688.msg114253#msg114253
Good luck
Joe

EDIT: The db_name needs to be input at about line 101 in a file called 2setConfig.php, which is in the /install directory

[mhiggins]

The critical piece of the jigsaw that has dropped into place thanks to Bosshog's post and & email from Klaus, is;

Once you have setup the datebase, you needed to manually enter the details for the database and user into 'config.php' once i did that it worked like a charm

[Drifting]

Not being a wiz at Mysql, would you mind giving more details on exactly how to create the database?

All I keep getting it this : -

>>>Error Message: Unable to connect to database Sever with the specified connection parameters. This may be due to the following reasons:

- specified database user, password , hostname or port is invalid.
- specified database user does not have access to connect to the database server from the host

Kindly check the specified database connection parameters...<<<<<

I have edited the config.php and added the user and password for mysql, can only think I have missed something?

Regards Drift.

[irian]

Hi Drifting,

I am stuck with the same problem you have or hopefully had.
Did you get it solved?
If so, can you please tell me how you solved it?

Irian

[Stefano]

Hi..

Vtiger 4.2 works like a charm on SME 6.0.1

no problem to setup in a i-bay from vtiger 4.2 source file (.zip)

HTH
regards

Stefano

[irian]

Just got it working.

I had to change the /etc/my.cnf file
Had to block the line skip-networking.
This enables the tcp port 3306 communication.
Then I could access the mysql database and finsih the installation.

Irian

[albatroz]

Another alternative would be to install phpmyadmin contrib and create your databases and database users from there

[p-jones]

I went CRAZY trying to get this to work on V7B8. I must have read this post and several other a hundred times. I tried the rpm but got an error and could find no infomation on how I really should be using that rpm

In the end, I went full circle back to the source files and found it was necessay to edit the "connection.php" file and after that it all went very smoothly. I think earlier posts suggested that the config.php file and the install.php files needed editing. I found this not to be the case.

I created the database with mysql_createpermission first. Also assigned a user and password as per an earlier post.

 ********************************************************************************/
$mysql_dir = 'MYSQLINSTALLDIR';
$mysql_username = 'adminusername';
$mysql_password = 'adminpassword';
$mysql_port = '3306';
$mysql_bundled = 'MYSQLBUNDLEDSTATUS';
$apache_dir = 'APACHEINSTALLDIR';
$apache_bin = 'APACHEBIN';
$apache_conf = 'APACHECONF';
$apache_port = 'APACHEPORT';
$apache_bundled = 'APACHEBUNDLED';
?>

Maybe this will save someone a lot of time !!!
Peter