主页 / user-346868

миха капа's questions

Martin Hope
миха капа
Asked: 2025-03-21 19:00:29 +0000 UTC
  • 5

尝试构建使用 oracle-instantclient 的项目时，出现错误：

/usr/bin/ld: cannot find -lclntsh
collect2: error: ld returned 1 exit status
make: *** [Makefile:10: build] Error 2

在instantclient-basic-linux.x64-[VERSION].zip包中- 缺少此文件/lib（或仅仅是密钥）lclntsh，但有这个：libclntsh.so。

这里提到了这个库：

/home/test/go/src/github.com/mattn/go-oci8/README.md:Libs: -L${libdir} -lclntsh
/home/test/go/src/github.com/mattn/go-oci8/oci8.pc:Libs: -L${libdir} -lclntsh
/home/test/go/src/github.com/mattn/go-oci8/.travis.yml:      echo "Libs: -L$ORACLE_HOME/lib -Wl,-rpath,$ORACLE_HOME/lib -lclntsh";

我手动指定了这些文件中 oracle-instantclient 内容的路径 - 就我而言，它在这里：

/usr/lib/oracle/19.10/client64/lib/

所以 ：

prefix=/usr
includedir=${prefix}/include/oracle/19.10/client64
libdir=${prefix}/lib/oracle/19.10/client64/lib

但没有任何帮助。

附言：

declare -x ORACLE_HOME="/usr/lib/oracle/19.10/client64"
declare -x LD_LIBRARY_PATH="/usr/lib/oracle/19.10/client64/lib/"
oracle
Martin Hope
миха капа
Asked: 2024-03-15 12:51:18 +0000 UTC
  • 5

在 Docker 中设置 Apache2 + Kerberos。file.keytab - 是的。krb5.conf 中的设置是正确的。

root@container:/# klist
Ticket cache: FILE:/tmp/ticket
Default principal: учётка@DOMEN.RU

Valid starting     Expires            Service principal
03/15/24 04:42:42  03/15/24 14:42:42  krbtgt/[email protected]
        renew until 03/22/24 04:42:32

Apache 中的设置：

    <Location "/">
       AuthType Kerberos
       AuthName "УЧЁТКА"
       KrbMethodNegotiate on
       KrbMethodK5Passwd off
       KrbServiceName HTTP/имя_сервера[email protected]
       KrbAuthRealms DOMEN.RU
       Krb5Keytab /etc/apache2/имя_сервера.keytab
       KrbLocalUserMapping On
       Require valid-user
    </Location>

错误：

[Fri Mar 15 04:39:57.061033 2024] [auth_kerb:error] [pid 10:tid 140193378916096] [client 10.108.77.177:58138] gss_accept_sec_context() failed: Unspecified GSS failure.  Minor code may provide more information (, No key table entry found for HTTP/имя_сервера[email protected])
docker
Martin Hope
миха капа
Asked: 2024-01-22 13:23:01 +0000 UTC
  • 5

有这样一个Apache + WSGI Django Docker 的组合。当容器启动时，默认的 Apache 页面正常打开。但是，当您使用 Django 应用程序访问某些页面时，它无法打开，并且日志中出现错误：This is a log in the container

root@828dcbc18f43:/# tail -f /var/log/apache2/error.log
mod_wsgi (pid=9): Failed to exec Python script file '/home/test/app1/backend/otu_it/wsgi.py'.
mod_wsgi (pid=9): Exception occurred processing WSGI script '/home/test/app1/backend/otu_it/wsgi.py'.
Traceback (most recent call last):
   File "/home/test/app1/backend/otu_it/wsgi.py", line 20, in <module>
     application = get_wsgi_application()
   File "/home/test/app1/venv/lib/python3.8/site-packages/django/core/wsgi.py", line 12, in get_wsgi_application
     django.setup(set_prefix=False)
   File "/home/test/app1/venv/lib/python3.8/site-packages/django/__init__.py", line 24, in setup
     apps.populate(settings.INSTALLED_APPS)
   File "/home/test/app1/venv/lib/python3.8/site-packages/django/apps/registry.py", line 83, in populate
     raise RuntimeError("populate() isn't reentrant")
 RuntimeError: populate() isn't reentrant

这是 Django 应用程序的 Apache 配置文件：

        WSGIPythonHome /home/test/app1/venv
        WSGIPythonPath /home/test/app1/backend


<VirtualHost *:80/api/user>
        # However, you must set it for any further virtual host explicitly.
        #ServerName www.example.com

        ServerAdmin webmaster@localhost
        DocumentRoot /home/test/app1/backend/
        WSGIScriptAlias / /home/test/app1/backend/otu_it/wsgi.py
#        WSGIPythonHome /home/test/app1/venv
#        WSGIPythonPath /home/test/app1/backend

        <Directory /home/test/app1/backend/otu_it/>

                ## NEW
                Require all granted

                <Files wsgi.py>
                        Require all granted
                </Files>
#                Order allow,deny
#                Allow from all
        </Directory>

        #LogLevel info ssl:warn

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        # after it has been globally disabled with "a2disconf".
        #Include conf-available/serve-cgi-bin.conf
</VirtualHost>

<VirtualHost *:443>
        SSLEngine on
        SSLCertificateFile /etc/apache2/ssl/cert.crt
        SSLCertificateKeyFile /etc/apache2/ssl/cert.key

        ServerAdmin webmaster@localhost
        DocumentRoot /home/test/app1/backend/
        WSGIScriptAlias / /home/test/app1/backend/otu_it/wsgi.py
#        WSGIPythonHome /home/test/app1/venv
#        WSGIPythonPath /home/test/app1/backend

        <Directory /home/test/app1/backend/otu_it/>
                <Files wsgi.py>
                        Require all granted
                </Files>
#                Order allow,deny
#                Allow from all
        </Directory>

        #LogLevel info ssl:warn

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        # after it has been globally disabled with "a2disconf".
        #Include conf-available/serve-cgi-bin.conf
</VirtualHost>

也许我错误地连接了 Django 的虚拟环境。我已经尝试了很多 - 没有任何帮助。可能是什么问题呢？PS - 在容器之外，一切都可以使用这些配置，没有问题。

django
Martin Hope
миха капа
Asked: 2022-04-25 15:32:16 +0000 UTC
  • 0

有一个像这样的表：

ID  ParentID    Name
1   0   Раздел 1
2   0   Раздел 2
3   0   Раздел 3
4   1   Раздел 4
5   1   Раздел 5
6   4   Раздел 6
7   2   Раздел 7
8   2   Раздел 8
9   3   Раздел 9
10  2   Раздел 10
11  2   Раздел 11
12  11  Раздел 12
13  6   Раздел 13
14  6   Раздел 14
15  9   Раздел 15
16  9   Раздел 16
17  9   Раздел 17
18  9   Раздел 18
19  17  Раздел 19
20  19  Раздел 20

如何选择所有部分并计算其所有节点中的子节点数（按其分支）？

WITH rec4 (id, pid, name)
AS 
(
    SELECT id, parentID, name
    FROM parent 
    WHERE id = 1
    UNION ALL
    SELECT p.id, p.parentID, p.name
    FROM parent AS p
        JOIN rec4 AS r ON p.parentID = r.id
)
SELECT * FROM rec4 ;

这显示了只有一个父母的孩子。如何全选并显示他们的号码？

sql
Martin Hope
миха капа
Asked: 2021-12-30 14:53:26 +0000 UTC
  • 0

如何在 Python 中剪切字符串并选择特定值，类似于 Bash。有一个像这样的 Bash 代码

hw=$(snmpget -Lo -v2c -c public $ip $cr_chassis_oid | awk -F'"' '{print $2}' | sed -E 's/[cC]hassis.*$//g')

而这段代码需要在Python中类推。但我没有找到用于处理字符串的类似函数。你需要这些行：

2811 chassis
CISCO2911R/K9 chassis, Hw Serial#: JTV2114TKYH, Hw Revision: 1.0
Cisco ISR4331 Chassis
3845 chassis

获取值：2811、2911R/K9、ISR4331、3845 等。

python