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.

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

[BUG]db_mysql connect failed #3516

Open
gao114882 opened this issue Nov 15, 2024 · 6 comments
Open

[BUG]db_mysql connect failed #3516

gao114882 opened this issue Nov 15, 2024 · 6 comments

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,

@gao114882
Copy link
Author

I fixed this bug, but I don't have permission to create branches or push requests.

Copy link

github-actions bot commented Dec 5, 2024

Any updates here? No progress has been made in the last 15 days, marking as stale. Will close this issue if no further updates are made in the next 30 days.

@github-actions github-actions bot added the stale label Dec 5, 2024
@gao114882
Copy link
Author

1

@stale stale bot removed the stale label Dec 9, 2024
Copy link

Any updates here? No progress has been made in the last 15 days, marking as stale. Will close this issue if no further updates are made in the next 30 days.

@github-actions github-actions bot added the stale label Dec 24, 2024
@gao114882
Copy link
Author

1

@github-actions github-actions bot removed the stale label Dec 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant