Status

Developer Services
General
RESOLVED FIXED
5 years ago
3 years ago

People

(Reporter: Gavin, Assigned: bkero)

Tracking

Details

Two things I noticed when I tried to investigate creating a new CVS account in bug 772257:

1) http://despot.mozilla.org no longer re-directs to https://despot.mozilla.org (arguably a feature, doesn't really matter that much, but I mention because it may be related)

2) Trying to sign-in at https://despot.mozilla.org results in:

Can't connect to database server at /opt/webtools/despot/despot.cgi line 111.

AFAIK the modules Christina wants access to in bug 772257 won't be accessible unless she has the appropriate despot permissions, so this is blocking getting her that access.
(Assignee)

Comment 1

5 years ago
Sure enough, this is having problems accessing the database.  I believe a network flow is in order.

[root@cvstools1.dmz.scl3 despot]# grep db_host config.pl
$::db_host = '10.22.70.105';
[root@cvstools1.dmz.scl3 despot]# nc -z 10.22.70.105 3306
[root@cvstools1.dmz.scl3 despot]# echo $?
1

We'll need a network route open up for this.
(Assignee)

Updated

5 years ago
Depends on: 773342

Updated

5 years ago
Assignee: server-ops-devservices → bkero
(Assignee)

Comment 2

5 years ago
The network connection has been fixed, although credentials are being ignored.

[root@cvstools1.dmz.scl3 despot]# mysql -udespot -p -h10.22.70.105 despot
Enter password: 
ERROR 1045 (28000): Access denied for user 'despot'@'10.22.74.60' (using password: YES)

[root@cvstools1.dmz.scl3 despot]# cat config.pl
#!/usr/bin/perl
#
# Despot configuration file
#

$::db_host = '10.22.70.105';
$::db_name = 'despot';
$::db_user = 'despot';
$::db_pass = 'omgseekrits';

$::sitename = 'mozilla.org';				# site name
$::ownersurl = 'http://www.mozilla.org/owners.html';	# owners page URL
$::adminname = 'sysadmins';				# owner name
$::adminmail = 'sysadmins@mozilla.org';			# owner e-mail address

#$::anonymous_sysuser = 'cvsuser';                        # the system user the "anonymous" account will use for pserver

1;

Off to the DBA's, hopefully they can get some auth working for this.
Assignee: bkero → server-ops-database
(Assignee)

Comment 3

5 years ago
For reference the password is not 'omgseekrits'.  I edited out the real password.
Assignee: server-ops-database → mpressman
added access for despot@10.22.74.60 using existing password
Out of curiosity, do you guys know what broke this?
(Assignee)

Comment 6

5 years ago
The datacenter migration probably broke this.  It broke both the user-host access field in the MySQL auth tables and network access was not explicitly allowed (which it needed to be)
Looks fixed now, any reason to leave this open?
(Assignee)

Comment 8

5 years ago
Can't think of anything.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
(Assignee)

Updated

5 years ago
Assignee: mpressman → bkero
Component: Server Operations: Developer Services → General
Product: mozilla.org → Developer Services
You need to log in before you can comment on or make changes to this bug.