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.1ContribsIn 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.phpin 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.phpSame 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.phpI 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?