- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Mysql link error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:34 AM
тАО03-17-2008 08:34 AM
I ve got an option file sql.opt:
MYSQL051_ROOT:[000000.VMS.LIB]MYSQLCLIENT_MIXED.OLB/lib
MYSQL051_ROOT:[000000.VMS.LIB]LIBZ_SHR32.exe/share
DKA0:[VMS$COMMON.SYSLIB]SSL$LIBSSL_SHR32/share
DKA0:[VMS$COMMON.SYSLIB]SSL$LIBCRYPTO_SHR32/share
and a compile/link program:
$ cc/float=ieee/iee=denorm/name=(as_is, trunc) -
/INCLUDE=SYS$COMMON:[000000.MYSQL051.INCLUDE]mysql testmysql
$ link testmysql, -
INA_DISK:[INA.PROGS.DK]sql/opt, -
MYSQL051_ROOT:[000000.VMS.LIB]MYSQLCLIENT_MIXED/lib
but when I try to run the compile/link program, some undefined symbols are detected:
ina > @linkmysql
%ILINK-W-NUDFSYMS, 2 undefined symbols:
%ILINK-I-UDFSYM, my_time
%ILINK-I-UDFSYM, thd_lib_detected
%ILINK-W-USEUNDEF, undefined symbol my_time referenced
section: $CODE$
offset: %X0000000000000270 slot: 2
module: client
file: MYSQL051_ROOT:[000000.VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
%ILINK-W-USEUNDEF, undefined symbol my_time referenced
section: $CODE$
offset: %X00000000000002F0 slot: 2
module: client
file: MYSQL051_ROOT:[000000.VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
%ILINK-W-USEUNDEF, undefined symbol thd_lib_detected referenced
section: $CODE$
offset: %X0000000000000000 slot: 1
module: my_thr_init
file: MYSQL051_ROOT:[000000.VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
%ILINK-W-USEUNDEF, undefined symbol thd_lib_detected referenced
section: $CODE$
offset: %X0000000000000010 slot: 1
module: my_thr_init
file: MYSQL051_ROOT:[000000.VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
but my_time should be included in the mysqlclient_mixed.olb.
Any ideas how I can solve this problem?
Thanks in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 09:06 AM
тАО03-17-2008 09:06 AM
Re: Mysql link error
I'd guess that the dependency isn't found until after the OLB has been processed.
And an OLB? I'll assume there's a reason JFP used that approach and not a shareable image version of that code.
As for options (and off the top), I might well try the following:
$ link testmysql, -
MYSQLCLIENT_MIXED/lib, -
sql/opt
and try:
$ link testmysql, -
sql/opt, -
MYSQLCLIENT_MIXED/lib, -
MYSQLCLIENT_MIXED/lib
--
And MYSQL051_ROOT:[000000.VMS.LIB]?
if that's a real rooted logical name, try:
MYSQL051_ROOT:[VMS.LIB]
Do also look for a logical that specifically references the VMS Library area.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 09:15 AM
тАО03-17-2008 09:15 AM
Re: Mysql link error
>>>
And MYSQL051_ROOT:[000000.VMS.LIB]?
if that's a real rooted logical name, try:
MYSQL051_ROOT:[VMS.LIB]
<<<
Yeah, one more case of that BL***D [000000. construct.
Regular readers will know my aversion.
Dario: DO follow Hoff's request, and report the result! I have a feeling that it DOES make a difference, and I would love another example of whence my aversion comes.
Proost.
Have one on me
jpe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 12:45 AM
тАО03-18-2008 12:45 AM
Re: Mysql link error
sql.opt:
MYSQL051_ROOT:[VMS.LIB]MYSQLCLIENT_MIXED.OLB/lib
MYSQL051_ROOT:[VMS.LIB]LIBZ_SHR32.exe/share
DKA0:[VMS$COMMON.SYSLIB]SSL$LIBSSL_SHR32/share
DKA0:[VMS$COMMON.SYSLIB]SSL$LIBCRYPTO_SHR32/share
linkmysql.com:
$ cc/float=ieee/iee=denorm/name=(as_is, trunc) -
/INCLUDE=mysql testmysql
$ link testmysql, -
sql/opt, -
MYSQL051_ROOT:[VMS.LIB]MYSQLCLIENT_MIXED/lib, -
MYSQL051_ROOT:[VMS.LIB]MYSQLCLIENT_MIXED/LIB
but still the same result: two undefined symbols.
ina > @linkmysql
%ILINK-W-NUDFSYMS, 2 undefined symbols:
%ILINK-I-UDFSYM, my_time
%ILINK-I-UDFSYM, thd_lib_detected
%ILINK-W-USEUNDEF, undefined symbol my_time referenced
section: $CODE$
offset: %X0000000000000270 slot: 2
module: client
file: MYSQL051_ROOT:[VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
there is only one MySQL symbol:
ina > sh log *sql*
(LNM$PROCESS_TABLE)
(LNM$JOB_884FECC0)
(LNM$GROUP_000300)
(LNM$SYSTEM_TABLE)
"MYSQL051_ROOT" = "ALESA$DKA0:[SYS0.SYSCOMMON.MYSQL051.]"
(LNM$SYSCLUSTER_TABLE)
(DECW$LOGICAL_NAMES)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 01:45 AM
тАО03-18-2008 01:45 AM
Re: Mysql link error
On the other hand, an OLB can contain object modules without having their symbols in the library's symbol table. You can ask ANALYZE/OBJECT to look at all object modules in the library and format the symbols. If you find the symbol in that output you can explicitly include the object module.
Anyway, as already said, it looks like something is missing in the documentation or in the envnironment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 02:07 AM
тАО03-18-2008 02:07 AM
Re: Mysql link error
I checked the library:
lib/list/names MYSQLCLIENT_MIXED.OLB
Module my_time
TIME_to_ulonglong
TIME_to_ulonglong_date
TIME_to_ulonglong_datetime
TIME_to_ulonglong_time
calc_daynr
calc_days_in_year
check_date
check_time_range
days_in_month
init_time
log_10_int
my_TIME_to_str
my_date_to_str
my_datetime_to_str
my_system_gmt_sec
my_time_to_str_default
number_to_datetime
set_zero_time
str_to_datetime
str_to_time
year_2000_handling
my_time seems OK.
anal/obj MYSQLCLIENT_MIXED.OLB output is attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 03:26 AM
тАО03-18-2008 03:26 AM
Re: Mysql link error
%ILINK-W-USEUNDEF, undefined symbol my_time referenced
section: $CODE$
offset: %X0000000000000270 slot: 2
module: client
file: MYSQL051_ROOT:[VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
and
%ILINK-W-USEUNDEF, undefined symbol thd_lib_detected referenced
section: $CODE$
offset: %X0000000000000000 slot: 1
module: my_thr_init
file: MYSQL051_ROOT:[VMS.LIB]MYSQLCLIENT_MIXED.OLB;1
how can I fix this? I already send a mail to JFP.
Module client
cli_advanced_command
cli_read_rows
cli_safe_read
default_client_charset_info
end_server
free_old_query
free_rows
my_connect
mysql_close
mysql_detach_stmt_list
mysql_errno
mysql_error
mysql_fetch_lengths
mysql_fetch_row
mysql_free_result
mysql_get_server_version
mysql_get_ssl_cipher
mysql_init
mysql_init_character_set
mysql_num_fields
mysql_num_rows
mysql_options
mysql_port
mysql_read_default_options
mysql_real_connect
mysql_real_query
mysql_reconnect
mysql_select_db
mysql_send_query
mysql_set_character_set
mysql_ssl_set
mysql_store_result
mysql_unix_port
not_error_sqlstate
set_mysql_error
sql_protocol_names_lib
sql_protocol_typelib
unknown_sqlstate
unpack_fields
Module my_thr_init
THR_thread_count
_my_thread_var
my_thread_dbug_id
my_thread_end
my_thread_end_wait_time
my_thread_global_end
my_thread_global_init
my_thread_init
my_thread_name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 04:16 AM
тАО03-18-2008 04:16 AM
Re: Mysql link error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 05:06 AM
тАО03-18-2008 05:06 AM
Re: Mysql link error
>>>
JFP is on holiday this week, wait for next Monday.
<<<
Surely, in France Easter Monday ("Lundi de Paques") is a holiday?
So, make that "wait for Tuesday".
Proost.
Have one on me.
jpe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 11:19 PM
тАО03-18-2008 11:19 PM
Re: Mysql link error
Worth a look to try that one.
Or put your question here:
http://www.pi-net.dyndns.org/piforum/viewforum.php?f=3
OpenVMS Developer & System Manager