Re: Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

To everyone that tried to help me:  Thank you!

I don't know what the problem is (or was?) but it is hidden in GoDaddy's
dashboards and setups.  I created a database on my private hosting account
with a different company and it just worked.  So...I guess the church is
going to have to move its WordPress site to the new host as well.

Thanks again,
...J...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[John Ralls]

> On Jan 16, 2018, at 2:45 PM, Jim_S  wrote:
> 
> When you say to check the database logs, is that on the server or on the PC?

I guess that depends on how you’ve configured your database logging, eh? You’re 
the DBA, not me.

Reminder: Users of the MySQL and Postgresql backends are expected to be 
experienced administrators of their database server or to have such an 
experienced administrator in their employ. We don’t, and can’t, provide support 
for database operations.

GnuCash will create the database if it’s not there already. It’s also supposed 
to create the tables if necessary, and if it doesn’t it should raise an error 
about that. See https://wiki.gnucash.org/wiki/Tracefile 
 for how to find GnuCash’s log file. 
You may find it useful to run GnuCash from the command line and pass --log 
gnc.backend.dbi=debug --log gnc.backend.sql=debug, which will add a *lot* of 
detail to the log about GnuCash’s interaction with the database. That, combined 
with the database logs, should give a very clear picture of what’s going wrong 
and why. 

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

When you say to check the database logs, is that on the server or on the PC?

TIA,
...J...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

The database is created, but there are no tables in it.  Did I  miss an
install step to actually create tables in the database??  If there is not
table, it cannot INSERT, correct?  Or does GnuCash actually do that itself??

TIA,
...J...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

John Ralls-2 wrote
>> On Jan 15, 2018, at 10:34 PM, Jim_S <

> James@

> > wrote:
>> 
> You do realize, though, that by using a remote database and then
> advertising your database URI you’ve invited the whole net to try to break
> your password and mess with your financial data.

The names have been changed to protect the innocent!!  I modified the names
from the real onesaltered the numbers, etc.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

Yes.  GoDaddy provides a tool From StarField Techologoies called
"phpMyAdmin".  ...j...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[John Ralls]

> On Jan 15, 2018, at 10:34 PM, Jim_S  wrote:
> 
> I am trying to install gnuCash using a MySQL database hosted by GoDaddy.  We
> also use GoDaddy for our WordPress web page, so I already have the hosting
> account.  GnCash keeps giving me an error "The server at URL
> mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an
> error or encountered bad or corrupt data.".
> 
> I must create the database through GoDaddy's page as GnuCash.  It makes the
> user name the same as the dbname.  GoDaddy assigns a host name of
> "GnuCash.db.3879949.hostedresource.com".  I put in "GnuCash" for both the
> database name and the user name, and enter the password I've selected.
> 
> Any help??

It’s connecting OK or it wouldn’t have gotten that far.

That error is emitted during save if, during a transaction INSERT or UPDATE it 
fails to either find or INSERT the commodity. Check your database logs to see 
why and correct the problem if you can. If you can’t you’ll have to find a 
different solution. 

You do realize, though, that by using a remote database and then advertising 
your database URI you’ve invited the whole net to try to break your password 
and mess with your financial data.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Re: Installing GnuCash using GoDaddy MySQL Server

[Colin Law]

On 16 January 2018 at 06:34, Jim_S  wrote:
> I am trying to install gnuCash using a MySQL database hosted by GoDaddy.  We
> also use GoDaddy for our WordPress web page, so I already have the hosting
> account.  GnCash keeps giving me an error "The server at URL
> mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an
> error or encountered bad or corrupt data.".

Can you access the db using that url from a mysql client on the PC?

Colin

>
> I must create the database through GoDaddy's page as GnuCash.  It makes the
> user name the same as the dbname.  GoDaddy assigns a host name of
> "GnuCash.db.3879949.hostedresource.com".  I put in "GnuCash" for both the
> database name and the user name, and enter the password I've selected.
>
> Any help??
> TIA.
> Jim_S
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.

Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

I am trying to install gnuCash using a MySQL database hosted by GoDaddy.  We
also use GoDaddy for our WordPress web page, so I already have the hosting
account.  GnCash keeps giving me an error "The server at URL
mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an
error or encountered bad or corrupt data.".

I must create the database through GoDaddy's page as GnuCash.  It makes the
user name the same as the dbname.  GoDaddy assigns a host name of
"GnuCash.db.3879949.hostedresource.com".  I put in "GnuCash" for both the
database name and the user name, and enter the password I've selected.

Any help??
TIA.
Jim_S





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.