Find attached the patch and the ebuild needed to get cacti-0.8.6g running with mysql-5.
Created attachment 73425 [details, diff] The needed Patch (sets the missing paranthesis in SQL-Statements)
Created attachment 73428 [details] The ebuild-file for Cacti with MySQL-5
Cacti-CactiD itself works excellent with MySQL-5 as it only has a few simple SELECT-Statements without any JOINs ... therefore there is no longer a need to have the DEPEND !>=mysql-5 nor to have RDEPEND= !>=mysql-5
Upstream says [1] to wait until they release the next version which will support mysql-5. I would rather wait for that than introduce something like this and deal with any bugs on it. If you want to help upstream with your patch, or any other issues with using mysl-5, please do so! :-) Going to mark as wontfix unless upstream says different. [1] http://forums.cacti.net/viewtopic.php?t=10175