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

Colin Law clanlaw at gmail.com
Sat May 10 17:18:00 EDT 2014


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



More information about the gnucash-user mailing list