Developer Services
5 years ago
3 years ago


(Reporter: Gavin, Assigned: bkero)



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

1) no longer re-directs to (arguably a feature, doesn't really matter that much, but I mention because it may be related)

2) Trying to sign-in at 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.

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
$::db_host = '';
[root@cvstools1.dmz.scl3 despot]# nc -z 3306
[root@cvstools1.dmz.scl3 despot]# echo $?

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


5 years ago
Depends on: 773342


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

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'@'' (using password: YES)

[root@cvstools1.dmz.scl3 despot]# cat
# Despot configuration file

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

$::sitename = '';				# site name
$::ownersurl = '';	# owners page URL
$::adminname = 'sysadmins';				# owner name
$::adminmail = '';			# owner e-mail address

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


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

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@ using existing password
Out of curiosity, do you guys know what broke this?

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?

Comment 8

5 years ago
Can't think of anything.
Last Resolved: 5 years ago
Resolution: --- → FIXED


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