[ixpmanager] Issues running these commands

[Barry O'Donovan]

I've never seen this before :-(

A solution seems to be indicated in:

http://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html

> If your character set index file does not contain the name for the
> character set, your program displays an error message. The file is
> named Index.xml and the message is:
> 
> Character set 'charset_name' is not a compiled character set and is
> not specified in the '/usr/share/mysql/charsets/Index.xml' file To
> solve this problem, you should either get a new index file or
> manually add the name of any missing character sets to the current
> file.

But, again, I've never encountered this. IXP Manager is running just
fine on a system as follows:

$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=14.04
DISTRIB_CODENAME=trusty
DISTRIB_DESCRIPTION="Ubuntu 14.04.4 LTS"

 $ dpkg -l | grep mysql-server
ii  mysql-server                        5.5.52-0ubuntu0.14.04.1
                  all          MySQL database server (metapackage
depending on the latest version)
ii  mysql-server-5.5                    5.5.52-0ubuntu0.14.04.1
                  amd64        MySQL database server binaries and system
database setup
ii  mysql-server-core-5.5               5.5.52-0ubuntu0.14.04.1
                  amd64        MySQL database server binaries

 - Barry




 wrote:
> Hi Barry,
> 
> I have started again (a fresh) using 14.04 and now have this
> message:
> 
> Creating database schema... Character set 'utf' is not a compiled
> character set and is not specified in the
> '/usr/share/mysql/charsets/Index.xml' file
> 
> 
> [Doctrine\ORM\Tools\ToolsException]
>  Schema-Tool failed with Error 'SQLSTATE[HY000] [2019] Can't
> initialize char acter set utf (path: /usr/share/mysql/charsets/)'
> while executing DDL: CREA TE TABLE infrastructure (id INT
> AUTO_INCREMENT NOT NULL, ixp_id INT NOT NUL L, name VARCHAR(255)
> DEFAULT NULL, shortname VARCHAR(255) DEFAULT NULL, isP rimary
> TINYINT(1) DEFAULT '0' NOT NULL, aggregate_graph_name VARCHAR(255) D
>  EFAULT NULL, INDEX IDX_D129B190A5A4E881 (ixp_id), UNIQUE INDEX IXPSN
> (short name, ixp_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8
> COLLATE utf8_uni code_ci ENGINE = InnoDB
> 
> 
> 
> 
> [PDOException]
>  SQLSTATE[HY000] [2019] Can't initialize character set utf (path:
> /usr/share /mysql/charsets/)
> 
> Any ideas?
> 
> Thanks!
> 
> Kind Regards,
> 
> 
> 
>  -  555-555-5555 
> email@example.com www.example.com 
> https://uk.linkedin.com/in/example
> 
> 
> -----Original Message----- From: ixpmanager
> [mailto:ixpmanager-bounces at inex.ie] On Behalf Of Barry O'Donovan 
> Sent: 29 September 2016 09:58 To: INEX IXP Manager Mailing List
> <ixpmanager at inex.ie> Subject: Re: [ixpmanager] Issues running these
> commands
> 
> 
> 
>  wrote:
>> Further to my last email I just noticed this error above the output
>> I sent below:
>> 
> 
> <snip>
> 
> looks like you messed up your php.ini file / extensions install.
> 
> You'll have to unravel that mess yourself :-(
> 
> 
> _______________________________________________ INEX IXP Manager
> mailing list ixpmanager at inex.ie 
> https://www.inex.ie/mailman/listinfo/ixpmanager 
> _______________________________________________ INEX IXP Manager
> mailing list ixpmanager at inex.ie 
> https://www.inex.ie/mailman/listinfo/ixpmanager

-- 

Kind regards,
Barry O'Donovan
INEX Operations

https://www.inex.ie/support/
+353 1 531 3339