[horde] SOLVED : [emergency] Unable to connect to SQL server

[J. Bakshi]

Michael Rubinsky wrote:
> Quoting "J. Bakshi" <joydeep at infoservices.in>:
>
>> J. Bakshi wrote:
>>> J. Bakshi wrote:
>>>
>>>> J. Bakshi wrote:
>>>>
>>>>
>>>>> Michael Rubinsky wrote:
>>>>>
>>>>>
>>>>>
>>>>>> Quoting "J. Bakshi" <joydeep at infoservices.in>:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hello everyone,
>>>>>>>
>>>>>>> I have installed horde rpm 3.1.4 in suse 11.
>>>>>>> I have already configure the sql related settings to authenticate
>>>>>>> users and checked all configuration multiple times.
>>>>>>>
>>>>>>> But After giving the username and password the browser shows
>>>>>>>
>>>>>>> ~~~~~~~~~~~~
>>>>>>> A fatal error has occurred
>>>>>>> Unable to connect to SQL server.
>>>>>>> Details have been logged for the administrator.
>>>>>>> ~~~~~~~~~~~~~~
>>>>>>>
>>>>>>> The log says
>>>>>>>
>>>>>>> HORDE [emergency] [horde] Unable to connect to SQL server. [on
>>>>>>> line 441
>>>>>>> of "/srv/www/htdocs/horde/lib/Horde/Auth/sql.php"]
>>>>>>>
>>>>>>>  and the 441 line is
>>>>>>>
>>>>>>> if (is_a($this->_db, 'PEAR_Error')) {
>>>>>>>             Horde::fatal(_("Unable to connect to SQL server."),
>>>>>>> __FILE__, __LINE__);
>>>>>>>         }
>>>>>>>
>>>>>>>
>>>>>>> I have no clue about this  :-(
>>>>>>> Could any one kindly suggest me what is wrong here ?
>>>>>>> Thanks
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> Well, the error is just what it says, that Horde is unable to
>>>>>> connect
>>>>>> to the SQL server.  Double check all configuration on both the horde
>>>>>> and the sql server end. How did you configure Horde to connect to
>>>>>> your
>>>>>> server? Is the server running, can you connect with other tools
>>>>>> etc...?
>>>>>>
>>>>>> If your unable to track it down, try doing a var_dump($this->_db);
>>>>>> right before the Horde::fatal line to get a more detailed error.
>>>>>>
>>>>>>
>>>>>> Thanks,
>>>>>> mike
>>>>>>
>>>>>>
>>>>>>
>>>>> Hello Mike,
>>>>> Thanks for your kind response.
>>>>>
>>>>> Yes, there were some misconfiguration in conf.php file.  I have just
>>>>> fixed it and can log in .
>>>>> But I don't see any email folder here :-(
>>>>> Regarding the server, it is suse 11 and the horde version is 3.1.4
>>>>> I have installed horde through yast.
>>>>>
>>>>> >From test.php there are information about some missing modules like
>>>>>
>>>>> ~~~~~~~~~~~~~~~~~~~~~~`
>>>>> Mail_Mime: *No*
>>>>> *You do not have the Mail_Mime package installed on your system.
>>>>> See the
>>>>> INSTALL file for instructions on how to install the package. THIS
>>>>> IS A
>>>>> REQUIRED MODULE!
>>>>>
>>>>> *MIME Magic Support (mime_magic): *No*
>>>>> *The fileinfo PECL module (see above) or the mime_magic PHP extension
>>>>> will most likely provide faster MIME Magic lookups than the built-in
>>>>> Horde PHP magic code. See horde/docs/INSTALL for information on
>>>>> how to
>>>>> install PECL/PHP extensions.
>>>>>
>>>>> *Net_SMTP: *No*
>>>>> *Make sure you are using the Net_SMTP module if you want "smtp" to
>>>>> work
>>>>> as a mailer option.
>>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>>>>
>>>>> but php5_pear-mail_mime is already installed here
>>>>>
>>>>> I have no clue :-(  kindly enlighten me.
>>>>> Thanks once again
>>>>> *
>>>>>
>>>>>
>>>>>
>>>>>
>>>> Well now I get the mail folder after installing "imp" ;-)
>>>> and it is looking imp configuration for the server.
>>>> Where can I define my server information ?
>>>>
>>>> Thnaks
>>>>
>>>>
>>>>
>>> please note I have imaps and no imap
>>> thanks
>>>
>>>
>>>
>>>
>>
>> Just follow the suggestion provided by imp/test.html and success :-)
>>
>>
>>
>> -- 
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Joydeep Bakshi, Linux System Admin
>> Kolkatainfoservices Pvt Ltd,
>> 23A Royd Street, Kolkata 700016, India
>> Work Phone 91 033 40014784
>> http://infoservices.in/
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> -- 
>> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>
>
>
> I'm glad that you got everything working, but you should know that
> Horde-3.1.4 is a fairly old version. You also didn't mention what
> version of any of the applications (like IMP) you installed, but if
> that is from the same time-frame, then that too is fairly outdated. 
> We just released Horde 3.3 and IMP H3 4.3 which fixes a *lot* of
> things, including many security issues. See http://horde.org for more
> information, including download information for the new versions.

Hello Mike,

sorry for the delayed response but I enjoyed my holidays :-)
Join the office today. The horde and IMP which I am using is shipped
with suse 11. I am configuring a remote server with suse 11 installed.
Hence I am using the default  packages already installed. I can install
the latest one of horde but it will then conflict with system integrity.
But still I try to use the latest horde and IMP
Thanks


>
>
>
> Thanks,
> mike
>
> -- 
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
>
> "Time just hates me. That's why it made me an adult." - Josh Joplin
> ------------------------------------------------------------------------
>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>   


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Joydeep Bakshi, Linux System Admin
Kolkatainfoservices Pvt Ltd,
23A Royd Street, Kolkata 700016, India
Work Phone 91 033 40014784
http://infoservices.in/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~