[ic] Upgraded to mysql 4.1.20 and now errors ?
kevin at cursor.biz
Sat Jun 17 14:02:09 EDT 2006
Jim Toro <jimtoro at liwebtech.com> wrote:
> We have been running IC 5.4.0 and Mysql 4.0.2x for a long time and today
> we had to upgrade to mysql 4.1.20, we did the compile and install along
> with the latest DBI and DBD, everything seems to come up ok but when
> starting interchange we get these errrors:
> [snip: access denied errors]
> Interchange does come up but of course we cannot do anything with the
> database at this point.
> I put the "old-passwords" setting in the my.cnf in the [mysqld] section
> too. Did full reboots, etc..
> What am I missing ???? Does something else have to be done to the database
> when going from mysql 4.0 to 4.1 or is it a IC or Perl issue ?
You probably didn't run the "mysql_fix_privilege_tables", as instructed
to in the MySQL 4.0 -> 4.1 upgrade guide. Backup your database and
run it now. That should fix it.
The servers I have that run MySQL were all upgraded to 4.1.20 a long
time ago. 4.1.20 is now the default version supplied with Gentoo
_/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
_/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n W a l s h
_/ _/ _/ _/ _/ _/ _/ _/_/ kevin at cursor.biz
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/
More information about the interchange-users