[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Savannah-hackers-public] download access for uploading files broken

From: Bob Proulx
Subject: Re: [Savannah-hackers-public] download access for uploading files broken
Date: Fri, 24 Feb 2017 01:29:55 -0700
User-agent: NeoMutt/20170113 (1.7.2)

> Where do groups come from?
> MySQL on internal0 ! which was just rebooted!
> Then, checking download:/var/log/daemon.log shows clearly:
> ===
> Feb 24 03:03:25 download mountd[4812]: libnss-mysql: Connection to server 
> '' failed: Lost connection to MySQL server at 'reading initial 
> communication packet', system error: 113
> ===
> and is old 'internal' which was shutdown!
> so somehow, "rpc.mountd" running on old download didn't get the memo :)

Found it!  Here is the sequence.

  mysql> use mysql
  mysql> select Host,User from user;
  | Host                       | User             |

The important parts are:

  |             | nss-root         |
  |             | nss-user         |
  |  | savannahscripts  |

When pointed to then things
worked.  But then it pointed to the new download0.  Nothing changed
until mysql was restarted. That lost the access to allow savannahscripts to the database.

  address@hidden:/# /usr/local/bin/sv_get_authorized_keys rwp
  DBI connect('database=savane:host=','savannahscripts',...) 
failed: Access denied for user 'savannahscripts'@'' (using 
password: YES) at /usr/local/share/perl/5.10.0/Savane/ line 44
  Compilation failed in require at /usr/local/share/perl/5.10.0/ line 
  BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.0/ 
line 34.
  Compilation failed in require at /usr/local/bin/sv_get_authorized_keys line 4.
  BEGIN failed--compilation aborted at /usr/local/bin/sv_get_authorized_keys 
line 4.

It can't access the database.  Because the
name is now changed.  (Which is why I tend to use IP addresses for
such things.)  I added the following access grant.

  mysql> GRANT SELECT, SHOW VIEW ON savane.* TO address@hidden IDENTIFIED BY 

  address@hidden:/# /usr/local/bin/sv_get_authorized_keys rwp
  ssh-rsa AAAA ...

Works.  With that I can now copy files to olddownload.  Which is okay.
And I can scp to download0.  But I still cannot rsync to the download0.

That is what changed with the reboot.  The mysql database refroze the
DNS name to the new address for it.

I am still leaning toward a problem with locks over nfs as to why the
rsync isn't working.  But not sure yet.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]