Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 10 Feb 2019 21:09:32 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 235654] databases/mariadb103-client installed mytop does not work with ~/.my.cnf
Message-ID:  <bug-235654-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D235654

            Bug ID: 235654
           Summary: databases/mariadb103-client installed mytop does not
                    work with ~/.my.cnf
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd@freebsd.org
          Reporter: 000.fbsd@quip.cz
             Flags: maintainer-feedback?(brnrd@freebsd.org)
          Assignee: brnrd@freebsd.org

Previously the "mytop" was standalone port. I upgraded MariaDB 10.1 to 10.3
which is conflicting with installed "mytop". Original "mytop" was removed a=
nd
"mytop" from mariadb103-client package does not work if user has ~/my.cnf w=
ith
stored password for different user (login) than should be used with "mytop".

"mytop" should read its options from ~/.mytop file where I have all the opt=
ions
specified

user=3Dmytop
pass=3DSomeStrongPasswordHere
host=3Dlocalhost
db=3Dmysql
delay=3D3
port=3D3306
socket=3D/tmp/mysql.sock
batchmode=3D0
header=3D1
color=3D1
idle=3D1
resolve=3D1

But when I run "mytop" I got these error:

Cannot connect to MariaDB server. Please check the:

  * database you specified "mysql" (default is "test")
  * username you specified "mytop" (default is "root")
  * password you specified "AnotherPassword" (default is "")
  * hostname you specified "localhost" (default is "localhost")
  * port you specified "3306" (default is 3306)
  * socket you specified "/tmp/mysql.sock" (default is "")

The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:'

Access denied for user 'mytop'@'localhost' (using password: YES)


Where "AnotherPassword" is the password read from ~/.my.cnf which is passwo=
rd
for my currently logged user and not password for user "mytop" under which
"mytop" should run.

It worked for me for the last 10+ years with standalone "mytop" but does not
work anymore.

The next problem is that "mytop" has dependencies on some Perl libraries but
they are not specified in the mariadb103-client package. (all are installed=
 in
my case)

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-235654-7788>