1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
/*
* $Id: db_utils.c,v 1.1.1.1 2005/06/13 16:47:43 bogdan_iancu Exp $
*
* POSTGRES module, portions of this code were templated using
* the mysql module, thus it's similarity.
*
* Copyright (C) 2003 August.Net Services, LLC
*
* This file is part of openser, a free SIP server.
*
* openser is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version
*
* openser is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* ---
*
* History
* -------
* 2003-04-06 initial code written (Greg Fausak/Andy Fullford)
*
*/
#define _GNU_SOURCE /* To avoid strptime warning */
#include <string.h>
#include <time.h>
#include "db_utils.h"
#include "defs.h"
char* trim(char* _s);
/*
* SQL URL parser
*/
int parse_sql_url(char* _url, char** _user, char** _pass,
char** _host, char** _port, char** _db)
{
char* slash, *dcolon, *at, *db_slash;
*_user = '\0';
*_pass = '\0';
*_host = '\0';
*_port = '\0';
*_db = '\0';
/* Remove any leading and trailing spaces and tab */
_url = trim(_url);
if (strlen(_url) < 6) return -1;
if (*_url == '\0') return -2; /* Empty string */
slash = strchr(_url, '/');
if (!slash) return -3; /* Invalid string, slashes not found */
if ((*(++slash)) != '/') { /* Invalid URL, 2nd slash not found */
return -4;
}
slash++;
at = strchr(slash, '@');
db_slash = strrchr(slash, '/');
if (db_slash <= at)
db_slash = NULL;
if (db_slash) {
*db_slash++ = '\0';
*_db = trim(db_slash);
}
if (!at) {
dcolon = strchr(slash, ':');
if (dcolon) {
*dcolon++ = '\0';
*_port = trim(dcolon);
}
*_host = trim(slash);
} else {
dcolon = strchr(slash, ':');
*at++ = '\0';
if (dcolon) {
*dcolon++ = '\0';
if (dcolon < at) { /* user:passwd */
*_pass = trim(dcolon);
dcolon = strchr(at, ':');
if (dcolon) { /* host:port */
*dcolon++ = '\0';
*_port = trim(dcolon);
}
} else { /* host:port */
*_port = trim(dcolon);
}
}
*_host = trim(at);
*_user = trim(slash);
}
return 0;
}
/*
* Remove any tabs and spaces from the beginning and the end of
* a string
*/
char* trim(char* _s)
{
int len;
char* end;
/* Null pointer, there is nothing to do */
if (!_s) return _s;
/* Remove spaces and tabs from the beginning of string */
while ((*_s == ' ') || (*_s == '\t')) _s++;
len = strlen(_s);
end = _s + len - 1;
/* Remove trailing spaces and tabs */
while ((*end == ' ') || (*end == '\t')) end--;
if (end != (_s + len - 1)) {
*(end+1) = '\0';
}
return _s;
}
|
