Have you been able to make connection earlier, with same connection string?

|
piterden 2019-10-03 11:50:08
The most favorite answer here is “it’s not MySQL problem” )))
piterden 2019-10-03 11:50:43
2019-10-03 04:57:24
I don’t know what is the condition to print last 20 city names

Let me see the create table statement please

smlkw 2019-10-03 11:50:58
piterden 2019-10-03 11:50:08
The most favorite answer here is “it’s not MySQL problem” )))

But if this is true why we need to dig more

piterden 2019-10-03 11:51:37
smlkw 2019-10-03 11:50:58
But if this is true why we need to dig more

Roger!

2019-10-03 12:40:29
piterden 2019-10-03 11:50:43
Let me see the create table statement please

Thanks but it is solved

Suneelpotluri 2019-10-03 12:58:23
MasterZiv 2019-10-03 11:49:23
At last, press yes and forget it

Tried that…But it rolled back and came to initial screen

Suneelpotluri 2019-10-03 12:59:13
MasterZiv 2019-10-03 11:48:49
This is JDBC problem, not of mysql, solve in your Java application

Thank you Ilia…MySQL connector is downloaded from MySQL site itself

Suneelpotluri 2019-10-03 13:05:06
2019-10-03 11:46:28
Have you been able to make connection earlier, with same connection string?

No. But without jdbc, connections are happening to database. This jdbc driver is required by one client application

MasterZiv 2019-10-03 13:06:37
Suneelpotluri 2019-10-03 13:05:06
No. But without jdbc, connections are happening to database. This jdbc driver is required by one client application

You must tune this particular driver via its connection string.
It is special knowledge for specific driver or for Java in common.

Suneelpotluri 2019-10-03 13:07:52
Was thinking to pass characterEnconding characterCollation settings at connection string
Suneelpotluri 2019-10-03 13:08:14
But looking for expertise advise
MasterZiv 2019-10-03 13:09:51
Suneelpotluri 2019-10-03 13:08:14
But looking for expertise advise

ask in Java chat , group or whatever

Suneelpotluri 2019-10-03 13:23:12
Thank you.. will do rjat
Dexy86 2019-10-03 14:03:32
hello guys
did anyone had this issue?
i am running mysql command from bash
and with ssh keys
i always get error SSL_CTX_set_default_verify_paths failed
but if i run the same command from terminal it works
bash is running the same user so that shouldn’t be the issue
any ideas ?
thanks
MasterZiv 2019-10-03 14:22:38
Dexy86 2019-10-03 14:03:32
hello guys
did anyone had this issue?
i am running mysql command from bash
and with ssh keys
i always get error SSL_CTX_set_default_verify_paths failed
but if i run the same command from terminal it works
bash is running the same user so that shouldn’t be the issue
any ideas ?
thanks

Bash and terminal is same thing, how can you use them separately?

MasterZiv 2019-10-03 14:23:41
Dexy86 2019-10-03 14:03:32
hello guys
did anyone had this issue?
i am running mysql command from bash
and with ssh keys
i always get error SSL_CTX_set_default_verify_paths failed
but if i run the same command from terminal it works
bash is running the same user so that shouldn’t be the issue
any ideas ?
thanks

If you work in terminal you work also in bash or other shell

MasterZiv 2019-10-03 14:26:12
Dexy86 2019-10-03 14:03:32
hello guys
did anyone had this issue?
i am running mysql command from bash
and with ssh keys
i always get error SSL_CTX_set_default_verify_paths failed
but if i run the same command from terminal it works
bash is running the same user so that shouldn’t be the issue
any ideas ?
thanks

Obviously you just have different environment variable set in two cases.
You must make it to be same

piterden 2019-10-03 15:29:00
Dexy86 2019-10-03 14:03:32
hello guys
did anyone had this issue?
i am running mysql command from bash
and with ssh keys
i always get error SSL_CTX_set_default_verify_paths failed
but if i run the same command from terminal it works
bash is running the same user so that shouldn’t be the issue
any ideas ?
thanks

mysql_en-260.jpg
This program called Terminal

Dexy86 2019-10-03 17:08:51
piterden 2019-10-03 15:29:00
This program called Terminal

yes when i run it from here it works but when i run it from bash script SCRIPT .sh file it doesnt

piterden 2019-10-03 17:09:44
Looks like a script has another environment
piterden 2019-10-03 17:10:16
This is not MySQL issue, sorry ))
piterden 2019-10-03 17:11:14
We need a sticker “this isn’t MySQL issue”
MasterZiv 2019-10-03 17:12:58
Dexy86 2019-10-03 17:08:51
yes when i run it from here it works but when i run it from bash script SCRIPT .sh file it doesnt

Where is this your “from here” ?

piterden 2019-10-03 17:15:17
Okay. Where do you launch a script from?
piterden 2019-10-03 17:16:19
Add echoes with variables using in this script
piterden 2019-10-03 17:16:39
To see the real situation
piterden 2019-10-03 17:18:15
Such of actions called a debug
MasterZiv 2019-10-03 17:22:38
piterden 2019-10-03 17:15:17
Okay. Where do you launch a script from?

Да он спать пошёл, чё…

piterden 2019-10-03 17:23:12
Сон – это святое ))
piterden 2019-10-03 17:24:21
A week ban for Russian text to both
piterden 2019-10-03 17:25:09
mysql_en-273.jpg

Dexy86 2019-10-03 17:30:42
piterden 2019-10-03 17:11:14
We need a sticker “this isn’t MySQL issue”

i agree but worth trying to ask here 😄

piterden 2019-10-03 17:31:37
Dexy86 2019-10-03 17:30:42
i agree but worth trying to ask here 😄

Dear friend, please read my above messages. They should help you

Dexy86 2019-10-03 17:31:38
MasterZiv 2019-10-03 17:12:58
Where is this your “from here” ?

if i run it from any terminal the mysql connect command with ssl args it works
but if i run bash script with the same stuff it out puts that error msg

piterden 2019-10-03 17:32:09
Dexy86 2019-10-03 17:31:38
if i run it from any terminal the mysql connect command with ssl args it works
but if i run bash script with the same stuff it out puts that error msg

What message?

Dexy86 2019-10-03 17:32:34
piterden 2019-10-03 17:18:15
Such of actions called a debug

yes i know that is how i run it from terminal as simple command

Dexy86 2019-10-03 17:32:44
SSL_CTX_set_default_verify_paths failed
piterden 2019-10-03 17:34:13
Where is your SSL stuff placed?
Dexy86 2019-10-03 17:34:34
i use absolute path
Dexy86 2019-10-03 17:34:54
i have put it in custom user folder
Dexy86 2019-10-03 17:35:20
i thought off permission problem or user problem but its not that 🙁
piterden 2019-10-03 17:36:54
Try echo $SSL<TAB><TAB>
piterden 2019-10-03 17:39:13
Try whoame from inside your script
Dexy86 2019-10-03 17:42:50
whoami is the same as terminal so thats ok
Dexy86 2019-10-03 17:43:37
but $SSL i will in few mins just left the office
ps tnx for helping
piterden 2019-10-03 22:17:16
http://bit.ly/smartquestions
MasterZiv 2019-10-03 22:38:40
Dexy86 2019-10-03 17:31:38
if i run it from any terminal the mysql connect command with ssl args it works
but if i run bash script with the same stuff it out puts that error msg

Can you give us link, URL, for home page of this “any terminal” you run it from?

Dexy86 2019-10-03 22:42:33
MasterZiv 2019-10-03 22:38:40
Can you give us link, URL, for home page of this “any terminal” you run it from?

r u kidding me ????!

MasterZiv 2019-10-03 22:46:54
Dexy86 2019-10-03 22:42:33
r u kidding me ????!

Damn no

MasterZiv 2019-10-03 22:47:37
Dexy86 2019-10-03 22:42:33
r u kidding me ????!

You telling us nonesence always.

|