vicidial.org

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.

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

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

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

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.

Please send me steps for Upgrade !!

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

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??

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

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

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.

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.

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.

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?

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.

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

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.

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.

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.

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.

have you upgrade to 5.1.0?

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.

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

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

Connected successfully
Could not execute: No database selected

Please help!

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

Sorry about that...
Goautodial CE 2.1 from ISO | VERSION: 2.4-309a | BUILD: 110430-1642 | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel Core2Duo E7500

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

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...

Interesting.

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

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

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

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...

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

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

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