The server at URL mysql://gnucash at 192.168.1.80/gnucash experienced an error or encountered bad or corrupt data.

[Aaron Artmann]

On Sun, May 11, 2014 at 2:21 AM, Colin Law <clanlaw at gmail.com> wrote:
> On 10 May 2014 22:52, Aaron Artmann <aartmann at comcast.net> wrote:
>> On Sat, May 10, 2014 at 4:18 PM, Colin Law <clanlaw at gmail.com> wrote:
>>> On 10 May 2014 22:06, Aaron <aartmann at comcast.net> wrote:
>>>> Good Afternoon,
>>>>
>>>> I have been searching the internet and I have been unable to find a solution to my problem. When I try and connect to my MySQL database (which is on another machine) it gives me the following error "The server at URL mysql://gnucash@192.168.1.80/gnucash experienced an error or encountered bad or corrupt data." I have checked the gnucash.trace file which contains the following 2 messages
>>>>
>>>> * 16:00:30 CRIT <gnc.backend.dbi> gnc_dbi_unlock: assertion 'dbi_conn_error( dcon, NULL ) == 0' failed
>>>> * 16:00:53 CRIT <gnc.backend.dbi> [gnc_dbi_mysql_session_begin()] Unable to connect to database 'gnucash'
>>>>
>>>> The dialog box that has the settings to connect to the database is located at http://venomslair.com/dialog.png
>>>>
>>>> I know that I can connect to the database and I have been able to but since the upgrade I haven't been able to. I am running Ubuntu 14.04 LTS in VMWare and the database is on Ubuntu 14.04 LTS server.
>>>>
>>>> Can someone shed some light on how I can get this to reconnect to the database?
>>>
>>> Try to connect to the db using the mysql command line program.  Then
>>> you can see whether it is gnucash or mysql that is giving the problem.
>>>
>>> Colin
>>
>> I was able to connect to the database via the command line from the
>> same linux that is trying to connect via gnucash.
>
> Make sure that you can create a database using the user and password
> that you are using in gnucash, obviously.
>
> Colin

I think the problem lies in the database data itself because I can
create new tables and use them but once I import a backup to the
database it becomes not useable.  I don't want to restart everything
over again but if I can not get it to work once its imported then I am
going to have to.  The data was backed up with MySQL Dumper but now it
will not work because something with gzopen().  I will have to
research more.

Thanks for the assistance.

Aaron