Package: nanourl
Version: 0.1-7
Severity: important
Tags: patch
/usr/share/doc/nanourl/README.Debian tells to use
/etc/nanourl.sql to initilize the database. This
file however does is not located in /etc/ but in /etc/nanourl/
Furthermore the provided nanourl.sql script does not work with a current
mysql installation, because the column count does not match for the
first INSERT statement. Even worse, the way the database is initialized
is more than weird, so I suggest applying the attached patch.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.15-1-686
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages nanourl depends on:
ii apache 1.3.34-2 versatile, high-performance HTTP s
ii apache2 2.0.55-4.2 next generation, scalable, extenda
ii apache2-mpm-prefork [apache2 2.0.55-4.2 traditional model for Apache2
ii mysql-client-5.0 [mysql-clie 5.0.24-3 mysql database client binaries
ii php4 4:4.4.2-1.1 server-side, HTML-embedded scripti
ii php4-mysql 4:4.4.2-1.1 MySQL module for php4
nanourl recommends no packages.
-- no debconf information
--- nanourl.sql.old 2006-10-10 15:09:37.301868289 +0200
+++ nanourl.sql 2006-10-10 15:13:09.614553862 +0200
@@ -1,6 +1,4 @@
-USE mysql;
-INSERT INTO user VALUES
('localhost','nanoUser',PASSWORD('7SSTz0KIS7BQqx9D'),'N','N','N','N','N','N','Y','N','Y','N','N','Y','N','N','N','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
-INSERT INTO db VALUES
('localhost','nanoDB','nanoUser','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
+GRANT SELECT, INSERT ON nanoDB.* TO [EMAIL PROTECTED] IDENTIFIED BY 'nanoUser';
CREATE DATABASE /*!32312 IF NOT EXISTS*/ nanoDB;
USE nanoDB;
-CREATE TABLE urls ( hash char(5) NOT NULL, url LONGBLOB, PRIMARY KEY (hash))
type=MyISAM;
+CREATE TABLE /*!32312 IF NOT EXISTS*/ urls ( hash char(5) NOT NULL, url
LONGBLOB, PRIMARY KEY (hash)) type=MyISAM;
