DBD-mysql-2.1028 test failure

am 11.07.2003 21:54:19 von Joe McCarty

I downloaded DBD-mysql-2.1028 from cpan so that I could use the command =
line=20
switches for "make." One test script fails-t/dbdadmin.t. Here's the out=
put:

t/akmisc...........ok
t/dbdadmin.........ok 6/21New DB not in DSN list
t/dbdadmin.........NOK 11DSN testab not in DSN list.
t/dbdadmin.........NOK 15DSN testac not in DSN list.
t/dbdadmin.........FAILED tests 7, 11, 15
Failed 3/21 tests, 85.71% okay

What is the issue, and what is the remedy?

Thanks,

Joe McCarty

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: DBD-mysql-2.1028 test failure

am 14.07.2003 17:01:21 von Joe McCarty

I combed this script looking for a definition of the dsn list that might =
show=20
a case variance in the actual test. I didn't see it, but I'm not a=20
programer. My install of MySQL is fresh, from a binary distribution, on =
a=20
new RedHat 7.3 box. The only two databases on this new install are "mysq=
l"=20
and "test" (the default testdb for "perl Makefile.PL).

What might I be looking for?

Can I go ahead and install with confidence?

Thanks,

Joe McCarty

On Friday 11 July 2003 02:19 pm, Jochen Wiedmann wrote:
> Zitat von Joe McCarty :
> > t/akmisc...........ok
> > t/dbdadmin.........ok 6/21New DB not in DSN list
> > t/dbdadmin.........NOK 11DSN testab not in DSN list.
> > t/dbdadmin.........NOK 15DSN testac not in DSN list.
> > t/dbdadmin.........FAILED tests 7, 11, 15
> > Failed 3/21 tests, 85.71% okay
> >
> > What is the issue, and what is the remedy?
>
> I do not believe that this is an actual problem. I would rather think
> that this is something related to upper- vs. lowercase letters or
> something similar.
>
> Would you mind to dig into the test script a little bit and find out
> what's wrong?
>
>
> Regards,
>
> Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: DBD-mysql-2.1028 test failure

am 14.07.2003 17:01:21 von Joe McCarty

Random IDs

am 14.07.2003 19:31:12 von Octavian Rasnita

Hi all,

I want to insert more records in a database and for each record I want to
insert a random ID, and not an auto_increment one.
Please tell me which should be the simplest method, because I need to check
first that random ID to be unique.
Should I generate a random ID, then check the database to see if there is
such an ID in it, and if it is, generate another one, and so on until the ID
generated is a newer one, then insert it into the database?

I think that this process could take a long time. Is there a better method?

Thanks.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: orasnita@home.ro

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Random IDs

am 14.07.2003 19:31:12 von Octavian Rasnita

Re: DBD-mysql-2.1028 test failure

am 14.07.2003 19:59:58 von carl

I get similar errors on Solaris 8 and have in the past.
I just installed it anyway and don't use the functions used in
that test. Of course, that is NOT a garentee.

That may not be good enough for critical use, but it may be
good enough for most uses, like the Space Shuttle.

On Mon, Jul 14, 2003 at 08:01:21AM -0700, Joe McCarty wrote:
> I combed this script looking for a definition of the dsn list that might show
> a case variance in the actual test. I didn't see it, but I'm not a
> programer. My install of MySQL is fresh, from a binary distribution, on a
> new RedHat 7.3 box. The only two databases on this new install are "mysql"
> and "test" (the default testdb for "perl Makefile.PL).
>
> What might I be looking for?
>
> Can I go ahead and install with confidence?
>
> Thanks,
>
> Joe McCarty
>
> On Friday 11 July 2003 02:19 pm, Jochen Wiedmann wrote:
> > Zitat von Joe McCarty :
> > > t/akmisc...........ok
> > > t/dbdadmin.........ok 6/21New DB not in DSN list
> > > t/dbdadmin.........NOK 11DSN testab not in DSN list.
> > > t/dbdadmin.........NOK 15DSN testac not in DSN list.
> > > t/dbdadmin.........FAILED tests 7, 11, 15
> > > Failed 3/21 tests, 85.71% okay
> > >
> > > What is the issue, and what is the remedy?
> >
> > I do not believe that this is an actual problem. I would rather think
> > that this is something related to upper- vs. lowercase letters or
> > something similar.
> >
> > Would you mind to dig into the test script a little bit and find out
> > what's wrong?
> >
> >
> > Regards,
> >
> > Jochen

--
Carl Hansen
Pictopia.com, Inc.
carl@pictopia.com
510 658 6587 x 117

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD-mysql-2.1028 test failure

am 14.07.2003 19:59:58 von carl

Re: Random IDs

am 14.07.2003 23:19:38 von Dave Howorth

Octavian Rasnita wrote:
> I want to insert a random ID, and not an auto_increment one.
> Please tell me which should be the simplest method, because I need to
check
> first that random ID to be unique.

I think you need to tell us why you need a random ID, because if you do as
you say and check whether the ID is a duplicate then you're changing the
probability function and it's no longer random! If you want something that's
truly random then it can't be an ID. So what are you trying to achieve?

Cheers, Dave

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Random IDs

am 14.07.2003 23:19:38 von Dave Howorth

Re: Random IDs

am 14.07.2003 23:33:53 von mussatto

> Hi all,
>
> I want to insert more records in a database and for each record I want
> to insert a random ID, and not an auto_increment one.
> Please tell me which should be the simplest method, because I need to
> check first that random ID to be unique.
> Should I generate a random ID, then check the database to see if there
> is such an ID in it, and if it is, generate another one, and so on until
> the ID generated is a newer one, then insert it into the database?
>
> I think that this process could take a long time. Is there a better
> method?
>
> Thanks.
>
> Teddy,
> Teddy's Center: http://teddy.fcc.ro/
> Email: orasnita@home.ro
>
If you want true randomness, then your approach will work. If the random
Id column is set as Unique then just insert the record and check for
failure. If it fails, generatea new id. It should be relatively fast if
the random ID field size is large relative to the actual number of records
you will have in the database. Speed should be an issue only if the
number of records approaches (say within a factor of 100) of the RandomID
size. This assumes you are actually using truely random process. If you
are using perl I believe there is a dicussion on how to get a random seed
for each program run. At least during debugging, make sure that you count
down the number of tries and do an error exit if say 2000 tries fail (you
may have bad sql or someone passed you data in one of the fields you
weren't expecting. Otherwise you will loop forever (now what's the
process ID and how do I kill it...been there).

William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Random IDs

am 14.07.2003 23:33:53 von mussatto

Re: Random IDs

am 15.07.2003 00:17:22 von Octavian Rasnita

Ok, here is why I want this.

I've cracked a site of an email provider and I've stolen all their email
addresses, not for other purposes but just for testing, because in their
database the users had IDs starting from 1 to over 6000.

I've seen that they put that id in the cookie sent to my computer and I've
changed that cookie to show another number, and the email address for that
ID appeared in the form on the web site and I needed to input only the
password.
I've done the same thing for all their email addresses and now I have them.
Of course, not manually, but using a perl script.

I don't want to make that mistake, because maybe sometimes in the future I
will forget to check every time a session ID, and maybe sometimes I will
need to allow the user see its email address without logging in, just like
in the case I've described.

I've seen some sites that use a random number with numbers and letters for
this, but I don't know which would be the best solution to insert it into
the database.

Thanks.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: orasnita@home.ro

----- Original Message -----
From: "Dave Howorth"
To:
Sent: Tuesday, July 15, 2003 12:19 AM
Subject: Re: Random IDs

Octavian Rasnita wrote:
> I want to insert a random ID, and not an auto_increment one.
> Please tell me which should be the simplest method, because I need to
check
> first that random ID to be unique.

I think you need to tell us why you need a random ID, because if you do as
you say and check whether the ID is a duplicate then you're changing the
probability function and it's no longer random! If you want something that's
truly random then it can't be an ID. So what are you trying to achieve?

Cheers, Dave

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=orasnita@home.ro

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Random IDs

am 15.07.2003 00:17:22 von Octavian Rasnita

Re: Random IDs

am 15.07.2003 02:51:45 von mussatto

> Ok, here is why I want this.
>
> I've cracked a site of an email provider and I've stolen all their email
> addresses, not for other purposes but just for testing, because in their
> database the users had IDs starting from 1 to over 6000.
>
> I've seen that they put that id in the cookie sent to my computer and
> I've changed that cookie to show another number, and the email address
> for that ID appeared in the form on the web site and I needed to input
> only the password.
> I've done the same thing for all their email addresses and now I have
> them. Of course, not manually, but using a perl script.
>
> I don't want to make that mistake, because maybe sometimes in the future
> I will forget to check every time a session ID, and maybe sometimes I
> will need to allow the user see its email address without logging in,
> just like in the case I've described.
>
> I've seen some sites that use a random number with numbers and letters
> for this, but I don't know which would be the best solution to insert it
> into the database.
>
> Thanks.
>
> Teddy,
> Teddy's Center: http://teddy.fcc.ro/
> Email: orasnita@home.ro
>
> ----- Original Message -----
> From: "Dave Howorth"
> To:
> Sent: Tuesday, July 15, 2003 12:19 AM
> Subject: Re: Random IDs
>
>
> Octavian Rasnita wrote:
>> I want to insert a random ID, and not an auto_increment one.
>> Please tell me which should be the simplest method, because I need to
> check
>> first that random ID to be unique.
>
> I think you need to tell us why you need a random ID, because if you do
> as you say and check whether the ID is a duplicate then you're changing
> the probability function and it's no longer random! If you want
> something that's truly random then it can't be an ID. So what are you
> trying to achieve?
>
> Cheers, Dave
>
Figured it was something like this. They want to have both a username
(letters) and a random number and make sure they match. This will also
increase the likelyhood of picking up an imposter.

Warning though, if its truely random they will write it down and paste it
on the outside of their laptop (read about that one on the security
section of a weekly magazine). Tying the cookie with a random number in
it and their username might help if they will always be coming in from the
same machine.

Bill

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Random IDs

am 15.07.2003 02:51:45 von mussatto