Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't connect pyHSS web #290

Closed
MAlexVR opened this issue Mar 10, 2024 · 10 comments
Closed

Can't connect pyHSS web #290

MAlexVR opened this issue Mar 10, 2024 · 10 comments

Comments

@MAlexVR
Copy link

MAlexVR commented Mar 10, 2024 •
edited
Loading

Dear Herle,

I'm deploying a fresh copy but the link to pyHSS http://<DOCKER_HOST_IP>:8080/docs/ doesn't work and the connection is refused.

image

Could you help me?
@herlesupreeth
Copy link
Owner

Please send me the output of docker logs pyhss

@modyngs
Copy link

modyngs commented Mar 11, 2024

@MAlexVR restart all the docker components!
docker compose down
docker compose Up

@platini2
Copy link
Contributor

Sometimes you need to restart pyhss in the first start as it fails to come up.

@MAlexVR
Copy link
Author

MAlexVR commented Mar 28, 2024

Hi @herlesupreeth this is my log:

root@vm:/home/user/Descargas/docker_open5gs# docker logs pyhss
mysqld is alive
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
mysql://pyhss:ims_db_pass@172.22.0.17/ims_hss_db?autocommit=true
Instantiating LogTool with Kwargs dict_items([])
2024-03-28 17:23:47,562 INFO sqlalchemy.engine.Engine SELECT DATABASE()
2024-03-28 17:23:47,562 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,563 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
2024-03-28 17:23:47,563 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,563 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
2024-03-28 17:23:47,563 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,564 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-03-28 17:23:47,564 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.operation_log
2024-03-28 17:23:47,564 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,565 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.apn
2024-03-28 17:23:47,565 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,565 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.subscriber_routing
2024-03-28 17:23:47,565 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,566 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.auc
2024-03-28 17:23:47,566 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,566 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.subscriber
2024-03-28 17:23:47,566 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,567 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.serving_apn
2024-03-28 17:23:47,567 INFO sqlalchemy.engine.Engine [raw sql] ()
mysql://pyhss:ims_db_pass@172.22.0.17/ims_hss_db?autocommit=true
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
2024-03-28 17:23:47,567 INFO sqlalchemy.engine.Engine SELECT DATABASE()
2024-03-28 17:23:47,567 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.ims_subscriber
2024-03-28 17:23:47,567 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,568 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,568 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.charging_rule
2024-03-28 17:23:47,568 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,568 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.tft
2024-03-28 17:23:47,568 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,568 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
2024-03-28 17:23:47,569 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,569 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
2024-03-28 17:23:47,569 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.eir
2024-03-28 17:23:47,569 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,569 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,569 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.eir_history
2024-03-28 17:23:47,570 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,570 INFO sqlalchemy.engine.Engine DESCRIBE ims_hss_db.subscriber_attributes
2024-03-28 17:23:47,570 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,570 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-03-28 17:23:47,570 INFO sqlalchemy.engine.Engine SHOW FULL TABLES FROM ims_hss_db
2024-03-28 17:23:47,570 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,571 INFO sqlalchemy.engine.Engine
CREATE TABLE apn (
apn_id INTEGER NOT NULL AUTO_INCREMENT,
apn VARCHAR(50) NOT NULL,
ip_version INTEGER,
pgw_address VARCHAR(50),
sgw_address VARCHAR(50),
charging_characteristics VARCHAR(4),
apn_ambr_dl INTEGER NOT NULL,
apn_ambr_ul INTEGER NOT NULL,
qci INTEGER,
arp_priority INTEGER,
arp_preemption_capability BOOL,
arp_preemption_vulnerability BOOL,
charging_rule_list VARCHAR(18),
last_modified VARCHAR(100),
PRIMARY KEY (apn_id)
)

2024-03-28 17:23:47,572 INFO sqlalchemy.engine.Engine [no key 0.00008s] ()
2024-03-28 17:23:47,572 INFO sqlalchemy.engine.Engine ROLLBACK
2024-03-28 17:23:47,572 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-03-28 17:23:47,573 INFO sqlalchemy.engine.Engine
CREATE TABLE operation_log (
id INTEGER NOT NULL AUTO_INCREMENT,
item_id INTEGER NOT NULL,
operation_id VARCHAR(36) NOT NULL,
operation VARCHAR(10),
changes TEXT,
last_modified VARCHAR(100),
timestamp DATETIME,
table_name VARCHAR(255),
apn_id INTEGER,
subscriber_routing_id INTEGER,
serving_apn_id INTEGER,
auc_id INTEGER,
subscriber_id INTEGER,
ims_subscriber_id INTEGER,
charging_rule_id INTEGER,
tft_id INTEGER,
eir_id INTEGER,
imsi_imei_history_id INTEGER,
subscriber_attributes_id INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)

2024-03-28 17:23:47,573 INFO sqlalchemy.engine.Engine [no key 0.00007s] ()
2024-03-28 17:23:47,581 INFO sqlalchemy.engine.Engine ROLLBACK
2024-03-28 17:23:47,581 INFO sqlalchemy.engine.Engine
CREATE TABLE auc (
auc_id INTEGER NOT NULL AUTO_INCREMENT,
ki VARCHAR(32) NOT NULL,
opc VARCHAR(32) NOT NULL,
amf VARCHAR(4) NOT NULL,
sqn BIGINT,
iccid VARCHAR(20),
imsi VARCHAR(18),
batch_name VARCHAR(20),
sim_vendor VARCHAR(20),
esim BOOL,
lpa VARCHAR(128),
pin1 VARCHAR(20),
pin2 VARCHAR(20),
puk1 VARCHAR(20),
puk2 VARCHAR(20),
kid VARCHAR(20),
psk VARCHAR(128),
des VARCHAR(128),
adm1 VARCHAR(20),
misc1 VARCHAR(128),
misc2 VARCHAR(128),
misc3 VARCHAR(128),
misc4 VARCHAR(128),
last_modified VARCHAR(100),
PRIMARY KEY (auc_id),
UNIQUE (iccid),
UNIQUE (imsi)
)

2024-03-28 17:23:47,581 INFO sqlalchemy.engine.Engine [no key 0.00017s] ()
Traceback (most recent call last):
File "/usr/local/bin/flask", line 8, in
sys.exit(main())
File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 1050, in main
cli.main()
File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1078, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/click/decorators.py", line 92, in new_func
return ctx.invoke(f, obj, *args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 911, in run_command
raise e from None
File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 897, in run_command
app = info.load_app()
File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 308, in load_app
app = locate_app(import_name, name)
File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 218, in locate_app
import(module_name)
File "/pyhss/PyHSS_API.py", line 27, in
import database
File "/pyhss/database.py", line 404, in
Base.metadata.tables[table_name].create(bind=engine)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/schema.py", line 1149, in create
bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 3226, in _run_ddl_visitor
conn._run_ddl_visitor(visitorcallable, element, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2430, in _run_ddl_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 670, in traverse_single
return meth(obj, **kw)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 958, in visit_table
CreateTable(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 315, in _invoke_with
return bind.execute(self)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1414, in execute
return meth(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 181, in _execute_on_connection
return connection._execute_ddl(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1526, in _execute_ddl
ret = self._execute_context(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2326, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
res = self._query(mogrified_query)
File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
db.query(q)
File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1824, "Failed to open the referenced table 'subscriber_routing'")
[SQL:
CREATE TABLE operation_log (
id INTEGER NOT NULL AUTO_INCREMENT,
item_id INTEGER NOT NULL,
operation_id VARCHAR(36) NOT NULL,
operation VARCHAR(10),
changes TEXT,
last_modified VARCHAR(100),
timestamp DATETIME,
table_name VARCHAR(255),
apn_id INTEGER,
subscriber_routing_id INTEGER,
serving_apn_id INTEGER,
auc_id INTEGER,
subscriber_id INTEGER,
ims_subscriber_id INTEGER,
charging_rule_id INTEGER,
tft_id INTEGER,
eir_id INTEGER,
imsi_imei_history_id INTEGER,
subscriber_attributes_id INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)

]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2024-03-28 17:23:47,593 INFO sqlalchemy.engine.Engine
CREATE TABLE ims_subscriber (
ims_subscriber_id INTEGER NOT NULL AUTO_INCREMENT,
msisdn VARCHAR(18),
msisdn_list VARCHAR(1200),
imsi VARCHAR(18),
ifc_path VARCHAR(18),
sh_profile TEXT(12000),
scscf VARCHAR(512),
scscf_timestamp DATETIME,
scscf_realm VARCHAR(512),
scscf_peer VARCHAR(512),
last_modified VARCHAR(100),
PRIMARY KEY (ims_subscriber_id),
UNIQUE (msisdn)
)

2024-03-28 17:23:47,593 INFO sqlalchemy.engine.Engine [no key 0.00017s] ()
2024-03-28 17:23:47,602 INFO sqlalchemy.engine.Engine
CREATE TABLE charging_rule (
charging_rule_id INTEGER NOT NULL AUTO_INCREMENT,
rule_name VARCHAR(20),
qci INTEGER,
arp_priority INTEGER,
arp_preemption_capability BOOL,
arp_preemption_vulnerability BOOL,
mbr_dl INTEGER NOT NULL,
mbr_ul INTEGER NOT NULL,
gbr_dl INTEGER NOT NULL,
gbr_ul INTEGER NOT NULL,
tft_group_id INTEGER,
precedence INTEGER,
rating_group INTEGER,
last_modified VARCHAR(100),
PRIMARY KEY (charging_rule_id)
)

2024-03-28 17:23:47,602 INFO sqlalchemy.engine.Engine [no key 0.00009s] ()
2024-03-28 17:23:47,609 INFO sqlalchemy.engine.Engine
CREATE TABLE tft (
tft_id INTEGER NOT NULL AUTO_INCREMENT,
tft_group_id INTEGER NOT NULL,
tft_string VARCHAR(100) NOT NULL,
direction INTEGER NOT NULL,
last_modified VARCHAR(100),
PRIMARY KEY (tft_id)
)

2024-03-28 17:23:47,609 INFO sqlalchemy.engine.Engine [no key 0.00013s] ()
2024-03-28 17:23:47,617 INFO sqlalchemy.engine.Engine
CREATE TABLE eir (
eir_id INTEGER NOT NULL AUTO_INCREMENT,
imei VARCHAR(60),
imsi VARCHAR(60),
regex_mode INTEGER,
match_response_code INTEGER,
last_modified VARCHAR(100),
PRIMARY KEY (eir_id)
)

2024-03-28 17:23:47,617 INFO sqlalchemy.engine.Engine [no key 0.00013s] ()
2024-03-28 17:23:47,624 INFO sqlalchemy.engine.Engine
CREATE TABLE eir_history (
imsi_imei_history_id INTEGER NOT NULL AUTO_INCREMENT,
imsi_imei VARCHAR(60),
match_response_code INTEGER,
imsi_imei_timestamp DATETIME,
last_modified VARCHAR(100),
PRIMARY KEY (imsi_imei_history_id),
UNIQUE (imsi_imei)
)

2024-03-28 17:23:47,624 INFO sqlalchemy.engine.Engine [no key 0.00011s] ()
2024-03-28 17:23:47,632 INFO sqlalchemy.engine.Engine
CREATE TABLE subscriber (
subscriber_id INTEGER NOT NULL AUTO_INCREMENT,
imsi VARCHAR(18),
enabled BOOL,
auc_id INTEGER NOT NULL,
default_apn INTEGER NOT NULL,
apn_list VARCHAR(64) NOT NULL,
msisdn VARCHAR(18),
ue_ambr_dl INTEGER,
ue_ambr_ul INTEGER,
nam INTEGER,
subscribed_rau_tau_timer INTEGER,
serving_mme VARCHAR(512),
serving_mme_timestamp DATETIME,
serving_mme_realm VARCHAR(512),
serving_mme_peer VARCHAR(512),
last_modified VARCHAR(100),
PRIMARY KEY (subscriber_id),
UNIQUE (imsi),
FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
FOREIGN KEY(default_apn) REFERENCES apn (apn_id)
)

2024-03-28 17:23:47,632 INFO sqlalchemy.engine.Engine [no key 0.00018s] ()
2024-03-28 17:23:47,647 INFO sqlalchemy.engine.Engine
CREATE TABLE subscriber_routing (
subscriber_routing_id INTEGER NOT NULL AUTO_INCREMENT,
subscriber_id INTEGER,
apn_id INTEGER,
ip_version INTEGER,
ip_address VARCHAR(254),
last_modified VARCHAR(100),
PRIMARY KEY (subscriber_routing_id),
UNIQUE (subscriber_id, apn_id),
FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id) ON DELETE CASCADE,
FOREIGN KEY(apn_id) REFERENCES apn (apn_id) ON DELETE CASCADE
)

2024-03-28 17:23:47,647 INFO sqlalchemy.engine.Engine [no key 0.00016s] ()
2024-03-28 17:23:47,660 INFO sqlalchemy.engine.Engine
CREATE TABLE serving_apn (
serving_apn_id INTEGER NOT NULL AUTO_INCREMENT,
subscriber_id INTEGER,
apn INTEGER,
pcrf_session_id VARCHAR(100),
subscriber_routing VARCHAR(100),
ip_version INTEGER,
serving_pgw VARCHAR(512),
serving_pgw_timestamp DATETIME,
serving_pgw_realm VARCHAR(512),
serving_pgw_peer VARCHAR(512),
last_modified VARCHAR(100),
PRIMARY KEY (serving_apn_id),
FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id) ON DELETE CASCADE,
FOREIGN KEY(apn) REFERENCES apn (apn_id) ON DELETE CASCADE
)

2024-03-28 17:23:47,660 INFO sqlalchemy.engine.Engine [no key 0.00012s] ()
2024-03-28 17:23:47,674 INFO sqlalchemy.engine.Engine
CREATE TABLE subscriber_attributes (
subscriber_attributes_id INTEGER NOT NULL AUTO_INCREMENT,
subscriber_id INTEGER NOT NULL,
key VARCHAR(60),
last_modified VARCHAR(100),
value VARCHAR(12000),
PRIMARY KEY (subscriber_attributes_id),
FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id) ON DELETE CASCADE
)

2024-03-28 17:23:47,674 INFO sqlalchemy.engine.Engine [no key 0.00013s] ()
2024-03-28 17:23:47,684 INFO sqlalchemy.engine.Engine
CREATE TABLE operation_log (
id INTEGER NOT NULL AUTO_INCREMENT,
item_id INTEGER NOT NULL,
operation_id VARCHAR(36) NOT NULL,
operation VARCHAR(10),
changes TEXT,
last_modified VARCHAR(100),
timestamp DATETIME,
table_name VARCHAR(255),
apn_id INTEGER,
subscriber_routing_id INTEGER,
serving_apn_id INTEGER,
auc_id INTEGER,
subscriber_id INTEGER,
ims_subscriber_id INTEGER,
charging_rule_id INTEGER,
tft_id INTEGER,
eir_id INTEGER,
imsi_imei_history_id INTEGER,
subscriber_attributes_id INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)

2024-03-28 17:23:47,684 INFO sqlalchemy.engine.Engine [no key 0.00012s] ()
2024-03-28 17:23:47,718 INFO sqlalchemy.engine.Engine COMMIT
2024-03-28 17:23:47,719 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-03-28 17:23:47,719 INFO sqlalchemy.engine.Engine SHOW FULL TABLES FROM ims_hss_db
2024-03-28 17:23:47,719 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-03-28 17:23:47,720 INFO sqlalchemy.engine.Engine ROLLBACK
/pyhss/database.py:1109: SyntaxWarning: "is not" with a literal. Did you mean "!="?
if page_size is not 0:
2024-03-28 17:26:16,765 WARNING {hss.py:752} manage_client: Socket timeout for client: ('172.22.0.20', 60910)
manage_client: Socket timeout for client: ('172.22.0.20', 60910)
root@vm:/home/user/Descargas/docker_open5gs#

@MAlexVR MAlexVR closed this as completed Apr 1, 2024
@herlesupreeth
Copy link
Owner

@MAlexVR was your issue resolved? If not, are you sure you are using latest commits from this repo and didnt do any modifications?

@energygreek
Copy link

hello, facing a similar problem, pyhss fails to start.
docker compose output error

icscf        | 28(60) ERROR: cdp [receiver.c:1060]: peer_connect(): peer_connect(): Error opening connection to to 172.22.0.18 port 3875 >No route to host
scscf        | 28(64) ERROR: cdp [receiver.c:1060]: peer_connect(): peer_connect(): Error opening connection to to 172.22.0.18 port 3875 >No route to host

and docker logs pyhss prints

root@vince-virtual-machine:~/docker_open5gs# docker logs pyhss
mysqld is alive
mysql://pyhss:ims_db_pass@172.22.0.17/ims_hss_db?autocommit=true
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
2024-04-17 11:08:26,331 INFO sqlalchemy.engine.Engine SELECT DATABASE()
2024-04-17 11:08:26,331 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,333 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
2024-04-17 11:08:26,334 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,335 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
2024-04-17 11:08:26,335 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,341 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-04-17 11:08:26,341 INFO sqlalchemy.engine.Engine SHOW FULL TABLES FROM `ims_hss_db`
2024-04-17 11:08:26,341 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,346 INFO sqlalchemy.engine.Engine ROLLBACK
2024-04-17 11:08:26,350 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-04-17 11:08:26,354 INFO sqlalchemy.engine.Engine
CREATE TABLE operation_log (
        id INTEGER NOT NULL AUTO_INCREMENT,
        item_id INTEGER NOT NULL,
        operation_id VARCHAR(36) NOT NULL,
        operation VARCHAR(10),
        changes TEXT,
        last_modified VARCHAR(100),
        timestamp DATETIME,
        table_name VARCHAR(255),
        apn_id INTEGER,
        subscriber_routing_id INTEGER,
        serving_apn_id INTEGER,
        auc_id INTEGER,
        subscriber_id INTEGER,
        ims_subscriber_id INTEGER,
        charging_rule_id INTEGER,
        tft_id INTEGER,
        eir_id INTEGER,
        imsi_imei_history_id INTEGER,
        subscriber_attributes_id INTEGER,
        PRIMARY KEY (id),
        FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
        FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
        FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
        FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
        FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
        FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
        FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
        FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
        FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
        FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
        FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)


2024-04-17 11:08:26,354 INFO sqlalchemy.engine.Engine [no key 0.00024s] ()
2024-04-17 11:08:26,358 INFO sqlalchemy.engine.Engine ROLLBACK
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
Instantiating LogTool with Kwargs dict_items([])
mysql://pyhss:ims_db_pass@172.22.0.17/ims_hss_db?autocommit=true
Instantiating LogTool with Kwargs dict_items([])
2024-04-17 11:08:26,375 INFO sqlalchemy.engine.Engine SELECT DATABASE()
2024-04-17 11:08:26,376 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,378 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
2024-04-17 11:08:26,378 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,378 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
2024-04-17 11:08:26,379 INFO sqlalchemy.engine.Engine [raw sql] ()
2024-04-17 11:08:26,381 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-04-17 11:08:26,382 INFO sqlalchemy.engine.Engine SHOW FULL TABLES FROM `ims_hss_db`
2024-04-17 11:08:26,382 INFO sqlalchemy.engine.Engine [raw sql] ()
Traceback (most recent call last):
  File "/usr/local/bin/flask", line 8, in <module>
    sys.exit(main())
  File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 1050, in main
    cli.main()
  File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/click/decorators.py", line 92, in new_func
    return ctx.invoke(f, obj, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 911, in run_command
    raise e from None
  File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 897, in run_command
    app = info.load_app()
  File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 308, in load_app
    app = locate_app(import_name, name)
  File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 218, in locate_app
    __import__(module_name)
  File "/pyhss/PyHSS_API.py", line 27, in <module>
    import database
  File "/pyhss/database.py", line 404, in <module>
    Base.metadata.tables[table_name].create(bind=engine)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/schema.py", line 1149, in create
    bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 3226, in _run_ddl_visitor
    conn._run_ddl_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2430, in _run_ddl_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 670, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 958, in visit_table
    CreateTable(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 315, in _invoke_with
    return bind.execute(self)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1414, in execute
    return meth(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 181, in _execute_on_connection
    return connection._execute_ddl(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1526, in _execute_ddl
    ret = self._execute_context(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2326, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1824, "Failed to open the referenced table 'subscriber_routing'")
[SQL:
CREATE TABLE operation_log (
        id INTEGER NOT NULL AUTO_INCREMENT,
        item_id INTEGER NOT NULL,
        operation_id VARCHAR(36) NOT NULL,
        operation VARCHAR(10),
        changes TEXT,
        last_modified VARCHAR(100),
        timestamp DATETIME,
        table_name VARCHAR(255),
        apn_id INTEGER,
        subscriber_routing_id INTEGER,
        serving_apn_id INTEGER,
        auc_id INTEGER,
        subscriber_id INTEGER,
        ims_subscriber_id INTEGER,
        charging_rule_id INTEGER,
        tft_id INTEGER,
        eir_id INTEGER,
        imsi_imei_history_id INTEGER,
        subscriber_attributes_id INTEGER,
        PRIMARY KEY (id),
        FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
        FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
        FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
        FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
        FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
        FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
        FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
        FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
        FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
        FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
        FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)

]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2024-04-17 11:08:26,395 INFO sqlalchemy.engine.Engine ROLLBACK
2024-04-17 11:08:26,397 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-04-17 11:08:26,399 INFO sqlalchemy.engine.Engine
CREATE TABLE operation_log (
        id INTEGER NOT NULL AUTO_INCREMENT,
        item_id INTEGER NOT NULL,
        operation_id VARCHAR(36) NOT NULL,
        operation VARCHAR(10),
        changes TEXT,
        last_modified VARCHAR(100),
        timestamp DATETIME,
        table_name VARCHAR(255),
        apn_id INTEGER,
        subscriber_routing_id INTEGER,
        serving_apn_id INTEGER,
        auc_id INTEGER,
        subscriber_id INTEGER,
        ims_subscriber_id INTEGER,
        charging_rule_id INTEGER,
        tft_id INTEGER,
        eir_id INTEGER,
        imsi_imei_history_id INTEGER,
        subscriber_attributes_id INTEGER,
        PRIMARY KEY (id),
        FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
        FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
        FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
        FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
        FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
        FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
        FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
        FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
        FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
        FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
        FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)


2024-04-17 11:08:26,399 INFO sqlalchemy.engine.Engine [no key 0.00020s] ()
2024-04-17 11:08:26,405 INFO sqlalchemy.engine.Engine ROLLBACK
/pyhss/database.py:1109: SyntaxWarning: "is not" with a literal. Did you mean "!="?
  if page_size is not 0:
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
    _mysql.connection.query(self, query)
MySQLdb.OperationalError: (1824, "Failed to open the referenced table 'subscriber_routing'")

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

Traceback (most recent call last):
  File "hss.py", line 16, in <module>
    import diameter as DiameterLib
  File "/pyhss/diameter.py", line 29, in <module>
    import database
  File "/pyhss/database.py", line 404, in <module>
    Base.metadata.tables[table_name].create(bind=engine)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/schema.py", line 1149, in create
    bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 3226, in _run_ddl_visitor
    conn._run_ddl_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2430, in _run_ddl_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 670, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 958, in visit_table
    CreateTable(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 315, in _invoke_with
    return bind.execute(self)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1414, in execute
    return meth(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 181, in _execute_on_connection
    return connection._execute_ddl(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1526, in _execute_ddl
    ret = self._execute_context(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2326, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1824, "Failed to open the referenced table 'subscriber_routing'")
[SQL:
CREATE TABLE operation_log (
        id INTEGER NOT NULL AUTO_INCREMENT,
        item_id INTEGER NOT NULL,
        operation_id VARCHAR(36) NOT NULL,
        operation VARCHAR(10),
        changes TEXT,
        last_modified VARCHAR(100),
        timestamp DATETIME,
        table_name VARCHAR(255),
        apn_id INTEGER,
        subscriber_routing_id INTEGER,
        serving_apn_id INTEGER,
        auc_id INTEGER,
        subscriber_id INTEGER,
        ims_subscriber_id INTEGER,
        charging_rule_id INTEGER,
        tft_id INTEGER,
        eir_id INTEGER,
        imsi_imei_history_id INTEGER,
        subscriber_attributes_id INTEGER,
        PRIMARY KEY (id),
        FOREIGN KEY(apn_id) REFERENCES apn (apn_id),
        FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id),
        FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id),
        FOREIGN KEY(auc_id) REFERENCES auc (auc_id),
        FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id),
        FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id),
        FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id),
        FOREIGN KEY(tft_id) REFERENCES tft (tft_id),
        FOREIGN KEY(eir_id) REFERENCES eir (eir_id),
        FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id),
        FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
)

]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
root@vince-virtual-machine:~/docker_open5gs#

@energygreek
Copy link

energygreek commented Apr 17, 2024 •
edited
Loading

after manually creatting these tables, it's OK now.

@LuanCavalcanti07
Copy link

Hello, I'm having a similar problem, but with a different table ('serving_apn'), the version I'm using is:
commit 086e9da
and the OS is ubuntu 22;

The log is:

pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | mysql://pyhss:ims_db_pass@172.22.0.17/ims_hss_db?autocommit=true
pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | 2024-06-20 17:45:39,054 INFO sqlalchemy.engine.Engine SELECT DATABASE()
pyhss      | 2024-06-20 17:45:39,054 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,054 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
pyhss      | 2024-06-20 17:45:39,055 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,055 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
pyhss      | 2024-06-20 17:45:39,055 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,055 INFO sqlalchemy.engine.Engine BEGIN (implicit)
pyhss      | 2024-06-20 17:45:39,055 INFO sqlalchemy.engine.Engine SHOW FULL TABLES FROM `ims_hss_db`
pyhss      | 2024-06-20 17:45:39,056 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,060 INFO sqlalchemy.engine.Engine ROLLBACK
pyhss      | 2024-06-20 17:45:39,060 INFO sqlalchemy.engine.Engine BEGIN (implicit)
pyhss      | 2024-06-20 17:45:39,061 INFO sqlalchemy.engine.Engine 
pyhss      | CREATE TABLE operation_log (
pyhss      |    id INTEGER NOT NULL AUTO_INCREMENT, 
pyhss      |    item_id INTEGER NOT NULL, 
pyhss      |    operation_id VARCHAR(36) NOT NULL, 
pyhss      |    operation VARCHAR(10), 
pyhss      |    changes TEXT, 
pyhss      |    last_modified VARCHAR(100), 
pyhss      |    timestamp DATETIME, 
pyhss      |    table_name VARCHAR(255), 
pyhss      |    apn_id INTEGER, 
pyhss      |    subscriber_routing_id INTEGER, 
pyhss      |    serving_apn_id INTEGER, 
pyhss      |    auc_id INTEGER, 
pyhss      |    subscriber_id INTEGER, 
pyhss      |    ims_subscriber_id INTEGER, 
pyhss      |    charging_rule_id INTEGER, 
pyhss      |    tft_id INTEGER, 
pyhss      |    eir_id INTEGER, 
pyhss      |    imsi_imei_history_id INTEGER, 
pyhss      |    subscriber_attributes_id INTEGER, 
pyhss      |    PRIMARY KEY (id), 
pyhss      |    FOREIGN KEY(apn_id) REFERENCES apn (apn_id), 
pyhss      |    FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id), 
pyhss      |    FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id), 
pyhss      |    FOREIGN KEY(auc_id) REFERENCES auc (auc_id), 
pyhss      |    FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id), 
pyhss      |    FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id), 
pyhss      |    FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id), 
pyhss      |    FOREIGN KEY(tft_id) REFERENCES tft (tft_id), 
pyhss      |    FOREIGN KEY(eir_id) REFERENCES eir (eir_id), 
pyhss      |    FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id), 
pyhss      |    FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
pyhss      | )
pyhss      | 
pyhss      | 
pyhss      | 2024-06-20 17:45:39,061 INFO sqlalchemy.engine.Engine [no key 0.00009s] ()
pyhss      | 2024-06-20 17:45:39,065 INFO sqlalchemy.engine.Engine ROLLBACK
pyhss      | /pyhss/database.py:1109: SyntaxWarning: "is not" with a literal. Did you mean "!="?
pyhss      |   if page_size is not 0:
pyhss      | Traceback (most recent call last):
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
pyhss      |     self.dialect.do_execute(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
pyhss      |     cursor.execute(statement, parameters)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
pyhss      |     res = self._query(mogrified_query)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
pyhss      |     db.query(q)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
pyhss      |     _mysql.connection.query(self, query)
pyhss      | MySQLdb.OperationalError: (1824, "Failed to open the referenced table 'serving_apn'")
pyhss      | 
pyhss      | The above exception was the direct cause of the following exception:
pyhss      | 
pyhss      | Traceback (most recent call last):
pyhss      |   File "hss.py", line 16, in <module>
pyhss      |     import diameter as DiameterLib
pyhss      |   File "/pyhss/diameter.py", line 29, in <module>
pyhss      |     import database
pyhss      |   File "/pyhss/database.py", line 404, in <module>
pyhss      |     Base.metadata.tables[table_name].create(bind=engine)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/schema.py", line 1149, in create
pyhss      |     bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 3226, in _run_ddl_visitor
pyhss      |     conn._run_ddl_visitor(visitorcallable, element, **kwargs)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2430, in _run_ddl_visitor
pyhss      |     visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 670, in traverse_single
pyhss      |     return meth(obj, **kw)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 958, in visit_table
pyhss      |     CreateTable(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 315, in _invoke_with
pyhss      |     return bind.execute(self)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1414, in execute
pyhss      |     return meth(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 181, in _execute_on_connection
pyhss      |     return connection._execute_ddl(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1526, in _execute_ddl
pyhss      |     ret = self._execute_context(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
pyhss      |     return self._exec_single_context(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
pyhss      |     self._handle_dbapi_exception(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2326, in _handle_dbapi_exception
pyhss      |     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
pyhss      |     self.dialect.do_execute(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
pyhss      |     cursor.execute(statement, parameters)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
pyhss      |     res = self._query(mogrified_query)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
pyhss      |     db.query(q)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
pyhss      |     _mysql.connection.query(self, query)
pyhss      | sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1824, "Failed to open the referenced table 'serving_apn'")
pyhss      | [SQL: 
pyhss      | CREATE TABLE operation_log (
pyhss      |    id INTEGER NOT NULL AUTO_INCREMENT, 
pyhss      |    item_id INTEGER NOT NULL, 
pyhss      |    operation_id VARCHAR(36) NOT NULL, 
pyhss      |    operation VARCHAR(10), 
pyhss      |    changes TEXT, 
pyhss      |    last_modified VARCHAR(100), 
pyhss      |    timestamp DATETIME, 
pyhss      |    table_name VARCHAR(255), 
pyhss      |    apn_id INTEGER, 
pyhss      |    subscriber_routing_id INTEGER, 
pyhss      |    serving_apn_id INTEGER, 
pyhss      |    auc_id INTEGER, 
pyhss      |    subscriber_id INTEGER, 
pyhss      |    ims_subscriber_id INTEGER, 
pyhss      |    charging_rule_id INTEGER, 
pyhss      |    tft_id INTEGER, 
pyhss      |    eir_id INTEGER, 
pyhss      |    imsi_imei_history_id INTEGER, 
pyhss      |    subscriber_attributes_id INTEGER, 
pyhss      |    PRIMARY KEY (id), 
pyhss      |    FOREIGN KEY(apn_id) REFERENCES apn (apn_id), 
pyhss      |    FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id), 
pyhss      |    FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id), 
pyhss      |    FOREIGN KEY(auc_id) REFERENCES auc (auc_id), 
pyhss      |    FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id), 
pyhss      |    FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id), 
pyhss      |    FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id), 
pyhss      |    FOREIGN KEY(tft_id) REFERENCES tft (tft_id), 
pyhss      |    FOREIGN KEY(eir_id) REFERENCES eir (eir_id), 
pyhss      |    FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id), 
pyhss      |    FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
pyhss      | )
pyhss      | 
pyhss      | ]
pyhss      | (Background on this error at: https://sqlalche.me/e/20/e3q8)
pyhss      | mysql://pyhss:ims_db_pass@172.22.0.17/ims_hss_db?autocommit=true
pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | Instantiating LogTool with Kwargs dict_items([])
pyhss      | 2024-06-20 17:45:39,126 INFO sqlalchemy.engine.Engine SELECT DATABASE()
pyhss      | 2024-06-20 17:45:39,127 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,127 INFO sqlalchemy.engine.Engine SELECT @@sql_mode
pyhss      | 2024-06-20 17:45:39,127 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,127 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names
pyhss      | 2024-06-20 17:45:39,127 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,128 INFO sqlalchemy.engine.Engine BEGIN (implicit)
pyhss      | 2024-06-20 17:45:39,128 INFO sqlalchemy.engine.Engine SHOW FULL TABLES FROM `ims_hss_db`
pyhss      | 2024-06-20 17:45:39,128 INFO sqlalchemy.engine.Engine [raw sql] ()
pyhss      | 2024-06-20 17:45:39,131 INFO sqlalchemy.engine.Engine ROLLBACK
pyhss      | 2024-06-20 17:45:39,131 INFO sqlalchemy.engine.Engine BEGIN (implicit)
pyhss      | 2024-06-20 17:45:39,133 INFO sqlalchemy.engine.Engine 
pyhss      | CREATE TABLE operation_log (
pyhss      |    id INTEGER NOT NULL AUTO_INCREMENT, 
pyhss      |    item_id INTEGER NOT NULL, 
pyhss      |    operation_id VARCHAR(36) NOT NULL, 
pyhss      |    operation VARCHAR(10), 
pyhss      |    changes TEXT, 
pyhss      |    last_modified VARCHAR(100), 
pyhss      |    timestamp DATETIME, 
pyhss      |    table_name VARCHAR(255), 
pyhss      |    apn_id INTEGER, 
pyhss      |    subscriber_routing_id INTEGER, 
pyhss      |    serving_apn_id INTEGER, 
pyhss      |    auc_id INTEGER, 
pyhss      |    subscriber_id INTEGER, 
pyhss      |    ims_subscriber_id INTEGER, 
pyhss      |    charging_rule_id INTEGER, 
pyhss      |    tft_id INTEGER, 
pyhss      |    eir_id INTEGER, 
pyhss      |    imsi_imei_history_id INTEGER, 
pyhss      |    subscriber_attributes_id INTEGER, 
pyhss      |    PRIMARY KEY (id), 
pyhss      |    FOREIGN KEY(apn_id) REFERENCES apn (apn_id), 
pyhss      |    FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id), 
pyhss      |    FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id), 
pyhss      |    FOREIGN KEY(auc_id) REFERENCES auc (auc_id), 
pyhss      |    FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id), 
pyhss      |    FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id), 
pyhss      |    FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id), 
pyhss      |    FOREIGN KEY(tft_id) REFERENCES tft (tft_id), 
pyhss      |    FOREIGN KEY(eir_id) REFERENCES eir (eir_id), 
pyhss      |    FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id), 
pyhss      |    FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
pyhss      | )
pyhss      | 
pyhss      | 
pyhss      | 2024-06-20 17:45:39,133 INFO sqlalchemy.engine.Engine [no key 0.00008s] ()
pyhss      | 2024-06-20 17:45:39,136 INFO sqlalchemy.engine.Engine ROLLBACK
pyhss      | Traceback (most recent call last):
pyhss      |   File "/usr/local/bin/flask", line 8, in <module>
pyhss      |     sys.exit(main())
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 1050, in main
pyhss      |     cli.main()
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1078, in main
pyhss      |     rv = self.invoke(ctx)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1688, in invoke
pyhss      |     return _process_result(sub_ctx.command.invoke(sub_ctx))
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 1434, in invoke
pyhss      |     return ctx.invoke(self.callback, **ctx.params)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 783, in invoke
pyhss      |     return __callback(*args, **kwargs)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/click/decorators.py", line 92, in new_func
pyhss      |     return ctx.invoke(f, obj, *args, **kwargs)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/click/core.py", line 783, in invoke
pyhss      |     return __callback(*args, **kwargs)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 911, in run_command
pyhss      |     raise e from None
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 897, in run_command
pyhss      |     app = info.load_app()
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 308, in load_app
pyhss      |     app = locate_app(import_name, name)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 218, in locate_app
pyhss      |     __import__(module_name)
pyhss      |   File "/pyhss/PyHSS_API.py", line 27, in <module>
pyhss      |     import database
pyhss      |   File "/pyhss/database.py", line 404, in <module>
pyhss      |     Base.metadata.tables[table_name].create(bind=engine)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/schema.py", line 1149, in create
pyhss      |     bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 3226, in _run_ddl_visitor
pyhss      |     conn._run_ddl_visitor(visitorcallable, element, **kwargs)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2430, in _run_ddl_visitor
pyhss      |     visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 670, in traverse_single
pyhss      |     return meth(obj, **kw)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 958, in visit_table
pyhss      |     CreateTable(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 315, in _invoke_with
pyhss      |     return bind.execute(self)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1414, in execute
pyhss      |     return meth(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 181, in _execute_on_connection
pyhss      |     return connection._execute_ddl(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1526, in _execute_ddl
pyhss      |     ret = self._execute_context(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
pyhss      |     return self._exec_single_context(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
pyhss      |     self._handle_dbapi_exception(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2326, in _handle_dbapi_exception
pyhss      |     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
pyhss      |     self.dialect.do_execute(
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 748, in do_execute
pyhss      |     cursor.execute(statement, parameters)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 179, in execute
pyhss      |     res = self._query(mogrified_query)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 330, in _query
pyhss      |     db.query(q)
pyhss      |   File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 261, in query
pyhss      |     _mysql.connection.query(self, query)
pyhss      | sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1824, "Failed to open the referenced table 'serving_apn'")
pyhss      | [SQL: 
pyhss      | CREATE TABLE operation_log (
pyhss      |    id INTEGER NOT NULL AUTO_INCREMENT, 
pyhss      |    item_id INTEGER NOT NULL, 
pyhss      |    operation_id VARCHAR(36) NOT NULL, 
pyhss      |    operation VARCHAR(10), 
pyhss      |    changes TEXT, 
pyhss      |    last_modified VARCHAR(100), 
pyhss      |    timestamp DATETIME, 
pyhss      |    table_name VARCHAR(255), 
pyhss      |    apn_id INTEGER, 
pyhss      |    subscriber_routing_id INTEGER, 
pyhss      |    serving_apn_id INTEGER, 
pyhss      |    auc_id INTEGER, 
pyhss      |    subscriber_id INTEGER, 
pyhss      |    ims_subscriber_id INTEGER, 
pyhss      |    charging_rule_id INTEGER, 
pyhss      |    tft_id INTEGER, 
pyhss      |    eir_id INTEGER, 
pyhss      |    imsi_imei_history_id INTEGER, 
pyhss      |    subscriber_attributes_id INTEGER, 
pyhss      |    PRIMARY KEY (id), 
pyhss      |    FOREIGN KEY(apn_id) REFERENCES apn (apn_id), 
pyhss      |    FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id), 
pyhss      |    FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id), 
pyhss      |    FOREIGN KEY(auc_id) REFERENCES auc (auc_id), 
pyhss      |    FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id), 
pyhss      |    FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id), 
pyhss      |    FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id), 
pyhss      |    FOREIGN KEY(tft_id) REFERENCES tft (tft_id), 
pyhss      |    FOREIGN KEY(eir_id) REFERENCES eir (eir_id), 
pyhss      |    FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id), 
pyhss      |    FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id)
pyhss      | )
pyhss      | 
pyhss      | ]
pyhss      | (Background on this error at: https://sqlalche.me/e/20/e3q8)
pyhss exited with code 1

```sh

@herlesupreeth
Copy link
Owner

@LuanCavalcanti07 I would suggest to drop the volume docker_open5gs_dbdata as follows and bring up all services again

docker volume rm docker_open5gs_dbdata

NOTE: Before you execute the above command you need to do docker compose -f <deployment-file-name> down

@LuanCavalcanti07
Copy link

Thank you very much, it helped me a lot!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@herlesupreeth @MAlexVR @platini2 @energygreek @modyngs @LuanCavalcanti07