[ic] MySQL Setup.

Craig Burton interchange-users@interchange.redhat.com
Sat Dec 29 15:44:01 2001


At 07:49 PM 12/29/01, you wrote:
>I have tried to find this out by looking trhough past articles, but
>no luck yet.
>
>I am getting this error in my new catalog errorlog file, and can't
>quite figure it out.
>
>I did learn that the username/password that is added during
>bin/makecat does not actually get written to the file, and fixed
>that.. but my quest continues.
>
>here is the error.
>
> >
>- - - [28/December/2001:23:27:40 -0500] - - table 'order_returns'
>failed: DBD::mysql::st execute failed: Table 'atapdb.order_returns'
>doesn't exist at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1370.
> >
>- - - [28/December/2001:23:27:40 -0500] - - table 'transactions'
>failed: DBD::mysql::st execute failed: Table 'atapdb.transactions'
>doesn't exist at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1370.
> >
>- - - [28/December/2001:23:27:40 -0500] - - table 'products' failed:
>DBD::mysql::st execute failed: Table 'atapdb.products' doesn't exist
>at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1370.
> >
>
>There are several of them, and it happens every time I restart the
>Interchange server. The tables in the database are never created. I
>am at least 1 step closer, since I am not getting the permission
>denied error anymore.
>
>Shouldn't something like this be in the FAQ? I can't be the only one
>having this problem.
>
>-Bill

only just installed my first interchange server, but may be of help... Are 
you sure that:
1) the database atapdb exists
2) the user you set up with makecat to access the database has permissions 
(grant all on atapdb.* to username identified by 'password'; [in mysql]) 
for the atapdb?

I wound up doing these bits manually through mysql and it worked after that 
(creating the tables next interchange server restart)

hope that helps, Craig
craig@rokitdesign.com