1 /*
2 ** 2006 June 7
3 **
4 ** The author disclaims copyright to this source code. In place of
5 ** a legal notice, here is a blessing:
6 **
7 ** May you do good and not evil.
8 ** May you find forgiveness for yourself and forgive others.
9 ** May you share freely, never taking more than you give.
10 **
11 *************************************************************************
12 ** This file contains code used to dynamically load extensions into
13 ** the SQLite library.
14 */
15
16 #ifndef SQLITE_CORE
17 #define SQLITE_CORE 1 /* Disable the API redefinition in sqlite3ext.h */
18 #endif
19 #include "sqlite3ext.h"
20 #include "sqliteInt.h"
21
22 #ifndef SQLITE_OMIT_LOAD_EXTENSION
23 /*
24 ** Some API routines are omitted when various features are
25 ** excluded from a build of SQLite. Substitute a NULL pointer
26 ** for any missing APIs.
27 */
28 #ifndef SQLITE_ENABLE_COLUMN_METADATA
29 # define sqlite3_column_database_name 0
30 # define sqlite3_column_database_name16 0
31 # define sqlite3_column_table_name 0
32 # define sqlite3_column_table_name16 0
33 # define sqlite3_column_origin_name 0
34 # define sqlite3_column_origin_name16 0
35 #endif
36
37 #ifdef SQLITE_OMIT_AUTHORIZATION
38 # define sqlite3_set_authorizer 0
39 #endif
40
41 #ifdef SQLITE_OMIT_UTF16
42 # define sqlite3_bind_text16 0
43 # define sqlite3_collation_needed16 0
44 # define sqlite3_column_decltype16 0
45 # define sqlite3_column_name16 0
46 # define sqlite3_column_text16 0
47 # define sqlite3_complete16 0
48 # define sqlite3_create_collation16 0
49 # define sqlite3_create_function16 0
50 # define sqlite3_errmsg16 0
51 # define sqlite3_open16 0
52 # define sqlite3_prepare16 0
53 # define sqlite3_prepare16_v2 0
54 # define sqlite3_prepare16_v3 0
55 # define sqlite3_result_error16 0
56 # define sqlite3_result_text16 0
57 # define sqlite3_result_text16be 0
58 # define sqlite3_result_text16le 0
59 # define sqlite3_value_text16 0
60 # define sqlite3_value_text16be 0
61 # define sqlite3_value_text16le 0
62 # define sqlite3_column_database_name16 0
63 # define sqlite3_column_table_name16 0
64 # define sqlite3_column_origin_name16 0
65 #endif
66
67 #ifdef SQLITE_OMIT_COMPLETE
68 # define sqlite3_complete 0
69 # define sqlite3_complete16 0
70 #endif
71
72 #ifdef SQLITE_OMIT_DECLTYPE
73 # define sqlite3_column_decltype16 0
74 # define sqlite3_column_decltype 0
75 #endif
76
77 #ifdef SQLITE_OMIT_PROGRESS_CALLBACK
78 # define sqlite3_progress_handler 0
79 #endif
80
81 #ifdef SQLITE_OMIT_VIRTUALTABLE
82 # define sqlite3_create_module 0
83 # define sqlite3_create_module_v2 0
84 # define sqlite3_declare_vtab 0
85 # define sqlite3_vtab_config 0
86 # define sqlite3_vtab_on_conflict 0
87 # define sqlite3_vtab_collation 0
88 #endif
89
90 #ifdef SQLITE_OMIT_SHARED_CACHE
91 # define sqlite3_enable_shared_cache 0
92 #endif
93
94 #if defined(SQLITE_OMIT_TRACE) || defined(SQLITE_OMIT_DEPRECATED)
95 # define sqlite3_profile 0
96 # define sqlite3_trace 0
97 #endif
98
99 #ifdef SQLITE_OMIT_GET_TABLE
100 # define sqlite3_free_table 0
101 # define sqlite3_get_table 0
102 #endif
103
104 #ifdef SQLITE_OMIT_INCRBLOB
105 #define sqlite3_bind_zeroblob 0
106 #define sqlite3_blob_bytes 0
107 #define sqlite3_blob_close 0
108 #define sqlite3_blob_open 0
109 #define sqlite3_blob_read 0
110 #define sqlite3_blob_write 0
111 #define sqlite3_blob_reopen 0
112 #endif
113
114 #if defined(SQLITE_OMIT_TRACE)
115 # define sqlite3_trace_v2 0
116 #endif
117
118 /*
119 ** The following structure contains pointers to all SQLite API routines.
120 ** A pointer to this structure is passed into extensions when they are
121 ** loaded so that the extension can make calls back into the SQLite
122 ** library.
123 **
124 ** When adding new APIs, add them to the bottom of this structure
125 ** in order to preserve backwards compatibility.
126 **
127 ** Extensions that use newer APIs should first call the
128 ** sqlite3_libversion_number() to make sure that the API they
129 ** intend to use is supported by the library. Extensions should
130 ** also check to make sure that the pointer to the function is
131 ** not NULL before calling it.
132 */
133 static const sqlite3_api_routines sqlite3Apis = {
134 sqlite3_aggregate_context,
135 #ifndef SQLITE_OMIT_DEPRECATED
136 sqlite3_aggregate_count,
137 #else
138 0,
139 #endif
140 sqlite3_bind_blob,
141 sqlite3_bind_double,
142 sqlite3_bind_int,
143 sqlite3_bind_int64,
144 sqlite3_bind_null,
145 sqlite3_bind_parameter_count,
146 sqlite3_bind_parameter_index,
147 sqlite3_bind_parameter_name,
148 sqlite3_bind_text,
149 sqlite3_bind_text16,
150 sqlite3_bind_value,
151 sqlite3_busy_handler,
152 sqlite3_busy_timeout,
153 sqlite3_changes,
154 sqlite3_close,
155 sqlite3_collation_needed,
156 sqlite3_collation_needed16,
157 sqlite3_column_blob,
158 sqlite3_column_bytes,
159 sqlite3_column_bytes16,
160 sqlite3_column_count,
161 sqlite3_column_database_name,
162 sqlite3_column_database_name16,
163 sqlite3_column_decltype,
164 sqlite3_column_decltype16,
165 sqlite3_column_double,
166 sqlite3_column_int,
167 sqlite3_column_int64,
168 sqlite3_column_name,
169 sqlite3_column_name16,
170 sqlite3_column_origin_name,
171 sqlite3_column_origin_name16,
172 sqlite3_column_table_name,
173 sqlite3_column_table_name16,
174 sqlite3_column_text,
175 sqlite3_column_text16,
176 sqlite3_column_type,
177 sqlite3_column_value,
178 sqlite3_commit_hook,
179 sqlite3_complete,
180 sqlite3_complete16,
181 sqlite3_create_collation,
182 sqlite3_create_collation16,
183 sqlite3_create_function,
184 sqlite3_create_function16,
185 sqlite3_create_module,
186 sqlite3_data_count,
187 sqlite3_db_handle,
188 sqlite3_declare_vtab,
189 sqlite3_enable_shared_cache,
190 sqlite3_errcode,
191 sqlite3_errmsg,
192 sqlite3_errmsg16,
193 sqlite3_exec,
194 #ifndef SQLITE_OMIT_DEPRECATED
195 sqlite3_expired,
196 #else
197 0,
198 #endif
199 sqlite3_finalize,
200 sqlite3_free,
201 sqlite3_free_table,
202 sqlite3_get_autocommit,
203 sqlite3_get_auxdata,
204 sqlite3_get_table,
205 0, /* Was sqlite3_global_recover(), but that function is deprecated */
206 sqlite3_interrupt,
207 sqlite3_last_insert_rowid,
208 sqlite3_libversion,
209 sqlite3_libversion_number,
210 sqlite3_malloc,
211 sqlite3_mprintf,
212 sqlite3_open,
213 sqlite3_open16,
214 sqlite3_prepare,
215 sqlite3_prepare16,
216 sqlite3_profile,
217 sqlite3_progress_handler,
218 sqlite3_realloc,
219 sqlite3_reset,
220 sqlite3_result_blob,
221 sqlite3_result_double,
222 sqlite3_result_error,
223 sqlite3_result_error16,
224 sqlite3_result_int,
225 sqlite3_result_int64,
226 sqlite3_result_null,
227 sqlite3_result_text,
228 sqlite3_result_text16,
229 sqlite3_result_text16be,
230 sqlite3_result_text16le,
231 sqlite3_result_value,
232 sqlite3_rollback_hook,
233 sqlite3_set_authorizer,
234 sqlite3_set_auxdata,
235 sqlite3_snprintf,
236 sqlite3_step,
237 sqlite3_table_column_metadata,
238 #ifndef SQLITE_OMIT_DEPRECATED
239 sqlite3_thread_cleanup,
240 #else
241 0,
242 #endif
243 sqlite3_total_changes,
244 sqlite3_trace,
245 #ifndef SQLITE_OMIT_DEPRECATED
246 sqlite3_transfer_bindings,
247 #else
248 0,
249 #endif
250 sqlite3_update_hook,
251 sqlite3_user_data,
252 sqlite3_value_blob,
253 sqlite3_value_bytes,
254 sqlite3_value_bytes16,
255 sqlite3_value_double,
256 sqlite3_value_int,
257 sqlite3_value_int64,
258 sqlite3_value_numeric_type,
259 sqlite3_value_text,
260 sqlite3_value_text16,
261 sqlite3_value_text16be,
262 sqlite3_value_text16le,
263 sqlite3_value_type,
264 sqlite3_vmprintf,
265 /*
266 ** The original API set ends here. All extensions can call any
267 ** of the APIs above provided that the pointer is not NULL. But
268 ** before calling APIs that follow, extension should check the
269 ** sqlite3_libversion_number() to make sure they are dealing with
270 ** a library that is new enough to support that API.
271 *************************************************************************
272 */
273 sqlite3_overload_function,
274
275 /*
276 ** Added after 3.3.13
277 */
278 sqlite3_prepare_v2,
279 sqlite3_prepare16_v2,
280 sqlite3_clear_bindings,
281
282 /*
283 ** Added for 3.4.1
284 */
285 sqlite3_create_module_v2,
286
287 /*
288 ** Added for 3.5.0
289 */
290 sqlite3_bind_zeroblob,
291 sqlite3_blob_bytes,
292 sqlite3_blob_close,
293 sqlite3_blob_open,
294 sqlite3_blob_read,
295 sqlite3_blob_write,
296 sqlite3_create_collation_v2,
297 sqlite3_file_control,
298 sqlite3_memory_highwater,
299 sqlite3_memory_used,
300 #ifdef SQLITE_MUTEX_OMIT
301 0,
302 0,
303 0,
304 0,
305 0,
306 #else
307 sqlite3_mutex_alloc,
308 sqlite3_mutex_enter,
309 sqlite3_mutex_free,
310 sqlite3_mutex_leave,
311 sqlite3_mutex_try,
312 #endif
313 sqlite3_open_v2,
314 sqlite3_release_memory,
315 sqlite3_result_error_nomem,
316 sqlite3_result_error_toobig,
317 sqlite3_sleep,
318 sqlite3_soft_heap_limit,
319 sqlite3_vfs_find,
320 sqlite3_vfs_register,
321 sqlite3_vfs_unregister,
322
323 /*
324 ** Added for 3.5.8
325 */
326 sqlite3_threadsafe,
327 sqlite3_result_zeroblob,
328 sqlite3_result_error_code,
329 sqlite3_test_control,
330 sqlite3_randomness,
331 sqlite3_context_db_handle,
332
333 /*
334 ** Added for 3.6.0
335 */
336 sqlite3_extended_result_codes,
337 sqlite3_limit,
338 sqlite3_next_stmt,
339 sqlite3_sql,
340 sqlite3_status,
341
342 /*
343 ** Added for 3.7.4
344 */
345 sqlite3_backup_finish,
346 sqlite3_backup_init,
347 sqlite3_backup_pagecount,
348 sqlite3_backup_remaining,
349 sqlite3_backup_step,
350 #ifndef SQLITE_OMIT_COMPILEOPTION_DIAGS
351 sqlite3_compileoption_get,
352 sqlite3_compileoption_used,
353 #else
354 0,
355 0,
356 #endif
357 sqlite3_create_function_v2,
358 sqlite3_db_config,
359 sqlite3_db_mutex,
360 sqlite3_db_status,
361 sqlite3_extended_errcode,
362 sqlite3_log,
363 sqlite3_soft_heap_limit64,
364 sqlite3_sourceid,
365 sqlite3_stmt_status,
366 sqlite3_strnicmp,
367 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
368 sqlite3_unlock_notify,
369 #else
370 0,
371 #endif
372 #ifndef SQLITE_OMIT_WAL
373 sqlite3_wal_autocheckpoint,
374 sqlite3_wal_checkpoint,
375 sqlite3_wal_hook,
376 #else
377 0,
378 0,
379 0,
380 #endif
381 sqlite3_blob_reopen,
382 sqlite3_vtab_config,
383 sqlite3_vtab_on_conflict,
384 sqlite3_close_v2,
385 sqlite3_db_filename,
386 sqlite3_db_readonly,
387 sqlite3_db_release_memory,
388 sqlite3_errstr,
389 sqlite3_stmt_busy,
390 sqlite3_stmt_readonly,
391 sqlite3_stricmp,
392 sqlite3_uri_boolean,
393 sqlite3_uri_int64,
394 sqlite3_uri_parameter,
395 sqlite3_vsnprintf,
396 sqlite3_wal_checkpoint_v2,
397 /* Version 3.8.7 and later */
398 sqlite3_auto_extension,
399 sqlite3_bind_blob64,
400 sqlite3_bind_text64,
401 sqlite3_cancel_auto_extension,
402 sqlite3_load_extension,
403 sqlite3_malloc64,
404 sqlite3_msize,
405 sqlite3_realloc64,
406 sqlite3_reset_auto_extension,
407 sqlite3_result_blob64,
408 sqlite3_result_text64,
409 sqlite3_strglob,
410 /* Version 3.8.11 and later */
411 (sqlite3_value*(*)(const sqlite3_value*))sqlite3_value_dup,
412 sqlite3_value_free,
413 sqlite3_result_zeroblob64,
414 sqlite3_bind_zeroblob64,
415 /* Version 3.9.0 and later */
416 sqlite3_value_subtype,
417 sqlite3_result_subtype,
418 /* Version 3.10.0 and later */
419 sqlite3_status64,
420 sqlite3_strlike,
421 sqlite3_db_cacheflush,
422 /* Version 3.12.0 and later */
423 sqlite3_system_errno,
424 /* Version 3.14.0 and later */
425 sqlite3_trace_v2,
426 sqlite3_expanded_sql,
427 /* Version 3.18.0 and later */
428 sqlite3_set_last_insert_rowid,
429 /* Version 3.20.0 and later */
430 sqlite3_prepare_v3,
431 sqlite3_prepare16_v3,
432 sqlite3_bind_pointer,
433 sqlite3_result_pointer,
434 sqlite3_value_pointer,
435 /* Version 3.22.0 and later */
436 sqlite3_vtab_nochange,
437 sqlite3_value_nochange,
438 sqlite3_vtab_collation,
439 /* Version 3.24.0 and later */
440 sqlite3_keyword_count,
441 sqlite3_keyword_name,
442 sqlite3_keyword_check,
443 sqlite3_str_new,
444 sqlite3_str_finish,
445 sqlite3_str_appendf,
446 sqlite3_str_vappendf,
447 sqlite3_str_append,
448 sqlite3_str_appendall,
449 sqlite3_str_appendchar,
450 sqlite3_str_reset,
451 sqlite3_str_errcode,
452 sqlite3_str_length,
453 sqlite3_str_value,
454 /* Version 3.25.0 and later */
455 sqlite3_create_window_function,
456 /* Version 3.26.0 and later */
457 #ifdef SQLITE_ENABLE_NORMALIZE
458 sqlite3_normalized_sql,
459 #else
460 0,
461 #endif
462 /* Version 3.28.0 and later */
463 sqlite3_stmt_isexplain,
464 sqlite3_value_frombind,
465 /* Version 3.30.0 and later */
466 #ifndef SQLITE_OMIT_VIRTUALTABLE
467 sqlite3_drop_modules,
468 #else
469 0,
470 #endif
471 /* Version 3.31.0 and later */
472 sqlite3_hard_heap_limit64,
473 sqlite3_uri_key,
474 sqlite3_filename_database,
475 sqlite3_filename_journal,
476 sqlite3_filename_wal,
477 /* Version 3.32.0 and later */
478 sqlite3_create_filename,
479 sqlite3_free_filename,
480 sqlite3_database_file_object,
481 /* Version 3.34.0 and later */
482 sqlite3_txn_state,
483 /* Version 3.36.1 and later */
484 sqlite3_changes64,
485 sqlite3_total_changes64,
486 /* Version 3.37.0 and later */
487 sqlite3_autovacuum_pages,
488 /* Version 3.38.0 and later */
489 sqlite3_error_offset,
490 #ifndef SQLITE_OMIT_VIRTUALTABLE
491 sqlite3_vtab_rhs_value,
492 sqlite3_vtab_distinct,
493 sqlite3_vtab_in,
494 sqlite3_vtab_in_first,
495 sqlite3_vtab_in_next,
496 #else
497 0,
498 0,
499 0,
500 0,
501 0,
502 #endif
503 /* Version 3.39.0 and later */
504 #ifndef SQLITE_OMIT_DESERIALIZE
505 sqlite3_deserialize,
506 sqlite3_serialize,
507 #else
508 0,
509 0,
510 #endif
511 sqlite3_db_name,
512 /* Version 3.40.0 and later */
513 sqlite3_value_type
514 };
515
516 /* True if x is the directory separator character
517 */
518 #if SQLITE_OS_WIN
519 # define DirSep(X) ((X)=='/'||(X)=='\\')
520 #else
521 # define DirSep(X) ((X)=='/')
522 #endif
523
524 /*
525 ** Attempt to load an SQLite extension library contained in the file
526 ** zFile. The entry point is zProc. zProc may be 0 in which case a
527 ** default entry point name (sqlite3_extension_init) is used. Use
528 ** of the default name is recommended.
529 **
530 ** Return SQLITE_OK on success and SQLITE_ERROR if something goes wrong.
531 **
532 ** If an error occurs and pzErrMsg is not 0, then fill *pzErrMsg with
533 ** error message text. The calling function should free this memory
534 ** by calling sqlite3DbFree(db, ).
535 */
sqlite3LoadExtension(sqlite3 * db,const char * zFile,const char * zProc,char ** pzErrMsg)536 static int sqlite3LoadExtension(
537 sqlite3 *db, /* Load the extension into this database connection */
538 const char *zFile, /* Name of the shared library containing extension */
539 const char *zProc, /* Entry point. Use "sqlite3_extension_init" if 0 */
540 char **pzErrMsg /* Put error message here if not 0 */
541 ){
542 sqlite3_vfs *pVfs = db->pVfs;
543 void *handle;
544 sqlite3_loadext_entry xInit;
545 char *zErrmsg = 0;
546 const char *zEntry;
547 char *zAltEntry = 0;
548 void **aHandle;
549 u64 nMsg = strlen(zFile);
550 int ii;
551 int rc;
552
553 /* Shared library endings to try if zFile cannot be loaded as written */
554 static const char *azEndings[] = {
555 #if SQLITE_OS_WIN
556 "dll"
557 #elif defined(__APPLE__)
558 "dylib"
559 #else
560 "so"
561 #endif
562 };
563
564
565 if( pzErrMsg ) *pzErrMsg = 0;
566
567 /* Ticket #1863. To avoid a creating security problems for older
568 ** applications that relink against newer versions of SQLite, the
569 ** ability to run load_extension is turned off by default. One
570 ** must call either sqlite3_enable_load_extension(db) or
571 ** sqlite3_db_config(db, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION, 1, 0)
572 ** to turn on extension loading.
573 */
574 if( (db->flags & SQLITE_LoadExtension)==0 ){
575 if( pzErrMsg ){
576 *pzErrMsg = sqlite3_mprintf("not authorized");
577 }
578 return SQLITE_ERROR;
579 }
580
581 zEntry = zProc ? zProc : "sqlite3_extension_init";
582
583 /* tag-20210611-1. Some dlopen() implementations will segfault if given
584 ** an oversize filename. Most filesystems have a pathname limit of 4K,
585 ** so limit the extension filename length to about twice that.
586 ** https://sqlite.org/forum/forumpost/08a0d6d9bf */
587 if( nMsg>SQLITE_MAX_PATHLEN ) goto extension_not_found;
588
589 handle = sqlite3OsDlOpen(pVfs, zFile);
590 #if SQLITE_OS_UNIX || SQLITE_OS_WIN
591 for(ii=0; ii<ArraySize(azEndings) && handle==0; ii++){
592 char *zAltFile = sqlite3_mprintf("%s.%s", zFile, azEndings[ii]);
593 if( zAltFile==0 ) return SQLITE_NOMEM_BKPT;
594 handle = sqlite3OsDlOpen(pVfs, zAltFile);
595 sqlite3_free(zAltFile);
596 }
597 #endif
598 if( handle==0 ) goto extension_not_found;
599 xInit = (sqlite3_loadext_entry)sqlite3OsDlSym(pVfs, handle, zEntry);
600
601 /* If no entry point was specified and the default legacy
602 ** entry point name "sqlite3_extension_init" was not found, then
603 ** construct an entry point name "sqlite3_X_init" where the X is
604 ** replaced by the lowercase value of every ASCII alphabetic
605 ** character in the filename after the last "/" upto the first ".",
606 ** and eliding the first three characters if they are "lib".
607 ** Examples:
608 **
609 ** /usr/local/lib/libExample5.4.3.so ==> sqlite3_example_init
610 ** C:/lib/mathfuncs.dll ==> sqlite3_mathfuncs_init
611 */
612 if( xInit==0 && zProc==0 ){
613 int iFile, iEntry, c;
614 int ncFile = sqlite3Strlen30(zFile);
615 zAltEntry = sqlite3_malloc64(ncFile+30);
616 if( zAltEntry==0 ){
617 sqlite3OsDlClose(pVfs, handle);
618 return SQLITE_NOMEM_BKPT;
619 }
620 memcpy(zAltEntry, "sqlite3_", 8);
621 for(iFile=ncFile-1; iFile>=0 && !DirSep(zFile[iFile]); iFile--){}
622 iFile++;
623 if( sqlite3_strnicmp(zFile+iFile, "lib", 3)==0 ) iFile += 3;
624 for(iEntry=8; (c = zFile[iFile])!=0 && c!='.'; iFile++){
625 if( sqlite3Isalpha(c) ){
626 zAltEntry[iEntry++] = (char)sqlite3UpperToLower[(unsigned)c];
627 }
628 }
629 memcpy(zAltEntry+iEntry, "_init", 6);
630 zEntry = zAltEntry;
631 xInit = (sqlite3_loadext_entry)sqlite3OsDlSym(pVfs, handle, zEntry);
632 }
633 if( xInit==0 ){
634 if( pzErrMsg ){
635 nMsg += strlen(zEntry) + 300;
636 *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg);
637 if( zErrmsg ){
638 assert( nMsg<0x7fffffff ); /* zErrmsg would be NULL if not so */
639 sqlite3_snprintf((int)nMsg, zErrmsg,
640 "no entry point [%s] in shared library [%s]", zEntry, zFile);
641 sqlite3OsDlError(pVfs, nMsg-1, zErrmsg);
642 }
643 }
644 sqlite3OsDlClose(pVfs, handle);
645 sqlite3_free(zAltEntry);
646 return SQLITE_ERROR;
647 }
648 sqlite3_free(zAltEntry);
649 rc = xInit(db, &zErrmsg, &sqlite3Apis);
650 if( rc ){
651 if( rc==SQLITE_OK_LOAD_PERMANENTLY ) return SQLITE_OK;
652 if( pzErrMsg ){
653 *pzErrMsg = sqlite3_mprintf("error during initialization: %s", zErrmsg);
654 }
655 sqlite3_free(zErrmsg);
656 sqlite3OsDlClose(pVfs, handle);
657 return SQLITE_ERROR;
658 }
659
660 /* Append the new shared library handle to the db->aExtension array. */
661 aHandle = sqlite3DbMallocZero(db, sizeof(handle)*(db->nExtension+1));
662 if( aHandle==0 ){
663 return SQLITE_NOMEM_BKPT;
664 }
665 if( db->nExtension>0 ){
666 memcpy(aHandle, db->aExtension, sizeof(handle)*db->nExtension);
667 }
668 sqlite3DbFree(db, db->aExtension);
669 db->aExtension = aHandle;
670
671 db->aExtension[db->nExtension++] = handle;
672 return SQLITE_OK;
673
674 extension_not_found:
675 if( pzErrMsg ){
676 nMsg += 300;
677 *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg);
678 if( zErrmsg ){
679 assert( nMsg<0x7fffffff ); /* zErrmsg would be NULL if not so */
680 sqlite3_snprintf((int)nMsg, zErrmsg,
681 "unable to open shared library [%.*s]", SQLITE_MAX_PATHLEN, zFile);
682 sqlite3OsDlError(pVfs, nMsg-1, zErrmsg);
683 }
684 }
685 return SQLITE_ERROR;
686 }
sqlite3_load_extension(sqlite3 * db,const char * zFile,const char * zProc,char ** pzErrMsg)687 int sqlite3_load_extension(
688 sqlite3 *db, /* Load the extension into this database connection */
689 const char *zFile, /* Name of the shared library containing extension */
690 const char *zProc, /* Entry point. Use "sqlite3_extension_init" if 0 */
691 char **pzErrMsg /* Put error message here if not 0 */
692 ){
693 int rc;
694 sqlite3_mutex_enter(db->mutex);
695 rc = sqlite3LoadExtension(db, zFile, zProc, pzErrMsg);
696 rc = sqlite3ApiExit(db, rc);
697 sqlite3_mutex_leave(db->mutex);
698 return rc;
699 }
700
701 /*
702 ** Call this routine when the database connection is closing in order
703 ** to clean up loaded extensions
704 */
sqlite3CloseExtensions(sqlite3 * db)705 void sqlite3CloseExtensions(sqlite3 *db){
706 int i;
707 assert( sqlite3_mutex_held(db->mutex) );
708 for(i=0; i<db->nExtension; i++){
709 sqlite3OsDlClose(db->pVfs, db->aExtension[i]);
710 }
711 sqlite3DbFree(db, db->aExtension);
712 }
713
714 /*
715 ** Enable or disable extension loading. Extension loading is disabled by
716 ** default so as not to open security holes in older applications.
717 */
sqlite3_enable_load_extension(sqlite3 * db,int onoff)718 int sqlite3_enable_load_extension(sqlite3 *db, int onoff){
719 sqlite3_mutex_enter(db->mutex);
720 if( onoff ){
721 db->flags |= SQLITE_LoadExtension|SQLITE_LoadExtFunc;
722 }else{
723 db->flags &= ~(u64)(SQLITE_LoadExtension|SQLITE_LoadExtFunc);
724 }
725 sqlite3_mutex_leave(db->mutex);
726 return SQLITE_OK;
727 }
728
729 #endif /* !defined(SQLITE_OMIT_LOAD_EXTENSION) */
730
731 /*
732 ** The following object holds the list of automatically loaded
733 ** extensions.
734 **
735 ** This list is shared across threads. The SQLITE_MUTEX_STATIC_MAIN
736 ** mutex must be held while accessing this list.
737 */
738 typedef struct sqlite3AutoExtList sqlite3AutoExtList;
739 static SQLITE_WSD struct sqlite3AutoExtList {
740 u32 nExt; /* Number of entries in aExt[] */
741 void (**aExt)(void); /* Pointers to the extension init functions */
742 } sqlite3Autoext = { 0, 0 };
743
744 /* The "wsdAutoext" macro will resolve to the autoextension
745 ** state vector. If writable static data is unsupported on the target,
746 ** we have to locate the state vector at run-time. In the more common
747 ** case where writable static data is supported, wsdStat can refer directly
748 ** to the "sqlite3Autoext" state vector declared above.
749 */
750 #ifdef SQLITE_OMIT_WSD
751 # define wsdAutoextInit \
752 sqlite3AutoExtList *x = &GLOBAL(sqlite3AutoExtList,sqlite3Autoext)
753 # define wsdAutoext x[0]
754 #else
755 # define wsdAutoextInit
756 # define wsdAutoext sqlite3Autoext
757 #endif
758
759
760 /*
761 ** Register a statically linked extension that is automatically
762 ** loaded by every new database connection.
763 */
sqlite3_auto_extension(void (* xInit)(void))764 int sqlite3_auto_extension(
765 void (*xInit)(void)
766 ){
767 int rc = SQLITE_OK;
768 #ifndef SQLITE_OMIT_AUTOINIT
769 rc = sqlite3_initialize();
770 if( rc ){
771 return rc;
772 }else
773 #endif
774 {
775 u32 i;
776 #if SQLITE_THREADSAFE
777 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN);
778 #endif
779 wsdAutoextInit;
780 sqlite3_mutex_enter(mutex);
781 for(i=0; i<wsdAutoext.nExt; i++){
782 if( wsdAutoext.aExt[i]==xInit ) break;
783 }
784 if( i==wsdAutoext.nExt ){
785 u64 nByte = (wsdAutoext.nExt+1)*sizeof(wsdAutoext.aExt[0]);
786 void (**aNew)(void);
787 aNew = sqlite3_realloc64(wsdAutoext.aExt, nByte);
788 if( aNew==0 ){
789 rc = SQLITE_NOMEM_BKPT;
790 }else{
791 wsdAutoext.aExt = aNew;
792 wsdAutoext.aExt[wsdAutoext.nExt] = xInit;
793 wsdAutoext.nExt++;
794 }
795 }
796 sqlite3_mutex_leave(mutex);
797 assert( (rc&0xff)==rc );
798 return rc;
799 }
800 }
801
802 /*
803 ** Cancel a prior call to sqlite3_auto_extension. Remove xInit from the
804 ** set of routines that is invoked for each new database connection, if it
805 ** is currently on the list. If xInit is not on the list, then this
806 ** routine is a no-op.
807 **
808 ** Return 1 if xInit was found on the list and removed. Return 0 if xInit
809 ** was not on the list.
810 */
sqlite3_cancel_auto_extension(void (* xInit)(void))811 int sqlite3_cancel_auto_extension(
812 void (*xInit)(void)
813 ){
814 #if SQLITE_THREADSAFE
815 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN);
816 #endif
817 int i;
818 int n = 0;
819 wsdAutoextInit;
820 sqlite3_mutex_enter(mutex);
821 for(i=(int)wsdAutoext.nExt-1; i>=0; i--){
822 if( wsdAutoext.aExt[i]==xInit ){
823 wsdAutoext.nExt--;
824 wsdAutoext.aExt[i] = wsdAutoext.aExt[wsdAutoext.nExt];
825 n++;
826 break;
827 }
828 }
829 sqlite3_mutex_leave(mutex);
830 return n;
831 }
832
833 /*
834 ** Reset the automatic extension loading mechanism.
835 */
sqlite3_reset_auto_extension(void)836 void sqlite3_reset_auto_extension(void){
837 #ifndef SQLITE_OMIT_AUTOINIT
838 if( sqlite3_initialize()==SQLITE_OK )
839 #endif
840 {
841 #if SQLITE_THREADSAFE
842 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN);
843 #endif
844 wsdAutoextInit;
845 sqlite3_mutex_enter(mutex);
846 sqlite3_free(wsdAutoext.aExt);
847 wsdAutoext.aExt = 0;
848 wsdAutoext.nExt = 0;
849 sqlite3_mutex_leave(mutex);
850 }
851 }
852
853 /*
854 ** Load all automatic extensions.
855 **
856 ** If anything goes wrong, set an error in the database connection.
857 */
sqlite3AutoLoadExtensions(sqlite3 * db)858 void sqlite3AutoLoadExtensions(sqlite3 *db){
859 u32 i;
860 int go = 1;
861 int rc;
862 sqlite3_loadext_entry xInit;
863
864 wsdAutoextInit;
865 if( wsdAutoext.nExt==0 ){
866 /* Common case: early out without every having to acquire a mutex */
867 return;
868 }
869 for(i=0; go; i++){
870 char *zErrmsg;
871 #if SQLITE_THREADSAFE
872 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN);
873 #endif
874 #ifdef SQLITE_OMIT_LOAD_EXTENSION
875 const sqlite3_api_routines *pThunk = 0;
876 #else
877 const sqlite3_api_routines *pThunk = &sqlite3Apis;
878 #endif
879 sqlite3_mutex_enter(mutex);
880 if( i>=wsdAutoext.nExt ){
881 xInit = 0;
882 go = 0;
883 }else{
884 xInit = (sqlite3_loadext_entry)wsdAutoext.aExt[i];
885 }
886 sqlite3_mutex_leave(mutex);
887 zErrmsg = 0;
888 if( xInit && (rc = xInit(db, &zErrmsg, pThunk))!=0 ){
889 sqlite3ErrorWithMsg(db, rc,
890 "automatic extension loading failed: %s", zErrmsg);
891 go = 0;
892 }
893 sqlite3_free(zErrmsg);
894 }
895 }
896