Re: [Sqlgrey-users] Sqlgrey dies while creating mysql tables

[Winfried N. <win...@ne...>]

Hi,

* Dan Faerch <da...@ha...>:

> If skip-networking is enabled, that would definently explain it, as
> sqlgrey doesn't connect through the socket file=20
> "/var/run/mysqld/mysqld.sock" like eg. php does pr. default.
>
That's not true. sqlgrey uses Perl's DBI mechanism, which is working
fine with connecting via socket. In fact it's working exactly the same
way here for me (Debian Sarge with self-compiles MySQL)

MySQL is started with UNIX socket only:
,---[ grep networking /etc/my.cnf ]
| skip-networking
`----

No my MySQL is listening on TCP port 3306:
,---[ lsof -n -i :3306 ]
|
`----

As sqlgrey doesn't seem to return the error why the query failed,
,---
| [...]
| Use of uninitialized value in concatenation (.) or string at
| /usr/local/sbin/sqlgrey line 227.
|
| (which would be the $DBI::errstr here
`---
please open a shell an execute this line an send us what error that is
returned by it:

,---
| perl -MDBI -le 'my $db=3DDBI->connect("DBI:mysql:database=3Dsqlgrey;host=
=3Dlocalhost","youruser","yourpass",undef) or die "Error: $DBI::errstr"$db-=
>disconnect()'
`---

Regards
Winfried

--=20
Winfried Neessen                           Phone:       +49 221 2612601
neessen.net - Webhosting                   Fax:         +49 221 2612602
Peter-Bauer-Str. 9                         Email:  win...@ne...
50823 Cologne                              PGP/GPG Key-ID:   0xda5cd8ef