This repository has been archived by the owner on Dec 10, 2022. It is now read-only.
Setting up mariadb... > ERROR 1064 (42000) at line 7: You have an error in your SQL syntax; #9
Assignees
Labels
bug
Something isn't working
Comments
|
Thanks for the report looks like backticks are missing on the mysql installation that is why you face this error. |
|
Can I do anything in the meantime? Manually?
…On Tue, Jul 16, 2019, 2:22 AM Diego Lendoiro ***@***.***> wrote:
Thanks for the report looks like backticks are missing on the mysql
installation that is why you face this error.
I will try to fix this soon as there is some work scheduled to revamp the
scripts for debian 10.
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#9?email_source=notifications&email_token=AEHOFXPWLMGLWQC53S46LLDP7WAK7A5CNFSM4ID4RF32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2AC4SA#issuecomment-511716936>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AEHOFXOFFV2BPN7VG5MKENTP7WAK7ANCNFSM4ID4RF3Q>
.
|
|
Hi, Yes you can patch it manually, it's pretty easy fix. Edit passbolt_pro_debian_installer.sh Go to line 683 and replace the whole line with the following one: Go to line 684 and proceed the same with the following: |
|
Like this:
[image: image.png]
https://i.imgur.com/rvXS1j4.png
…On Tue, Jul 16, 2019 at 10:20 AM Diego Lendoiro ***@***.***> wrote:
Hi,
Yes you can patch it manually, it's pretty easy fix.
Edit passbolt_pro_debian_installer.sh
Go to line 683 and replace the whole line with the following one:
CREATE DATABASE IF NOT EXISTS \`$(__config_get "$_config_db")\`;
Go to line 684 and proceed the same with the following:
GRANT ALL ON \`$(__config_get "$_config_db")\`.* to \`$(__config_get "$_config_user")\`@'localhost' identified by '$(__config_get "$_config_pw")';
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#9?email_source=notifications&email_token=AEHOFXORAKOOXKPDCZELTELP7XYLHA5CNFSM4ID4RF32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2BMKOI#issuecomment-511886649>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AEHOFXILRPQB5UZB7IGAZQDP7XYLHANCNFSM4ID4RF3Q>
.
|
|
Now I'm getting a new error, in trying to setup "let's encrypt":
[image: image.png]
https://i.imgur.com/CVzM9zc.png
…On Tue, Jul 16, 2019 at 10:20 AM Diego Lendoiro ***@***.***> wrote:
Hi,
Yes you can patch it manually, it's pretty easy fix.
Edit passbolt_pro_debian_installer.sh
Go to line 683 and replace the whole line with the following one:
CREATE DATABASE IF NOT EXISTS \`$(__config_get "$_config_db")\`;
Go to line 684 and proceed the same with the following:
GRANT ALL ON \`$(__config_get "$_config_db")\`.* to \`$(__config_get "$_config_user")\`@'localhost' identified by '$(__config_get "$_config_pw")';
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#9?email_source=notifications&email_token=AEHOFXORAKOOXKPDCZELTELP7XYLHA5CNFSM4ID4RF32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2BMKOI#issuecomment-511886649>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AEHOFXILRPQB5UZB7IGAZQDP7XYLHANCNFSM4ID4RF3Q>
.
|
|
NM. Seems I need to use my public info for a public Let's Encrypt. Not your
issue.
https://community.letsencrypt.org/t/name-does-not-end-in-a-public-suffix/77293/3
…On Tue, Jul 16, 2019 at 12:00 PM Kuerious Guy ***@***.***> wrote:
Now I'm getting a new error, in trying to setup "let's encrypt":
[image: image.png]
https://i.imgur.com/CVzM9zc.png
On Tue, Jul 16, 2019 at 10:20 AM Diego Lendoiro ***@***.***>
wrote:
> Hi,
>
> Yes you can patch it manually, it's pretty easy fix.
>
> Edit passbolt_pro_debian_installer.sh
>
> Go to line 683 and replace the whole line with the following one:
>
> CREATE DATABASE IF NOT EXISTS \`$(__config_get "$_config_db")\`;
>
> Go to line 684 and proceed the same with the following:
>
> GRANT ALL ON \`$(__config_get "$_config_db")\`.* to \`$(__config_get "$_config_user")\`@'localhost' identified by '$(__config_get "$_config_pw")';
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <#9?email_source=notifications&email_token=AEHOFXORAKOOXKPDCZELTELP7XYLHA5CNFSM4ID4RF32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2BMKOI#issuecomment-511886649>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AEHOFXILRPQB5UZB7IGAZQDP7XYLHANCNFSM4ID4RF3Q>
> .
>
|
|
Or like this:
[image: image.png]
https://i.imgur.com/fHsRf0K.png
…On Tue, Jul 16, 2019 at 12:00 PM Kuerious Guy ***@***.***> wrote:
Now I'm getting a new error, in trying to setup "let's encrypt":
[image: image.png]
https://i.imgur.com/CVzM9zc.png
On Tue, Jul 16, 2019 at 10:20 AM Diego Lendoiro ***@***.***>
wrote:
> Hi,
>
> Yes you can patch it manually, it's pretty easy fix.
>
> Edit passbolt_pro_debian_installer.sh
>
> Go to line 683 and replace the whole line with the following one:
>
> CREATE DATABASE IF NOT EXISTS \`$(__config_get "$_config_db")\`;
>
> Go to line 684 and proceed the same with the following:
>
> GRANT ALL ON \`$(__config_get "$_config_db")\`.* to \`$(__config_get "$_config_user")\`@'localhost' identified by '$(__config_get "$_config_pw")';
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <#9?email_source=notifications&email_token=AEHOFXORAKOOXKPDCZELTELP7XYLHA5CNFSM4ID4RF32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2BMKOI#issuecomment-511886649>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AEHOFXILRPQB5UZB7IGAZQDP7XYLHANCNFSM4ID4RF3Q>
> .
>
|
|
This one looks good: https://i.imgur.com/fHsRf0K.png |
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
System:
ESXi 6.7 VM, Debian 9 x64 with full updates, ntpdate configured, security auto-updates configured
Attempt:
Installing Passbolt using installation script
Expectation:
Passbolt installer on clean Debian 9 install would function as described.
Result:
The script failed at the following code:
Processing triggers for systemd (232-25+deb9u11) ...=====================Setting up mariadb...=====================ERROR 1064 (42000) at line 7: You have an error in your SQL syntax; check the manual thatcorresponds to your MariaDB server version for the right syntax to use near '-user@'localhost'identified by xxxxxxxxx at line 1root@passwords:~#The text was updated successfully, but these errors were encountered: