Hue 部署过程中的报错处理

数据库初始化报错

• 解决

# 1. 进入数据库
mysql -uroot -pHoMf@123

# 2. 进入mysql数据库
mysql> use mysql;

# 3. 查询MySQL数据库中所有用户的主机名、用户名和加密后的密码信息。
mysql> SELECT host, user, authentication_string FROM mysql.user;

# host列没有172-15-0-2.lightspeed.stlsmo.sbcglobal.net则进行添加，并修改权限
mysql> CREATE USER 'root'@'172-15-0-2.lightspeed.stlsmo.sbcglobal.net' IDENTIFIED BY 'HoMf@123';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'172-15-0-2.lightspeed.stlsmo.sbcglobal.net';

# host列已有172-15-0-2.lightspeed.stlsmo.sbcglobal.net则进行权限更改
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'172-15-0-2.lightspeed.stlsmo.sbcglobal.net';

# 4.刷新MySQL的权限表，使对mysql.user表的更改立即生效。
mysql> FLUSH PRIVILEGES;

• 报错现象

hue@hue:/usr/share/hue$ /usr/share/hue/build/env/bin/hue syncdb
[22/Nov/2024 15:32:10 +0800] settings     INFO     Welcome to Hue 4.11.0
[22/Nov/2024 15:32:10 +0800] conf         WARNING  enable_extract_uploaded_archive is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
[22/Nov/2024 15:32:10 +0800] conf         WARNING  enable_new_create_table is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
[22/Nov/2024 15:32:10 +0800] conf         WARNING  force_hs2_metadata is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
[22/Nov/2024 15:32:10 +0800] conf         WARNING  show_table_erd is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
[21/Nov/2024 23:32:10 -0800] backend      WARNING  mozilla_django_oidc module not found
[21/Nov/2024 23:32:11 -0800] apps         INFO     AXES: BEGIN LOG
[21/Nov/2024 23:32:11 -0800] apps         INFO     AXES: Using django-axes version 5.13.0
[21/Nov/2024 23:32:11 -0800] apps         INFO     AXES: blocking by IP only.
Traceback (most recent call last):
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 200, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 234, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/MySQLdb/__init__.py", line 123, in Connect
    return Connection(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/MySQLdb/connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
MySQLdb.OperationalError: (1045, "Access denied for user 'root'@'172-15-0-2.lightspeed.stlsmo.sbcglobal.net' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/share/hue/build/env/bin/hue", line 33, in <module>
    sys.exit(load_entry_point('desktop', 'console_scripts', 'hue')())
  File "/usr/share/hue/desktop/core/src/desktop/manage_entry.py", line 233, in entry
    execute_from_command_line(sys.argv)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/core/management/__init__.py", line 395, in execute
    django.setup()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/__init__.py", line 24, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/apps/registry.py", line 122, in populate
    app_config.ready()
  File "/usr/share/hue/desktop/libs/notebook/src/notebook/apps.py", line 34, in ready
    table_names = connection.introspection.table_names()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/introspection.py", line 50, in table_names
    with self.connection.cursor() as cursor:
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 259, in cursor
    return self._cursor()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 235, in _cursor
    self.ensure_connection()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/base/base.py", line 200, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 234, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/MySQLdb/__init__.py", line 123, in Connect
    return Connection(*args, **kwargs)
  File "/usr/share/hue/build/env/lib/python3.8/site-packages/MySQLdb/connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'172-15-0-2.lightspeed.stlsmo.sbcglobal.net' (using password: YES)")

Hue WebUI界面弹出红色提示框，yarn连接权限不足的问题

• 解决
  在Hadoop的配置文件中添加或修改代理用户的配置。在core-site.xml中添加以下的配置：

<property>
  <name>hadoop.proxyuser.hue.hosts</name>
  <value>*</value>
</property>
<property>
  <name>hadoop.proxyuser.hue.groups</name>
  <value>admin</value>
</property>

• 报错现象

YARN RM returned a failed response: 403 Client Error: 
Forbidden for url: http://192.168.10.75:8088/ws/v1/cluster/apps?doAs=admin&user.name=hue&user=admin&limit=500&startedTimeBegin=1731719313000 { 
"RemoteException" : { "message" : "User: hue is not allowed to impersonate admin", "exception" : "AuthorizationException", "javaClassName" : 
"org.apache.hadoop.security.authorize.AuthorizationException" } } (error 403)