Yubico Forum ...visit our web-store at 2009-08-19T12:20:29+01:00 https://forum.yubico.com/feed.php?f=5&t=367 2009-08-19T12:20:29+01:00 2009-08-19T12:20:29+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1686#p1686 <![CDATA[Re: ykksm and ykval setup for yms]]>
Code:
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=8.04
DISTRIB_CODENAME=hardy
DISTRIB_DESCRIPTION="Ubuntu 8.04.1"


The following PHP 5 packages are installed on the server:

Code:
root@ubuntu-server:~# dpkg -l | grep php5
ii  libapache2-mod-php5-zend-ce           5.2.10                      server-side, HTML-embedded scripting languag
ii  php5-cli                              5.2.4-2ubuntu5.6            command-line interpreter for the php5 script
ii  php5-common                           5.2.4-2ubuntu5.6            Common files for packages built from the php
ii  php5-extra-extensions-zend-ce         4.0.0-1+b63                 Additional PHP extensions.
ii  php5-mysql                            5.2.4-2ubuntu5.6            MySQL module for php5
ii  php5-unix-extensions-zend-ce          4.0.0-1+b63                 PHP Sys V and POSIX extensions.
root@ubuntu-server:~#


We hope this helps!

Statistics: Posted by network-marvels — Wed Aug 19, 2009 12:20 pm

]]> 2009-08-19T05:51:44+01:00 2009-08-19T05:51:44+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1684#p1684 <![CDATA[Re: ykksm and ykval setup for yms]]>

thanks

Statistics: Posted by mo5245 — Wed Aug 19, 2009 5:51 am

]]> 2009-08-13T08:35:02+01:00 2009-08-13T08:35:02+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1670#p1670 <![CDATA[Re: ykksm and ykval setup for yms]]>
We populated the respective databases using the dumps provided by you and we were able to verify the OTP successfully. We then dropped the "yubico" database, created an empty "yubico" database, populated the schema using the "yubiphpbase/db/setup_schema.sql", replaced our "config.php" file with the "config.php" file provided by you and ran the "install.php" script, changed the "tokenID" column to "publicName" column and we were able to successfully validate the OTP and login to the YMS server.

When we used one of the OTP provided by you earlier as follows:
Code:
yubikey-val-server-php/ykval-verify.php?id=1&otp=jgnibvduunfvvtdfiklvctfhkrdbnhbddlclclkhjkee


we received the following status:
Code:
h=DMeBJNIwMQFecmF3qIdCoXzbcVw=
t=2009-08-12T17:29:15Z0391
status=OK



We are attaching the working copies of the config.php, ykval-config and the respective database dumps from our environment.

We would appreciate if you can populate the databases according to the dumps provided and try again.

Statistics: Posted by network-marvels — Thu Aug 13, 2009 8:35 am

]]> 2009-08-12T17:35:07+01:00 2009-08-12T17:35:07+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1669#p1669 <![CDATA[Re: ykksm and ykval setup for yms]]>
ykksm
Code:
-- MySQL dump 10.11
--
-- Host: localhost    Database: ykksm
-- ------------------------------------------------------
-- Server version   5.0.68

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `yubikeys`
--

DROP TABLE IF EXISTS `yubikeys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `yubikeys` (
  `id` int(11) NOT NULL auto_increment,
  `serialNr` int(11) default NULL,
  `publicName` varchar(16) default NULL,
  `created` datetime NOT NULL,
  `internalName` varchar(12) default NULL,
  `aesKey` varchar(32) default NULL,
  `lockCode` varchar(12) default NULL,
  `creator` varchar(8) default NULL,
  `active` tinyint(1) default '1',
  `hardware` tinyint(1) default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `publicName` (`publicName`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `yubikeys`
--

LOCK TABLES `yubikeys` WRITE;
/*!40000 ALTER TABLE `yubikeys` DISABLE KEYS */;
INSERT INTO `yubikeys` VALUES (1,1,'jgnibvduunfv','2009-08-01 21:27:51','e7797c4edc91','d0bcfe42958ed134b2d3800b98b2a0de',NULL,NULL,1,0);
/*!40000 ALTER TABLE `yubikeys` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-08-12 16:29:30



ykval
Code:
-- MySQL dump 10.11
--
-- Host: localhost    Database: ykval
-- ------------------------------------------------------
-- Server version   5.0.68

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `clients` (
  `id` int(11) NOT NULL auto_increment,
  `active` tinyint(1) default '1',
  `created` datetime NOT NULL,
  `secret` varchar(60) NOT NULL default '',
  `email` varchar(255) default NULL,
  `notes` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,1,'2008-08-07 21:27:51','IAjGn8pkXZ0RfotKYoMuP6Gih8jTXf6tdIvP61U9pVzGtOpDWa/tA4twPS7p','admin@localhost',NULL);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yubikeys`
--

DROP TABLE IF EXISTS `yubikeys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `yubikeys` (
  `id` int(11) NOT NULL auto_increment,
  `active` tinyint(1) default '1',
  `created` datetime NOT NULL,
  `accessed` datetime default NULL,
  `publicName` varchar(16) NOT NULL,
  `internalName` varchar(12) NOT NULL,
  `counter` int(11) default NULL,
  `low` int(11) default NULL,
  `high` int(11) default NULL,
  `sessionUse` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `publicName` (`publicName`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `yubikeys`
--

LOCK TABLES `yubikeys` WRITE;
/*!40000 ALTER TABLE `yubikeys` DISABLE KEYS */;
INSERT INTO `yubikeys` VALUES (1,1,'2008-09-03 02:21:34','2008-09-03 02:21:34','jgnibvduunfv','e7797c4edc91',0,0,0,0);
/*!40000 ALTER TABLE `yubikeys` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-08-12 16:28:51



yubico
Code:
-- MySQL dump 10.11
--
-- Host: localhost    Database: yubico
-- ------------------------------------------------------
-- Server version   5.0.68

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `admin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyid` int(11) NOT NULL default '0',
  `note` varchar(45) default NULL,
  `pin` varchar(120) default NULL,
  `last_access` datetime default NULL,
  `ip` varchar(45) default NULL,
  `creation` datetime default NULL,
  `client` int(11) NOT NULL default '0',
  `timeout` int(10) unsigned NOT NULL default '3600',
  PRIMARY KEY  (`id`),
  KEY `FK_admin_2` (`keyid`),
  KEY `FK_admin_1` (`client`),
  CONSTRAINT `FK_admin_1` FOREIGN KEY (`client`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_admin_2` FOREIGN KEY (`keyid`) REFERENCES `yubikeys` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (3,1,'Root admin','HwHU6NyGMiPJdeALdipiOw==','2009-08-12 12:08:58','127.1.1.0','2009-08-12 12:08:58',1,3600);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `buyers`
--

DROP TABLE IF EXISTS `buyers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `buyers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `email` varchar(100) default NULL,
  `created` datetime default NULL,
  `addr` varchar(200) default NULL,
  `qty` int(10) unsigned default NULL,
  `client_id` int(11) NOT NULL default '0',
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK_client_id_1` USING BTREE (`client_id`),
  CONSTRAINT `FK_client_info_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `buyers`
--

LOCK TABLES `buyers` WRITE;
/*!40000 ALTER TABLE `buyers` DISABLE KEYS */;
/*!40000 ALTER TABLE `buyers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `clients` (
  `id` int(11) NOT NULL auto_increment,
  `perm_id` int(11) default NULL,
  `active` tinyint(1) default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `email` varchar(255) NOT NULL default '',
  `secret` varchar(60) NOT NULL default '',
  `notes` varchar(100) default NULL,
  `chk_sig` tinyint(1) NOT NULL default '0',
  `chk_owner` tinyint(1) NOT NULL default '0',
  `chk_time` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `perm_id` (`perm_id`),
  CONSTRAINT `clients_ibfk_1` FOREIGN KEY (`perm_id`) REFERENCES `perms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,1,1,'2009-08-12 12:08:58','admin@localhost','o4wMIib34RuPp+eyXky+szZOIVTjudsPSTN7iGyn9fw=','Root client',0,0,1);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history`
--

DROP TABLE IF EXISTS `history`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `usrid` int(10) unsigned NOT NULL default '0',
  `note` varchar(45) NOT NULL default '',
  `ip` varchar(45) NOT NULL default '',
  `creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `keyid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `FK_hist_1` (`usrid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history`
--

LOCK TABLES `history` WRITE;
/*!40000 ALTER TABLE `history` DISABLE KEYS */;
/*!40000 ALTER TABLE `history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `perms`
--

DROP TABLE IF EXISTS `perms`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `perms` (
  `id` int(11) NOT NULL auto_increment,
  `verify_otp` tinyint(1) default '0',
  `add_clients` tinyint(1) default '0',
  `delete_clients` tinyint(1) default '0',
  `add_keys` tinyint(1) default '0',
  `delete_keys` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `perms`
--

LOCK TABLES `perms` WRITE;
/*!40000 ALTER TABLE `perms` DISABLE KEYS */;
INSERT INTO `perms` VALUES (1,1,1,1,1,1),(2,1,0,0,1,1),(3,1,0,0,0,0);
/*!40000 ALTER TABLE `perms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yubikeys`
--

DROP TABLE IF EXISTS `yubikeys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `yubikeys` (
  `id` int(11) NOT NULL auto_increment,
  `client_id` int(11) NOT NULL default '0',
  `active` tinyint(1) default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `accessed` datetime default NULL,
  `publicName` varchar(60) character set latin1 collate latin1_bin default NULL,
  `userId` varchar(60) NOT NULL default '',
  `secret` varchar(60) NOT NULL default '',
  `counter` int(11) default NULL,
  `low` int(11) default NULL,
  `high` int(11) default NULL,
  `notes` varchar(100) default NULL,
  `serial` varchar(45) default NULL,
  `sessionUse` int(11) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userId` (`userId`),
  UNIQUE KEY `tokenId` (`publicName`),
  UNIQUE KEY `sn` (`serial`),
  KEY `client_id` (`client_id`),
  CONSTRAINT `yubikeys_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `yubikeys`
--

LOCK TABLES `yubikeys` WRITE;
/*!40000 ALTER TABLE `yubikeys` DISABLE KEYS */;
INSERT INTO `yubikeys` VALUES (1,1,1,'2009-08-12 12:08:58','2009-08-12 12:08:58','hbcfLutP','MTI1MDA5MzMzOA==','IAjGn8pkXZ0RfotKYoMuP6Gih8jTXf6tdIvP61U9pVzGtOpDWa/tA4twPS7p',0,0,0,'Root admin key','00001001',0);
/*!40000 ALTER TABLE `yubikeys` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-08-12 16:28:34

Statistics: Posted by mo5245 — Wed Aug 12, 2009 5:35 pm

]]> 2009-08-12T17:25:04+01:00 2009-08-12T17:25:04+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1668#p1668 <![CDATA[Re: ykksm and ykval setup for yms]]>
Code:
<?php
/******************************************************
*
*      Customize EVERY parameter for your environment
*
******************************************************/

//// AES secrets
//
$aesParams = array ();

/******** Erase this section after installation *******/

// OTP from your admin key you are to use to log in to KMS
// Eg. $otp = 'gklhtdkvrbfnbuicngergckgdfvfrbfjfhgiffghcithv';
$otp = 'jgnibvduunfvjibrukdntjbfdtdfnlnlkrifjjlgkicb';

// Admin PIN as the 2nd factor of auth
//Eg. $pin = '12345678';
$pin = '1234';

// This is the AES secret inside your key
// Eg. $aesParams['__ADM_KEY_SECRET__'] = '7Bs1Rl4Itr2+ZmbyO/KCWQ==';
$aesParams['__ADM_KEY_SECRET__'] = 'd0bcfe42958ed134b2d3800b98b2a0de';

/********* End of section to erase after installation *******/
// Make up a random secret to encrypt data in DB in b64 format
$aesParams['__ENC_KEY_SECRET__'] = '0Lz+QpWO0TSy04ALmLKg3g==';

//// DB, email and web related
//
$baseParams = array ();
$baseParams['__DB_HOST__'] = 'localhost';
$baseParams['__DB_USER__'] = 'yubico';
$baseParams['__DB_PW__'] = 'yubico';
$baseParams['__DB_NAME__'] = 'yubico';

// Eg. $baseParams['__ROOT_EMAIL__'] = 'support@yubico.com';
$baseParams['__ROOT_EMAIL__'] = 'admin@localhost';

$baseParams['__ORDER_URL__'] = 'http://yubico.com/products/order/';
$baseParams['__DOMAIN__'] = 'localhost';

// Eg. $baseParams['__DOC_ROOT__'] = '/apache/htdocs/'
$baseParams['__DOC_ROOT__'] = '/var/www/html/';

//// Validation server
//

$valParams = array ();
$valParams['__VAL_URL__'] = 'http://localhost/wsapi/verify.php?id=';

//// HTML related
//
$headParams = array ();
$headParams['__SHORTCUT_ICON_URL__'] = 'http://localhost/kms/images/favicon.ico';

//// KMS admin activation welcome letter
//
$letterParams = array ();
$letterParams['__KMS_URL__'] = 'http://localhost/kms';

?>


ran php install.php got
Code:
* Connected to DB successfully
Insert root client
Insert root client key
Insert root admin


updated DB with alter command

and im still getting
Code:
OK counter=0004 low=8058 high=1f use=02
on
Code:
/decrypt.php?otp=jgnibvduunfvibntlhkkgleghcdntnbrelvhntvgekji


and for
Code:
verify.php?id=1&otp=jgnibvduunfvibntlhkkgleghcdntnbrelvhntvgekji
i get
Code:
h=M0Ox8a2TyNcwHLejjaz+OLXPcfw=
t=2009-08-12T16:21:35Z0401
status=BAD_OTP


will add mysql dumps

Statistics: Posted by mo5245 — Wed Aug 12, 2009 5:25 pm

]]> 2009-08-12T16:14:06+01:00 2009-08-12T16:14:06+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1667#p1667 <![CDATA[Re: ykksm and ykval setup for yms]]>
Code:
<?php
/******************************************************
 *
 *      Customize EVERY parameter for your environment
 *
 ******************************************************/

//// AES secrets
//
$aesParams = array ();

/******** Erase this section after installation *******/

// OTP from your admin key you are to use to log in to KMS
// Eg. $otp = 'gklhtdkvrbfnbuicngergckgdfvfrbfjfhgiffghcithv';
$otp = 'jgnibvduunfvrhjjrbnrgiiiuvgjhfnntchtnubdnfjb';

// Admin PIN as the 2nd factor of auth
//Eg. $pin = '12345678';
$pin = '12345';

// This is the AES secret inside your key
// Eg. $aesParams['__ADM_KEY_SECRET__'] = '7Bs1Rl4Itr2+ZmbyO/KCWQ==';
$aesParams['__ADM_KEY_SECRET__'] = '.....enter yours.....';

/********* End of section to erase after installation *******/

// Make up a random secret to encrypt data in DB in b64 format
// Eg. $aesParams['__ENC_KEY_SECRET__'] = 'gklftrkvbvcbfhdafbedtjerrbbcgkuk';
$aesParams['__ENC_KEY_SECRET__'] = 'bml0aW5wYXRpbA0K';

//// DB, email and web related
//
$baseParams = array ();
$baseParams['__DB_HOST__'] = 'localhost';
$baseParams['__DB_USER__'] = 'yubico';
$baseParams['__DB_PW__'] = 'yubico';
$baseParams['__DB_NAME__'] = 'yubico';

// Eg. $baseParams['__ROOT_EMAIL__'] = 'support@yubico.com';
$baseParams['__ROOT_EMAIL__'] = 'admin@localhost';

$baseParams['__ORDER_URL__'] = 'http://yubico.com/products/order/';
$baseParams['__DOMAIN__'] = 'localhost';

// Eg. $baseParams['__DOC_ROOT__'] = '/apache/htdocs/'
$baseParams['__DOC_ROOT__'] = '/var/www';

//// Validation server
//

$valParams = array ();
$valParams['__VAL_URL__'] = 'http://localhost/wsapi/verify.php?id=';

//// HTML related
//
$headParams = array ();
$headParams['__SHORTCUT_ICON_URL__'] = 'http://localhost/kms/images/favicon.ico';

//// KMS admin activation welcome letter
//
$letterParams = array ();
$letterParams['__KMS_URL__'] = 'http://localhost/kms';

?>


Please change the $otp, $pin and $aesParams['__ENC_KEY_SECRET__'] as per your setup.

Once the config.php is populated correctly, please follow the steps below:
    1) Please delete the yubico database and recreate it using the "setup_schema.sql" present in the "yubiphpbase/db" directory.
    2) Go to the yubiphpbase directory and run the following command:
    Code:
    php install.php

    3) Login to the MySQL database, select the "yubico" database and change the tokenID column of the yubikeys table to publicName by using the following command:
    Code:
    alter table yubikeys change column tokenId publicName varchar(60) character set latin1 collate latin1_bin default NULL;

We would appreciate if you can make the changes listed above and test again.

Statistics: Posted by network-marvels — Wed Aug 12, 2009 4:14 pm

]]> 2009-08-12T03:58:47+01:00 2009-08-12T03:58:47+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1665#p1665 <![CDATA[Re: ykksm and ykval setup for yms]]>
Code:
jgnibvduunfvrlnjnluethtnhcegktitjdrldebefiif
jgnibvduunfvvtdfiklvctfhkrdbnhbddlclclkhjkee
jgnibvduunfvgjencdtthgnbdljjftltldckgttfcdgg
jgnibvduunfvthejeujhkifhklndcguctllrkkfblrju
jgnibvduunfvincdducinculrjurtuegfhvvdnuvcrej
jgnibvduunfvghgjhnvfltgdtrnccduidlibhbubgihk
jgnibvduunfvleterbthrunhnfbdfuhedcjblltkgnji


and config.php from yubiphpbase

Code:
<?php
/******************************************************
 *
 *      Customize EVERY parameter for your environment
 *
 ******************************************************/

//// AES secrets
//
$aesParams = array ();



// Make up a random secret to encrypt data in DB in b64 format
$aesParams['__ENC_KEY_SECRET__'] = '0Lz+QpWO0TSy04ALmLKg3g==';

//// DB, email and web related
//
$baseParams = array ();
$baseParams['__DB_HOST__'] = 'localhost';
$baseParams['__DB_USER__'] = 'yubico';
$baseParams['__DB_PW__'] = 'yubico';
$baseParams['__DB_NAME__'] = 'yubico';

// Eg. $baseParams['__ROOT_EMAIL__'] = 'support@yubico.com';
$baseParams['__ROOT_EMAIL__'] = 'admin@localhost';

$baseParams['__ORDER_URL__'] = 'http://yubico.com/products/order/';
$baseParams['__DOMAIN__'] = 'localhost';

// Eg. $baseParams['__DOC_ROOT__'] = '/apache/htdocs/'
$baseParams['__DOC_ROOT__'] = '/var/www/html/';

//// Validation server
//

$valParams = array ();
$valParams['__VAL_URL__'] = 'http://localhost/wsapi/verify.php?id=';

//// HTML related
//
$headParams = array ();
$headParams['__SHORTCUT_ICON_URL__'] = 'http://localhost/kms/images/favicon.ico';

//// KMS admin activation welcome letter
//
$letterParams = array ();
$letterParams['__KMS_URL__'] = 'http://localhost/kms';

?>

Statistics: Posted by mo5245 — Wed Aug 12, 2009 3:58 am

]]> 2009-08-11T16:33:05+01:00 2009-08-11T16:33:05+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1661#p1661 <![CDATA[Re: ykksm and ykval setup for yms]]> Statistics: Posted by network-marvels — Tue Aug 11, 2009 4:33 pm

]]> 2009-08-07T09:46:45+01:00 2009-08-07T09:46:45+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1643#p1643 <![CDATA[Re: ykksm and ykval setup for yms]]>
We are working on the issue and will update you soon.

Statistics: Posted by network-marvels — Fri Aug 07, 2009 9:46 am

]]> 2009-08-06T14:52:13+01:00 2009-08-06T14:52:13+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1634#p1634 <![CDATA[Re: ykksm and ykval setup for yms]]>
DB ykksm
Code:
-- MySQL dump 10.11
--
-- Host: localhost    Database: ykksm
-- ------------------------------------------------------
-- Server version   5.0.68

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `yubikeys`
--

DROP TABLE IF EXISTS `yubikeys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `yubikeys` (
  `id` int(11) NOT NULL auto_increment,
  `serialNr` int(11) default NULL,
  `publicName` varchar(16) default NULL,
  `created` datetime NOT NULL,
  `internalName` varchar(12) default NULL,
  `aesKey` varchar(32) default NULL,
  `lockCode` varchar(12) default NULL,
  `creator` varchar(8) default NULL,
  `active` tinyint(1) default '1',
  `hardware` tinyint(1) default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `publicName` (`publicName`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `yubikeys`
--

LOCK TABLES `yubikeys` WRITE;
/*!40000 ALTER TABLE `yubikeys` DISABLE KEYS */;
INSERT INTO `yubikeys` VALUES (1,1,'jgnibvduunfv','2009-08-01 21:27:51','e7797c4edc91','d0bcfe42958ed134b2d3800b98b2a0de',NULL,NULL,1,0);
/*!40000 ALTER TABLE `yubikeys` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'ykksm'
--
DELIMITER ;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-08-06 13:07:58


DB kyval
Code:
-- MySQL dump 10.11
--
-- Host: localhost    Database: ykval
-- ------------------------------------------------------
-- Server version   5.0.68

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `clients` (
  `id` int(11) NOT NULL auto_increment,
  `active` tinyint(1) default '1',
  `created` datetime NOT NULL,
  `secret` varchar(60) NOT NULL default '',
  `email` varchar(255) default NULL,
  `notes` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,1,'2008-08-07 21:27:51','0Lz+QpWO0TSy04ALmLKg3g==','admin@localhost',NULL);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yubikeys`
--

DROP TABLE IF EXISTS `yubikeys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `yubikeys` (
  `id` int(11) NOT NULL auto_increment,
  `active` tinyint(1) default '1',
  `created` datetime NOT NULL,
  `accessed` datetime default NULL,
  `publicName` varchar(16) NOT NULL,
  `internalName` varchar(12) NOT NULL,
  `counter` int(11) default NULL,
  `low` int(11) default NULL,
  `high` int(11) default NULL,
  `sessionUse` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `publicName` (`publicName`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `yubikeys`
--

LOCK TABLES `yubikeys` WRITE;
/*!40000 ALTER TABLE `yubikeys` DISABLE KEYS */;
INSERT INTO `yubikeys` VALUES (1,1,'2008-09-03 02:21:34','2008-09-03 02:21:34','jgnibvduunfv','e7797c4edc91',0,0,0,0);
/*!40000 ALTER TABLE `yubikeys` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'ykval'
--
DELIMITER ;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-08-06 13:08:38


DB yubico
Code:
-- MySQL dump 10.11
--
-- Host: localhost    Database: yubico
-- ------------------------------------------------------
-- Server version   5.0.68

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `admin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyid` int(11) NOT NULL default '0',
  `note` varchar(45) default NULL,
  `pin` varchar(120) default NULL,
  `last_access` datetime default NULL,
  `ip` varchar(45) default NULL,
  `creation` datetime default NULL,
  `client` int(11) NOT NULL default '0',
  `timeout` int(10) unsigned NOT NULL default '3600',
  PRIMARY KEY  (`id`),
  KEY `FK_admin_2` (`keyid`),
  KEY `FK_admin_1` (`client`),
  CONSTRAINT `FK_admin_1` FOREIGN KEY (`client`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_admin_2` FOREIGN KEY (`keyid`) REFERENCES `yubikeys` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,1,'Root admin','eXp9pHe0z1ix1L8fkoCEBQ==','2009-08-02 03:39:39','127.1.1.0','2009-08-02 03:39:39',1,3600);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `buyers`
--

DROP TABLE IF EXISTS `buyers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `buyers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `email` varchar(100) default NULL,
  `created` datetime default NULL,
  `addr` varchar(200) default NULL,
  `qty` int(10) unsigned default NULL,
  `client_id` int(11) NOT NULL default '0',
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK_client_id_1` USING BTREE (`client_id`),
  CONSTRAINT `FK_client_info_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `buyers`
--

LOCK TABLES `buyers` WRITE;
/*!40000 ALTER TABLE `buyers` DISABLE KEYS */;
/*!40000 ALTER TABLE `buyers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `clients` (
  `id` int(11) NOT NULL auto_increment,
  `perm_id` int(11) default NULL,
  `active` tinyint(1) default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `email` varchar(255) NOT NULL default '',
  `secret` varchar(60) NOT NULL default '',
  `notes` varchar(100) default NULL,
  `chk_sig` tinyint(1) NOT NULL default '0',
  `chk_owner` tinyint(1) NOT NULL default '0',
  `chk_time` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `perm_id` (`perm_id`),
  CONSTRAINT `clients_ibfk_1` FOREIGN KEY (`perm_id`) REFERENCES `perms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,1,1,'2009-08-02 03:39:39','admin@localhost','0Lz+QpWO0TSy04ALmLKg3g==','Root client',0,0,1);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history`
--

DROP TABLE IF EXISTS `history`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `usrid` int(10) unsigned NOT NULL default '0',
  `note` varchar(45) NOT NULL default '',
  `ip` varchar(45) NOT NULL default '',
  `creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `keyid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `FK_hist_1` (`usrid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history`
--

LOCK TABLES `history` WRITE;
/*!40000 ALTER TABLE `history` DISABLE KEYS */;
/*!40000 ALTER TABLE `history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `perms`
--

DROP TABLE IF EXISTS `perms`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `perms` (
  `id` int(11) NOT NULL auto_increment,
  `verify_otp` tinyint(1) default '0',
  `add_clients` tinyint(1) default '0',
  `delete_clients` tinyint(1) default '0',
  `add_keys` tinyint(1) default '0',
  `delete_keys` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `perms`
--

LOCK TABLES `perms` WRITE;
/*!40000 ALTER TABLE `perms` DISABLE KEYS */;
INSERT INTO `perms` VALUES (1,1,1,1,1,1),(2,1,0,0,1,1),(3,1,0,0,0,0);
/*!40000 ALTER TABLE `perms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yubikeys`
--

DROP TABLE IF EXISTS `yubikeys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `yubikeys` (
  `id` int(11) NOT NULL auto_increment,
  `client_id` int(11) NOT NULL default '0',
  `active` tinyint(1) default NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `accessed` datetime default NULL,
  `tokenId` varchar(60) character set latin1 collate latin1_bin default NULL,
  `userId` varchar(60) NOT NULL default '',
  `secret` varchar(60) NOT NULL default '',
  `counter` int(11) default NULL,
  `low` int(11) default NULL,
  `high` int(11) default NULL,
  `notes` varchar(100) default NULL,
  `serial` varchar(45) default NULL,
  `sessionUse` int(11) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userId` (`userId`),
  UNIQUE KEY `tokenId` (`tokenId`),
  UNIQUE KEY `sn` (`serial`),
  KEY `client_id` (`client_id`),
  CONSTRAINT `yubikeys_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `yubikeys`
--

LOCK TABLES `yubikeys` WRITE;
/*!40000 ALTER TABLE `yubikeys` DISABLE KEYS */;
INSERT INTO `yubikeys` VALUES (1,1,1,'2009-08-02 03:39:39','2009-08-02 03:39:39','hbcfLutP','jgnibvduunfv','0Lz+QpWO0TSy04ALmLKg3g==',0,0,0,'Root admin key','1',0);
/*!40000 ALTER TABLE `yubikeys` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'yubico'
--
DELIMITER ;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-08-06 13:09:04

Statistics: Posted by mo5245 — Thu Aug 06, 2009 2:52 pm

]]> 2009-08-06T11:32:37+01:00 2009-08-06T11:32:37+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1628#p1628 <![CDATA[Re: ykksm and ykval setup for yms]]>
Code:
# mysqldump <name of the database> > <file name.sql>

Statistics: Posted by network-marvels — Thu Aug 06, 2009 11:32 am

]]> 2009-08-05T18:06:02+01:00 2009-08-05T18:06:02+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1626#p1626 <![CDATA[Re: ykksm and ykval setup for yms]]> Code:
OK counter=0002 low=dff2 high=33 use=04
from
decrypt.php?otp=jgnibvduunfvrjdfccbteevikntfnncdtjhdnviujgnj
but now the problem i have is when i verify.php?id=1&otp=jgnibvduunfvrjdfccbteevikntfnncdtjhdnviujgnj i get
Code:
verify.php?id=1&otp=jgnibvduunfvrjdfccbteevikntfnncdtjhdnviujgnj
h=WlJJSIUZ/41QIN215FGtp1gV898=
t=2009-08-05T14:20:37Z0958
status=BAD_OTP

and all i get from the error.log is
Code:
[Wed Aug 05 09:51:18 2009] [error] [client ] Request: id=1&otp=jgnibvduunfvrjdfccbteevikntfnncdtjhdnviujgnj
[Wed Aug 05 09:51:18 2009] [error] [client ] SQL query: SELECT id, secret FROM clients WHERE active AND id='1'
[Wed Aug 05 09:51:18 2009] [error] [client ] Client data: id=1 secret=0Lz+QpWO0TSy04ALmLKg3g==
[Wed Aug 05 09:51:18 2009] [error] [client ] SIGN: status=BAD_OTP&t=2009-08-05T13:51:18Z0500 H=G9qQhQGgZGlp+mHnuLq9h2OHpmI=

any idea what is causing this?

thanks again.

Statistics: Posted by mo5245 — Wed Aug 05, 2009 6:06 pm

]]> 2009-08-05T10:19:07+01:00 2009-08-05T10:19:07+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1621#p1621 <![CDATA[Re: ykksm and ykval setup for yms]]>
http://home2.paulschou.net/tools/xlate/

The converted values using the above utility are as follows:

AES KEY = d0bcfe42958ed134b2d3800b98b2a0de --> base 64 = 0Lz+QpWO0TSy04ALmLKg3g==
private id = e7797c4edc91 --> base 64 = 53l8TtyR
public id = 85b71f2eeb4f in modhex = jgnibvduunfv

The answers to your questions are as follows:

    1) what should my __ADM_KEY_SECRET__ be for config.php in yubiphpbase? --> Leave it blank or don't modify it, as the AES key is now stored in the YKKSM database and it is not required to store in in the YMS server database.

    2) what should my __ENC_KEY_SECRET__ be for config.php in yubiphpbase? --> This is the encryption key. This can be any string of your choice. Just convert your encryption key to base 64 format and enter it in the config.php file

    3) what should aesKey be in database ykksm table yubikeys? --> The AES Key should be entered in Hex encoded format. In your case it will be "d0bcfe42958ed134b2d3800b98b2a0de"

    4) what should publicName be in database ykksm table yubikeys? --> This is the YubiKey Id of your YubiKey (first 12 characters of the OTP). It needs to be in modhex encoded format. In your case it will be "jgnibvduunfv"

    5) what should internalName be in database ykksm table yubikeys? --> Internal name is the Private ID of the YubiKey. It needs to be entered in Hex encoded format. In your case it will be "e7797c4edc91"

    Once the YKKSM server is up and able to decrypt the OTP, you can then follow the exact steps mentioned at the following forum link to install the Yubico validation as well as the management server:

    viewtopic.php?f=5&t=315&p=1418#p1418

    To check if the YKKSM server can decrypt the OTP, use the "ykksm-decrypt.php". For example, the request to the YKKSM server will be as follows:

    Code:
    http://<WebServer IP/Domain name>/yubikey-ksm/ykksm-decrypt.php?otp=etlfjrhdghnljbeeicenintdlejjgfgfengkdkitukge


    This should return the following results:
    Code:
    OK counter=0001 low=2741 high=14 use=01


    We hope this helps!

Statistics: Posted by network-marvels — Wed Aug 05, 2009 10:19 am

]]> 2009-08-04T15:25:17+01:00 2009-08-04T15:25:17+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1618#p1618 <![CDATA[Re: ykksm and ykval setup for yms]]> Code:
oppenssl enc base64
the best utility to use to get the base64 data? should my base64 encoding be larger than 32 characters, if so do i need to increase the limit on the database for aesKey table data, if someone can give me the above info in my first post i would be able to figure this out.

thanks

Statistics: Posted by mo5245 — Tue Aug 04, 2009 3:25 pm

]]> 2009-08-04T07:54:25+01:00 2009-08-04T07:54:25+01:00 https://forum.yubico.com/viewtopic.php?t=367&p=1616#p1616 <![CDATA[Re: ykksm and ykval setup for yms]]>
viewtopic.php?f=5&t=315&p=1418#p1418

We would appreciate if you can try to install the YMS as per the steps given at the above forum post.

Statistics: Posted by network-marvels — Tue Aug 04, 2009 7:54 am

]]>