| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> given the number of multi-million record identity theft occurrences at the credit card processing companies, I just presumed that was in the contract ;)
<1> shabbs: but have a look at the C-source, it is virtually a copy paste to have it perform an encryption
<2> shabbs: lol
<1> shabbs: it uses http://www.eskimo.com/~weidai/cryptlib.html , there are some examples on using AES
<1> ... if you really want something quick and dirty :)
<2> err sjrussell
<0> shabbs - do they allow non-symetric encryption?
<3> K_F: not really looking for quick and dirty, more like quick and official. it'd be so much easier if mysql just shipped with aes256 by default, or openssl compiled in
<3> I know the last one is a licensing thing so
<1> shabbs: yeah, I wouldn't say no to some proper hashing support
<1> and encryption ..
<0> like PGP for example - put the public key on the webserver, lock the private in a vault
<3> sjrussel: afaik the 3 approved algorithms were tdes, aes256 and rsa1024
<1> sjrussel: technically OpenPGP actually use a hybrid
<4> K_F, a bit of problem here, i have this query http://pastebin.com/637712 Now it returns 2 rows e.g. but i want that if add other req for part 14 (which is not ***igned to that ad) it would return zero rows
<0> K_F - for the public key encryption, or to transmit the keys?
<1> sjrussel: the message itself is encrypted using a symmetrical encryption to a random key. the key itself is stored for each recipient using an asymmetrical encryption
<0> ah
<0> for speed, right?
<1> and size
<0> seems like that could be changed for a secure application
<0> maybe not as easy as cut-n-paste :)
<1> but you can use it in symmetrical mode only, so to speak
<1> -c, --symmetric encryption only with symmetric cipher
<0> I was thinking asymetrical would be better
<5> Hi guys, I really hate to interrupt with such a newbie mysql related question, but is there an easier way to do this ... How would I best do this statement ... ? WHERE teachers.arrival=school_jobs.month OR teachers.arrival+1=school_jobs.month OR teachers.arrival-1=school_jobs.month ... ?
<0> to control access to the data
<2> crypto nerds
<1> sjrussel: the theoretical similarity for a 256bit symmetrical cipher would be a 15360 bit asymmetrical key though :)
<1> sjrussel: http://www.kfwebs.net/news/62 if you want ot read more about my tests on that :p
<0> babo - < / > or BETWEEN
<1> alphablue: I've never claimed otherwise :) I even have http://www.secure-my-email.com :)
<2> hah
<6> is it possible to do two queries in one line?
<6> instead of
<6> $newnamea = "INSERT INTO one(id, name) VALUES ('$count2', '$namea')";
<6> $newaddressa = "INSERT INTO two(id, address) VALUES ('$count2', '$addressa')";
<2> espionage: depends on your version of mysql
<0> K_F - really? I thought the reverse
<2> 4.1+ you have subselects
<6> ah
<6> how do i check the version, if its on my webhost's server?
<1> sjrussel: well, don't take the number in itself for real, different types of attacks would be used, but yes, you require a grander asymmetrical key for it to be of the same strength
<2> php ?
<3> anyone know if a mysql network subscription buys us 'custom' compiled servers?
<1> shabbs: sorry, no idea
<2> http://us3.php.net/manual/en/function.mysql-get-server-info.php
<7> K_F: How do you get the short name or utc ofset for datetime in a particular timezone? eg CONVERT_TZ("2006-04-01 12:00:00", 'UTC', 'Europe/London') - how do I know if the result is GMT (+0) or BST (+1) ?
<1> Trevelyan`: well, you do say from timezone: UTC to timezone...
<1> anyways the result of your query is UTC+1
<8> is there a function to get the next autoincrement value of a field?
<1> kon: that is impossible
<1> due to a multi-user environment
<6> 4.1.15-standard15
<6> :D
<1> kon: who knows if another user concurrently inserts a record?
<6> subselects :D
<7> K_F no. that one is BST (UTC+1) but CONVERT_TZ("2006-03-01 12:00:00", 'UTC', 'Europe/London') is GMT UTC+0
<1> kon: read up on last_insert_id()
<8> K_F: this always returns 0
<1> kon: after you insert a record to a table with an auto-incremental field?
<6> alphablue: even its its not a select query?
<6> what if its insert, update or delete?
<1> Trevelyan`: it returns 2006-04-01 13:00:00 here
<8> nope, that's the problem. so i need to insert something first, there is no way around that?
<3> right
<8> K_F what i am trying to do is copy one table to another
<1> and INSERT INTO ..... SELECT doesn't work?
<7> K_F, your timezone table/db is broken if CONVERT_TZ("2006-03-01 12:00:00", 'UTC', 'Europe/London') doesn't give 2006-03-01 12:00:00 for you
<1> | CONVERT_TZ("2006-04-01 12:00:00", "UTC", "Europe/London") |
<1> | 2006-04-01 13:00:00 |
<7> K_F, use mysql_tzinfo_to_sql to update them (on Linux) or down load the tables if you on Windows
<7> | CONVERT_TZ("2006-03-01 12:00:00", 'UTC', 'Europe/London') |
<6> does anyone know if its possible to use sub queries to consolidate UPDATE, INSERT and DELETE queries?
<7> | 2006-03-01 12:00:00
<7> | CONVERT_TZ("2006-04-01 12:00:00", 'UTC', 'Europe/London') |
<7> | 2006-04-01 13:00:00
<7> K_F, note 2006-03-01 and 2006-04-01
<9> hi guys. i've got a big mysql dump (about 7,5 mbytes). if i try to import it (e.g. by using mysql <settings> < dump.sql) i get he error "Got a packet bigger than 'max_allowed_packet' bytes". where is this 'max_allowed_packet' setting?
<7> March and April. UK went UTC+1 on March 26 at 1AM
<9> the error*
<10> anno: It's in your my.cnf most likely?
<1> Trevelyan`: yeah, you're right I didn't notice you switching between 04 and 03
<1> and I know. I'm on CEST myself
<1> so we switched at the same time..
<1> Anyways, I should read some econometrics
<9> Etriaph: hm, perhaps it's more intelligent to use mysqldump for backuping the dump?
<1> enjoy folks
<10> anno: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
<7> I can convert UTC to localtime eg with CONVERT_TZ but then I can't display (or get) what the resulting local ofset is
<5> The last AND statement here is mandatory ... where do I put my brackets ??? ... WHERE teachers.arrival = recruiter_jobs.arrival BETWEEN recruiter_jobs.arrival -1 AND recruiter_jobs.arrival +1
<5> AND teachers.location=recruiter_jobs.city";
<5> oops...
<5> The last AND statement here is mandatory ... where do I put my brackets ??? ... WHERE teachers.arrival BETWEEN recruiter_jobs.arrival -1 AND recruiter_jobs.arrival +1
<7> unless I do TIMEDIFF("2006-04-01 12:00:00", CONVERT_TZ("2006-04-01 12:00:00", 'UTC', 'Europe/London'));
<7> which is a bit silly
<7> is it worth suggesting a new func/feature for mysql to improve its methods of presenting time
<7> It nice i can convert to localtime, but i still need to know what ofset was applied
<11> i'm trying to build an application frontend in php for a customer database. Whats the best way to record all changes? triggers? query log? or do it in the frontend?
<12> !man to_unixtime
<13> Nothing found.
<12> wtf
<12> !man from_unixtime
<13> (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<12> wtf
<12> oh
<12> !man unix_timestamp
<13> (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<12> ah
<12> sorry
<14> Hi! http://www.muzyka.oz.pl :)
<0> ??
<11> if i was to use triggers to create an audit trail
<11> whats the best way to p*** the username from php to mysql?
<2> ?
<11> i mean like. If user x logs in and deletes company z. All that gets past to mysql is
<11> delete company where id=companyid;
<3> cmwneo: current_user()
<11> so the trigger is only going to copy the company data to the audit table
<11> shabbs wouldn't that be the current mysql user?
<3> right
<3> that's as close as you get
<11> ;\ so there is no way to past varibles to triggers via querys?
<3> you could theoretically be p***ing a value through your query, but if a person does 'delete from company blah blah' they most likely won't p*** all the information you need anyway
<11> well the query is generated in php
<11> the frontend enforces the restrictions
<15> http://hashmysql.org/paste/viewentry.php?id=1655
<3> in that case you might want to consider stored procedures rather than triggers to keep an audit trail
<15> i'm getting errno: 150
<15> which is "improper foreign key" relationships on the code i just pasted
<15> anyone know why?
<16> show innodb status
<16> check the LATEST FOREIGN KEY part
<15> it works if I comment out the foreign keys
<15> flupps|NL, talking to me?
<11> shabbs how so?
<15> latest foreign key?
<16> !perror 150
<13> MySQL error: 150 = Foreign key constraint is incorrectly formed
<15> yes
<3> cmwneo: well, for one you can p*** in variables such as user names
<15> but i don't know how it's incorrect
<15> i read the docs, it looks exactly like it should afaik
<3> cmwneo: and if you're enforcing a restriction anyway, you might as well have the sp do the work for ya
<15> flupps|NL mind taking a look at http://hashmysql.org/paste/viewentry.php?id=1655 ?
<15> http://pastebin.com/637812
<15> that's the error I was getting
<17> How could I update 4 tables which are connected each other with field ID_ART with a single query, after I am collecting the info with a php form ?
<15> i googled the error but a lot of places had it listed as a bug
<15> having to do with primary keys
Return to
#mysql
or
Go to some related
logs:
#web
reiserfs ubuntu v4
wine ragexe.exe font
#sql
#fluxbox
call python from java
#perl
#php
+what starts xscreensaver linux
gparted plugdev
|
|