MySQL error when trying to run /otrs-schema.mysql.sql script for otrs 6.0.3
Hello, I have installed MySQL 5.7.20 for Cent OS 7 using RPM method. [64bit] I have installed OTRS 6.0.3 using RPM. OTRS & MySQL are on same Cent OS 7 machine. Now trying to run mysql script using following command = mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [Same error if I execute this command by root user or by otrs user.] But it's throwing error as follows = ------------------------------------------------------------------------------------------------------------------------------------------ [root@localhost ~]# mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [1] 29397 bash: lt: command not found... [1]+ Stopped mysql -u root -p otrs /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: syntax error near unexpected token `(' /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: `CREATE TABLE acl (' ------------------------------------------------------------------------------------------------------------------------------------------ How to solve this issue? Thanks & Regards, Amey.
Replace < with < mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql Am 26.12.2017 um 08:38 schrieb Amey Abhyankar:
Hello,
I have installed MySQL 5.7.20 for Cent OS 7 using RPM method. [64bit] I have installed OTRS 6.0.3 using RPM. OTRS & MySQL are on same Cent OS 7 machine.
Now trying to run mysql script using following command = mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [Same error if I execute this command by root user or by otrs user.]
But it's throwing error as follows =
------------------------------------------------------------------------------------------------------------------------------------------ [root@localhost ~]# mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [1] 29397 bash: lt: command not found...
[1]+ Stopped mysql -u root -p otrs /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: syntax error near unexpected token `(' /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: `CREATE TABLE acl (' ------------------------------------------------------------------------------------------------------------------------------------------
How to solve this issue?
Thanks & Regards, Amey. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
-- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de
On 26 December 2017 at 13:24, Renee B
Replace < with <
mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql
Thanks Renee it worked for above command but getting error for following command = ------------------------------------------------------------------------------------------------------------------------------------------------------------ [otrs@localhost ~]$ mysql -u root -p otrsdb < /opt/otrs/scripts/database/otrs-initial_insert.mysql.sql Enter password: ERROR 1366 (HY000) at line 1838: Incorrect string value: '\xE2\x96\xA0
Am 26.12.2017 um 08:38 schrieb Amey Abhyankar:
Hello,
I have installed MySQL 5.7.20 for Cent OS 7 using RPM method. [64bit] I have installed OTRS 6.0.3 using RPM. OTRS & MySQL are on same Cent OS 7 machine.
Now trying to run mysql script using following command = mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [Same error if I execute this command by root user or by otrs user.]
But it's throwing error as follows =
------------------------------------------------------------------------------------------------------------------------------------------ [root@localhost ~]# mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [1] 29397 bash: lt: command not found...
[1]+ Stopped mysql -u root -p otrs /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: syntax error near unexpected token `(' /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: `CREATE TABLE acl (' ------------------------------------------------------------------------------------------------------------------------------------------
How to solve this issue?
Thanks & Regards, Amey. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
-- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
Do you have the database's character set and collation set to utf8/utf8_general_ci (you can check it with "USE otrsdb; SELECT @@character_set_database, @@collation_database;" )?
Regards
Gergely Kún
Amaris GmbH
+421232115171
-----Original Message-----
From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Amey Abhyankar
Sent: Thursday, December 28, 2017 10:20 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] MySQL error when trying to run /otrs-schema.mysql.sql script for otrs 6.0.3
On 26 December 2017 at 13:24, Renee B
Replace < with <
mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql
Thanks Renee it worked for above command but getting error for following command = ------------------------------------------------------------------------------------------------------------------------------------------------------------ [otrs@localhost ~]$ mysql -u root -p otrsdb < /opt/otrs/scripts/database/otrs-initial_insert.mysql.sql Enter password: ERROR 1366 (HY000) at line 1838: Incorrect string value: '\xE2\x96\xA0
Am 26.12.2017 um 08:38 schrieb Amey Abhyankar:
Hello,
I have installed MySQL 5.7.20 for Cent OS 7 using RPM method. [64bit] I have installed OTRS 6.0.3 using RPM. OTRS & MySQL are on same Cent OS 7 machine.
Now trying to run mysql script using following command = mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [Same error if I execute this command by root user or by otrs user.]
But it's throwing error as follows =
--------------------------------------------------------------------- --------------------------------------------------------------------- [root@localhost ~]# mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql [1] 29397 bash: lt: command not found...
[1]+ Stopped mysql -u root -p otrs /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: syntax error near unexpected token `(' /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: `CREATE TABLE acl (' --------------------------------------------------------------------- ---------------------------------------------------------------------
How to solve this issue?
Thanks & Regards, Amey. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: https://urlsand.esvalabs.com/?u=http%3A%2F%2Fotrs.org%2F&e=abe3d79a&h =40517080&f=n&p=y Archive: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fpiperma il%2Fotrs&e=abe3d79a&h=3fcb0a61&f=n&p=y To unsubscribe: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fmailman %2Flistinfo%2Fotrs&e=abe3d79a&h=9cf85515&f=n&p=y
-- Perl / OTRS development: https://urlsand.esvalabs.com/?u=http%3A%2F%2Fperl-services.de&e=abe3d7 9a&h=7e35bb6d&f=n&p=y OTRS AddOn repository: https://urlsand.esvalabs.com/?u=http%3A%2F%2Fopar.perl-services.de&e=a be3d79a&h=d823bc4f&f=n&p=y
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: https://urlsand.esvalabs.com/?u=http%3A%2F%2Fotrs.org%2F&e=abe3d79a&h= 40517080&f=n&p=y Archive: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fpipermai l%2Fotrs&e=abe3d79a&h=3fcb0a61&f=n&p=y To unsubscribe: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fmailman% 2Flistinfo%2Fotrs&e=abe3d79a&h=9cf85515&f=n&p=y
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: https://urlsand.esvalabs.com/?u=http%3A%2F%2Fotrs.org%2F&e=abe3d79a&h=405170... Archive: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fot... To unsubscribe: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flist...
participants (3)
-
Amey Abhyankar -
KÚN Gergely -
Renee B