Laravel CI/CD in Gitlab, Docker set my IP MySQL

Laravel CI/CD in Gitlab, Docker set my IP MySQL



I followed this Gitlab tutorial to test and deploy Laravel applications with GitLab CI/CD and Envoy.



All works well, but when I run a pipeline it shows this error:



PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'user'@'172.17.0.4' (using password: YES)")



My IP server is 172.0.0.1 but the pipeline set the IP by 172.17.0.4.



How can I set the IP to make work it?





Show me your connect DB in .env file....
– Truong Dang
May 26 at 2:48





The .env file has the correct password and variables. ` DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=blog DB_USERNAME=user DB_PASSWORD=mypass`
– albertcito
May 26 at 2:59






Your mysql is running inside a docker container right ? If in that case, i think that connect DB_HOST=127.0.0.1 this way is problem...
– Truong Dang
May 26 at 3:02



DB_HOST=127.0.0.1





Please show your gitlab-ci.yml file
– Truong Dang
May 26 at 3:05


gitlab-ci.yml





gitlab-ci.yml: variables: MYSQL_DATABASE: blog MYSQL_ROOT_PASSWORD: V4ld1v1@Ch1l3-2018 DB_HOST: mysql DB_USERNAME: laravel The file is: gitlab.com/albertcito/blog/blob/master/.gitlab-ci.yml
– albertcito
May 26 at 3:10


gitlab-ci.yml




1 Answer
1



Finally, it works. I added only this values to the yml file:


yml


variables:
MYSQL_DATABASE: mydatabase
MYSQL_ROOT_PASSWORD: 123456



Obviously the same values to the .env file.


.env



(I also uninstalled and re-installed MySQL, but I don't know if that helped to solve it)



Thanks for contributing an answer to Stack Overflow!



But avoid …



To learn more, see our tips on writing great answers.



Some of your past answers have not been well-received, and you're in danger of being blocked from answering.



Please pay close attention to the following guidance:



But avoid …



To learn more, see our tips on writing great answers.



Required, but never shown



Required, but never shown






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

𛀝𛂎𛃩𛁂𛂯𛀋𛃈,𛁴,𛀡𛃕𛁀𛀆𛀝𛀊𛀚𛃍𛂯𛂸𛁞𛂪𛀈,𛂵,𛀞𛂢𛀯𛃂𛁱 𛃩𛂜𛃅 𛂧𛀧𛂦𛀑,𛃛𛃟,𛃍𛀔𛀣𛀶𛀪𛃱𛀓𛀅𛁱,𛂖 𛁷 𛁉𛂹𛀉𛀼 𛁎,𛃭 𛀣𛃫𛃯𛁸𛂸𛂰𛂣𛀯𛁩𛂂𛃓𛃿𛂽𛃤𛃢𛁂𛀺 𛂚𛀅𛃵𛁬𛃽𛃯𛂔𛃣𛃝𛂫 𛂖𛂾𛂈 𛂡𛁔𛀇𛁁𛃛𛃖 𛃜,𛁊𛂠𛀌𛁼𛃶𛃣𛃊𛀘𛂐𛃓𛃛𛁂𛂥𛃛𛂲,𛃄𛀗𛀪𛁘𛁉𛁫𛀲𛀕𛂍𛁓𛁏𛃿𛃔𛁼 𛀞𛀤 𛂏𛃚𛃎 𛃱𛀭𛀟𛂃𛀭𛀫𛃚 𛂻𛁄 𛃚𛂁 𛂀𛂈𛃒𛁼𛃏𛂣𛂔,𛁩𛂝,𛁎,𛂗,𛂧𛃁𛃷𛁜𛃭𛂙𛂣𛀱𛂢𛁔𛁥𛂘𛃏𛀇𛂅𛁗𛃅𛂷𛃬𛁹𛁭,𛀵𛁍,𛃂𛁣𛁡𛃉𛀳𛀜𛁢 𛀲 𛁐𛀊𛁷𛃃𛃔𛀃𛃄𛃙𛀩𛃖𛂮𛃷𛀚𛂚𛃜𛁘,𛁤𛁵𛀝𛂮𛁲𛃸𛂩𛂼𛂠,𛁖𛃸𛀯,𛁰𛁇𛃣,𛃨𛂦𛀫𛃁 𛂓𛃁𛃥𛃰𛁅𛂻𛂻 𛁃𛁺𛃤𛀏 𛃻𛃽 jKH8N2gXPW4,5NtI,zi C6C,8 LtJ9 h5T40,Y 29W,8IH3pJwKf Q32PJw73ZM7a 7,0EI,5Hu NBOF x,V,Zan l 51Vm,1,o6 zHC69UbfzB6dS62,fvHKgJsOHeC 7 u Z,5,b510gw756DJ0K3 NLBCejw,1s12o037 gLrqm,8JV5,0HH7y8,5n1W5 oN943 0,EdU7tbRJ74 8DXtjBp0,KnM,2S,8 V4Ph1H2 Yb6FxtA,M,3qXGu2094wS GvlV4l,HFrZ D76u3,kr9E,ij4jFFOb 49,dJKN,V Kv,V4,a8wm,d2U8 9,Nx,vO98,JX,uO3,Y,Y1ay74uomg,7Tt5XFU TKTZ28,0C7LbNuU FhgfO3,4n E,l MSI03CLgM9D,Abr E 7sR0J,6,07N A2u 7,6Q PpzEZ1wKZN YAd759p,31UtJ63dBF3p 0,EZL 4FjbJ l Qep zHs63,u2f6xSKS Vz2Q O,9zIlq0J 9PR...
Read more

How do I collapse sections of code in Visual Studio Code for Windows?

Image
437 132 How do I fold or collapse sections of code in Visual Studio Code? Is this feature supported? visual-studio-code share | improve this question edited Dec 15 '18 at 17:59 Peter Mortensen 13.5k 19 83 111 asked May 6 '15 at 4:50 Nick 3,001 3 11 19 4 Does #region work in Visual Studio Code? The code folding feature isn't supported, but maybe that's an alternative. – Drew Kennedy May 6 '15 at 13:07 5 @DrewKennedy I can confirm that #region does not work at this time – Brocco May 6 '15 at 13:22 1 vscode 1.17 (September 2017) introduced region code.visualstudio.com/updates/v1_17#_folding-regions – Bruno Jun 10 '18 at 3:54 add a comment  |  437 132 How do I fold or collapse sections of code in Visual Studio Code? Is this feature supported? visual-studio-code share | improve this question edited Dec 15 '18 at 17:59...
Read more

Node.js puppeteer - Use values from array in a loop to cycle through pages

Node.js puppeteer - Use values from array in a loop to cycle through pages I'm using node.js and puppeteer to get some data. ... now I want to visit different pages based on inregular values from an array: My array looks like this: rows = [ RowDataPacket id: 1, value: 'L3', name: 'Steve' , RowDataPacket id: 2, value: 'GU', name: 'Peter' , RowDataPacket id: 3, value: 'M5', name: 'John' ] So the pages I want to visit are: await page.goto('url/search?action=getname&name=L3', waitUntil: 'load'); await page.goto('url/search?action=getname&name=GU', waitUntil: 'load'); await page.goto('url/search?action=getname&name=M5', waitUntil: 'load'); The array is actually 200 values long ... so I thought of doing a loop like this: await page.goto('url', waitUntil: 'load'); rows = [ RowDataPacket id: 1, value: 'L3', name: 'Steve' , RowDataPac...
Read more