Comments (7)
energygreek
commented on June 24, 2024
1
after manually creatting these tables, it's OK now.
from docker_open5gs.
herlesupreeth
commented on June 24, 2024
Please send me the output of docker logs pyhss
from docker_open5gs.
modyngs
commented on June 24, 2024
@MAlexVR restart all the docker components!
docker compose down
docker compose Up
from docker_open5gs.
platini2
commented on June 24, 2024
Sometimes you need to restart pyhss in the first start as it fails to come up.
from docker_open5gs.
MAlexVR
commented on June 24, 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:[email protected]/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:[email protected]/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#
from docker_open5gs.
herlesupreeth
commented on June 24, 2024
@MAlexVR was your issue resolved? If not, are you sure you are using latest commits from this repo and didnt do any modifications?
from docker_open5gs.
energygreek
commented on June 24, 2024
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:[email protected]/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:[email protected]/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#
from docker_open5gs.
Related Issues (20)
- Initial Registration failed [PLMN_NOT_ALLOWED] HOT 11
- Failed to setup/configure GW interface HOT 30
- Does open5gs-hss support sms over ims? HOT 11
- VoNR SCSCF forwarding INVITE message with wrong request-uri HOT 4
- VoLTE don't work HOT 15
- IMS Registration with Samsung devices HOT 6
- IMS registration and network deploy HOT 5
- VoNR Rx interface HOT 1
- MME not responding to Create Bearer Request after device wake up HOT 3
- PCSCF blocking with latest configs HOT 4
- Add multiple user on open5gs without using WebUI HOT 2
- Does the SMSC module support sending emojis? HOT 5
- VoLTE_UEs HOT 3
- CoIMS sim card config has no effect HOT 6
- using latest rtpengine for hss-cx branch HOT 1
- VONR : SIP REGISTERING : 403 Forbidden - HSS User Unknown HOT 19
- VOLTE, INVITE create 408 Request Timeout HOT 14
- VOLTE: Unable to establish calls between two UEs using new PCSCF HOT 4
- Config for 30Mhz bw on 5G in gnb.yml HOT 5
- ./kamailio: Operation not permitted HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from docker_open5gs.