headers
Jan Eden | 6 Jan 2005 14:32

TIMESTAMP confusion

Hi,

I maintain a database locally which is queried via a Perl script to generate my website. Now there is one
field of the TIMESTAMP type which should reflect the respective page's last modification date. This
works fine when the database is queried locally.

But when I dump the database (using mysqldump), transfer it to my webserver and import the dump into the
database on the server, some pages carry the correct timestamp, while others have the timestamp of the import.

Why is that? The tables are all dropped and recreated prior to inserting the data. Now I could understand if
all the pages get a new timestamp (i.e. if the current value is not honored at all), but some pages are not affected.

Those pages still carry the timestamp from the time when I initially added the TIMESTAMP field to my
database. Why should this timestamp be more sticky than others?

Thanks,

Jan
-- 
How many Microsoft engineers does it take to screw in a lightbulb? None. They just redefine "dark" as the new standard.

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 2 comments |
headers
Jan Eden | 6 Jan 2005 15:01

Re: TIMESTAMP confusion

Hi,

an update to my question: 219 of 2500 records on the server carry the import timestamp, while in the local
database, only 65 records where modified and carry a timestamp different from 20041226131319.

I am completely confused.

- Jan

Jan Eden wrote on 06.01.2005:

>Hi,
>
>I maintain a database locally which is queried via a Perl script to
>generate my website. Now there is one field of the TIMESTAMP type
>which should reflect the respective page's last modification date.
>This works fine when the database is queried locally.
>
>But when I dump the database (using mysqldump), transfer it to my
>webserver and import the dump into the database on the server, some
>pages carry the correct timestamp, while others have the timestamp
>of the import.
>
>Why is that? The tables are all dropped and recreated prior to
>inserting the data. Now I could understand if all the pages get a
>new timestamp (i.e. if the current value is not honored at all), but
>some pages are not affected.
>
>Those pages still carry the timestamp from the time when I initially
>added the TIMESTAMP field to my database. Why should this timestamp
(Continue reading)

Permalink | Reply | 1 comment |
headers
Rudy Lippan | 6 Jan 2005 15:25

Re: TIMESTAMP confusion

On Thu, 6 Jan 2005, Jan Eden wrote:

> Hi,
> 

Hi

> >I maintain a database locally which is queried via a Perl script to
> >generate my website. Now there is one field of the TIMESTAMP type
> >which should reflect the respective page's last modification date.
> >This works fine when the database is queried locally.
> >
> >But when I dump the database (using mysqldump), transfer it to my
> >webserver and import the dump into the database on the server, some
> >pages carry the correct timestamp, while others have the timestamp
> >of the import.

Your best bet would be to ask this on the mysql general list.

-r

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Ken Wood | 7 Jan 2005 01:52
Picon
Favicon

DBD-mysql failure

I have MySQL 4.0.23 installed on a Solaris 9 machine.  It seems to be fine.  
I got DBD::mysql to
compile fine but when running it I get the following error:

ld.so.1: /usr/bin/perl: fatal: relocation error: file /usr/local/lib/perl5/
site_perl/5.8.5/sun4-solaris/auto/DBD/mysql/mysql.so: symbol mysql_init: 
referenced symbol not found

Here is the mysql_config output:

Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
        --cflags         [-I/usr/local/mysql/include]
        --include        [-I/usr/local/mysql/include]
        --libs           [-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lgen 
-lsocket
-lnsl -lm]
        --libs_r         [-L/usr/local/mysql/lib -lmysqlclient_r -lcrypt 
-lgen -lsock
et -lnsl -lm]
        --socket         [/tmp/mysql.sock]
        --port           [3306]
        --version        [4.0.23]
        --libmysqld-libs [-L/usr/local/mysql/lib -lmysqld -lcrypt -lgen 
-lsocket -lns
l -lm]

I have verified that all the listed libraries exist.  Any ideas what is 
wrong?
(Continue reading)

Permalink | Reply | 0 comments |
headers
National Stistics Office - Region XI | 7 Jan 2005 08:03

problem installing DBD::mysql 2.9004

its been quite a while i am trying to test and install DBD::mysql 2.9004 on 
my system under windows 2000.
here's some test id made.

to jan eden would you pls help how to make some script same as you are 
doing with your project queried via perl script to generate my website.
because i am trying make some query tools like you did.
any reply would be appreciated
nsoXI <at> skyinet.net

installation and test of DBI 1.45 ------- ok success
installation and test of dbd::mysql 2.9004 ------- failed.

C:\dbdmy2.9004>perl makefile.pl --cflags="-IC:\tmp\mysql-static\Imysql.h" 
--libs
="-LC:\tmp\mysql-static\Lmysqlclient.lib"
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
(Continue reading)

Permalink | Reply | 4 comments |
headers
Ken Wood | 8 Jan 2005 01:43
Picon
Favicon

MySQL make errors

When attempting to do a make on MySQL 4.0.23a source on Solaris 9 using gcc 
3.3.2 I get the
following error:

rm -f libreadline.a
false cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o 
rltty.o comp
lete.o bind.o isearch.o display.o signals.o util.o kill.o undo.o macro.o 
input.o call
back.o terminal.o xmalloc.o history.o histsearch.o histexpand.o histfile.o 
nls.o sear
ch.o shell.o tilde.o
make[2]: *** [libreadline.a] Error 1
make[2]: Leaving directory `/mysql-4.0.23a/readline'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/mysql-4.0.23a'
make: *** [all] Error 2

Configure produced a few warnings but exited with a status of 0 and seemed 
to be successful.

Any ideas what could be wrong?

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Jochen Wiedmann | 10 Jan 2005 01:28
Picon
Gravatar

Re: problem installing DBD::mysql 2.9004

National Stistics Office - Region XI wrote:
> its been quite a while i am trying to test and install DBD::mysql 2.9004 
> on my system under windows 2000.

Why aren't you simply using PPM to install the driver?

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 3 comments |
headers
Christoffer Vig | 12 Jan 2005 13:21
Picon

foreign_key_info

Hello people.
Apparently, the foreign_key_info method is not implemented yet, I
checked DBD-mysql-2.9005_3 on CPAN and it is not there.
What is the status on this method?
Will it be added sometime, is it under development or just not
interesting or impossible.
regards, 
Christoffer

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
David Jacopille | 12 Jan 2005 22:01

Escape characters handled differently between mysql and DBD: mysql ???

I've used INSERT to load the following string exactly as shown with the
double backslashes:

(.+)\\.[0-9A-Z]+(\\.pdf)$

When issuing a SELECT statement directly in mysql from a terminal window I
get exactly the regular expression I want and would expect:

(.+)\.[0-9A-Z]+(\.pdf)$

When issuing the same select statement in a Perl script using DBI and
DBD::mysql I get the double backslash plus an extra bonus escape character
for the $.

(.+)\\.[0-9A-Z]+(\\.pdf)\$

I'm sure this is literally what's stored in the database and the mysql
application is applying a filter to deal with the escape characters that the
Perl DBI is not.

Of course I could build a regular expression to fix this regular expression
- but does anyone know how to just get the Perl DBI to handle the escape
characters with a bit more savvy?

Thanks,
David Jacopille

"MFS Relay Service" made the following
 annotations on 01/12/2005 04:07:50 PM
------------------------------------------------------------------------------
(Continue reading)

Permalink | Reply | 1 comment |
headers
Gregg R. Allen | 13 Jan 2005 10:44

URL protection using MySQL databases.

	
I've been asked to create some web pages that use username and password 
authentication for resources on our web server.

I want people to be able to log into our web server, provide a username 
and password, and be given a URL that allows them
to download their data file(s) for the day.  (from anywhere in the 
world.)

The URL table, (it's not the username and password table for the 
database) looks like this:

username varchar(20),
password  varchar(20), # MD5 hashed, or whatever,
URL           varchar(80);

Note:  Their can be multiple URL's for one username and password.

At this point the URL's only point to data files on our web server.  I 
want to make it flexible enough
for ANY URL.

I thought I had solved the problem by simply pulling out the URL's by 
username and displaying them on that user's
web page with a simple CGI script.  That was obviously not secure 
enough, because a manager embarrassed me by finding a user with an
open web page, and after writing down the URL and typing it into his 
computer, he downloaded the file, which was not his.

I don't expect anyone to write code for me, but if someone could just
(Continue reading)

Permalink | Reply | 1 comment |

Gmane