vicidial.org

by **papove01** » Tue Jun 16, 2009 6:51 am

Hi,

I'm having problem opening the vtiger_user.php and vtiger_search.php for Vicidial i get message : Connected successfully
Could not execute: No database selected

went through the vtiger.txt doc but still not helping me i wonder what could be wrong the dbconnect.php looks fine.... please help.

by **mflorell** » Tue Jun 16, 2009 8:04 am

What version of admin.php in ViciDial and what version of Vtiger are you using?

by **papove01** » Tue Jun 16, 2009 8:51 am

Hi,

the Vicidial version is 2.0.5-173 and vtiger is 5.0.3 . what i have notice now is that when specify the Vtiger DB Name under admin=>settings as vtigercrm503 i keep on get message Database not selected but when try to put a different DB name like asterisk for testing purpose, asterisk is selected but cant just find the tables required. So vtigercrm503 cant be selected. Please help

by **mflorell** » Tue Jun 16, 2009 8:56 am

You need to upgrade to Vtiger 5.0.4. 5.0.3 is no longer supported.

by **papove01** » Tue Jun 16, 2009 9:03 am

Now when trying to add new user im getting the same message "Connected successfullyCould not execute: No database selected" when Enable Vtiger Integration is ON. But when Enable Vtiger Integration is OFF new users can be added with no error message.

Is the Enable Vtiger Integration disturbs the Vicidial DB when On and how to fix this.

by **papove01** » Tue Jun 16, 2009 9:21 am

Please send me steps for Upgrade !!

by **mflorell** » Tue Jun 16, 2009 12:12 pm

I believe that the vtiger website could help you with that.

by **papove01** » Tue Jun 16, 2009 1:17 pm

Thank you very much for your help i got it working with version 5.0.4.

One more concern is that when starting vtiger_search.php, i get a pop up error that says " Fireox doesn't know how to open this address, because the protocol (varhttp) isn't associated with any program". any idea??

by **mflorell** » Tue Jun 16, 2009 8:07 pm

sounds like something is configured wrong. What is the exact webform address as you have it entered into the campaign detail screen?

by **papove01** » Wed Jun 17, 2009 1:57 am

Here's the web form address: VARhttp://192.168.1.2/vicidial/vtiger_search.php
The IP is the Vicidial Box IP address.

by **ykhan** » Wed Jun 17, 2009 9:58 am

I am having a similar issue in Vicidialnow 1.2. I successfully upgraded to vtigercrm 5.0.4. Then I made the following settings on the System Settings page of Vicidial:

Code: Select all: Vtiger DB Server IP: Live Internet IP Vtiger DB Name: vtigercrm503 (the database is upgraded to 5.0.4) Vtiger DB Login: cron Vtiger DB Password: 1234 Vtiger URL: http://Live Internet IP/vtigercrm

When I click on the "Click here to Synchronize users with Vtiger" link, I get the following error:

Code: Select all: Could not connect: Live Internet IP|vtigercrm503|cron|1234

Alternatively, when I change the IP to the local network IP of the 192.169.0.XXX scheme, I get the following error:

Code: Select all: Connected successfully Could not execute: No database selected

Thansk for help in advance.

by **papove01** » Wed Jun 17, 2009 10:26 am

After upgranding to version 5.0.4 you must change the credentials to connect with vtiger DB. I see you still using DB name as vtigercrm503. The connection details shoulb be as follow with version 5.0.4

Vtiger DB Server IP: your Mysql DB server IP
Vtiger DB Name: vtigercrm504
Vtiger DB Login: vtiger
Vtiger DB Password: vtuser
Vtiger URL: http://vtiger Server IP/vtigercrm

Unless you have change those details during your new Vtiger installation, these are the default one.

by **papove01** » Wed Jun 17, 2009 10:33 am

About your Live Internet IP, if your Vtiger mysql DB is in the same server as Vicidial installation you dont need to specify your Public IP, you can just put 127.0.0.1 meaning to find the DB on the same server. the error you getting means that the system cant find any mysql DB at the address specified or if you have DB on a different server where you point to then the error means that either the login and password are incorrect or you should check the mysql connection port or bind on that remote server. but in our case you are trying to connect to Vtiger version 5.0.4 so user cron and pass 1234 are for vtiger 5.0.3.

by **ykhan** » Wed Jun 17, 2009 11:43 am

Even though I upgraded the DB, the name of the DB is still the same (vtigercrm503), hence I get the "Connected successfully" message. When I leave the username and password blank, I get an error for "Could not connect:".

ANy changes I need to make in the php files?

by **papove01** » Wed Jun 17, 2009 12:11 pm

the connect succesfully is maybe because you still have the previous DB vtigercrm503and your vicidial is connecting to it still. plz check if you have two DB vtigercrm503 and vtigercrm504 if yes, use credentials for version 5.0.4 as explained on previous post.

by **ykhan** » Wed Jun 17, 2009 12:21 pm

No other databases for vtigercrm. Only vtigercrm503. When you upgraded, did it create an additional database for you?

by **ykhan** » Wed Jun 17, 2009 12:28 pm

Funnily enough, I don't think that the Connected Successfully message has anything to do with the database name, cause I changed it to vtigercrm504 and then to abcd, but I got the same message as below:

Code: Select all: Connected successfully Could not execute: No database selected

Could this be an issue with folder permissions? I have given full control to all on the Vicidial folder. No change.

by **papove01** » Thu Jun 18, 2009 3:02 am

My bad, i have not considered you did an upgrade though it was a fresh install, in my case i did a fresh install of vtiger5.0.4 and it sorted my problems out. Follow the stpeps in vtiger.txt file if you want to do a fresh install and dont forget to apply the patch.

by **ykhan** » Thu Jun 18, 2009 8:58 am

Did you install vtiger 5.0.4 from source (tar.gz) or the .bin file? The .bin file prompts to install php5.1.2, which I am wary of doing at this time. I used the v5.0.0 Patch 4 to upgrade from 5.0.3.

by **papove01** » Thu Jun 18, 2009 10:58 am

I have installed from tar.gz, which still requires PHP 5.12.1 and i have upgraded to that. the patch only works with vtiger version 5.0.4 and it's for user sync between Vicidial and Vtiger.

by **agukoy** » Tue Jul 28, 2009 2:43 pm

have you upgrade to 5.1.0?

by **mflorell** » Tue Jul 28, 2009 3:35 pm

There is a new patch file for the 5.1.0RC in SVN trunk. Haven't tried it on the official release, but it should work.

by **agukoy** » Fri Aug 07, 2009 5:32 pm

do i need to do first the set of instruction in REQUIRED_APPS_INSTALL.txt before getting into the VTIGER.txt?

vtiger CRM 5.0.3
I Know that 5.0.3 is no longer supported and needed to be upgrade to 5.0.4

VERSION: 2.0.5-173
BUILD: 90320-0424

by **mrkvaja** » Fri Dec 07, 2012 5:29 pm

Hi, I'm on vTiger 510, having the same problem:

Connected successfully
Could not execute: No database selected

Please help!

by **williamconley** » Sat Dec 08, 2012 1:09 pm

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

by **mrkvaja** » Sun Dec 09, 2012 10:42 pm

by **williamconley** » Mon Dec 10, 2012 2:43 pm

Have you installed vTiger? (the installation package is automatically available, but you must still actually install vTiger for it to work ...).

by **mrkvaja** » Mon Dec 10, 2012 5:59 pm

Absolutely. Installed and working properly.
I did a fresh install from the same ISO on a test machine, works fine, it's an enigma for me...

by **williamconley** » Mon Dec 10, 2012 6:18 pm

Interesting.

Where (exactly) do you see the message "Could not execute: No database selected" and under what circumstances?

by **mrkvaja** » Mon Dec 10, 2012 6:56 pm

When trying to synchronize users from the ViciDial admin. Everything else works perfectly...

by **williamconley** » Mon Dec 10, 2012 8:52 pm

And ... what settings do you have in the Vicidial vTiger configuration?

by **mrkvaja** » Tue Dec 11, 2012 2:43 am

Tried everything... The server/vtiger addresses and the DB are 100% correct, used both vtiger/vtuser and cron/1234 combos. Apparently, it connects to the DB but can't find the table...

by **williamconley** » Tue Dec 11, 2012 10:15 pm

Have you tried to access the vTiger database via mysql command line or phpMyAdmin using those same credentials?

by **mrkvaja** » Wed Dec 12, 2012 1:25 am

Fixed it! A weirdly corrupted config file caused the error. Rewriting the file from the original fixed it.
Thanks williamconley for all the help!

by **williamconley** » Wed Dec 12, 2012 9:37 am

The nice thing about methodical troubleshooting ... eventually you drill down to the problem. Then all you need is a brain.

vicidial.org

Vtiger Integration

Vtiger Integration

5.0.4 upgrade to 510

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Re: Vtiger Integration

Who is online