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

[John Ralls]

On May 10, 2014, at 6: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.

It does indeed suggest that, with the caveat that "file" is not the appropriate term. That's pretty much the way SQL servers work. The permissions in question are those of the user id (MySql uses another name for it, but I don't remember offhand what it is) in the MySql server, not those of any actual user at the OS or network level.

Regards,
John Ralls