Re: [Sqlgrey-users] strange install problem

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

the only 'non-commented' lines are...

db_type = mysql
db_name = sqlgrey
db_user = sqlgrey
db_pass = (REMOVED)

Craig

On Tue, 2010-02-09 at 16:23 +0100, Winfried Neessen wrote:
> What does your config look like? 
> 
> -----Original Message-----
> From: Craig White [mailto:cra...@az...] 
> Sent: Tuesday, February 09, 2010 3:50 PM
> To: SQLgrey users mailing-list
> Subject: Re: [Sqlgrey-users] strange install problem
> 
> 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.
> 
> 
> ------------------------------------------------------------------------
> ------
> 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.