ERROR: gcloud crashed

[GoogleCodeExporter]

Issue running command [gcloud beta sql connect].

blemtorp@blemtorp2:~$ gcloud config set project 
google.com:sandbox-publisheruniversityblemtorp@blemtorp2:~$ gcloud beta sql 
connect publisheruniversitydb -u root
Whitelisting your IP for incoming connection for 1 minute...done.
ERROR: gcloud crashed (TypeError): coercing to Unicode: need string or buffer, 
NoneType found

What steps will reproduce the problem?

I thought maybe the project id was the issue, but tried both, and 
google.com:sandbox...seem to be the right syntax for the config part.

What is the expected output? What do you see instead?
To connect to database.

Please provide any additional information below.
It may be a user error, but wanted to check to see if this was an existing 
issue.

Traceback (most recent call last):
  File "googlecloudsdk/gcloud_main.py", line 169, in main
    gcloud_cli.Execute()
  File "googlecloudsdk/calliope/cli.py", line 643, in Execute
    result = args.cmd_func(cli=self, args=args)
  File "googlecloudsdk/calliope/backend.py", line 1401, in Run
    resources = command_instance.Run(args)
  File "googlecloudsdk/api_lib/sql/errors.py", line 40, in Func
    return foo(*args, **kwargs)
  File "surface/sql/connect.py", line 192, in Run
    execution_utils.Exec(mysql_args)
  File "googlecloudsdk/core/execution_utils.py", line 252, in Exec
    p = subprocess.Popen(args, env=env, **extra_popen_kwargs)
  File "/usr/lib/python2.7/subprocess.py", line 710, in __init__
    errread, errwrite)
  File "/usr/lib/python2.7/subprocess.py", line 1327, in _execute_child
    raise child_exception
TypeError: coercing to Unicode: need string or buffer, NoneType found

Installation information:

Google Cloud SDK [93.0.0]

Platform: [Linux, x86_64]
Python Version: [2.7.6 (default, Jun 22 2015, 17:58:13)  [GCC 4.8.2]]
Python Location: [/usr/bin/python2]
Site Packages: [Disabled]

Installation Root: [/usr/local/google/home/blemtorp/google-cloud-sdk]
Installed Components:
  core: [2016.01.14]
  core-nix: [2015.11.24]
  gcloud: []
  gsutil-nix: [4.15]
  beta: [2016.01.12]
  gsutil: [4.16]
  bq: [2.0.18]
  alpha: [2016.01.12]
  bq-nix: [2.0.18]
[output truncated]

Original issue reported on code.google.com by blemt...@google.com on 14 Mar 2016 at 11:11

[GoogleCodeExporter]

Thanks for the feedback.

Does the problem reproduce?

Original comment by gsfow...@google.com on 16 Mar 2016 at 2:39

• Changed state: NeedsMoreInfo

[GoogleCodeExporter]

Yes, it is reproducible. It's when I connect to internal googleplex like
this:

gcloud config set project gXXX.com:PROJECTNAME

followed by:

gcloud beta sql connect DATABASENAME -u root

I've been unable to get into the database. Any help is very appreciated.

Thanks.

-- 

----
Bibi Lemtorp
Training Systems Specialist
Google Inc.
+1 (415) 736-5334

Original comment by blemt...@google.com on 16 Mar 2016 at 4:28