Re: [Sqlgrey-users] Creating initial database tables

[Karl O. P. <ko...@me...>]

On Sat, 26 Sep 2015 12:22:38 -0400
Alex <mys...@gm...> wrote:

> Hi, I posted the message below a few days ago, and haven't received
> any replies, and I'm really stuck.
> 
> I followed the directions in the HOWTO for configuring sqlgrey to be
> used with mysql/mariadb, and just don't understand why it's not
> creating the tables.
> 
> When I connect this new database to the master, slave status says
> this:
> 
> Last_SQL_Error: Error 'Table 'sqlgrey.domain_awl' doesn't exist' on
> query. Default database: 'sqlgrey'. Query: 'UPDATE domain_awl SET
> last_seen = NOW(), first_seen = first_seen WHERE sender_domain =
> 'bounce.twitter.com' AND src = '199.59.150''
> 
> I'd sure appreciate any ideas.

Look in your database logs to see why the tables didn't
create.  If there's nothing, then reconfigure the db to log
errors and try again.



Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein