[Sqlgrey-users] strange install problem

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

Post by Craig White
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
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

Craig White

2010-02-09 14:50:05 UTC

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

Post by Winfried Neessen
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

------------------------------------------------------------------------------
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
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.

Karl O. Pinc

2010-02-09 16:04:23 UTC

Post by Craig White

Post by Craig White
Feb 9 05:52:22 li34-197 sqlgrey: warning: Use of uninitialized

value

Post by Craig White
$DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey

line

Post by Craig White
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,

Post by Craig White
sender_domain varchar(255) NOT NULL, src varchar(39) NOT NULL,
first_seen timestamp NOT NULL, last_seen timestamp NOT NULL,

PRIMARY

Post by Craig White
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

Post by Craig White
at /usr/sbin/sqlgrey line 176.

Have you searched the list archives? This looks familiar.

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

Craig White

2010-02-09 17:00:53 UTC

Post by Craig White

Post by Craig White
Feb 9 05:52:22 li34-197 sqlgrey: warning: Use of uninitialized

value

Post by Craig White
$DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey

line

Post by Craig White
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,

Post by Craig White
sender_domain varchar(255) NOT NULL, src varchar(39) NOT NULL,
first_seen timestamp NOT NULL, last_seen timestamp NOT NULL,

PRIMARY

error

Post by Craig White
at /usr/sbin/sqlgrey line 176.

Have you searched the list archives? This looks familiar.

----
I think the problem was my creation. I created it as UTF8 and when I
dropped it and created it as a latin type, it worked.

Craig

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

Karl O. Pinc

2010-02-09 17:21:33 UTC

Post by Craig White

Post by Craig White
Feb 9 05:52:22 li34-197 sqlgrey: warning: Use of

uninitialized

value

Post by Craig White
$DBI::errstr in concatenation (.) or string at

/usr/sbin/sqlgrey

line

Post by Craig White
227.

Have you searched the list archives? This looks familiar.

----
I think the problem was my creation. I created it as UTF8 and when I
dropped it and created it as a latin type, it worked.

But then I believe you have problems with internationalized
domains. It's a mysql related problem. Definitely already
discussed in the list archives. I forget the details.

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

Winfried Neessen

2010-02-09 15:23:24 UTC

What does your config look like?

-----Original Message-----
From: Craig White [mailto:***@azapple.com]
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

value

Post by Craig White
$DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey

line

Post by Craig White
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.
---
---
---

---------------------------------------------------------------------

Post by Craig White
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
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

------------------------------------------------------------------------
------

Post by Winfried Neessen
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the

business

Post by Winfried Neessen
Choose flexible plans and management services without long-term

contracts

Post by Winfried Neessen
Personal 24x7 support from experience hosting pros just a phone call

away.

Post by Winfried Neessen
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Sqlgrey-users mailing list
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

Craig White

2010-02-09 16:52:26 UTC

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

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

Craig

Post by Winfried Neessen
What does your config look like?
-----Original Message-----
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
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

value

Post by Craig White
$DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey

line

---------------------------------------------------------------------