jabba:~/koha-2.0.2$ mysql -u root -pjabba:~/koha-2.0.2$ perl -e 'use DBI; use DBI::DBD; use DBD::mysql;' mslowejabba:~/koha-2.0.2$jabba:~/koha-2.2.4$← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 16:34 | owen | does Koha use mysql's built-in md5 function for encrypting passwords? |
| 16:34 | paul | hi owen. |
| 16:34 | owen | Hi paul. You're up late! |
| 16:34 | paul | (yes, lot of stuff...) |
| 16:34 | (working while listening france - costa rica in soccer, in 30mn) | |
| 16:36 | the answer to your question is no | |
| 16:36 | use Digest::MD5 qw(md5_base64); | |
| 16:36 | my $digest=md5_base64($input->param('newpassword')); | |
| 16:36 | uses Perl Diget::MD5 | |
| 16:36 | owen | So it uses that to encrypt the password before inserting it into the database? |
| 16:37 | paul | ye |
| 16:37 | p | |
| 16:37 | owen | Okay, thanks |
| 16:42 | Ah... found it. Thanks Internet! | |
| 22:22 | jamesa | hey Chris, are you ever logged out of this channel? |
| 22:23 | you are on every time I login | |
| 22:28 | rach | his connection is up all the time |
| 22:28 | but he personally isn't here the whole time | |
| 22:28 | jamesa | yeah, so I have gathered |
| 22:29 | I am working through getting z3950 queries to loc working to begin populating my pool, | |
| 22:29 | any tips ? | |
| 22:29 | rach | most of us that would be the same thing |
| 22:29 | umm have a lot of patience I believe is the best tip | |
| 22:29 | but you prolly need to ask one of the americans about it | |
| 22:30 | jamesa | where r u ? |
| 22:31 | I am in east coast Australia | |
| 22:32 | rach | NZ |
| 22:33 | do you have a kinitica connection/account? | |
| 22:33 | jamesa | no what is that ? |
| 22:35 | rach | australian national library equiv of loc |
| 22:35 | what sort of library are you? | |
| 22:35 | you might find them easier/quicker etc to get records from | |
| 22:35 | but I believe they will charge you - | |
| 22:36 | they wanted to charge us when we asked for a demo account @alia conference last year | |
| 22:36 | wwas about $350 from memory | |
| 22:37 | jamesa | I am setting up a koha installation at home to get familiar with it, a local environmental org has a small library |
| 22:37 | they want to computerize ( now on cards!) | |
| 22:38 | so I am using my books at home and learning as I go | |
| 22:39 | do people really wait till the biblio.item is in before printing barcodes or do they use an external program to print them ? | |
| 22:39 | rach | ah right |
| 22:40 | um both - the big libraries usually get a roll of codes printed for them | |
| 22:40 | so they have a box of stickers | |
| 22:41 | and others do make their own sheets of stickers I believe | |
| 22:41 | jamesa | have you used kbarcode ? |
| 22:59 | Ok, have a nice day rach | |
| 22:59 | cheers | |
| 10:45 | foo | DBI connect('Koha:localhost','kohaadmin',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/koha/intranet/modules/C4/Context.pm line 368 |
| 10:46 | similar error for 2.2 but different line number on Context.pm | |
| 10:46 | paul | frenchies are not sleeping at this hour ;-) |
| 10:46 | foo | kiwis are though ;) |
| 10:46 | paul | but i have no ideas aboutyour problem... pls explain OS & other soft versions |
| 10:47 | foo | linux[debian], apache, mysql4.1.11 |
| 10:47 | paul | which debian ? sarge ? older ? |
| 10:47 | foo | stable |
| 10:47 | paul | compiled package or .deb ? |
| 10:48 | does mysql -uroot -p YOUR_DB work ? | |
| 10:48 | foo | for what? |
| 10:48 | yes | |
| 10:48 | paul | (on command line) |
| 10:48 | foo | mslowejabba:~/koha-2.0.2$ mysql -u root -p |
| 10:48 | paul | (mysql) |
| 10:48 | foo | Enter password: |
| 10:48 | Welcome to the MySQL monitor. Commands end with ; or \g. | |
| 10:48 | Your MySQL connection id is 12 to server version: 4.1.11-Debian_4sarge2-log | |
| 10:48 | oh, deb for mysql | |
| 10:49 | paul | dig Perl::DBI & Perl::DBD & Perl::DBD::mysql |
| 10:49 | to check they are installed | |
| 10:49 | foo | hmm, kind of assumed they were, will check |
| 10:50 | libdbd-mysql is already the newest version. | |
| 10:50 | libdbd-mysql-perl is already the newest version. | |
| 10:50 | libdbi-perl is already the newest version. | |
| 10:52 | mslowejabba:~/koha-2.0.2$ perl -e 'use DBI; use DBI::DBD; use DBD::mysql;' mslowejabba:~/koha-2.0.2$ |
|
| 10:52 | paul | koha 2.0.2 ???? |
| 10:52 | foo | i tried 2.2 too |
| 10:53 | i was trying an older version ;) | |
| 10:53 | mslowejabba:~/koha-2.2.4$ |
|
| 10:53 | better? ;) | |
| 10:54 | from 2.2.4, i get: | |
| 10:54 | Creating the MySQL database for Koha... | |
| 10:54 | ERROR 1062 (23000) at line 1: Duplicate entry 'localhost-kohaadmin' for key 1 | |
| 10:54 | 256ERROR 1062 (23000) at line 1: Duplicate entry '%-Koha-kohaadmin' for key 1 | |
| 10:54 | DBI connect('Koha:localhost','kohaadmin',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/koha/intranet/modules/C4/Context.pm line 411 | |
| 10:54 | Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1008. | |
| 10:55 | Problem updating database... | |
| 10:55 | paul | (on phone) |
| 10:55 | foo | k |
← Previous day | Today | Next day → | Search | Index
