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

[BUG]db_mysql connect failed #3516

Open
gao114882 opened this issue Nov 15, 2024 · 1 comment
Open

[BUG]db_mysql connect failed #3516

gao114882 opened this issue Nov 15, 2024 · 1 comment

Comments

@gao114882
Copy link

OpenSIPS version you are running

./opensips -V        
version: opensips 3.3.10 (x86_64/linux)
flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, HP_MALLOC, DBG_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll, sigio_rt, select.
main.c compiled on 06:05:46 Nov 15 2024 with gcc 4.8.5

Describe the bug

mysql host：172.16.4.111
port: 3306
userName: martbase@gtja_smartcc#obcluster
password: Smartbase7890

Can we support this format？

db_url: mysql://martbase@gtja_smartcc#obcluster:[email protected]:3306/opensips

error:

core:str2s: unexpected char S in [email protected]:3306
Nov 15 14:47:46 [108] DBG:core:db_do_init: connection 0x7efd3cf84508 not found in pool
Nov 15 14:47:46 [108] DBG:db_mysql:db_mysql_connect: opening connection: mysql://xxxx:xxxx@gtja_smartcc#obcluster/sbc
Nov 15 14:47:46 [108] ERROR:db_mysql:db_mysql_connect: driver error(2005): Unknown MySQL server host 'gtja_smartcc#obcluster' (2)
Nov 15 14:47:46 [108] ERROR:db_mysql:db_mysql_new_connection: initial connect failed
Nov 15 14:47:46 [108] ERROR:core:db_do_init: could not add connection to the pool
Nov 15 14:47:46 [108] ERROR:usrloc:destroy: failed to connect to database

To Reproduce

Expected behavior

Relevant System Logs

OS/environment information

  • Operating System:
  • OpenSIPS installation:
  • other relevant information:

Additional context
@gao114882
Copy link
Author

Kamailio 5.7 can parse this URL correctly,

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
1 participant
@gao114882