sqlgrey-users

[Sqlgrey-users] Error installing under Slack.11

[John S. <ke...@gm...>]

Hello again,

I'm stucked trying to install SQLgrey undel Slackware 11.
Postfix is working, and all other components needed are installed(Perl, =
DBI, Net::Server::Multiplex, SQLite)
in /etc/sqlgrey/sqlgrey.conf i have:

## Database settings
# instead of Pg below use "mysql" for MySQL, "SQLite" for SQLite
# any DBD driver is allowed, but only the previous 3 have been tested
# db_type =3D Pg
db_type =3D SQLite
# db_name =3D sqlgrey
db_name =3D sqlgrey.db

in /etc/group there is:

postfix:x:102:
postdrop:x:103:
sqlgrey:x:104:

and in /etc/passwd:
postfix:x:1001:102:Postfix MTA:/var/spool/postfix:/bin/false
sqlgrey:x:1002:104::/var/lib/sqlgrey:

I even create manually /var/lib/sqlgrey.

Now, the problem:

root@slack11:/etc# sqlgrey
2007/02/28-16:29:30 sqlgrey (type Net::Server::Multiplex) starting! =
pid(4433)
Binding to TCP port 2501 on host localhost
Setting gid to "104 104"
Setting uid to "1002"
dbaccess: can't connect to DB: unable to open database file(1) at =
dbdimp.c line 94
Can't call method "do" on an undefined value at /usr/sbin/sqlgrey line =
298.
root@slack11:/etc#


Thanks allot

Re: [Sqlgrey-users] Error installing under Slack.11

[Lionel B. <lio...@bo...>]

John Smith wrote the following on 28.02.2007 15:34 :
> (...)
>  
> postfix:x:102:
> postdrop:x:103:
> sqlgrey:x:104:
> and in /etc/passwd:
> postfix:x:1001:102:Postfix MTA:/var/spool/postfix:/bin/false
> sqlgrey:x:1002:104::/var/lib/sqlgrey:
>  
> I even create manually /var/lib/sqlgrey.
>  
> Now, the problem:
>  
> root@slack11:/etc <mailto:root@slack11:/etc># sqlgrey
> 2007/02/28-16:29:30 sqlgrey (type Net::Server::Multiplex) starting! 
> pid(4433)
> Binding to TCP port 2501 on host localhost
> Setting gid to "104 104"
> Setting uid to "1002"
> dbaccess: can't connect to DB: unable to open database file(1) at 
> dbdimp.c line 94
> Can't call method "do" on an undefined value at /usr/sbin/sqlgrey line 
> 298.
> root@slack11:/etc <mailto:root@slack11:/etc>#

Are /var/lib/sqlgrey permissions OK?
It should belong to sqlgrey and be user writable.

Lionel

Re: [Sqlgrey-users] Error installing under Slack.11

[John S. <ke...@gm...>]

Lionel Bouton <lionel-dev@...> writes:

> 
> John Smith wrote the following on 28.02.2007 15:34 :
> > (...)
> >  
> > postfix:x:102:
> > postdrop:x:103:
> > sqlgrey:x:104:
> > and in /etc/passwd:
> > postfix:x:1001:102:Postfix MTA:/var/spool/postfix:/bin/false
> > sqlgrey:x:1002:104::/var/lib/sqlgrey:
> >  
> > I even create manually /var/lib/sqlgrey.
> >  
> > Now, the problem:
> >  
> > root <at> slack11:/etc <mailto:root <at> slack11:/etc># sqlgrey
> > 2007/02/28-16:29:30 sqlgrey (type Net::Server::Multiplex) starting! 
> > pid(4433)
> > Binding to TCP port 2501 on host localhost
> > Setting gid to "104 104"
> > Setting uid to "1002"
> > dbaccess: can't connect to DB: unable to open database file(1) at 
> > dbdimp.c line 94
> > Can't call method "do" on an undefined value at /usr/sbin/sqlgrey line 
> > 298.
> > root <at> slack11:/etc <mailto:root <at> slack11:/etc>#
> 
> Are /var/lib/sqlgrey permissions OK?
> It should belong to sqlgrey and be user writable.
> 
> Lionel
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 

Hello Lionel,
and thanks very much for help...

you were right, the permissions wasn't OK!

but now, they are:

root@slack11:/var/lib# ls -l
total 60
......

drwxrwxrwx 2 sqlgrey sqlgrey 4096 2007-03-01 08:48 sqlgrey/
drwxrwx--T 2 root    nogroup 4096 2006-09-12 10:33 stunnel/
drwxr-xr-x 2 root    root    4096 2006-09-16 11:47 xdm/
drwxr-xr-x 2 root    root    4096 2007-03-01 08:14 xkb/
root@slack11:/var/lib#

But error is the same:

root@slack11:/var/lib# sqlgrey
2007/03/01-08:59:04 sqlgrey (type Net::Server::Multiplex) starting! pid(1517)
Binding to TCP port 2501 on host localhost
Setting gid to "104 104"
Setting uid to "1002"
dbaccess: can't connect to DB: unable to open database file(1) at dbdimp.c line 
94
Can't call method "do" on an undefined value at /usr/sbin/sqlgrey line 298.
root@slack11:/var/lib#


I even tryed using a sqlgrey.db file from another computer running under FC-5...
Error was the same.....

Thank's again

Re: [Sqlgrey-users] Error installing under Slack.11

[Lionel B. <lio...@bo...>]

Ok, I got it, you must be in the sqlgrey user's directory. Init scripts 
deal with it on debian/gentoo/redhat and derived distributions. It's 
probably a bug, sqlgrey should change its working directory itself. 
Until we fix this, please launch sqlgrey after "cd /var/lib/sqlgrey"

Lionel

Re: [Sqlgrey-users] Error installing under Slack.11

[John S. <ke...@gm...>]

Lionel Bouton <lionel-dev@...> writes:

> 
> Ok, I got it, you must be in the sqlgrey user's directory. Init scripts 
> deal with it on debian/gentoo/redhat and derived distributions. It's 
> probably a bug, sqlgrey should change its working directory itself. 
> Until we fix this, please launch sqlgrey after "cd /var/lib/sqlgrey"
> 
> Lionel
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 

You're right. Just look:

login as: root
root@192.168.0.247's password:
Last login: Thu Mar  1 08:32:40 2007
Linux 2.6.17.8.

We may hope that machines will eventually compete with men in all purely
intellectual fields.  But which are the best ones to start with?  Many people
think that a very abstract activity, like the playing of chess, would be
best.  It can also be maintained that it is best to provide the machine with
the best sense organs that money can buy, and then teach it to understand
and speak English.
                -- Alan M. Turing

root@slack11:~# cd /var/lib/sqlgrey
root@slack11:/var/lib/sqlgrey# sqlgrey
2007/03/01-21:23:03 sqlgrey (type Net::Server::Multiplex) starting! pid(1900)
Binding to TCP port 2501 on host localhost
Setting gid to "104 104"
Setting uid to "1002"
perf: spent 0s cleaning: from_awl (0) domain_awl (0) connect (0)
conf: warning: /etc/sqlgrey/clients_ip_whitelist.local not found or unreadable
conf: warning: /etc/sqlgrey/clients_fqdn_whitelist.local not found or unreadable
2007/03/01-21:24:27 Server closing!
root@slack11:/var/lib/sqlgrey# sqlgrey -d
root@slack11:/var/lib/sqlgrey# lsof -i tcp:2501
COMMAND  PID    USER   FD   TYPE DEVICE SIZE NODE NAME
sqlgrey 1902 sqlgrey    5u  IPv4   4196       TCP localhost:rtsclient (LISTEN)
root@slack11:/var/lib/sqlgrey#