Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 250651 - net-analyzer/cacti-0.8.7b-r3 fails authentication to mysql after update
Summary: net-analyzer/cacti-0.8.7b-r3 fails authentication to mysql after update
Status: RESOLVED DUPLICATE of bug 243260
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High major (vote)
Assignee: Peter Volkov (RETIRED)
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-11 23:44 UTC by Jim Smilanich
Modified: 2008-12-14 23:23 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Smilanich 2008-12-11 23:44:33 UTC
This is actually the second time that this has happened.  I was unable to determine what changes to the configuration files had occurred that created this situation last time.  I ended up re-installing both cacti and mysql from scratch, then rebuilding most of the connections.  As it is, there were two sets of data that I was unable to recreate connections for.

Reproducible: Always

Steps to Reproduce:
1.update cacti and/or mysql.  I'm not sure which causes the failure.
2.
3.

Actual Results:  
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'cactiuser'@'localhost' (using password: YES) in /usr/share/php5/adodb/drivers/adodb-mysql.inc.php on line 382

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'cactiuser'@'localhost' (using password: YES) in /usr/share/php5/adodb/drivers/adodb-mysql.inc.php on line 382

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'cactiuser'@'localhost' (using password: YES) in /usr/share/php5/adodb/drivers/adodb-mysql.inc.php on line 382

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'cactiuser'@'localhost' (using password: YES) in /usr/share/php5/adodb/drivers/adodb-mysql.inc.php on line 382

(repeated over and over)

Expected Results:  
Either a cacti login screen or normal Web displays.

There should _never_ be an update that breaks authentication between systems.  The ebuild for either cacti (the most likely suspect in my mind and therefore why I filed the bug under it) or mysql is breaking working installations for no apparent reason.

Installed mysql version:
dev-db/mysql
      Latest version available: 5.0.70-r1
      Latest version installed: 5.0.70-r1
Comment 1 Peter Volkov (RETIRED) gentoo-dev 2008-12-14 18:51:16 UTC
Thank you for report. This is known problem with webapp-config. Too bad nobody fixed that yet.

*** This bug has been marked as a duplicate of bug 243260 ***
Comment 2 Jim Smilanich 2008-12-14 21:42:17 UTC
Re-opening the ticket as there is still an unresolved issue.  How do I recover from the authentication failure?  Last time, I tried to run through just the instructions in the Wiki that seemed to cover authentication.  After all, I wanted to avoid a complete reinstallation.  

Unfortunately, I failed and had to back out the installation completely and re-install.  I would love to avoid that situation this time around if I can.  Does anyone with knowledge of cacti, mysql,and/or webapp-config have any idea as to how I should proceed?  What information do you need from me?

emerge --info output:

Portage 2.1.4.5 (default-linux/x86/2007.0/desktop, gcc-3.4.6, glibc-2.6.1-r0, 2.6.22-gentoo-r9 i686)
=================================================================
System uname: 2.6.22-gentoo-r9 i686 Intel(R) XEON(TM) CPU 2.40GHz
Timestamp of tree: Tue, 09 Dec 2008 12:32:01 +0000
app-shells/bash:     3.2_p33
dev-lang/python:     2.4.4-r13, 2.5.2-r7
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.13, 2.61-r2
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=i686 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-O2 -march=i686 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="en_US"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="acl acpi alsa arts berkdb cairo cdr cli cracklib crypt cups dbus dedicated doc dri dvd dvdr dvdread eds emboss encode esd evo fam firefox fortran gdbm gif gpm gstreamer hal iconv ipv6 isdnlog jpeg kde kerberos ldap mad midi mikmod mp3 mpeg mudflap ncurses nls nptl nptlonly ogg opengl openmp oss pam pcre pdf perl png pnp pppd python qt3support qt4 quicktime readline reflection sdl session spell spl ssl svg tcpd tiff truetype usb vorbis win32codecs x86 xml xorg xv zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i740 i810 imstt intel mach64 mga neomagic nsc nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 3 Peter Volkov (RETIRED) gentoo-dev 2008-12-14 23:23:39 UTC
(In reply to comment #2)
> Re-opening the ticket as there is still an unresolved issue.

It is, but, please, don't reopen this bug report. It is duplicate of another one...

> How do I recover
> from the authentication failure?  Last time, I tried to run through just the
> instructions in the Wiki that seemed to cover authentication.  After all, I
> wanted to avoid a complete reinstallation.  

Your configure files was overwirted with default one so now you have to provide correct information inside include/config.php.

> Unfortunately, I failed and had to back out the installation completely and
> re-install.  I would love to avoid that situation this time around if I can. 
> Does anyone with knowledge of cacti, mysql,and/or webapp-config have any idea
> as to how I should proceed?  What information do you need from me?

Take a look at include/config.php file. You need to provide database name, database user and password. I don't know how you configured that but if you did everything manually probably you still have some information in .mysql_history file (look for GRANT there).

If you need more assistance feel free to ask here, but please don't reopen this bug if possible. Thanks.

*** This bug has been marked as a duplicate of bug 243260 ***