Thomas 'Balu' Walter �����(�):
>
> I wonder if this is a bug or a feature:
>
> In that script (/usr/local/aspseek/sbin/aspseek-mysql-postinstall)
> you do:
>
> ...
> ASPSEEK=aspseek
> ASPSEEK_DIR=${ASPSEEK}
> ...
> mysql $MYSQL_ROOT_ARGS ${ASPSEEK_SQLDB} < /etc/${ASPSEEK_DIR}/sql/mysql/tables.sql
> ...
>
> Which is wrong, as long as you don't install aspseek into /etc.
This is already fixed in CVS, thanx for the reporting anyway.
Now real sysconfdir is inserted by configure script.
> Also
> the setting of the ASPSEEK_DIR is wrong (or ASPSEEK is), I guess this is
> a problem with putting the right configure-values into the script?
ASPSEEK_DIR is not needed anymore and it is removed from the script.
> Additionally I would restrict the access to localhost e.g.
>
> GRANT ALL PRIVILEGES ON ${ASPSEEK_SQLDB}.localhost TO
Why ${ASPSEEK_SQLDB}.localhost? I thought .name here is the name
of the tables, so I write ${ASPSEEK_SQLDB}.* to grant access to
all the tables from this database.
I just consulted mysql docs (http://www.mysql.com/doc/G/R/GRANT.html)
and I was right.
> ${ASPSEEK_SQLUSER}@localhost IDENTIFIED BY '$DB_PASSWD';
>
> And perhaps
>
> REVOKE GRANT OPTION ON ${ASPSEEK_SQLDB}.localhost TO
> ${ASPSEEK_SQLUSER}@localhost IDENTIFIED BY '$DB_PASSWD';
"ALL" does not mean GRANT OPTION here, it is given if you explicitly
say "WITH GRANT OPTION" then you issue "GRANT" statement.
See again http://www.mysql.com/doc/G/R/GRANT.html
>
> to disallow granting (dunno if grant is included in ALL PRIVILEGES in
> the actual mysql-version)
>
> Balu
-- [EMAIL PROTECTED] http://kir.sever.net ICQ 7551596 --
Bend the facts to fit the conclusion. It's easier that way.
-- |_ | |\| |_| >< -- |_| |\| | >< -- | ) |\/| --
