Re: DBD::mysql not reading host from config file
Danny Rice via Cygwin writes: >> it's more likely that the DB itself is the culprit > > In what way do you mean? As mentioned, it reads all the option data from > the config file (except host) and connects without issue as long as you > supply host in the dsn. Again, the client library (not DBI) processes these statements, so if it doesn't act on a host configured in your config file and you can positively confirm that it actually did read the correct configuration file and group within it, then the host key is most likely not getting through to the module. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ Samples for the Waldorf Blofeld: http://Synth.Stromeko.net/Downloads.html#BlofeldSamplesExtra -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
Re: DBD::mysql not reading host from config file
> > it's more likely that the DB itself is the culprit In what way do you mean? As mentioned, it reads all the option data from the config file (except host) and connects without issue as long as you supply host in the dsn. The cygwin command line mysql command reads all the options, including host, from the config file. The database tested on both cygwin and linux was the same database. I also did the same tests on two completely independent hosts/databases. > examples of this sort of DSN I've seen reverse the two keys This doesn't change anything. > versions available in Cygwin, which are almost certainly older than the > ones on Linux This has been an issue since at least 2020. The current cygwin DBD::mysql is version is 4.052. The one I tested on linux is currently 4.046. On Sat, Jul 27, 2024 at 2:50 AM ASSI via Cygwin wrote: > Danny Rice via Cygwin writes: > > With a dsn like > > > > $dsn = > > > "dbi:mysql:mysql_ssl=1;mysql_read_default_file=test.cnf;mysql_read_default_group=test_group"; > > $dbh = DBI->connect($dsn); > > > > seemingly fails to read the host from [test_group] in test.cnf. Adding a > > valid host=host_name to the $dsn succeeds in reading the user, password > etc > > from test.cnf and the connection succeeds > > > > This has been an issue since at least 2020 and I've had to just specify > the > > host in the $dsn on cygwin. > > I fail to see how this can be caused by DBD::mysql, so it's more likely > that the DB itself is the culprit (you might want to check if that's a > known issue with the versions available in Cygwin, whilch are almost > certainly older than the ones on Linux). Anyway, I'll just note that > the examples of this sort of DSN I've seen reverse the two keys: > > $dsn = "dbi:mysql:mysql_ssl=1;" > . "mysql_read_default_group=test_group;" > . "mysql_read_default_file=test.cnf"; > > so maybe give that a try. > > > Regards, > Achim. > -- > +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ > > Wavetables for the Terratec KOMPLEXER: > http://Synth.Stromeko.net/Downloads.html#KomplexerWaves > > -- > Problem reports: https://cygwin.com/problems.html > FAQ: https://cygwin.com/faq/ > Documentation:https://cygwin.com/docs.html > Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple > -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
Re: DBD::mysql not reading host from config file
Danny Rice via Cygwin writes: > With a dsn like > > $dsn = > "dbi:mysql:mysql_ssl=1;mysql_read_default_file=test.cnf;mysql_read_default_group=test_group"; > $dbh = DBI->connect($dsn); > > seemingly fails to read the host from [test_group] in test.cnf. Adding a > valid host=host_name to the $dsn succeeds in reading the user, password etc > from test.cnf and the connection succeeds > > This has been an issue since at least 2020 and I've had to just specify the > host in the $dsn on cygwin. I fail to see how this can be caused by DBD::mysql, so it's more likely that the DB itself is the culprit (you might want to check if that's a known issue with the versions available in Cygwin, whilch are almost certainly older than the ones on Linux). Anyway, I'll just note that the examples of this sort of DSN I've seen reverse the two keys: $dsn = "dbi:mysql:mysql_ssl=1;" . "mysql_read_default_group=test_group;" . "mysql_read_default_file=test.cnf"; so maybe give that a try. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ Wavetables for the Terratec KOMPLEXER: http://Synth.Stromeko.net/Downloads.html#KomplexerWaves -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
DBD::mysql not reading host from config file
With a dsn like $dsn = "dbi:mysql:mysql_ssl=1;mysql_read_default_file=test.cnf;mysql_read_default_group=test_group"; $dbh = DBI->connect($dsn); seemingly fails to read the host from [test_group] in test.cnf. Adding a valid host=host_name to the $dsn succeeds in reading the user, password etc from test.cnf and the connection succeeds This has been an issue since at least 2020 and I've had to just specify the host in the $dsn on cygwin. On linux it does read the host from the config file. -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
[Pending NMU] mysql, mariadb-connector-c
Due to a problem with a new major version of perl-DBD-mysql (trhat hasn't been resolved and will have to wait for an upstream fix) I've been looking at re-building those two packages. The updated packaging is available in the playground branches: https://cygwin.com/cgit/cygwin-packages/mysql/commit/?h=playground The version used is the last of the 10.3 LTS GA branch which went out of support in May this year. Once this is out we can discuss updating to one of the LTS versions that are still in support, I have not yet looked into whether these build without problems and how much changes to the patch set are required. https://cygwin.com/cgit/cygwin-packages/mariadb-connector-c/commit/?h=playground That's the latest version available from upstream. Appveyor times out before mysql is fully built, the connector library has built without errors. I'd like to get feedback from actual users of these packages before doing an NMU on them… Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ SD adaptation for Waldorf microQ V2.22R2: http://Synth.Stromeko.net/Downloads.html#WaldorfSDada
Re: MYSQL cygwin database connection requests root password
On August 18, 2023 at 22:14 cygwin@cygwin.com (HECTOR MENDEZ via Cygwin) wrote: > > Hi there, > I tried with an empty password and "root" word a password but no luck, so > far. > Thank youEl miércoles, 16 de agosto de 2023, 22:56:12 GMT-6, > rapp...@dds.nl escribió: MySQL's 'root' account and the system root account have little relationship other than they share the same four characters in the same order. There are instructions in the online MySQL manual on how to recover the MySQL root password, no doubt others have summarized, try your favorite search engine. But it basically amounts to: 1. Stop the MySQL server 2. Start it with a command line flag which says don't use passwords 3. Login as root via the MySQL client, it won't ask for a password 4. Set a password for that root account using the usual MySQL SET PASSWORD command 5. Logout of the client 6. Stop the MySQL server 7. Start the MySQL the normal way, without the flag to not use passwords 8. You are done Here's a link to the MySQL 8.0 instructions; https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html -- -Barry Shein Software Tool & Die| b...@theworld.com | http://www.TheWorld.com Purveyors to the Trade | Voice: +1 617-STD-WRLD | 800-THE-WRLD The World: Since 1989 | A Public Information Utility | *oo* -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
Re: MYSQL cygwin database connection requests root password
Hi there, I tried with an empty password and "root" word a password but no luck, so far. Thank youEl miércoles, 16 de agosto de 2023, 22:56:12 GMT-6, rapp...@dds.nl escribió: > Hi everyone I saw that in order to connect MYSQL database on cygwin, this > statement must be executed: > mysql -u root -p -h 127.0.0.1 > However, as far as I know, there's no root user on cygwin. > How can I get that requested password? Isn't "root" a MySQL username? If I recall correctly its default password is either empty or "root". -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
Re: MYSQL cygwin database connection requests root password
> Hi everyone I saw that in order to connect MYSQL database on cygwin, this > statement must be executed: > mysql -u root -p -h 127.0.0.1 > However, as far as I know, there's no root user on cygwin. > How can I get that requested password? Isn't "root" a MySQL username? If I recall correctly its default password is either empty or "root". -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
MYSQL cygwin database connection requests root password
Hi everyone I saw that in order to connect MYSQL database on cygwin, this statement must be executed: mysql -u root -p -h 127.0.0.1 However, as far as I know, there's no root user on cygwin. How can I get that requested password? Thank you in advance. Regards -- Problem reports: https://cygwin.com/problems.html FAQ: https://cygwin.com/faq/ Documentation:https://cygwin.com/docs.html Unsubscribe info: https://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] mysql 10.3.14-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.3.14-1 * mysql-server-10.3.14-1 * mysql-server-utils-10.3.14-1 * mysql-bench-10.3.14-1 * mysql-test-10.3.14-1 * mysql-common-10.3.14-1 * mysql-errmsg-10.3.14-1 * mysql-devel-10.3.14-1 * libmariadbd19-10.3.14-1 * libmariadbd-devel-10.3.14-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest upstream stable release. The embedded server library has been renamed, and the client library is now built in a separate package. -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.3.14-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.3.14-1 * mysql-server-10.3.14-1 * mysql-server-utils-10.3.14-1 * mysql-bench-10.3.14-1 * mysql-test-10.3.14-1 * mysql-common-10.3.14-1 * mysql-errmsg-10.3.14-1 * mysql-devel-10.3.14-1 * libmariadbd19-10.3.14-1 * libmariadbd-devel-10.3.14-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest upstream stable release. The embedded server library has been renamed, and the client library is now built in a separate package. -- Yaakov
Re: [ANNOUNCEMENT] mysql 10.1.26-1
On 2017-09-10 12:03, Wayne Davison wrote: > On Sun, Sep 3, 2017 at 2:46 PM, Yaakov Selkowitz wrote: >> This is an update to the latest 10.1 release: > > Is there any chance that readline support is going to make a comeback > in mysql? I downloaded the src, changed the readline option in the > cygport file to "-DWITH_READLINE=ON" (it was "OFF") and compiled my > own mysql.exe so that I have access to the much-superior readline > editing (I can't stand being without Ctrl+R searching, Ctrl+_ undo, > etc, etc), but it would be nice if it was a default part of each > release. > > Aside: it's too bad the cygport file doesn't seem to have a way to > mention all the packages required for a build. I waded through the > cmake output and installed all of the following (I already had things > like gcc installed) -- hopefully this will help someone: > > cmake, openssl-devel, libncurses-devel, libpcre-devel, > libgcrypt-devel, libiconv-devel, libxml2-devel, liblzo2-devel, > liblzma-devel, liblz4-devel, libbz2-devel, bison, libreadline-devel Add to or define DEPEND= - note singular - for build time dependencies https://cygwinports.github.io/cygport/check_funcs_cygpart.html#robo906 some maintainers have so many packages and dependencies installed that it may be hard for them to figure out what each package needs; it would be great if this info was captured as a build-depends: line in each package's setup.ini entry. Add to or define REQUIRES= - note plural - for run time dependencies https://cygwinports.github.io/cygport/pkg_pkg_cygpart.html#robo443 cygport tries to figure these out, and the result is captured as a requires: line in each package's setup.ini entry. Note that if the cygport file defines PKG_NAMES= with more than one package, https://cygwinports.github.io/cygport/pkg_pkg_cygpart.html#robo432 then each Cygwin package should have its own _CONTENTS=, _DEPEND=, and _REQUIRES= entries in the cygport file, or sometimes in a .list file in the CYGWIN-PATCHES directory. You can submit cygport file patches on the cygwin-apps list, where discussions on building packages normally occurs. -- Take care. Thanks, Brian Inglis, Calgary, Alberta, Canada -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: [ANNOUNCEMENT] mysql 10.1.26-1
On Sun, Sep 3, 2017 at 2:46 PM, Yaakov Selkowitz <yselkow...@cygwin.com> wrote: > This is an update to the latest 10.1 release: Is there any chance that readline support is going to make a comeback in mysql? I downloaded the src, changed the readline option in the cygport file to "-DWITH_READLINE=ON" (it was "OFF") and compiled my own mysql.exe so that I have access to the much-superior readline editing (I can't stand being without Ctrl+R searching, Ctrl+_ undo, etc, etc), but it would be nice if it was a default part of each release. Aside: it's too bad the cygport file doesn't seem to have a way to mention all the packages required for a build. I waded through the cmake output and installed all of the following (I already had things like gcc installed) -- hopefully this will help someone: cmake, openssl-devel, libncurses-devel, libpcre-devel, libgcrypt-devel, libiconv-devel, libxml2-devel, liblzo2-devel, liblzma-devel, liblz4-devel, libbz2-devel, bison, libreadline-devel ..wayne.. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] mysql 10.1.26-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.26-1 * mysql-server-10.1.26-1 * mysql-bench-10.1.26-1 * mysql-common-10.1.26-1 * mysql-test-10.1.26-1 * libmysqlclient18-10.1.26-1 * libmysqlclient-devel-10.1.26-1 * libmysqld18-10.1.26-1 * libmysqld-devel-10.1.26-1 * mingw64-i686-mariadb-connector-c-2.3.3-1 * mingw64-x86_64-mariadb-connector-c-2.3.3-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest 10.1 release: https://mariadb.com/kb/en/the-mariadb-library/mariadb-10126-release-notes/ -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.1.26-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.26-1 * mysql-server-10.1.26-1 * mysql-bench-10.1.26-1 * mysql-common-10.1.26-1 * mysql-test-10.1.26-1 * libmysqlclient18-10.1.26-1 * libmysqlclient-devel-10.1.26-1 * libmysqld18-10.1.26-1 * libmysqld-devel-10.1.26-1 * mingw64-i686-mariadb-connector-c-2.3.3-1 * mingw64-x86_64-mariadb-connector-c-2.3.3-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest 10.1 release: https://mariadb.com/kb/en/the-mariadb-library/mariadb-10126-release-notes/ -- Yaakov
Re: [ANNOUNCEMENT] mysql 10.1.19-1
On Sun, Nov 13, 2016 at 12:36 PM, Yaakov Selkowitz <yselkow...@cygwin.com> wrote: > The following packages have been uploaded to the Cygwin distribution: > * mysql-10.1.19-1 > * [...] Would you consider a change in the mysql packages back to using readline? It should hopefully be as simple as: CYGCONF_ARGS="--with-readline" I tried doing a cygport prep with that set, but the mysql package's patches aren't applying successfully, so I couldn't easily give it a try. The reason for the switch back is that the current line-editing lib is severely crippled compared to readline. There's no search (and the suggestions I saw for how to enable Ctrl-R don't work), there's no undo (or redo), there's no Esc-. arg references, there's no word delete, etc. Also, its save format is quite unreadable (not to mention that it blew-away my mysql command history in ~/.mysql_history, which was really quite rude of it). I know that RHEL/CentOS still uses readline in their mariadb packages, so hopefully it will be an easy change. ..wayne.. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] mysql 10.1.19-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.19-1 * mysql-server-10.1.19-1 * mysql-bench-10.1.19-1 * mysql-common-10.1.19-1 * mysql-test-10.1.19-1 * libmysqlclient18-10.1.19-1 * libmysqlclient-devel-10.1.19-1 * libmysqld18-10.1.19-1 * libmysqld-devel-10.1.19-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest upstream stable release: https://mariadb.com/kb/en/mariadb/mariadb-10119-release-notes/ -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.1.19-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.19-1 * mysql-server-10.1.19-1 * mysql-bench-10.1.19-1 * mysql-common-10.1.19-1 * mysql-test-10.1.19-1 * libmysqlclient18-10.1.19-1 * libmysqlclient-devel-10.1.19-1 * libmysqld18-10.1.19-1 * libmysqld-devel-10.1.19-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest upstream stable release: https://mariadb.com/kb/en/mariadb/mariadb-10119-release-notes/ -- Yaakov
[ANNOUNCEMENT] mysql 10.1.18-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.18-1 * mysql-server-10.1.18-1 * mysql-bench-10.1.18-1 * mysql-common-10.1.18-1 * mysql-test-10.1.18-1 * libmysqlclient18-10.1.18-1 * libmysqlclient-devel-10.1.18-1 * libmysqld18-10.1.18-1 * libmysqld-devel-10.1.18-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest upstream release: https://mariadb.com/kb/en/mariadb/mariadb-10118-release-notes/ -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.1.18-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.18-1 * mysql-server-10.1.18-1 * mysql-bench-10.1.18-1 * mysql-common-10.1.18-1 * mysql-test-10.1.18-1 * libmysqlclient18-10.1.18-1 * libmysqlclient-devel-10.1.18-1 * libmysqld18-10.1.18-1 * libmysqld-devel-10.1.18-1 MariaDB turns data into structured information in a wide array of applications. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. This is an update to the latest upstream release: https://mariadb.com/kb/en/mariadb/mariadb-10118-release-notes/ -- Yaakov
Re: [ANNOUNCEMENT] mysql 10.1.17-1
Greetings, Yaakov Selkowitz! > The following packages have been uploaded to the Cygwin distribution: > * mysql-10.1.17-1 > * mysql-server-10.1.17-1 > * mysql-bench-10.1.17-1 > * mysql-common-10.1.17-1 > * mysql-test-10.1.17-1 > * libmysqlclient18-10.1.17-1 > * libmysqlclient-devel-10.1.17-1 > * libmysqld18-10.1.17-1 > * libmysqld-devel-10.1.17-1 > MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL > (Structured Query Language) database server. The client components are > stable, but the daemon should be considered experimental and not ready for > mission-critical deployment. > This is an update to the latest upstream stable release: > https://mariadb.com/kb/en/mariadb/mariadb-10117-release-notes/ You saying "MySQL", while shipping MariaDB. That's not quite nice, IMO. -- With best regards, Andrey Repin Tuesday, September 13, 2016 12:22:06 Sorry for my terrible english... -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] mysql 10.1.17-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.17-1 * mysql-server-10.1.17-1 * mysql-bench-10.1.17-1 * mysql-common-10.1.17-1 * mysql-test-10.1.17-1 * libmysqlclient18-10.1.17-1 * libmysqlclient-devel-10.1.17-1 * libmysqld18-10.1.17-1 * libmysqld-devel-10.1.17-1 MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. The client components are stable, but the daemon should be considered experimental and not ready for mission-critical deployment. This is an update to the latest upstream stable release: https://mariadb.com/kb/en/mariadb/mariadb-10117-release-notes/ -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.1.17-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.17-1 * mysql-server-10.1.17-1 * mysql-bench-10.1.17-1 * mysql-common-10.1.17-1 * mysql-test-10.1.17-1 * libmysqlclient18-10.1.17-1 * libmysqlclient-devel-10.1.17-1 * libmysqld18-10.1.17-1 * libmysqld-devel-10.1.17-1 MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. The client components are stable, but the daemon should be considered experimental and not ready for mission-critical deployment. This is an update to the latest upstream stable release: https://mariadb.com/kb/en/mariadb/mariadb-10117-release-notes/ -- Yaakov
[ANNOUNCEMENT] mysql 10.1.16-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.16-1 * mysql-server-10.1.16-1 * mysql-bench-10.1.16-1 * mysql-common-10.1.16-1 * mysql-test-10.1.16-1 * libmysqlclient18-10.1.16-1 * libmysqlclient-devel-10.1.16-1 * libmysqld18-10.1.16-1 * libmysqld-devel-10.1.16-1 MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. The client components are stable, but the daemon should be considered experimental and not ready for mission-critical deployment. This is an update to the latest MariaDB release, which includes fixes for CVE-2016-3477, CVE-2016-3521, CVE-2016-3615, and CVE-2016-5440: https://mariadb.com/kb/en/mariadb/mariadb-10115-release-notes/ https://mariadb.com/kb/en/mariadb/mariadb-10116-release-notes/ -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.1.16-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.16-1 * mysql-server-10.1.16-1 * mysql-bench-10.1.16-1 * mysql-common-10.1.16-1 * mysql-test-10.1.16-1 * libmysqlclient18-10.1.16-1 * libmysqlclient-devel-10.1.16-1 * libmysqld18-10.1.16-1 * libmysqld-devel-10.1.16-1 MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. The client components are stable, but the daemon should be considered experimental and not ready for mission-critical deployment. This is an update to the latest MariaDB release, which includes fixes for CVE-2016-3477, CVE-2016-3521, CVE-2016-3615, and CVE-2016-5440: https://mariadb.com/kb/en/mariadb/mariadb-10115-release-notes/ https://mariadb.com/kb/en/mariadb/mariadb-10116-release-notes/ -- Yaakov
[ANNOUNCEMENT] mysql 10.1.14-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.14-1 * mysql-server-10.1.14-1 * mysql-bench-10.1.14-1 * mysql-common-10.1.14-1 * mysql-test-10.1.14-1 * libmysqlclient18-10.1.14-1 * libmysqlclient-devel-10.1.14-1 * libmysqld18-10.1.14-1 * libmysqld-devel-10.1.14-1 MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. The client components are stable, but the daemon should be considered experimental and not ready for mission-critical deployment. This is an update to the latest stable release from the MariaDB project. Those using the server should review the following documents before upgrading: https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-55-to-mariadb-100/ https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-100-to-101/ -- Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql 10.1.14-1
The following packages have been uploaded to the Cygwin distribution: * mysql-10.1.14-1 * mysql-server-10.1.14-1 * mysql-bench-10.1.14-1 * mysql-common-10.1.14-1 * mysql-test-10.1.14-1 * libmysqlclient18-10.1.14-1 * libmysqlclient-devel-10.1.14-1 * libmysqld18-10.1.14-1 * libmysqld-devel-10.1.14-1 MySQL delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. The client components are stable, but the daemon should be considered experimental and not ready for mission-critical deployment. This is an update to the latest stable release from the MariaDB project. Those using the server should review the following documents before upgrading: https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-55-to-mariadb-100/ https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-100-to-101/ -- Yaakov
mysql - poor performance when restoring from large mysqldump backup
Hello. I am trying to restore a backup of our database in order to examine the data state three weeks ago. Backup is 1GB large SQL text file created by mysqldump. After many attempts I found this: Processing of backup file runs fluently in the beginning, several tables are successfully restored, including table event_log 3x10e6 row big. Processing hangs after cca one hour of run during insert-s to table student_grade - this is approx 6x10e6 row big. (Exact place differs in every attempt.) Mysqld process is running as before: 13%CPU, 187MB RAM, but HDD activity is now very low. Open connection to mysqld is not possible. I was waiting that mysqld will recover more than six hours, but the situation has not improved. All this occurs on my workstation Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz, 16GB RAM, Windows 7 Professional x64, Cygwin 32-bit, mysql Ver 14.14 Distrib 5.5.41, for CYGWIN (i686) using readline 6.3. On the other hand I tried to restore the same backup file on linux machine (Pentium(R) Dual-Core CPU E5300 @ 2.60GHz, 4GB RAM, CentOS release 6.6 (Final), 32-bit, mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (i386) using readline 5.1). Whole database was successfully restored after cca two and half hours of run. Can I tweak something in mysql or cygwin to improve restore (inserts) performance? Any other suggestions, please? -- .: Vlado :. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] Updated: mysql-5.5.41-2
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.41-2
*** mysqld-5.5.41-2
*** mysql-test-5.5.41-2
*** libmysqlclient18-5.5.41-2
*** libmysqlclient-devel-5.5.41-2
*** libmysqld0-5.5.41-2
*** libmysqld-devel-5.5.41-2
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream 5.5 release, which includes
fixes for several security issues:
https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-41.html
--
Yaakov
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Updated: mysql-5.5.41-2
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.41-2
*** mysqld-5.5.41-2
*** mysql-test-5.5.41-2
*** libmysqlclient18-5.5.41-2
*** libmysqlclient-devel-5.5.41-2
*** libmysqld0-5.5.41-2
*** libmysqld-devel-5.5.41-2
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream 5.5 release, which includes
fixes for several security issues:
https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-41.html
--
Yaakov
How to use odbc-mysql ?
Hello, I have been installed mysql, mysqld, myodbc-mysql. However I don't know how to set myodbc-mysql. Does anyone who use myldbc-mysql? Could you pls how to use it ? Regards...Taku -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] Updated: mysql-5.5.40-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.40-1
*** mysqld-5.5.40-1
*** mysql-test-5.5.40-1
*** libmysqlclient18-5.5.40-1
*** libmysqlclient-devel-5.5.40-1
*** libmysqld0-5.5.40-1
*** libmysqld-devel-5.5.40-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream 5.5 release, which includes
fixes for several security issues:
https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-40.html
--
Yaakov
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Updated: mysql-5.5.40-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.40-1
*** mysqld-5.5.40-1
*** mysql-test-5.5.40-1
*** libmysqlclient18-5.5.40-1
*** libmysqlclient-devel-5.5.40-1
*** libmysqld0-5.5.40-1
*** libmysqld-devel-5.5.40-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream 5.5 release, which includes
fixes for several security issues:
https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-40.html
--
Yaakov
[ANNOUNCEMENT] Updated: mysql-5.5.39-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.39-1
*** mysqld-5.5.39-1
*** mysql-test-5.5.39-1
*** libmysqlclient18-5.5.39-1
*** libmysqlclient-devel-5.5.39-1
*** libmysqld0-5.5.39-1
*** libmysqld-devel-5.5.39-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream 5.5 release.
Yaakov
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Updated: mysql-5.5.39-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.39-1
*** mysqld-5.5.39-1
*** mysql-test-5.5.39-1
*** libmysqlclient18-5.5.39-1
*** libmysqlclient-devel-5.5.39-1
*** libmysqld0-5.5.39-1
*** libmysqld-devel-5.5.39-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream 5.5 release.
Yaakov
broken links on few man pages : xmon, mysql, bind-utils
Hi, just as by product of looking why mc had a unusable man page, and why u2d was making me crazy... these are the other broken pages on my system, that look as upstream bugs. $ grep ROFF mandb.log mandb: warning: /usr/share/man/man1/bind9-config.1.gz: bad symlink or ROFF `.so' request mandb: warning: /usr/share/man/man1/mysqltest_embedded.1.gz: bad symlink or ROFF `.so' request mandb: warning: /usr/share/man/man1/mysql_client_test_embedded.1.gz: bad symlink or ROFF `.so' request mandb: warning: /usr/share/man/man1/u2d.1.gz: bad symlink or ROFF `.so' request mandb: warning: /usr/share/man/man1/xmond.1.gz: bad symlink or ROFF `.so' request $ cygcheck -f /usr/share/man/man1/bind9-config.1.gz bind-utils-9.9.5-3 $ gzip -cd /usr/share/man/man1/bind9-config.1.gz .so isc-config.sh.1 but there is no isc-config.sh.1 page in any cygwin package $ cygcheck -f /usr/share/man/man1/mysqltest_embedded.1.gz mysql-5.5.35-1 $ gzip -cd /usr/share/man/man1/mysqltest_embedded.1.gz .so man-gpl-tmp2/mysqltest.1 $ gzip -cd /usr/share/man/man1/mysqltest_embedded.1.gz .so man-gpl-tmp2/mysqltest.1 but the file is located on /usr/share/man/man1/mysqltest.1.gz $ cygcheck -f /usr/share/man/man1/xmond.1.gz xmon-1.5.6-3 $ gzip -cd /usr/share/man/man1/xmond.1.gz .so man1/xmonui.1x so there is an extra x as the page is /usr/share/man/man1/xmonui.1.gz Regards Marco -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Cygwin's PHP MySQL
On Sun, Dec 1, 2013 at 8:57 AM, wynfield wrote: Re: http://cygwinports.org/ Thanks for the url. I found the proper package there. I appeciate the information. Good to know. Please use the list for so that it may help others in future. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Cygwin's PHP MySQL
I meant for this to go to the list so that others can find the cygwin ports site which has ported many useful and needed packages to cygwin, which are not in the main base distribution. This is where I found the php_MySQLi extension. This interface to MySQL is an improved version of the older PHP MySQL driver,offering various benefits.le I needed for interfacing php to MySQL databases. Here is the url for the site: http://cygwinports.org/ Regards Balaji Venkataraman wrote: Re: http://cygwinports.org/ Thanks for the url. I found the proper package there. I appeciate the information. Good to know. Please use the list for so that it may help others in future. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Cygwin's PHP MySQL
On Fri, Nov 29, 2013 at 6:25 AM, wynfield @ gmail.com wrote: I am attempting to learn php programming together with interfacing it to an MySQL server from an http web-page. I ran into a fatal error. The httpd2 server logs shows the following message: PHP Fatal error: Class 'mysqli' not found The phpinfo() function has no mention of the mysqli extension. Have you installed the php-mysqli package? -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Cygwin's PHP MySQL
Balaji Venkataraman wrote: On Fri, Nov 29, 2013 at 6:25 AM, wynfield wrote: I am attempting to learn php programming together with interfacing it to an MySQL server from an http web-page. I ran into a fatal error. The httpd2 server logs shows the following message: PHP Fatal error: Class 'mysqli' not found The phpinfo() function has no mention of the mysqli extension. Have you installed the php-mysqli package? No. I did look for one for serveral hours, but haven't found one yet. Can you give me a URL to where one is. Thank you. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Cygwin's PHP MySQL
Andrey Repin wrote: wgc I am attempting to learn php programming together with interfacing it to wgc an MySQL server from an http web-page. Why you are doing it with Cygwin? There's a native MySQL server, native PHP and native Apache server, that works together very well. You might as wel ask why am I using cygwin at all, since there's a proprietary Microsoft operating system and it works very well. What is Cygwin-specific in your aim, that you go into a trouble of running all the suite under Cygwin? A posix environment is one thing, education, compatibility and transporting are some others. wgc I ran into a fatal error. wgc The httpd2 server logs shows the following message: wgc PHP Fatal error: Class 'mysqli' not found wgc The phpinfo() function has no mention of the mysqli extension. wgc What do I need to do to get this important extension and install it in for my cygwin environment? wgc Any help or advice would be much appreciated. Install native applications. Also, switch to PDO ASAP. mysqli_* family of functions isn't much better than mysql_* ones. You apparently didn't understand my question. It relates to cygwin and mysqli and my attempts to learn and build using it, and not Microsoft Windows. -- Sincerely, Andrey Repin mailto:anrdae...@freemail.ru Sorry for my terrible english... Not to worry, I can understand it. Regards -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Cygwin's PHP MySQL
On Sat, Nov 30, 2013 at 5:22 PM, wynfield wrote: Balaji Venkataraman wrote: On Fri, Nov 29, 2013 at 6:25 AM, wynfield wrote: I am attempting to learn php programming together with interfacing it to an MySQL server from an http web-page. I ran into a fatal error. The httpd2 server logs shows the following message: PHP Fatal error: Class 'mysqli' not found The phpinfo() function has no mention of the mysqli extension. Have you installed the php-mysqli package? No. I did look for one for serveral hours, but haven't found one yet. Can you give me a URL to where one is. http://cygwinports.org/ -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Cygwin's PHP MySQL
I am attempting to learn php programming together with interfacing it to an MySQL server from an http web-page. I ran into a fatal error. The httpd2 server logs shows the following message: PHP Fatal error: Class 'mysqli' not found The phpinfo() function has no mention of the mysqli extension. What do I need to do to get this important extension and install it in for my cygwin environment? Any help or advice would be much appreciated. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
mysql package
I jsut installed the mysql pacakge and tried to start the daemon. I got the follow error listing. It is late now and I plan to continue on the morrow, but if anyone can point out why the daemon wont start up, it would be very helpful. Thanks --- 130926 23:25:40 [Note] Plugin 'FEDERATED' is disabled. mysqld: Table 'mysql.plugin' doesn't exist 130926 23:25:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 130926 23:25:40 InnoDB: The InnoDB memory heap is disabled 130926 23:25:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130926 23:25:40 InnoDB: Compressed tables use zlib 1.2.8 130926 23:25:40 InnoDB: Initializing buffer pool, size = 128.0M 130926 23:25:41 InnoDB: Completed initialization of buffer pool 130926 23:25:41 InnoDB: highest supported file format is Barracuda. 130926 23:25:41 InnoDB: 5.5.31 started; log sequence number 1595675 130926 23:25:41 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130926 23:25:41 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130926 23:25:41 [Note] Server socket created on IP: '0.0.0.0'. 130926 23:25:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: mysql package
Andrey Repin wrote: Greetings, I jsut installed the mysql pacakge and tried to start the daemon. I got the follow error listing. Why not use native mysql server?... Looking for troubles? No. I just prefer a posix environment and it makes it better for porting to production in a Linux environment. ... Thanks 130926 23:25:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Check server configuration file, it should point to a proper directory for a database, and the user under which server is run should have write access to it. Also, -- Problem reports: http://cygwin.com/problems.html This ^^^ -- WBR, Andrey Repin Sorry for my terrible english... Your English is understandable and I appreciate the response. I have a problem. I can not find the MySQL configuration file, that I assume comes with the package. Documentation I read says that it would be /etc/my.cnf , but it's not there. I grep'd for anything sql in /etc and fouund nothing related to mysql or my* Does anyone know where it is or does it have to be made from scratch? If there any default or example MySQL configuration files in the package or installed, I'd appreciate it if someone would tell me where they are. Regards -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Mysql shows wrong error message
Hi, I have a dump of a MySQL database. I'm trying to import it to a MySQL server running on cygwin. But during the import process I got ERROR 2006 (HY000) at line 1642: MySQL server has gone away. This is not quite true, the MySQL server is still up and running and I can connect fine. I then tried to import the very same dump into a MySQL database on Debian and got the more helpful and more correct message ERROR 1153 (08S01) at line 2630: Got a packet bigger than 'max_allowed_packet' bytes. After increasing 'max_allowed_packet' on the server side, the import went smoothly on Debian. So I then also tried this on Cygwin, increasing 'max_allowed_packet' and importing et voila, the import worked fined. So Cygwin here seems to show ERROR 2006 (HY000) at line 1642: MySQL server has gone away when it should have shown ERROR 1153 (08S01) at line 2630: Got a packet bigger than 'max_allowed_packet' bytes instead. Regards Björn -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] Updated: mysql-5.5.28-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.28-1
*** mysqld-5.5.28-1
*** mysql-test-5.5.28-1
*** libmysqlclient18-5.5.28-1
*** libmysqlclient-devel-5.5.28-1
*** libmysqld0-5.5.28-1
*** libmysqld-devel-5.5.28-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
This is an update to the latest upstream release.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
[ANNOUNCEMENT] Updated: mysql-5.5.25-1, perl-DBD-mysql-4.021-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.25-1
*** mysqld-5.5.25-1
*** mysql-test-5.5.25-1
*** libmysqlclient18-5.5.25-1
*** libmysqlclient-devel-5.5.25-1
*** libmysqld0-5.5.25-1
*** libmysqld-devel-5.5.25-1
*** perl-DBD-mysql-4.021-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
These are updates to the latest upstream releases, and include a fix for
CVE-2012-2122.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Updated: mysql-5.5.25-1, perl-DBD-mysql-4.021-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.25-1
*** mysqld-5.5.25-1
*** mysql-test-5.5.25-1
*** libmysqlclient18-5.5.25-1
*** libmysqlclient-devel-5.5.25-1
*** libmysqld0-5.5.25-1
*** libmysqld-devel-5.5.25-1
*** perl-DBD-mysql-4.021-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
These are updates to the latest upstream releases, and include a fix for
CVE-2012-2122.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
[ANNOUNCEMENT] Updated: mysql-5.5.21-1, odbc-msyql-5.1.10-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.21-1
*** mysqld-5.5.21-1
*** mysql-test-5.5.21-1
*** libmysqlclient18-5.5.21-1
*** libmysqlclient-devel-5.5.21-1
*** libmysqld0-5.5.21-1
*** libmysqld-devel-5.5.21-1
*** odbc-mysql-5.1.10-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
These are updates to the latest upstream releases, built for openssl-1.0.1.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Updated: mysql-5.5.21-1, odbc-msyql-5.1.10-1
The following packages have been updated for the Cygwin distribution:
*** mysql-5.5.21-1
*** mysqld-5.5.21-1
*** mysql-test-5.5.21-1
*** libmysqlclient18-5.5.21-1
*** libmysqlclient-devel-5.5.21-1
*** libmysqld0-5.5.21-1
*** libmysqld-devel-5.5.21-1
*** odbc-mysql-5.1.10-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component would be welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
These are updates to the latest upstream releases, built for openssl-1.0.1.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
[GTG] Re: [ITP] libiodbc, freetds, mysql, phonon (qt4 deps)
Yaakov writes: On Tue, 2012-02-28 at 17:43 -0600, Yaakov (Cygwin/X) wrote: * Phonon: ftp://ftp.cygwinports.org/pub/cygwinports/uploads/phonon/ I almost forgot: * automoc4 (build-time dependency of Phonon): ftp://ftp.cygwinports.org/pub/cygwinports/release-2/KDE/automoc4/ Builds fine from source, packaging and setup.hint look good Yaakov Ciao Volker
[GTG] Re: [ITP] libiodbc, freetds, mysql, phonon (qt4 deps)
Yaakov writes: poppler includes qt4 bindings, so I can't delay the qt4 upgrade any longer. These new dependencies are already in major distros. (FWIW, this would also resolve the missing dependencies for ITPing PHP.) * iODBC: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/libiodbc/ Builds fine from source, packaging and setup.hint look good ftp://ftp.cygwinports.org/pub/cygwinports/release-2/odbc-psql/ Packaging and setup.hint look good ftp://ftp.cygwinports.org/pub/cygwinports/release-2/odbc-sqlite3/ Packaging and setup.hint look good There are two ODBC implementations for *NIX: iODBC and unixODBC. There is no reason for both and they partially conflict; I chose iODBC for various technical reasons. Drivers for PostreSQL and SQLite3, the SQL engines already in the distro, are available separately. * FreeTDS: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/freetds/ Packaging and setup.hint look good Includes an ODBC driver. * MySQL: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/mysql/ Builds fine from source, packaging and setup.hint look good ftp://ftp.cygwinports.org/pub/cygwinports/release-2/Perl/perl-DBI/ Packaging and setup.hint look good ftp://ftp.cygwinports.org/pub/cygwinports/release-2/Perl/perl-DBD-mysql/ Packaging and setup.hint look good ftp://ftp.cygwinports.org/pub/cygwinports/release-2/odbc-mysql/ Packaging and setup.hint look good I consider the server to be experimental and not for production use. The client side is working fine, as does the embedded server as best as I can tell (amarok uses it). The perl modules are required for some of the server administration scripts. Also includes the upstream ODBC driver. * Phonon: ftp://ftp.cygwinports.org/pub/cygwinports/uploads/phonon/ Packaging and setup.hint look good While an older version is shipped with Qt itself, KDE requires the newer versions they ship. I hacked the qt4 build to use this version, so its used by QtWebKit, qtconfig, and qtdemo. Phonon uses backends, so this won't do anything yet until I ITP GStreamer, but that can wait for the moment. Yaakov Ciao Volker
Re: [GTG] Re: [ITP] libiodbc, freetds, mysql, phonon (qt4 deps)
Volker Zell writes: Yaakov writes: * FreeTDS: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/freetds/ Packaging and setup.hint look good Actually I think this package should provide postinstall scripts for copying the following files into /etc/freetds locales.conf freetds.conf pool.conf otherwise when the user changes them, they will be overwritten. Ciao Volker
[ANNOUNCEMENT] New packages: mysql, odbc-mysql, perl-DBD-mysql
The following packages have been added to the Cygwin distribution:
*** mysql-5.5.20-1
*** mysqld-5.5.20-1
*** mysql-test-5.5.20-1
*** libmysqlclient18-5.5.20-1
*** libmysqlclient-devel-5.5.20-1
*** libmysqld0-5.5.20-1
*** libmysqld-devel-5.5.20-1
*** odbc-mysql-5.1.9-1
*** perl-DBD-mysql-4.020-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component is welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
ODBC and Perl DBI drivers are also provided.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
New packages: mysql, odbc-mysql, perl-DBD-mysql
The following packages have been added to the Cygwin distribution:
*** mysql-5.5.20-1
*** mysqld-5.5.20-1
*** mysql-test-5.5.20-1
*** libmysqlclient18-5.5.20-1
*** libmysqlclient-devel-5.5.20-1
*** libmysqld0-5.5.20-1
*** libmysqld-devel-5.5.20-1
*** odbc-mysql-5.1.9-1
*** perl-DBD-mysql-4.020-1
MySQL Community Edition is a freely downloadable version of the world's
most popular open source database that is supported by an active
community of open source developers and enthusiasts.
Please note that the server ('mysqld' package) should be considered
*experimental*; for production use, I suggest using a native Windows
version from dev.mysql.com. Input from experienced MySQL server
administrators to improve this component is welcome.
The client library and apps are stable, but when connecting to a native
Windows MySQL server on the same machine, you MUST use 127.0.0.1 as the
hostname; 'localhost' is reserved for connecting to the Cygwin mysqld
via a UNIX socket.
ODBC and Perl DBI drivers are also provided.
--
Yaakov
Cygwin/X
CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
If you want to unsubscribe from the cygwin-announce mailing list, please
use the automated form at:
http://cygwin.com/lists.html#subscribe-unsubscribe
If this does not work, then look at the List-Unsubscribe: tag in the
email header of this message. Send email to the address specified
there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain@cygwin.com
If you need more information on unsubscribing, start reading here:
http://sourceware.org/lists.html#unsubscribe-simple
Please read *all* of the information on unsubscribing that is available
starting at this URL.
Re: [ITP] libiodbc, freetds, mysql, phonon (qt4 deps)
On Tue, 2012-02-28 at 17:43 -0600, Yaakov (Cygwin/X) wrote: * Phonon: ftp://ftp.cygwinports.org/pub/cygwinports/uploads/phonon/ I almost forgot: * automoc4 (build-time dependency of Phonon): ftp://ftp.cygwinports.org/pub/cygwinports/release-2/KDE/automoc4/ Yaakov
[ITP] libiodbc, freetds, mysql, phonon (qt4 deps)
poppler includes qt4 bindings, so I can't delay the qt4 upgrade any longer. These new dependencies are already in major distros. (FWIW, this would also resolve the missing dependencies for ITPing PHP.) * iODBC: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/libiodbc/ ftp://ftp.cygwinports.org/pub/cygwinports/release-2/odbc-psql/ ftp://ftp.cygwinports.org/pub/cygwinports/release-2/odbc-sqlite3/ There are two ODBC implementations for *NIX: iODBC and unixODBC. There is no reason for both and they partially conflict; I chose iODBC for various technical reasons. Drivers for PostreSQL and SQLite3, the SQL engines already in the distro, are available separately. * FreeTDS: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/freetds/ Includes an ODBC driver. * MySQL: ftp://ftp.cygwinports.org/pub/cygwinports/release-2/mysql/ ftp://ftp.cygwinports.org/pub/cygwinports/release-2/Perl/perl-DBI/ ftp://ftp.cygwinports.org/pub/cygwinports/release-2/Perl/perl-DBD-mysql/ ftp://ftp.cygwinports.org/pub/cygwinports/release-2/odbc-mysql/ I consider the server to be experimental and not for production use. The client side is working fine, as does the embedded server as best as I can tell (amarok uses it). The perl modules are required for some of the server administration scripts. Also includes the upstream ODBC driver. * Phonon: ftp://ftp.cygwinports.org/pub/cygwinports/uploads/phonon/ While an older version is shipped with Qt itself, KDE requires the newer versions they ship. I hacked the qt4 build to use this version, so its used by QtWebKit, qtconfig, and qtdemo. Phonon uses backends, so this won't do anything yet until I ITP GStreamer, but that can wait for the moment. Yaakov
Re: Back to mysql
Andrew DeFaria and...@defaria.com was heard to say: On 12/13/2010 09:47 PM, Yaakov (Cygwin/X) wrote: mysql_config is YA foo-config script as included in some -devel packages. Can you translate that into English? What's a YA foo-config script? YA: yet another. A strong indication that mysql_config isn't the first of its kind. foo-config: config script shipped with the foo package. You invoke it in your Makefile or in configure to insert the proper -L, -I, and -lib options in your gcc invocations. This way it's not the configure script of packages that use foo, but the foo package itself that figures out how to invoke the compiler/linker properly and where to find the dev files shipped with foo. regards, Markus -- Markus Hoenicka http://www.mhoenicka.de AQ score 38 -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Back to mysql
On 14 December 2010 03:37, Andrew DeFaria wrote: You can get mysql, libmysql*, perl-DBI, and perl-DBD-mysql from Ports. Never been to Ports. Can you elaborate? Cygwin Ports, at http://sourceware.org/cygwinports. A quite amazing repository of additional Cygwin packages, all maintained by Yaakov. Thanks to recent improvements to Cygwin's setup.exe by Jon Turney, the timestamp hack shown on the Ports website is no longer needed, i.e. the steps required now are: 1. Download the latest Cygwin setup.exe from http://cygwin.com. 2. Launch setup.exe with the -X flag (for allowing unsigned repositories). A convenient way to do this is to create a setup.exe shortcut and add the -X to its target. 3. Add and select ftp://sourceware.org/pub/cygwinports or one of its mirrors (http://sourceware.org/mirrors.html) in the mirror list. (Official mirrors and Ports ones can be selected at the same time; just hold Ctrl while doing so. Unfortunately there's currently no way to tell apart different repositories on the same mirror, but Jon is working on that as well.) 4. Select the packages of your choice and install. Ports issues should be discussed on the cygwin-ports-general mailing list. Andy -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Back to mysql
On 12/14/2010 04:21 AM, Andy Koppe wrote: Cygwin Ports, at http://sourceware.org/cygwinports. A quite amazing repository of additional Cygwin packages, all maintained by Yaakov. Thanks to recent improvements to Cygwin's setup.exe by Jon Turney, the timestamp hack shown on the Ports website is no longer needed, i.e. the steps required now are: 1. Download the latest Cygwin setup.exe from http://cygwin.com. 2. Launch setup.exe with the -X flag (for allowing unsigned repositories). A convenient way to do this is to create a setup.exe shortcut and add the -X to its target. 3. Add and select ftp://sourceware.org/pub/cygwinports or one of its mirrors (http://sourceware.org/mirrors.html) in the mirror list. (Official mirrors and Ports ones can be selected at the same time; just hold Ctrl while doing so. Unfortunately there's currently no way to tell apart different repositories on the same mirror, but Jon is working on that as well.) 4. Select the packages of your choice and install. Ports issues should be discussed on the cygwin-ports-general mailing list. Thanks for the explanation. I'm working on a Perl script to gather information about systems and store it in a MySQL database. As such I can't always be sure that Cygwin (thus Perl and even DBI, DBD and MySQL) will be there. Installing DBI and DBD is pretty simply with cpan and to me Cygwin's a no brainer. But having to install a port of the mysql-client stuff seems like hacking a bit to far. Any particular reason why mysql-client is not an official (perhaps optionally installed) part of Cygwin by now? I remember working with this a while back (years back actually) and there was a separate mysql package that somebody put together (probably from cygports). I just would have thought that by now it would have been put into Cygwin in a more official manner. Any thoughts about how to do this without Cygwin (I know, not Cygwin related then and I'd probably need to get some sort of Perl - can you say ActiveState! Yuck - and install some Windows based mysql libs or something like that... Yuck. Cygwin's just so much nicer. Wish mysql was simply YA Cygwin package). -- Andrew DeFaria http://defaria.com Beauty is in the eye of the beer holder. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Back to mysql
On 12/14/2010 8:57 AM, Andrew DeFaria wrote: I remember working with this a while back (years back actually) and there was a separate mysql package that somebody put together (probably from cygports). I just would have thought that by now it would have been put into Cygwin in a more official manner. As with all packages, it needs a maintainer to become an official package. -- Larry _ A: Yes. Q: Are you sure? A: Because it reverses the logical flow of conversation. Q: Why is top posting annoying in email? -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Back to mysql
I'm trying to port a Perl script of mine that uses DBI and DBD::mysql to update a database running on another, Linux, server. I have been able to install DBI (cpan DBI) and get it to compile, but I cannot get DBD::mysql to install. When I try I get Can't exec mysql_config: No such file or directory at Makefile.PL line 464. Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located My understanding is that this mysql_config is only present when you install mysql_client (well on a Linux system it's called mysql_client) but IIRC there is no mysql_client for Cygwin - or is there? Any workarounds? Is there a way I can install the Windows version of mysql_client and have Cygwin's Perl interact with it? -- Andrew DeFaria http://defaria.com Nostalgia isn't what it used to be. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Back to mysql
On Mon, 2010-12-13 at 18:52 -0500, Andrew DeFaria wrote: I'm trying to port a Perl script of mine that uses DBI and DBD::mysql to update a database running on another, Linux, server. I have been able to install DBI (cpan DBI) and get it to compile, but I cannot get DBD::mysql to install. When I try I get Can't exec mysql_config: No such file or directory at Makefile.PL line 464. Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located My understanding is that this mysql_config is only present when you install mysql_client (well on a Linux system it's called mysql_client) but IIRC there is no mysql_client for Cygwin - or is there? Any workarounds? Is there a way I can install the Windows version of mysql_client and have Cygwin's Perl interact with it? mysql_config is YA foo-config script as included in some -devel packages. You can get mysql, libmysql*, perl-DBI, and perl-DBD-mysql from Ports. Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Back to mysql
On 12/13/2010 09:47 PM, Yaakov (Cygwin/X) wrote: mysql_config is YA foo-config script as included in some -devel packages. Can you translate that into English? What's a YA foo-config script? Which -devel packages does it appear in? You can get mysql, libmysql*, perl-DBI, and perl-DBD-mysql from Ports. Never been to Ports. Can you elaborate? -- Andrew DeFaria http://defaria.com When companies ship Styrofoam, what do they pack it in? -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Back to mysql
it's likely cygports, see http://sourceware.org/cygwinports/ I didn't check if those packages are there though On Mon, Dec 13, 2010 at 10:37 PM, Andrew DeFaria and...@defaria.com wrote: On 12/13/2010 09:47 PM, Yaakov (Cygwin/X) wrote: mysql_config is YA foo-config script as included in some -devel packages. Can you translate that into English? What's a YA foo-config script? Which -devel packages does it appear in? You can get mysql, libmysql*, perl-DBI, and perl-DBD-mysql from Ports. Never been to Ports. Can you elaborate? -- Andrew DeFaria http://defaria.com When companies ship Styrofoam, what do they pack it in? -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
MySQL?
Hello! Has MySQL ever been successfully ported to Cygwin? I recall as we were making the move towards 1.7 that it came up several times. - Gregg C Levine gregg.drw...@gmail.com This signature fought the Time Wars, time and again. -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL?
On Thu, 2010-08-19 at 13:22 -0400, Gregg Levine wrote: Has MySQL ever been successfully ported to Cygwin? I recall as we were making the move towards 1.7 that it came up several times. Cygwin Ports provides MySQL packages. The clients are fine, but I do not guarantee that the server is usable, although I think it should be if properly configured. YMMV. Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Error with libtool when compiling MySQL
make fails when building MySQL 5.1.48, using libtool: make[3]: Entering directory `/home/Eric Thompson/My Documents/Downloads/mysql-5.1.48/unittest/mytap/t' /bin/sh ../../../libtool --preserve-dup-deps --tag=CC --mode=link gcc -O2 -L../../../unittest/mytap -o basic-t.exe basic-t.o -lmytap -lcrypt -lm libtool: link: cannot find the library `' or unhandled argument `Thompson/My'\ Path is truncated. What could cause this? Thanks, Jet -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
R: Error with libtool when compiling MySQL
--- Gio 1/7/10, Jet Thompson ha scritto: make fails when building MySQL 5.1.48, using libtool: make[3]: Entering directory `/home/Eric Thompson/My ^^ a space in the path Documents/Downloads/mysql-5.1.48/unittest/mytap/t' /bin/sh ../../../libtool --preserve-dup-deps --tag=CC --mode=link gcc -O2 -L../../../unittest/mytap -o basic-t.exe basic-t.o -lmytap -lcrypt -lm libtool: link: cannot find the library `' or unhandled argument `Thompson/My'\ Path is truncated. What could cause this? try to build in a path with no space at all Thanks, Jet Marco -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL client, prompt, redux
Yaakov (Cygwin/X) yselkow...@users.sourceforge.net was heard to say: What do you mean by local server? If you mean a Win32-native server, that case is clearly noted in the mysql Cygwin README. If you mean the mysqld which is provided by the Ports package, further discussion thereof would be welcome on the cygwin-ports-general list. I'm sorry I wasn't explicit enough here. The problem occurs if I connect to a Win32 mysqld. I don't use the Cygwin mysqld at this time. I thought I'd mention this limitation because people may try the Cygwin client and go like great, this !#**# doesn't work either if they are not aware they have to use the -h option in this particular case. This was not intended to create the impression something's wrong with your port. regards, Markus -- Markus Hoenicka http://www.mhoenicka.de AQ score 38 -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL client, prompt, redux
On 2010-04-07 01:06, Tim McDaniel wrote: From Google searches and some experience, it appears that it's a long-standing situation that, if you run the mysql.exe client program under mintty or rxvt from Cygwin, then mysql figures that it's not on an interactive terminal and therefore does not prompt. Is there yet any workaround other than simply using cmd.exe instead? (In mintty, BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason that mysql alone doesn't prompt.) When I run cygwin inside a TakeCommand shell, I do get a working mysql client program. You might want to check it out (it's a commercial app, however), see http://jpsoft.com/ Also, I see that the just released beta of MySQL Workbench has a proper command interpreter now, another option you might be interested in. - Eric Lilja -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL client, prompt, redux
Jeremy Bopp jer...@bopp.net was heard to say: real Windows console which mintty and rxvt are unable to provide. If there is no mysql package in the Cygwin repository, have you tried to see if Cygwin Ports has a Cygwin-native build which will work for you? This is just to confirm, for the sake of the archive's completeness, that Cygwin Ports has builds, or patch sets if you prefer to build them from scratch, and that these Cygwin builds provide a working command prompt. The only downside is that I don't seem to be able to connect through a socket, so I always have to use the network layer (via the -h hostname option) to connect to my local server. regards, Markus -- Markus Hoenicka http://www.mhoenicka.de AQ score 38 -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL client, prompt, redux
On 2010-04-07 09:24, Markus Hoenicka wrote: This is just to confirm, for the sake of the archive's completeness, that Cygwin Ports has builds, or patch sets if you prefer to build them from scratch, and that these Cygwin builds provide a working command prompt. The only downside is that I don't seem to be able to connect through a socket, so I always have to use the network layer (via the -h hostname option) to connect to my local server. What do you mean by local server? If you mean a Win32-native server, that case is clearly noted in the mysql Cygwin README. If you mean the mysqld which is provided by the Ports package, further discussion thereof would be welcome on the cygwin-ports-general list. Yaakov Cygwin Ports -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
MySQL client, prompt, redux
From Google searches and some experience, it appears that it's a long-standing situation that, if you run the mysql.exe client program under mintty or rxvt from Cygwin, then mysql figures that it's not on an interactive terminal and therefore does not prompt. Is there yet any workaround other than simply using cmd.exe instead? (In mintty, BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason that mysql alone doesn't prompt.) -- Tim McDaniel, t...@panix.com -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL client, prompt, redux
Tim McDaniel wrote: From Google searches and some experience, it appears that it's a long-standing situation that, if you run the mysql.exe client program under mintty or rxvt from Cygwin, then mysql figures that it's not on an interactive terminal and therefore does not prompt. Is there yet any workaround other than simply using cmd.exe instead? (In mintty, BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason that mysql alone doesn't prompt.) If you are using the Windows-native build of the mysql client, then there is no way to fix this. That build of the client expects to have a real Windows console which mintty and rxvt are unable to provide. If there is no mysql package in the Cygwin repository, have you tried to see if Cygwin Ports has a Cygwin-native build which will work for you? -Jeremy -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: MySQL client, prompt, redux
Jeremy Bopp: Tim McDaniel wrote: From Google searches and some experience, it appears that it's a long-standing situation that, if you run the mysql.exe client program under mintty or rxvt from Cygwin, then mysql figures that it's not on an interactive terminal and therefore does not prompt. Is there yet any workaround other than simply using cmd.exe instead? (In mintty, BTW, cmd /c mysql ... doesn't prompt, presumably for the same reason that mysql alone doesn't prompt.) If you are using the Windows-native build of the mysql client, then there is no way to fix this. That build of the client expects to have a real Windows console which mintty and rxvt are unable to provide. Yep. It probably calls isatty() on the standard streams, which in the case of the Windows C library (MSVCRT) returns false for pipes, which Cygwin's pty emulation is based on. It shouldn't be horrendously difficult, however, to add a switch for forcing interactive mode to the mysql client. Python does have such a switch. Perhaps you could raise this on the relevant mysql mailing list? Andy -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Error when compiling mySQL client libraries
While trying to compile mySQL 5.1.34 client libraries, I get the following errors : In file included from readline.c:54: readline/readline.h:70:29: error: sys/ttydefaults.h: No such file or directory make[2]: *** [readline.o] Error 1 make[2]: Leaving directory `/home/beq00908/mv_builds/mysql-5.1.34/cmd-line-utils/libedit' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/beq00908/mv_builds/mysql-5.1.34/cmd-line-utils' make: *** [all-recursive] Error 1 In which package is sys/ttydefaults.h supposed to be ? Regards, Jurgen -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: Error when compiling mySQL client libraries
On 1/27/2010 5:53 AM, Jurgen Defurne wrote:
In which package is sys/ttydefaults.h supposed to be ?
One answers such questions with this: http://www.cygwin.com/packages/
The answer is no package, which then calls into question how the MySQL
maintainers came to believe they should #include that file.
MySQL has always been somewhat screwy to build on Cygwin, no doubt in
large part because there's a perfectly good and far faster native version.
I assume you are only after the client libraries, not the DB server.
You may find that you can make it build by skipping the parts you don't
need. Try something like this:
$ ./configure --without-{debug,readline,libedit,server}
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
R: Error when compiling mySQL client libraries
--- Mer 27/1/10, Jurgen Defurne ha scritto: While trying to compile mySQL 5.1.34 client libraries, I get the following errors : In file included from readline.c:54: readline/readline.h:70:29: error: sys/ttydefaults.h: No such file or directory make[2]: *** [readline.o] Error 1 make[2]: Leaving directory `/home/beq00908/mv_builds/mysql-5.1.34/cmd-line-utils/libedit' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/beq00908/mv_builds/mysql-5.1.34/cmd-line-utils' make: *** [all-recursive] Error 1 In which package is sys/ttydefaults.h supposed to be ? Regards, Jurgen Hi Jurgen, there is a fault in the editline/libedit package.. When I built it for another package from http://thrysoee.dk/editline/ I modified as : --- origsrc/libedit-20090923-3.0/src/editline/readline.h2009-09-23 23:04:26.0 +0200 +++ src/libedit-20090923-3.0/src/editline/readline.h2009-09-27 21:53:26.0 +0200 @@ -75,7 +75,7 @@ typedef KEYMAP_ENTRY *Keymap; #ifndef CTRL #include sys/ioctl.h -#if !defined(__sun) !defined(__hpux) !defined(_AIX) +#if !defined(__sun) !defined(__hpux) !defined(_AIX) !defined(__CYGWIN__) #include sys/ttydefaults.h #endif #ifndef CTRL see attached the full patch. Is someone interested to have libedit package in cygwin ? Regards Marco --- origsrc/libedit-20090923-3.0/src/editline/readline.h 2009-09-23 23:04:26.0 +0200 +++ src/libedit-20090923-3.0/src/editline/readline.h 2009-09-27 21:53:26.0 +0200 @@ -75,7 +75,7 @@ typedef KEYMAP_ENTRY *Keymap; #ifndef CTRL #include sys/ioctl.h -#if !defined(__sun) !defined(__hpux) !defined(_AIX) +#if !defined(__sun) !defined(__hpux) !defined(_AIX) !defined(__CYGWIN__) #include sys/ttydefaults.h #endif #ifndef CTRL --- origsrc/libedit-20090923-3.0/src/vi.c 2009-09-23 23:04:26.0 +0200 +++ src/libedit-20090923-3.0/src/vi.c 2009-09-27 21:56:26.0 +0200 @@ -916,6 +916,11 @@ vi_comment_out(EditLine *el, int c) * NB: posix implies that we should enter insert mode, however * this is against historical precedent... */ + +#ifdef __CYGWIN__ +#undef __weak_reference +#endif + #ifdef __weak_reference extern char *get_alias_text(const char *) __weak_reference(get_alias_text); #endif -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: R: Error when compiling mySQL client libraries
On 27/01/2010 07:49, Marco Atzeri wrote: there is a fault in the editline/libedit package.. When I built it for another package from http://thrysoee.dk/editline/ I modified as : Is someone interested to have libedit package in cygwin ? I think not, readline already serves that purpose. But there are MySQL packages in Cygwin Ports; I don't guarantee, however, that the server is stable or even usable. Yaakov -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: R: Error when compiling mySQL client libraries
--- Mer 27/1/10, Yaakov (Cygwin/X) ha scritto: On 27/01/2010 07:49, Marco Atzeri wrote: there is a fault in the editline/libedit package.. When I built it for another package from http://thrysoee.dk/editline/ I modified as : Is someone interested to have libedit package in cygwin ? I think not, readline already serves that purpose. usually yes, but packages like ngspice prefer it versus readline. Eventually there are others. Yaakov Marco -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Re: cygwin/mysql entering password, some characters plain text
William Finn-2 wrote: I just freshly installed cygwin along with a variety of other things. When attempting to connect to mysql from within a cygwin bash shell, it goes something like this: [EMAIL PROTECTED]:~] $ mysql -uroot -p Enter password: **ldk*jvjl* ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) [EMAIL PROTECTED]:~] $ ldkjvjl bash: ldkjvjl: command not found When typing my password (slowly, quickly, whatever), some of the characters show up in plain text and apparently are not sent as part of the password. If I try to type anything on the prompt after attempting to connect, it first prints all of those characters. I tried reinstalling all the base modules for cygwin, same effect. The windows command prompt has no problems. Has anybody encountered something like this before? Yes, I get this as well. Sometimes on the first attempt it doesn't happen, but then on the second execution of the mysql command it does. I had never before seen mixed *'s and characters, but seeing your note here I tried holding down a single key and saw mixed for the first time. I did this a couple of times and then I was able to type in the whole password with getting any non-hidden char's mixed in. This has plagued me for a long while (years), and it also happens when I SSH into my XP box. -Jaz -- View this message in context: http://www.nabble.com/cygwin-mysql-entering-password%2C-some-characters-plain-text-tp17348791p19070070.html Sent from the Cygwin list mailing list archive at Nabble.com. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
MySql doesn't work in cygwin
Hi! I installed mysql 5 from the source(in version 5.0.45,with ./configure then make install).Allright, but when I try to lauch (mysql -u root -p, after put password) this error occurs: can't connect to local Mysql Server through socket '/tmp/mysql.sock' Bellow, my mysql options in my.cnt [client] port = 3306 socket = /var/tmp/mysql.sock [mysqld] port = 3306 socket = /var/tmp/mysql.sock datadir = /usr/local/mysql/data I try this configuration to I'm my file my.cnt I put this: # The following options will be passed to all MySQL clients [client] password = admin port= 3306 # The MySQL server [mysqld] port= 3306 and I try to connect with db: mysql -h 127.0.0.1 -u root -p So, after the password, this error happen: Error 2003 (HY000):Can't connect to MySQL server on '127.0.0.1' (111) the same occurs if I put host = 127.0.0.1. in the my.cnt and execute mysql -u root -p Why this kind of problem happen? Many post in others forum about this problem don't help me But I'm want just use mysql command line in the same way than I use in windows. Thank's for help me! -- View this message in context: http://www.nabble.com/MySql-doesn%27t-work-in-cygwin-tp17673717p17673717.html Sent from the Cygwin list mailing list archive at Nabble.com. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: MySql doesn't work in cygwin
Berable wrote: I installed mysql 5 from the source(in version 5.0.45,with ./configure then make install).Allright, but when I try to lauch (mysql -u root -p, after put password) this error occurs: can't connect to local Mysql Server through socket '/tmp/mysql.sock' How did you start the server? Everything that you've said indicates that you compiled the software and then tried running the client but without a server running that's never going to achieve anything. Note that if you want to use the Win32 server you can only use a TCP socket, not a unix socket, since the Win32 server doesn't have a notion of a unix domain socket. Brian -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: MySql doesn't work in cygwin
Berable wrote: can't connect to local Mysql Server through socket '/tmp/mysql.sock' [snip] socket = /var/tmp/mysql.sock Try changing /var/tmp to /tmp. Error 2003 (HY000):Can't connect to MySQL server on '127.0.0.1' (111) What are the results of this command: $ netstat -na |grep LISTEN Do you see anything listening on port 3306? But I'm want just use mysql command line My suggestion -- as one who has fought with this in the past -- is to just use the native Windows port, from mysql.com. If you really need a Cygwin client, you can pass flags to MySQL's configure script to build only the client stuff. You can then use the resulting mysql program and libmysqlclient library to connect to the native Windows server. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: MySql doesn't work in cygwin
Warren Young wrote: Berable wrote: can't connect to local Mysql Server through socket '/tmp/mysql.sock' [snip] socket = /var/tmp/mysql.sock Try changing /var/tmp to /tmp. Error 2003 (HY000):Can't connect to MySQL server on '127.0.0.1' (111) What are the results of this command: $ netstat -na |grep LISTEN Do you see anything listening on port 3306? But I'm want just use mysql command line My suggestion -- as one who has fought with this in the past -- is to just use the native Windows port, from mysql.com. If you really need a Cygwin client, you can pass flags to MySQL's configure script to build only the client stuff. You can then use the resulting mysql program and libmysqlclient library to connect to the native Windows server. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/ I can access the my mysql running in windows from cygwin, instead of mysql that I have installed in cygwin environment? How can I do this? I prefer this way... but I'm newbie in this subjectr Thank's -- View this message in context: http://www.nabble.com/MySql-doesn%27t-work-in-cygwin-tp17673717p17677561.html Sent from the Cygwin list mailing list archive at Nabble.com. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: MySql doesn't work in cygwin
Please keep replies on the mailing list. Berable wrote: I can access the my mysql running in windows from cygwin, instead of mysql that I have installed in cygwin environment? How can I do this? I prefer this way... but I'm newbie in this subjectr If you install the Windows port of the MySQL server from mysql.com, that will include the mysql command line program. You can use that from the Cygwin command line. If that's all you need, you don't need any special Cygwin support. If you need to develop Cygwin programs that act as MySQL clients, see README-Cygwin.txt in the MySQL++ distribution for instructions on how to build a Cygwin version of libmysqlclient: http://tangentsoft.net/mysql++/ Those instructions are valid even if you don't use MySQL++. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: MySql doesn't work in cygwin
But I have now this error ERROR 2005 (HY000): Unknown MySQL server host 127.0.0.1 (1) So , when I try start the server...another drug : [EMAIL PROTECTED]:mysql$ ./mysql.server start Starting MySQL/mysql.server: line 159: kill: (3208) - No such process ERROR! I'll to forgive with cygwin for Rails development, In the end of tunnel Ubuntu stay waitingrss I'll use instant rails and mysql on windows Thank's so much for help me guys Warren Young wrote: Please keep replies on the mailing list. Berable wrote: I can access the my mysql running in windows from cygwin, instead of mysql that I have installed in cygwin environment? How can I do this? I prefer this way... but I'm newbie in this subjectr If you install the Windows port of the MySQL server from mysql.com, that will include the mysql command line program. You can use that from the Cygwin command line. If that's all you need, you don't need any special Cygwin support. If you need to develop Cygwin programs that act as MySQL clients, see README-Cygwin.txt in the MySQL++ distribution for instructions on how to build a Cygwin version of libmysqlclient: http://tangentsoft.net/mysql++/ Those instructions are valid even if you don't use MySQL++. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/ -- View this message in context: http://www.nabble.com/MySql-doesn%27t-work-in-cygwin-tp17673717p17684322.html Sent from the Cygwin list mailing list archive at Nabble.com. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
cygwin/mysql entering password, some characters plain text
I just freshly installed cygwin along with a variety of other things. When attempting to connect to mysql from within a cygwin bash shell, it goes something like this: [EMAIL PROTECTED]:~] $ mysql -uroot -p Enter password: **ldk*jvjl* ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) [EMAIL PROTECTED]:~] $ ldkjvjl bash: ldkjvjl: command not found [EMAIL PROTECTED]:~] $ When typing my password (slowly, quickly, whatever), some of the characters show up in plain text and apparently are not sent as part of the password. If I try to type anything on the prompt after attempting to connect, it first prints all of those characters. I tried reinstalling all the base modules for cygwin, same effect. The windows command prompt has no problems. Has anybody encountered something like this before? cygcheck.out Description: cygcheck.out -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
mysql shared libraries.
Has anyone had any success compiling these on cygwin? I'm just installing a project I worked on a few years back, however it requires a little known eggdrop module that allows tcl calls to mysql (yes that's right :)). Compilation of the module however under cygwin could make for a lot of fun if I can get enough of the mysql libraries installed. thanks TF. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: mysql shared libraries.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 thefinn wrote: Has anyone had any success compiling these on cygwin? http://cygwin-ports.cvs.sourceforge.net/cygwin-ports/ports/db/mysql/ Yaakov Cygwin Ports -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Cygwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHGANSpiWmPGlmQSMRCLC9AJ9GTp1DSwBFtRC/R136XRo7CYlxhgCfeWqJ 97TPULPWa3WEzGf+BkaxzNQ= =hL43 -END PGP SIGNATURE- -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: Cygwin w/ Apache+mysql+php+Perl (win XP)
JamesStock wrote: Hi I am having issues w/ the following config: Rule of thumb: Don't use non Cygwin stuff with Cygwin stuff! Corollary: Well since Cygwin runs under Windows there are many interactions and you can use some (a lot) of non Cygwin stuff with Cygwin. Corollary #1: If you're gonna interface between Cygwin and non Cygwin, you'll have to hack, take into account the differences and do lots of experimentation. BTW: You'll probably do lots of this... OK. So, I have Apache, mysql, PHP and perl (activestate) installed in my XP (NOT through cygwin but installed individually). Stop. We know perl (activestate) is not Cygwin I assume Apache, Mysql and Php are similarly not Cygwin? Cygwin stuff works best with other Cygwin stuff. Piecemealing a bunch of Unix like utilities together from different places (perl: activestate, apache: apache.org, mysql: mysql.com, etc...) is asking for trouble (and I never understand why people insist on doing it! I mean why use PuTTY when Cygwin already provides ssh!) Why are you not simply using the Cygwin versions of all of these? I can use dos prompt and connect to mysql DB (e.g mysql -U -P?), Windows DOS box, running a Windows oriented mysql... I can also use Mysql-Front / SQLyog to connect to mysql (localhost of course). Whatever that is... But if I open an xterm through cygwin, I cannot connect to mysql (e.g mysql -U -P?). Ah so now you're using a Cygwin program (xterm) and a non-Cygwin program (mysql) Also the activestate perl (has DBD DBI mysql module installed) can access mysql db (through dos calling a pl script / using cgi through apache). Non-Cygwin perl (activestate) using a non-Cygwin mysql. But I cannot use perl through cygwin to connect to mysql. WHen I tried to do a 'mysql -U -P' through the xterm in cygwin, it'll just 'hang' and keep me waiting and waiting w/out errors.. Have you heard of ptys? They're what Unix uses when using things like xterm (BTW, stop the X server and use rxvt. Works like xterm but will also work without an X server using Windows widgets instead). Cygwin, being Unix-like, also uses them. Windows knowns nothing about them. So the Windows oriented mysql gets confused when it attempts to talk to you through stdout/stdin because those are connected to ptys, which Windows knows nothing about. Bottom line is it is talking to you (displaying the mysql banner and prompt) and it will listen to you (accept input). It's just that you don't see any of the output because it's sorta lost in the pty. Again, mixing Cygwin programs (xterm) with non-Cygwin programs (mysql). so I had to do a hard excape. What's that? Try just typing exit (blindly) and I bet you return to the shell prompt. also when I tried to execute the same perl script (the same script I used through dos prompt) through the xterm in cygwin, i cannot connect to mysql. Might be the same thing. Not sure if it's the same issue (mysql and perl), but how should I tackle them? Personally I would remove all of the non Cygwin versions of LAMP that you have there and install the Cygwin versions. They are designed to work well together. I know that the perl and mysql package is different b/w the one installed in windows and the one installed through cygwin. anyways I can have cygwin use the perl and mysql installed in windows? Maybe but it may take considerable effort. For example, Windows programs typically use \ as the directory separator whereas Cygwin uses /. To the shell the \ will need to be doubled. Again, just going all Cygwin (or all non-Cygwin if you must) would be much less hassle. when I do a 'which perl' it tells me it's using /usr/bin/perl while the perl (activestate) under windows is installed in another dir so it's definitely using a different perl package. When you type which perl *in the cygwin environment* it will be evaluated in that light. It's no wonder it would favor the Cygwin version. However, if the activestate perl was in say C:\Perl\bin you could do: $ export PATH=/cygdrive/c/perl/bin:$PATH and which perl would yield the activestate one. However I wouldn't advise that you do that. (BTW: Write a simple perl script to call setsid. Run it under activestate. What does it say?) I tried installed DBI:mysql bundle into the perl pkg in cygwin but it failed becoz it cannot find the mysql_config. so I cannot installed that. ANyhelp will be appreciated. thx I'm not sure of the status of the availability of mysql as a Cygwin package. I think that package just lacks an owner. My solution was to invest $400 and get a real Linux system instead. However if one were available (and I believe it is, somewhere, unofficially) then you could just install the Cygwin mysql then install (I suspect) the DBD::mysql (DBI is, as it's name implies, DataBase *Independent*). DBD is the DataBase Driver, of which there is a MySQL version... -- Andrew DeFaria http://defaria.com Why is it that when you
Cygwin w/ Apache+mysql+php+Perl (win XP)
Hi I am having issues w/ the following config: I have Apache, mysql, PHP and perl (activestate) installed in my XP (NOT through cygwin but installed individually). I can use dos prompt and connect to mysql DB (e.g mysql -U -P?), I can also use Mysql-Front / SQLyog to connect to mysql (localhost of course). But if I open an xterm through cygwin, I cannot connect to mysql (e.g mysql -U -P?). Also the activestate perl (has DBD DBI mysql module installed) can access mysql db (through dos calling a pl script / using cgi through apache). But I cannot use perl through cygwin to connect to mysql. WHen I tried to do a 'mysql -U -P' through the xterm in cygwin, it'll just 'hang' and keep me waiting and waiting w/out errors..so I had to do a hard excape. also when I tried to execute the same perl script (the same script I used through dos prompt) through the xterm in cygwin, i cannot connect to mysql. Not sure if it's the same issue (mysql and perl), but how should I tackle them? I know that the perl and mysql package is different b/w the one installed in windows and the one installed through cygwin. anyways I can have cygwin use the perl and mysql installed in windows? when I do a 'which perl' it tells me it's using /usr/bin/perl while the perl (activestate) under windows is installed in another dir so it's definitely using a different perl package. I tried installed DBI:mysql bundle into the perl pkg in cygwin but it failed becoz it cannot find the mysql_config. so I cannot installed that. ANyhelp will be appreciated. thx -- View this message in context: http://www.nabble.com/Cygwin-w--Apache%2Bmysql%2Bphp%2BPerl-%28win-XP%29-tf4357512.html#a12418256 Sent from the Cygwin Users mailing list archive at Nabble.com. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: Cygwin w/ Apache+mysql+php+Perl (win XP)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 JamesStock wrote: I have Apache, mysql, PHP and perl (activestate) installed in my XP (NOT through cygwin but installed individually). I can use dos prompt and connect to mysql DB (e.g mysql -U -P?), I can also use Mysql-Front / SQLyog to connect to mysql (localhost of course). But if I open an xterm through cygwin, I cannot connect to mysql (e.g mysql -U -P?). Try mysql -h 127.0.0.1. Yaakov -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Cygwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG13z6piWmPGlmQSMRCKApAKCmSxmNZRmwYF2xkQ+2hsUD2/wWqwCeJJ7N f6edttkh9YnPpgj4XyqiaSk= =rE38 -END PGP SIGNATURE- -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: Cygwin w/ Apache+mysql+php+Perl (win XP)
Hi, thx for the response. I tried w/ 'mysql -h 127.0.0.1 -u -p' (substitute the s w/ the appropriate username and passwd of course) and it seems to just 'hang' there w/out doing anything. If I entered an invalid username, it'll immediately give me ERROR 1045 (28000): Access denied for user '@'localhost' (Using password: YES). SO I am confused. Besides this mysql connection through cygwin, I have issues w/ the perl connecting to mysql through cygwin also. Everything through DOS / apache server is fine. - Yaakov (Cygwin Ports) wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 JamesStock wrote: I have Apache, mysql, PHP and perl (activestate) installed in my XP (NOT through cygwin but installed individually). I can use dos prompt and connect to mysql DB (e.g mysql -U -P?), I can also use Mysql-Front / SQLyog to connect to mysql (localhost of course). But if I open an xterm through cygwin, I cannot connect to mysql (e.g mysql -U -P?). Try mysql -h 127.0.0.1. Yaakov -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Cygwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG13z6piWmPGlmQSMRCKApAKCmSxmNZRmwYF2xkQ+2hsUD2/wWqwCeJJ7N f6edttkh9YnPpgj4XyqiaSk= =rE38 -END PGP SIGNATURE- -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/ -- View this message in context: http://www.nabble.com/Cygwin-w--Apache%2Bmysql%2Bphp%2BPerl-%28win-XP%29-tf4357512.html#a12420267 Sent from the Cygwin Users mailing list archive at Nabble.com. -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: Running mysql as a service ...
On Tue, 19 Jun 2007, Igor Peshansky wrote: http://cygwin.com/acronyms/#PCYMTWLL. Thanks. On Sat, 16 Jun 2007, Tilman Schröder wrote: Hello everyone, I just spend some frunstrating hours on figuring out how to run a self-compiled cygwin mysql daemon as a service (win xp). first of all: using cygrunsrv.exe did not work for me, I do not know why, the problem is that there is no error log file for cygrunsrv or i am too stupid and did not found the log file Check the Windows Event Log (under My Computer-Manage, or whatever the Deutsche equivalent is). You did not tell us what command you are using to install mysql as service (with cygrunsrv). Also, you didn't provide the error you are getting from cygrunsrv on the console (you must be getting something, even if it's service not started). Another option is to install syslog-ng and run that as a service. Then all errors will be logged wherever you configure them to be (e.g., in /var/log/mysqld.log)... then i tried this: C:\Programme\cygwin\bin\bash.exe -login -i -c /usr/local/mysql/libexec/mysqlmanager.exe --run-as-service this command opens up 3 console windows which are being closed immediately again and after this, the mysql-server runs in the background! The console windows are the consequence of the implicit -mconsole. If you compile with -mwindows instead, you'll lose the ability to display messages on the console, so that's probably not a good option. it's not a very good solution because this is no real service but just a command which can be put into the Autostart folder ... and now we have got a problem when more than one real windows user is logged in ... Does anyone know how to start the cygwin mysql server as a windows service ??? Would be very nice if somebody knew the trick ... Sure -- use cygrunsrv. Beyond that, you need to check various permissions (cygrunsrv will run as SYSTEM), and make sure the paths are in order, etc (e.g., c:\cygwin\bin needs to be in the PATH unless mysqld is in /bin). Forgot to mention: cygrunsrv is a wrapper to run a non-service (console) program as a service. That means that you'll need to put mysqld in non-daemon mode. Either that, or explore the --pid option of cygrunsrv (read the man page and the description in the User's Guide). Igor -- http://cs.nyu.edu/~pechtcha/ |\ _,,,---,,_[EMAIL PROTECTED] | [EMAIL PROTECTED] ZZZzz /,`.-'`'-. ;-;;,_Igor Peshansky, Ph.D. (name changed!) |,4- ) )-,_. ,\ ( `'-' old name: Igor Pechtchanski '---''(_/--' `-'\_) fL a.k.a JaguaR-R-R-r-r-r-.-.-. Meow! Freedom is just another word for nothing left to lose... -- Janis Joplin -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: Running mysql as a service ...
http://cygwin.com/acronyms/#PCYMTWLL. Thanks. On Sat, 16 Jun 2007, Tilman Schröder wrote: Hello everyone, I just spend some frunstrating hours on figuring out how to run a self-compiled cygwin mysql daemon as a service (win xp). first of all: using cygrunsrv.exe did not work for me, I do not know why, the problem is that there is no error log file for cygrunsrv or i am too stupid and did not found the log file Check the Windows Event Log (under My Computer-Manage, or whatever the Deutsche equivalent is). You did not tell us what command you are using to install mysql as service (with cygrunsrv). Also, you didn't provide the error you are getting from cygrunsrv on the console (you must be getting something, even if it's service not started). Another option is to install syslog-ng and run that as a service. Then all errors will be logged wherever you configure them to be (e.g., in /var/log/mysqld.log)... then i tried this: C:\Programme\cygwin\bin\bash.exe -login -i -c /usr/local/mysql/libexec/mysqlmanager.exe --run-as-service this command opens up 3 console windows which are being closed immediately again and after this, the mysql-server runs in the background! The console windows are the consequence of the implicit -mconsole. If you compile with -mwindows instead, you'll lose the ability to display messages on the console, so that's probably not a good option. it's not a very good solution because this is no real service but just a command which can be put into the Autostart folder ... and now we have got a problem when more than one real windows user is logged in ... Does anyone know how to start the cygwin mysql server as a windows service ??? Would be very nice if somebody knew the trick ... Sure -- use cygrunsrv. Beyond that, you need to check various permissions (cygrunsrv will run as SYSTEM), and make sure the paths are in order, etc (e.g., c:\cygwin\bin needs to be in the PATH unless mysqld is in /bin). BTW: no its not an option to use the precompiled windows mysql binaries because i need the php postscript extension on windows which needs pslib. and pslib can only be compiled within cygwin, not mingw or native windows. and if pslib only works in a cygwin environment, then the postscript extension and php have to be built within cygwin. but a cygwin php cannot be linked against windows binaries and therefor i need a cygwin version of mysql, too :( HTH, Igor -- http://cs.nyu.edu/~pechtcha/ |\ _,,,---,,_[EMAIL PROTECTED] | [EMAIL PROTECTED] ZZZzz /,`.-'`'-. ;-;;,_Igor Peshansky, Ph.D. (name changed!) |,4- ) )-,_. ,\ ( `'-' old name: Igor Pechtchanski '---''(_/--' `-'\_) fL a.k.a JaguaR-R-R-r-r-r-.-.-. Meow! Freedom is just another word for nothing left to lose... -- Janis Joplin -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Re: Running mysql as a service ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, Igor Peshansky wrote: On Tue, 19 Jun 2007, Igor Peshansky wrote: http://cygwin.com/acronyms/#PCYMTWLL. Thanks. On Sat, 16 Jun 2007, Tilman Schröder wrote: Hello everyone, I just spend some frunstrating hours on figuring out how to run a self-compiled cygwin mysql daemon as a service (win xp). first of all: using cygrunsrv.exe did not work for me, I do not know why, the problem is that there is no error log file for cygrunsrv or i am too stupid and did not found the log file Check the Windows Event Log (under My Computer-Manage, or whatever the Deutsche equivalent is). You did not tell us what command you are using to install mysql as service (with cygrunsrv). Also, you didn't provide the error you are getting from cygrunsrv on the console (you must be getting something, even if it's service not started). Another option is to install syslog-ng and run that as a service. Then all errors will be logged wherever you configure them to be (e.g., in /var/log/mysqld.log)... then i tried this: C:\Programme\cygwin\bin\bash.exe -login -i -c /usr/local/mysql/libexec/mysqlmanager.exe --run-as-service this command opens up 3 console windows which are being closed immediately again and after this, the mysql-server runs in the background! The console windows are the consequence of the implicit -mconsole. If you compile with -mwindows instead, you'll lose the ability to display messages on the console, so that's probably not a good option. it's not a very good solution because this is no real service but just a command which can be put into the Autostart folder ... and now we have got a problem when more than one real windows user is logged in ... Does anyone know how to start the cygwin mysql server as a windows service ??? Would be very nice if somebody knew the trick ... Sure -- use cygrunsrv. Beyond that, you need to check various permissions (cygrunsrv will run as SYSTEM), and make sure the paths are in order, etc (e.g., c:\cygwin\bin needs to be in the PATH unless mysqld is in /bin). Forgot to mention: cygrunsrv is a wrapper to run a non-service (console) program as a service. That means that you'll need to put mysqld in non-daemon mode. Either that, or explore the --pid option of cygrunsrv (read the man page and the description in the User's Guide). Igor Thank you for your tips, but I changed the way to achieve my goal ... I ported the app to fpdf, a free pdf creation class for php which does not require any external library. Then I converted the pdf to postscript using ghostscript and then sending the postscript-file to the printer using the program printfile (http://www.lerup.com/printfile/) ... I've had enough problems with cygwin and I had lots of problems with ghostscript+printfile, too, I am happy now because it just works and will work for the next 5 years ... Perhaps somebody has got a similar problem and finds this thread :) Bye, Tilman -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGd/0ZxWHJ8ml5laIRAtorAKCLQIw/JghKOGWyfniISwAcHoVkPgCdGm09 9HVAdqj4iGXRZNpkxMpw/ZE= =xT5v -END PGP SIGNATURE- -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
RE: Running mysql as a service ...
On 19 June 2007 16:58, Tilman Schröder wrote: On Sat, 16 Jun 2007, Tilman Schröder wrote: Hello everyone, I just spend some frunstrating hours on figuring out how to run a self-compiled cygwin mysql daemon as a service (win xp). Thank you for your tips, but I changed the way to achieve my goal ... I ported the app to fpdf, a free pdf creation class for php which does not require any external library. Then I converted the pdf to postscript using ghostscript and then sending the postscript-file to the printer using the program printfile (http://www.lerup.com/printfile/) ... I've had enough problems with cygwin and I had lots of problems with ghostscript+printfile, too, I am happy now because it just works and will work for the next 5 years ... To be honest, if you have been having difficulty using mysql to convert files between postscript and pdf, that's probably not actually Cygwin's fault... cheers, DaveK -- Can't think of a witty .sigline today -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
