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

Aaron Artmann aartmann at comcast.net
Sat May 10 21:37:50 EDT 2014


On Sat, May 10, 2014 at 5:51 PM, David Carlson
<david.carlson.417 at gmail.com> wrote:
> On 5/10/2014 5:39 PM, John Ralls wrote:
>> On May 10, 2014, at 5:52 PM, 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.
>> This is generally a privilege issue: GnuCash needs to create databases.
>>
>> Regards,
>> John Ralls
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
> This may be a very dumb question.  If MYSQL is using a 192.168.1.xxx
> address as opposed to localhost, would not that imply that the file is
> on a different computer?  This could still be permissions, but perhaps
> on a different level.
>
> David C
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Could it need more global permissions besides usage? Currently has all
privileges including grant on the database itself?

Aaron



More information about the gnucash-user mailing list