Re: [Sqlgrey-users] strange install problem

[Craig W. <cra...@az...>]

Sorry... should have provided the info

Mysql, yes, the user 'sqlgrey' can connect and has privileges to create
the necessary tables.

# mysql sqlgrey -h localhost -u sqlgrey -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 281
Server version: 5.1.42 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

perl-DBD-MySQL-4.010-1.fc11.i586

I'm still wondering why it doesn't work.

Craig

On Tue, 2010-02-09 at 08:56 +0100, Winfried Neessen wrote:
> Hi,
> 
> looks like DBI isn't able to create the tables. Which database are you  
> using?Did you install the corresponding DBD::<dbtype> module?
> 
> Does the DB user have permissions to create tables?
> 
> Winni
> 
> -- 
> 
> Sent from my wireless handheld device
> 
> Am 09.02.2010 um 06:54 schrieb Craig White <cra...@az...>:
> 
> > sqlgrey-1.6.7-1.noarch
> >
> > perl-DBI-1.607-2.fc11.i586
> >
> > logs say...
> > Feb  9 05:52:22 li34-197 sqlgrey: 2010/02/09-05:52:22 sqlgrey (type
> > Net::Server::Multiplex) starting! pid(9629)
> > Feb  9 05:52:22 li34-197 sqlgrey: Binding to TCP port 2501 on host
> > localhost#012
> > Feb  9 05:52:22 li34-197 sqlgrey: Setting gid to "504 504"
> > Feb  9 05:52:22 li34-197 sqlgrey: Setting uid to "504"
> > Feb  9 05:52:22 li34-197 sqlgrey: warning: Use of uninitialized value
> > $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line
> > 227.
> > Feb  9 05:52:22 li34-197 sqlgrey: dbaccess: warning: couldn't do
> > query:#012CREATE TABLE from_awl (sender_name varchar(64) NOT NULL,
> > sender_domain varchar(255) NOT NULL, src varchar(39) NOT NULL,
> > first_seen timestamp NOT NULL, last_seen timestamp NOT NULL, PRIMARY  
> > KEY
> > (src, sender_domain, sender_name)):#012, reconnecting to DB
> > Feb  9 05:52:22 li34-197 sqlgrey: mail: failed to send: No child
> > processes#012
> > Feb  9 05:52:22 li34-197 sqlgrey: fatal: create_from_awl_table error
> > at /usr/sbin/sqlgrey line 176.
> >
> > and I really don't think it's anything that I did in sqlgrey.conf
> >
> > do I have to go to an older version?
> >
> > Craig
> >
> >
> > -- 
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> >
> >
> > --- 
> > --- 
> > --- 
> > ---------------------------------------------------------------------
> > The Planet: dedicated and managed hosting, cloud storage, colocation
> > Stay online with enterprise data centers and the best network in the  
> > business
> > Choose flexible plans and management services without long-term  
> > contracts
> > Personal 24x7 support from experience hosting pros just a phone call  
> > away.
> > http://p.sf.net/sfu/theplanet-com
> > _______________________________________________
> > Sqlgrey-users mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
> 
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
> 



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.