MySQL Forums - Perl

WARNING: MYSQL_OPT_RECONNECT (no replies)

Alan Dunwell — Sun, 23 Nov 2025 19:44:35 +0000

Howdy All,

Running Alma9
> mysql -V
mysql Ver 15.1 Distrib 10.5.29-MariaDB, for Linux (x86_64) using EditLine wrapper

I am NOT a mysql/mariadb guru

I have a perl script run via a cron job that takes data from a solar array every 10 minutes and plugs it into a mariadb database.
Starting ~ the first week of November there was an update/upgrade of Alma9 and there after the script, while still working fine and taking the data, started throwing and error message from the cron job that says

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
version

This was an old message and problem back in ~2023 but searching around I see nothing about it recently. Clearly it is just a warning, but I could find nothing about what is needed to be changed in my code. Given the info on the warning message I think it relates to how one makes the connection to the db. The relevant lines in my file where I make the connection are

---------------
use strict;
use warnings;
use DBI;
#use CGI;
use Device::SerialPort;
use lib '/usr/local/solar-web_monitor/cgi-bin';
use localvars;

my $db = DBI->connect ("DBI:mysql:$mysql_db:$mysql_host", $mysql_user, $mysql_passwd, {RaiseError => 1})>
#
-----------------

Any info as to how to change this, or where to look elsewhere in my code, so as to kill off the warning message is appreciated.

authentication from .cgi scripts (no replies)

Alan Dunwell — Sun, 29 Sep 2024 20:00:48 +0000

Howdy Gang,
New forum user here so let me know if I do anything off protocol.

I'm migrating some perl scripts from a CentOS7 machine to Alma9 and of course mysql/mariadb is a more recent version (10.5.22) and uses the new non-password type logins. Many of the .pl scripts are called from
/var/spool/cron/root
so of course they run even though the original scripts reference root@localhost and give a password. Since it is root runing the script it just ignores the PW bit.

However I also have .cgi scripts that use the same sort of DBI->connect type line for DB login. These script are getting run from a web page that runs the script and now it isn't root running the script and the login fails. In
/var/log/httpd/error_log I see lines like

[cgid:error] [pid 33953:tid 34123] [client 192.168.1.10:62362] DBI connect('xantrex:localhost','root',...) failed: Access denied for user 'root'@'localhost' at /usr/local/solar-web_monitor/cgi-bin/power_graph.cgi line 26.: /usr/local/solar-web_monitor/cgi-bin/power_graph.cgi

{I did not see a way to post code in a box here, please advise on that}

Line 26 is the DBI->connect line with the creds. Does anyone know the proper way to configure mysql/mariadb to be able to pass login credentials? I saw some references to mods to my.cnf to do
skip-networking+0
skip-bind-address
but was leery of that for maybe security reasons, not sure.

Please advise,
Alan D.

Impact of creating calculated fields in Workday (no replies)

krishna Manohar — Wed, 20 Mar 2024 10:05:28 +0000

What is the impact of creating calculated fields in Workday Will it make Workday slower, if this is slower how we can avoid to make some changes specially for integration ?

Is it better to have a report based calculated fields. If Yes, then will it impact on the report only ?

Is Workday doesn't calculated field OR they have any special recommendation on this ?

Strawberry Perl and TLS 1.2 connection error with DBD::mysql (no replies)

sesame technologies — Fri, 03 Feb 2023 05:33:06 +0000

My company currently relies on ActivePerl for windows implementations, but are trying out Strawberry Perl. The only real problem we have hit is accessing MySQL when TLS 1.2 is required. We get the error "Can't connect to DB: TLS version used does not meet minimal requirements for this server. Please use a higher TLS version and retry".

The database I am trying to connect to is an Azure MySQL database that has a minimum of TLS 1.2 set.

Here is the test app I'm using as my test case:

#!/usr/bin/perl

use DBI;

my $ssl = 1; ## 1 = on, 0 = off

my $driver='mysql';
my $database = 'testdatabase';
my $hostname = '';
my $port = '3306';
my $dbuid = '';
my $dbpwd = '';

#DBI->trace(15);
if ($ssl == 1) {
$dbh = DBI->connect("DBI:$driver:$database;host=$hostname;port=$port","$dbuid","$dbpwd", {RaiseError => 0, mysql_ssl => 1, mysql_ssl_optional => 1}) or die ("Can't connect to DB: $DBI::errstr");
}
elsif ($ssl == 0) {
$dbh = DBI->connect("DBI:$driver:$database:$hostname","$dbuid","$dbpwd", {RaiseError => 0}) or die ("Can't connect to DB: $DBI::errstr");
}

print qq~
Connection Successful!
~;

I've confirmed that if I setup the Azure MySQL instance to allow TLS 1.0 or TSL 1.1, the test program connects successfully, just not when TLS 1.2 is required (which is a regulatory requirement in this case).

I've tried Windows 2016 and 2019 to no avail and I'm using the latest version of Strawberry available. I can connect to another database with SSL disabled, so I know DBD::mysql is there and usable.

I have tried to specifically enable TLS 1.2 in the registry. My understanding is that is not necessary anymore for later versions of Windows, and that did not resolve the issue.

I'm at a loss and not sure how to get this working.

Can't display comment for table index (3 replies)

barry kimelman — Tue, 26 Apr 2022 21:50:31 +0000

I created a table as follows

CREATE TABLE contacts(
contact_id INT AUTO_INCREMENT,
first_name VARCHAR(100) NOT NULL,
last_name VARCHAR(100) NOT NULL,
email VARCHAR(100),
phone VARCHAR(20),
PRIMARY KEY(contact_id),
UNIQUE(email),
INDEX phone(phone) INVISIBLE,
INDEX name(first_name, last_name) comment 'By first name and/or last name'
);

When I run a query to retrieve the info for the index the comment is not displayed.

select index_schema,
index_name,
group_concat(column_name order by seq_in_index) as index_columns,
index_type,
case non_unique
when 1 then 'Not Unique'
else 'Unique'
end as is_unique,
table_name,
comment
from information_schema.statistics
where table_schema not in ('information_schema', 'mysql',
'performance_schema', 'sys')
and table_name = 'contacts'
group by index_schema,
index_name,
index_type,
non_unique,
table_name,
comment
order by index_schema,
index_name;

Why can't I retrieve the comment associated with the index ?

Perl performance with mysql (no replies)

James Barton — Tue, 28 Jan 2020 00:49:08 +0000

I am far from an expert, knowledgable enough only to get myself into trouble usually. But here is my situation.

I have a perl script that I've written and it's running fine on a Windows 2012 server with Active State Perl 5.16.1 and a mysql server v5.5.28 and has been running fine for years. A data query completes in less than a second and the web interface is very responsive.

I upgraded computers and moved this to a Windows 10 machine that's much faster.

On the new server, a database query takes about 45-55 seconds to complete. Does not time-out but takes forever to complete. Static pages load fine. I'm able to access the mysql database using Heidisql quickly as well.

I installed the latest version of Active State Perl, then Strawberry Perl, the latest version of mySql server and then the v5.5.28 mysql server

When I point the perl script from the new server to the old server running mysql, it still takes forever to complete so I think it's a perl problem but not really a coding problem but maybe a dbi:mysql installation problem?

When I installed Perl (both Active State and Strawberry) neither came with DBI:MYSQL working, I had to copy copy C:\strawberry\c\bin\libmysql_.dll to C:\strawberry\perl\vendor\lib\auto\DBD\mysql\libmysql_.dll to get connected at all.

I've found online that a Microsoft update changed the locations theat DLL's are searched for which is why that file was moved. But the program still runs very slowly against the new database and old.

I've added the DBI:MYSQL module to the active state download but it does not connect properly as installed.

I'm really at a loss and any suggestions would be appreciated.

Thank you.

Problem with upgrade 5.6 to 5.7 (2 replies)

Peter Leipzig — Tue, 10 Sep 2019 15:46:01 +0000

My server company told me that I needed to upgrade MySQL 5.6 to 5.7.

My site is a small auction for the commercial fishing industry. The main program for the site is written in Perl and operates in cgi-bin. In the beginning I added code to store sales data in a MySQL database. The site has been up and running since 2011. No problems until the upgrade.

The following is the code used to insert sales records in the database:

##### connect to database
my $dbh = DBI->connect("DBI:mysql:$db:$server", $userid, $passwd);

##### prepare and execute query
my $query = "INSERT INTO closedauctions (seller, sellerusername, category, title, bids, pounds, description, winningbid, price_per_pound, highbidder, buyerusername, month, day, year, itemnum, filename) VALUES(\"$sellername\",\"$sellerusername\",\"$quota\", \"$category\", 1, \"$pounds\", \"$desc\", \"$buyit\", \"$price_per_pound\", \"$buyername\",\"$buyerusername\", \"$month\", \"$day\", \"$year\", \"$form{'ITEM'}\", \"$cat\")";

my $sth = $dbh->prepare($query) || die "Could not prepare SQL statement ... maybe invalid?";

$sth->execute() || die "Could not execute SQL statement ... maybe invalid?";

##### disconnect from database
$dbh->disconnect;

The server company told me the upgrade was complete and to test it out. I did and received the following error:Software error:

[Sat Sep 7 22:51:26 2019] auction.pl: install_driver(mysql) failed: Can't load '/home/jeffer36/perl5/lib/perl5/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/local/lib/perl5/5.8.8/x86_64-linux/DynaLoader.pm line 224, line 1715.
[Sat Sep 7 22:51:26 2019] auction.pl: at (eval 15) line 3.
[Sat Sep 7 22:51:26 2019] auction.pl: Compilation failed in require at (eval 15) line 3, line 1715.
[Sat Sep 7 22:51:26 2019] auction.pl: Perhaps a required shared library or dll isn't installed where expected
[Sat Sep 7 22:51:26 2019] auction.pl: at ../auction/buyit.pl line 285.
Compilation failed in require at auction.pl line 21.

I reported the error to the server company and was told:

"Upon further review it appears that the automated process that updates MySql for you did not properly install all MySql modules as expected. We have force installed those modules for you at this time, however without replication steps we were unable to verify that. Could you please check to see that things are working as expected?"

I did another test and received the following error:

Software error:

install_driver(mysql) failed: Can't load '/home/jeffer36/perl5/lib/perl5/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/local/lib/perl5/5.8.8/x86_64-linux/DynaLoader.pm line 224, line 18.
at (eval 15) line 3.
Compilation failed in require at (eval 15) line 3, line 18.
Perhaps a required shared library or dll isn't installed where expected
at ../auction/buyit.pl line 285.

I reported this error to the server company and now I am being told:

"It does not seem likely that any missing modules in MySQL itself would play in to this, as the error presented indicates that the issue is something cannot access the following file:

/home/jeffer36/perl5/lib/perl5/x86_64-linux/auto/DBD/mysql/mysql.so

However that file does exist:

root@mail [/]# ls -lah /home/jeffer36/perl5/lib/perl5/x86_64-linux/auto/DBD/mysql/mysql.so
-r-xr-xr-x 1 jeffer36 jeffer36 299K May 5 2016 /home/jeffer36/perl5/lib/perl5/x86_64-linux/auto/DBD/mysql/mysql.so*

MySQL 5.6 and MySQL 5.7 aren't terribly different in terms of core functionality, and the files changed during the upgrade process wouldn't have touched user files or (to my knowledge) Perl files on the system."

They are at a loss and so am I. Any suggestions.

Perl & MySQL 8.0 (no replies)

Edwin Desouza — Thu, 06 Jun 2019 14:27:41 +0000

https://lefred.be/content/perl-mysql-8-0/

using load_file() function (1 reply)

emna nefzi — Thu, 25 Apr 2019 03:30:09 +0000

hi ,

my object is to insert image in MySQL table using load_file()

i want to know how to located file in the server host .

Can't connect to mysql from MAMP Perl (no replies)

Richard Nicholas — Mon, 22 Oct 2018 21:59:30 +0000

Hi,

I installed the latest version of MAMP. I am able to connect to mysql with PHP but I want to also connect with Perl. MAMP says use this template:

my $user = 'root';
my $password = 'root';
my $db = 'db';

my $link = DBI->connect(
"DBI:mysql:database=$db",
$user,
$password
);

My database name is actually db. I get this error:

install_driver(mysql) failed: Can't load 'C:/MAMP/bin/perl/vendor/lib/auto/DBD/m
ysql/mysql.dll' for module DBD::mysql: load_file:The specified module could not
be found at C:/MAMP/bin/perl/lib/DynaLoader.pm line 190.
at (eval 6) line 3.
Compilation failed in require at (eval 6) line 3.
Perhaps a required shared library or dll isn't installed where expected
at test.pl line 28.

At someone's suggestion, I added localhost information to the connect like this:

my $link = DBI->connect(
"DBI:mysql:database=$db:localhost:3306",
$user,
$password
);

But I get the same error. And the file it says it can't find: C:/MAMP/bin/perl/vendor/lib/auto/DBD/mysql/mysql.dll' is there!

Any help would be appreciated. Its very frustrating to have spent hours just trying to figure out how to *connect*. I can't even get started on real work. Thanks.

ODBC Connector 8.0 and MySQL 5.7.20 - Bad Handshake error (no replies)

Neeraj Yadav — Thu, 13 Sep 2018 10:14:45 +0000

Using ODBC 8.0 to create linked server for MySQL 5.7.20. There is error message as:

OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[MySQL][ODBC 8.0(a) Driver]Bad handshake".

Bad handshake took my long time and still not resolved. Let me know if it is product bug.

Thanks
Neeraj

Problem installing DBD-mysql-4.036 on AIX 7.1 - Unable to load DBD::mysql (no replies)

Philippe Arcudi — Tue, 20 Sep 2016 08:43:18 +0000

Hi,

I want to install the DBD-mysql-4.036 on AIX 7.1 with the following commands :

perl Makefile.PL => all seems to be OK
make => all seems to be OK

When i try the "make test", i have the following message :

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.tt/00base.t ........................... 1/6 Bailout called. Further testing stopped: Unable to load DBD::mysql

# Failed test 'use DBD::mysql;'
# at t/00base.t line 15.
# Tried to use 'DBD::mysql'.
# Error: Can't load '/tmp/DBI/DBD-mysql-4.036/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: rtld: 0712-001 Symbol __PureVirtualCalled was referenced
# from module /tmp/DBI/DBD-mysql-4.036/blib/arch/auto/DBD/mysql/mysql.so(), but a runtime definition
# of the symbol was not found.
# rtld: 0712-001 Symbol __ReThrowV6 was referenced
# from module /tmp/DBI/DBD-mysql-4.036/blib/arch/auto/DBD/mysql/mysql.so(), but a runtime definition
# of the symbol was not found.
# rtld: 0712-001 Symbol __setUncaughtExceptionFlag__3stdFb was referenced
# from module /tmp/DBI/DBD-mysql-4.036/blib/arch/auto/DBD/mysql/mysql.so(), but a runtime definition
# of the symbol was not found.
# rtld: 0712-001 Symbol __dl__FPv was referenced
# from module /tmp/DBI/DBD-mysql-4.036/blib/arch/auto/DBD/mysql/mysql.so(), but a runtime definition
# of the symbol was not found.
# rtld: 0712-001 Symbol __UnsupportedConditionalExpressionDestruction__FPvl was referenced
# from module /tmp/DBI/DBD-mysql-4.036/blib/arch/auto/DBD/mysql/mysql.so() , but a runtime definition
# of the symbol was not found. at /usr/opt/perl5/lib/5.10.1/aix-thread-multi/DynaLoader.pm line 200.
# at (eval 8) line 2
# Compilation failed in require at (eval 8) line 2.
# BEGIN failed--compilation aborted at (eval 8) line 2.
FAILED--Further testing stopped: Unable to load DBD::mysql
make: 1254-004 The error code from the last command is 255.

Stop.

Any suggestion ?

Best regards

Philippe

Use of Mysql Sandbox (2 replies)

Joseph Norris — Wed, 31 Aug 2016 21:09:42 +0000

Hello to all
I have been attempting to get just a small replication testing environment set up and I am running into problems. I have mysql-5.5.51-linux2.6-x86_64.tar.gz but when I run make_replication_sandbox mysql-5.5.51-linux2.6-x86_64.tar.gz - it runs and runs builds directories under $SANDBOX_HOME then dies:
installing and starting master
can't start server
error installing the master

(512 )

I cannot figure this out - I have used sandbox before and have not had this issue. SBDEBUG does not shed a whole of light on the issue. Any help would be most appreciated.

Why MySQL use Perl "Data::Dumper" module? (no replies)

Sami Salami — Tue, 19 Jan 2016 09:34:29 +0000

Hi,

I noticed that MySQL is unable to be installed in Linux if the Perl "Data::Dumper" module is not pre-installed.
Can you please explain to me, what is the functionality needed for MySQL that require using this module?
Also, Is this "Data::Dumper" module necessarily for MySQL to work after the installation part? I mean, would MySQL continue to work normally even after we remove this module (after we use it to install MySQL)?

Why I can't insert more than 100,000 rows in a script?(mysql+php) (3 replies)

Bhupendra Chouhan — Thu, 10 Sep 2015 00:13:13 +0000

Hi,

I'm having a script for inserting a number of rows into a mysql table.
it goes something like this

$i=0;
while ($i<300000)
{
$x=rand(1,58000);
echo "I'm inserting number $i - amount $x
";
$query="INSERT INTO sales (amount) values('$x')";
mysql_query($query) or die(mysql_error());
$i++;
}

The script works well , but the problem is that it has a limit of aprox 100,000 rows per call.
Why can't I insert more than 100,000 rows?Can somebody explain me?

Setting login Payload information (no replies)

Chris Kottaridis — Sat, 02 May 2015 15:21:51 +0000

I tried this snippet of the sample program and captured the information sent via wireshark:
===================================
#!/usr/bin/perl

use strict;
use warnings;
use DBI;

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1",
"joe", "joe's password",
{'RaiseError' => 1});

# Disconnect from the database.
$dbh->disconnect();

exit;
=================================

In wireshark output I see the login request for Joe and also has a PayLoad section:

Username: joe
Password: eac7451479b75687f0e71e7aa3244870145937be
Schema: test
Payload: 6d7973716c5f6e61746976655f70617373776f7264005303...

In the Payload section is some information regarding the client, specifically:

client_name libmysql _pid8871
client_version 10.0.17

Is there a way to set the client name and version to match the application I am writing rather then the library used ?

In general how do I control the content of the login Payload ?

Thanks
Chris Kottaridis

Max_allowed_packet problem (3 replies)

Richard Law — Mon, 08 Jun 2015 00:48:23 +0000

Hi All,

We're trying to migrate a code base from Solaris to Ubuntu and running into an odd max_allowed_packet problem. We have seen those before long ago and adjusted accordingly in my.cnf to the 1G max. We don't see this error on the Solaris box nor in the mysql client. We're running 5.5.41-0ubuntu0.14.04.1 with the latest DBI and DBD::mysql.

The table definition:

CREATE TABLE `ME` (
`url` varchar(255) NOT NULL DEFAULT '',
`dltime` int(11) DEFAULT NULL,
`depth` int(11) DEFAULT NULL,
`content_type` varchar(128) DEFAULT NULL,
`body` mediumtext,
`meta` mediumtext,
`title` varchar(255) DEFAULT NULL,
`linktext` varchar(255) DEFAULT '',
`visited` datetime DEFAULT NULL,
`size` int(10) unsigned DEFAULT NULL,
`descript` text,
`keywords` text,
`docroot` varchar(255) DEFAULT NULL,
`mineid` mediumint(9) NOT NULL DEFAULT '0',
`lodeid` mediumint(9) NOT NULL DEFAULT '0',
PRIMARY KEY (`url`),
KEY `visited` (`visited`),
KEY `linktext` (`linktext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

The test code:
#!/usr/local/bin/perl -w

use DBI;

my $dbh = DBI->connect("dbi:mysql:mill;mysql_read_default_group=mysqld1", "xxxxxxx", "xxxxxxxx") ||
die "Could not connect to mysql";

($var, $max) = $dbh->selectrow_array("show variables like 'max_allowed_packet'");
print "$var: $max\n";

$bsel = $dbh->prepare("select body from ore.ME");
$ssel = $dbh->prepare("select length(body) from ore.ME");
$ssel->execute();
$xx = 0;
while ($xx < 10 and ($size) = $ssel->fetchrow_array()) {
print "The record I'm about to get is $size characters.\n";

$bsel->execute();
($body) = $bsel->fetchrow_array;
print "$body\n";
$xx++;
}

$dbh->disconnect();
exit(0);

Group mysqld1 from my.cnf:

[mysqld1]
pid-file = /var/run/mysqld/mysqld.pid
socket = /run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
key_buffer_size = 4G
max_allowed_packet = 1G
net_buffer_length = 1M
thread_stack = 192K
thread_cache_size = 16
myisam-recover = BACKUP
myisam_sort_buffer_size = 16M
max_sort_length = 32M
max_connections = 160
table_cache = 512
thread_concurrency = 16

And, finally, the beginning of the output we get:

law@chinacat> testmaxpack
max_allowed_packet: 1073741824
The record I'm about to get is 7991 characters.
DBD::mysql::st execute failed: Got packet bigger than 'max_allowed_packet' bytes at ./testmaxpack line 18.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at ./testmaxpack line 19.
Use of uninitialized value $body in concatenation (.) or string at ./testmaxpack line 20.

The record I'm about to get is 8024 characters.
DBD::mysql::st execute failed: MySQL server has gone away at ./testmaxpack line 18.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at ./testmaxpack line 19.
Use of uninitialized value $body in concatenation (.) or string at ./testmaxpack line 20.

We're baffled by the small record length and the error. Does anyone have ideas on how to figure this one out? Of course, we're under pressure to fix this asap.

Thanks for any suggestions!

AutoCommit issue (1 reply)

chen gene — Sun, 08 Feb 2015 02:34:53 +0000

Hi, I set autocommit=1 in my perl script, but found the record cannot be inserted.
[root@dhcpc tmp]# cat dbd1.pl
#!/usr/bin/perl

use DBI;

my $dbh = DBI->connect( "DBI:mysql:database=test;host=localhost", "root", "123456", { 'RaiseError' => 1, AutoCommit => 1 } );
my $sql =qq{insert into test(name, id) values('hello ', 2)};
$dbh->do($sql);

my $query = $dbh->prepare("SELECT name FROM test");
$query->execute();

while ( $ary = $query->fetchrow_arrayref() ) {
print ( $ary->[0] . "\n");
}

[root@dhcpc tmp]# perl dbd1.pl
hello
[root@dhcpc tmp]# perl dbd1.pl
hello

but if I execute commit, it runs as expected.
[root@dhcpc tmp]# cat dbd2.pl
#!/usr/bin/perl

use DBI;

my $dbh = DBI->connect( "DBI:mysql:database=test;host=localhost", "root", "123456", {AutoCommit => 0 } ) ;
# my $dbh = DBI->connect( "DBI:mysql:database=test;host=localhost", "root", "123456", { 'RaiseError' => 1, AutoCommit => 1 } );
my $sql =qq{insert into test(name, id) values('hello ', 2)};
$dbh->do($sql);

my $query = $dbh->prepare("SELECT name FROM test");
$query->execute();
$dbh->commit();

while ( $ary = $query->fetchrow_arrayref() ) {
print ( $ary->[0] . "\n");
}

[root@dhcpc tmp]# perl dbd2.pl
hello
[root@dhcpc tmp]# perl dbd2.pl
hello
hello

btw, mysql is 5.6.22 and I set autocommit=off in /etc/my.cnf

cmake compile for 64 bit (no replies)

Christine Ross — Sat, 15 Nov 2014 16:18:35 +0000

I have 32 bit mysql, compiled from source on Sparc 64 bit Solaris 10. I have to upgrade mysql to newer versions which require using CMAKE. I did this for another application that used Suns CC Compiler, without any compiler flags, and it built a 32 bit version of mysqld (server).

The CMAKE documentation say that to get 32bit, you specify -m32, but it doesn't say anything about requiring a flag for 64 bit.

If I use gcc or CC, do I need a flag to compile 64 bit mysql using CMAKE.

Does anyone have a good configuration line to compile 64 bit solaris or do I just put -m64 for gcc or CC please?

I'm also looking to create a mysqld binary that will make use of a multi-core T4-2 server. If there are any additional compile options for this, please let me know.

Thanks very much.

compiling separate 32 bit client and 64 bit mysqld instances (no replies)

Christine Ross — Sat, 15 Nov 2014 16:06:24 +0000

We currently have a very old 32 bit client and server mysql installation on Sparc Solaris, compiled from source. Additionally I have 32bit perl modules for connectors (DBD::Mysql, and other perl modules). GCC is also 32bit. I have to upgrade the mysql version and include 64 bit support. I do not want to recompile all supporting tools for 64 bit, (ie) perl, but I just want a 64 bit server.

I was told I could compile a 32bit client and again compile 64 bit mysqld (server) and just copy the mysqld server binary to the 32 bit installation. Then I could use all the 32bit connectors, perl and such without recompiling everything. I tried it and restarted mysql without issue, but I'm concerned that in production, mysqld might fail because it referenced a 32bit library.

I am not sure how to separate the 32bit client portion and the 64bit server portion. Typically I install into /usr/local/mysql and specify that as base-dir. Is it as simple and copying mysqld into the 32bit installation?

If I don't do that, I know I could specify the 64bit mysqld location in the startup script, but then do I use specify the 32bit for basedir?

Has anyone had experience separating the two installations and using both please? What was their experience?

Thanks for any help.

DO when mysql connection failed in perl (1 reply)

RAO peddineni — Sat, 24 May 2014 20:45:02 +0000

Hi any one can suggest me to set a variable in perl when mysql connection failed.

Copy mysql database on same machine. (2 replies)

Ajay Sharma — Fri, 20 Dec 2013 16:30:26 +0000

Hello Members.

please let me know how to copy database and make separate databases for dev, test and live environment.

I am working on a Perl project and Mysql as database.

we have dev test and live environemnts.

We have only one mysql database and we have to connect to this database from dev, test and live environments.

Thanks in Advance.

DBD-mysql installation failure (no replies)

Milton Spain — Fri, 13 Sep 2013 17:33:32 +0000

I’m having a problem installing DBD-mysql so I can use PERL cgi scripts to communicate with the MySQL database I’ve just installed on a Microsoft Server 2003. I’ve had PERL installed and operational for several years in conjunction with one of my websites. Now I need a new and potentially large database, hence the MySQL. I’ve logged into the server as administrator and followed the instructions to use run, cmd and ppm to open the ppm. That happens just fine, but instead of getting an opportunity to type in “install DBD-mysql, I’m given a window where I can select available modules, etc. or those already installed. After highlighting DBD-mysql I click on file and then “Install The Selected Item” etc. Then I get a Error 401 – Authorization Required message. Why? What authorization is required since I am logged in as the administrator.

Any assistance that you can provide will be greatly appreciate.

Thanks!

Milt Spain

Unknown column 'subtest_id' in 'NEW' (4 replies)

Prashant Tekriwal — Fri, 13 Sep 2013 03:37:27 +0000

Hi,

I have the following trigger in my mysql database:

-------------------------------------------------------------

CREATE TRIGGER set_subtest_id BEFORE INSERT ON subtest
FOR EACH ROW
BEGIN
UPDATE seq SET id = id + 1;
SET new.subtest_id = (SELECT id FROM seq); <-- Failure is happening here
SET new.time_begin = UNIX_TIMESTAMP(NOW());
IF new.visible_id = -1 AND new.hidden_results = 1 THEN
SET new.visible_id = new.subtest_id;
ELSEIF new.visible_id = -1 THEN
SET new.visible_id = (SELECT visible_id FROM subtest WHERE subtest_id = new.subtest_parent_id);
END IF;
INSERT INTO contains VALUES (new.subtest_id, new.subtest_id);
END; |

-----------------------------------------------------------------------

This above trigger has been working fine for over a year and now suddenly I have started seeing intermittent issue with this trigger.

I assume the error is happening at the point I have marked above ( <-- ).

I sometimes see the following error in my logs:

DBD::mysql::db do failed: Unknown column 'subtest_id' in 'NEW'

This issue is not easily reproducible and I have seen this error only several times till now.

The same set of code is working fine sometimes and sometimes it fails with above error.

I am using Mysql Server 5.6.

Can anybody help me finding out what is the issue?

Let me know if any other information is needed.

Thanks

ora2pg-help-oracle-driver (no replies)

Mehmet akdoğan — Wed, 28 Aug 2013 08:00:29 +0000

Hi everyone, I get the following error after running ora2pg, I do not know about it, can you help please?

[oracle@db ~]$ ora2pg
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 8) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, SQLite, Sponge, mysql.
at /usr/local/lib64/perl5/Ora2Pg.pm line 852

Installed all perl modules.

Thanks to everyone in advance.

update DBD::mysql error (no replies)

h h — Wed, 19 Jun 2013 06:02:08 +0000

i upgrade DBD::mysql from 3.0007 to 4.023 ,get an error,anyone know how to solve this problem? thanks a lot

# find /usr -name 'mysql_config'
/usr/lib64/mysql/mysql_config
/usr/local/mysql-5.5.30-linux2.6-x86_64/bin/mysql_config
/usr/local/mysql-5.1.63/bin/mysql_config
/usr/local/mysql-cluster-gpl-7.1.22/bin/mysql_config
/usr/bin/mysql_config
/usr/lib/mysql/mysql_config

i use mysql5.5 so
# perl Makefile.PL --mysql_config=/usr/local/mysql-5.5.30-linux2.6-x86_64/bin/mysql_config

]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok 1/6
t/00base....................NOK 2# Failed test 'use DBD::mysql;'
# at t/00base.t line 21.
# Tried to use 'DBD::mysql'.
# Error: Can't load '/root/DBD-mysql-4.023/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
# at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 9

# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Writing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/.packlist
Appending installation info to /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/perllocal.pod
[root@CHS118 DBD-mysql-4.023]# perl -MDBD:mysql
syntax error at - line 0, near "use DBD:"
Execution of - aborted due to compilation errors.

# perl -MDBD::mysql
Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at - line 0
Compilation failed in require.
BEGIN failed--compilation aborted.

Using DBI for MySQL metadata (no replies)

CHap Harrison — Sun, 17 Feb 2013 19:47:23 +0000

I'm unable to get the information I need from reading the CPAN DBI documentation, and it was suggested I post here for help specifically for MySQL. (FYI I'm using Perl 5.10 and MySQL 5.5/5.6).

I can't seem to find a list of descriptions of the info that's being returned from this:

my $sth_column_info = $dbh->column_info( $catalog, $schema, $table, undef );
my $aoa_ref = $sth_column_info->fetchall_arrayref;

There are 30-some elements in the array for each column. The meaning of some is obvious, the meaning of others is not.

It's also not clear to me how to express the arguments to fetchall_arrayref() to ask for only certain information.

And there are some numeric codes that aren't meaningful without a key.

Is there some documentation, specifically aimed at MySQL, on how to use the DBI for obtaining metadata?

Select query returns false result. (1 reply)

Tom Thomas — Tue, 05 Feb 2013 03:03:01 +0000

eg:

Table : user
column : user_id (type is int)

SELECT * FROM user WHERE user_id = '10xyz' is giving same result of
SELECT * FROM user WHERE user_id = '10'

The input value is not integer but not giving an error in this case.

MySql, Perl, and HTML Update function not working (6 replies)

adam gruber — Tue, 05 Feb 2013 14:51:14 +0000

Hello,
I used a guide that I found that was written by Tony Darnell regarding using MySql, Perl, and a little HTML to create, update, and delete database records. Everything works perfectly, except for the UPDATE functionality. Is there anything explicitly wrong with the following lines

$serial = $formdata{'serial'};
$name_first = $formdata{'name_first'};
$name_last = $formdata{'name_last'};
$address_01 = $formdata{'address_01'};
$address_02 = $formdata{'address_02'};
$address_city = $formdata{'address_city'};
$address_state = $formdata{'address_state'};
$address_postal_code = $formdata{'address_postal_code'};

$dbh = ConnectToMySql($Database);

$query = "update address set name_first = '$name_first', name_last = '$name_last', address_01 = '$address_01', address_02', address_city = '$address_city', address_state = '$address_state', address_postal_code = '$address_postal_code' where serial = '$serial'";

$sth = $dbh->prepare($query);

$sth->execute();

$dbh->disconnect;

When I takek out the $serial and enter in a manual value in the $query line, it works. So something is not kosher with having it grab that value on its own. I am a complete MySql and Perl n00b btw, so I apologize right off the bat if i misunderstand something or am missing something easy. Thanks for the help and let me know if you need any other info.

Mysql query produces different results for different users (3 replies)

Amir Weinberger — Sun, 09 Dec 2012 19:45:19 +0000

Hello,

On my website I have a form with 6 fields the user fills in order to retrieve desired records from database.
The user can leave all fields empty, in which case all the records are displayed.
Alternetively, he can fill any combination of fields and the mysql query will be built dynamically based on the user's choices.

When I click the submit button, it works fine, no matter what fields combination I fill in the form.

But, I have a problem with a user, actually a company with a network of 20 users connecting online using Sbox (router).
When they leave all the above form fields empty, they get the recordset and it's working fine. But, when they fill any of the form fields (any number of fields in any combination), they get an empty recordset. No errors but no records.

I have no idea what's the reason for this.

If they get all the records when the form fields left empty, it means they connect successfully to the database. Also, the PHP code is OK, after all I tested it and it worked (and still working) fine.
So if there is no connection problem and no code problem, what can the problem be?

If it is relevant, the difference between their computers and mine:
They use ie8 (I use ie9)
Their OS: Windows XP (mine Windows 7)
Om all stations they have NOD32 antivirus. (I have a different one)

I don't think any of the above is relevant, but because the situation is so
unexpected so I don't know where to look for the solution, I provide all details....

Any ideas?

Thanks for your help!