| # |
Dec 19th 2017, 09:28 |
hmic |
thing is: it's there, you just need to use it. an ssh tunnel is another dependency and point of failure - not even possible to easily HA the thing. thats why you dont want it. if you want/need vpn between your database host and frontend webservers - go for a full blown solution *with* HA and proper monitoring, why not... |
| # |
Dec 19th 2017, 09:26 |
hmic |
you do know that this article is 5 years old? *lol* and if your database server is on the other end of a slow and high latency link, you have more problems then just ssl vs. ssh performance :P |
| # |
Dec 19th 2017, 09:23 |
 heke |
why would I have 100+ ssl connections ( Mysql SSL ) between hosts, when I could have just one SSL connection between hosts ( SSL tunnel ). |
| # |
Dec 19th 2017, 09:22 |
heke |
@hmic some guys like more ssh-tunnel , https://www.percona.com/blog/2013/11/18/mysql-encryption-performance-revisited/ and autossh works just fine in our case ... |
| # |
Dec 19th 2017, 09:14 |
birdy247 |
morning |
| # |
Dec 19th 2017, 08:57 |
hmic |
heke: there is nothing to wander about. one is a dirty hack, the other a common and best practice usecase. |
| # |
Dec 19th 2017, 08:49 |
heke |
I am wanderin which better , mysql through ssl tunnel , or just mysql over ssl ? |
| # |
Dec 19th 2017, 08:49 |
heke |
@hmic |
| # |
Dec 19th 2017, 08:40 |
hmic |
if you want to specify them in the config array the keys used are: ssl_key, ssl_cert and ssl_ca, the last being optional |
| # |
Dec 19th 2017, 08:37 |
hmic |
aro: you can just add the requried ssl options to the connect string (url) |
| # |
Dec 19th 2017, 08:36 |
heke |
@aro command goes something like this, ssh -fN -L 3320:{ip_addess}:3306 user@subdomain.remote-host.com , I am sure google helps you |
| # |
Dec 19th 2017, 08:35 |
hmic |
totally different story! |
| # |
Dec 19th 2017, 08:35 |
hmic |
this is mysql through an ssh tunnel |
| # |
Dec 19th 2017, 08:35 |
hmic |
this is not mysql with ssl |
| # |
Dec 19th 2017, 08:35 |
hmic |
slaps heke |
| # |
Dec 19th 2017, 08:35 |
mamchenkov |
I think I'm misunderstanding something about the log configuration ... I thought 'levels' should limit the messages to specific levels, ignoring the rest |
| # |
Dec 19th 2017, 08:34 |
heke |
we are using cake 2 and DB over SSL ... totally non cake issue ... you set up ssh connection with ssh command .... you connect cake to locahost port which in fact is forwarded via SSH connection to remote host ... Is that what you are searching ? , @aro |
| # |
Dec 19th 2017, 08:29 |
mamchenkov |
hello all :) |
| # |
Dec 19th 2017, 07:18 |
joop |
good morning to all community members |
| # |
Dec 19th 2017, 06:08 |
braeden |
,:) |
| # |
Dec 19th 2017, 06:08 |
braeden |
@admad I thought so, but then again I saw a blog post which was using the Paginator Component within a Cell, to which I asked myself 'did he read the cookbook?!' |
| # |
Dec 19th 2017, 04:22 |
aro |
i know it was there in 2.0 |
| # |
Dec 19th 2017, 04:13 |
aro |
does cake support ssl db connections? |
| # |
Dec 19th 2017, 04:09 |
aro |
anyone kn ow |
| # |
Dec 19th 2017, 03:49 |
aro |
how do i get Cake to use SSL on a db connection? |
| # |
Dec 19th 2017, 03:39 |
admad |
yes |
| # |
Dec 19th 2017, 02:19 |
braeden |
Is it bad practice to use a Component inside a Cell? |
| # |
Dec 18th 2017, 22:45 |
meder |
how come i defined a _getEditablePair method in my entity but it doesn't trigger when I do $this->Form->control('editablepair') in the template? does it only trigger if you access it directly? eg $entity->editablepair |
| # |
Dec 18th 2017, 22:32 |
joop |
idont find in the debug include tab |
| # |
Dec 18th 2017, 22:32 |
joop |
i need to check which validation rule was loaded,how can i do that? |
| # |
Dec 18th 2017, 21:43 |
rafael.junqueira.sant |
It worked just fine, thank you, @admad. It was a relief not having to deal with joins, pretty simple and beautiful. |
| # |
Dec 18th 2017, 20:41 |
tomicapo |
Of course, there must be different features on different plugins, but I need it for simple user management with roles and permissions. |
| # |
Dec 18th 2017, 20:39 |
tomicapo |
Hi. I want to see your opinion. Is the CakeDC Users Plugin the best one around? |
| # |
Dec 18th 2017, 20:36 |
birdy247 |
@bravo-kernel thanks |
| # |
Dec 18th 2017, 18:27 |
rafael.junqueira.sant |
thank you, I'll read. |
| # |
Dec 18th 2017, 18:27 |
admad |
@rafael.junqueira.sant setup association https://book.cakephp.org/3.0/en/orm/associations.html then use contain() when querying table https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#eager-loading-associations-via-contain |
| # |
Dec 18th 2017, 18:26 |
joop |
commenting out this line shows no error |
| # |
Dec 18th 2017, 18:26 |
joop |
echo $this->Form->control($index.'.points',['label'=>(__('Points:'))]); |
| # |
Dec 18th 2017, 18:25 |
joop |
ohm that really interesting,i dig into deeper myself,its shows something in the template |
| # |
Dec 18th 2017, 18:24 |
rafael.junqueira.sant |
hey, can someone help me? I've been searching for a while and can't find a solution on how to retrieve data from multiple tables with the orm. |
| # |
Dec 18th 2017, 18:19 |
joop |
Call to undefined function App\Model\Table\ValidPoint() |