Yubico Forum

...visit our web-store at store.yubico.com
It is currently Tue Jan 30, 2018 3:02 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 16 posts ]  Go to page Previous  1, 2
Author Message
PostPosted: Wed Aug 12, 2009 4:14 pm 
Offline
Yubico Team
Yubico Team

Joined: Wed Oct 01, 2008 8:11 am
Posts: 210
It seems that your config.php file is incomplete. The config.php file should be as follows:

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.


Top
 Profile  
Reply with quote  

Share On:

Share on Facebook FacebookShare on Twitter TwitterShare on Tumblr TumblrShare on Google+ Google+

PostPosted: Wed Aug 12, 2009 5:25 pm 
Offline

Joined: Mon Aug 03, 2009 4:42 pm
Posts: 8
ok my config.php is now
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


Top
 Profile  
Reply with quote  
PostPosted: Wed Aug 12, 2009 5:35 pm 
Offline

Joined: Mon Aug 03, 2009 4:42 pm
Posts: 8
mysql dumps

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


Top
 Profile  
Reply with quote  
PostPosted: Thu Aug 13, 2009 8:35 am 
Offline
Yubico Team
Yubico Team

Joined: Wed Oct 01, 2008 8:11 am
Posts: 210
Thank you for providing the valuable information.

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.


Top
 Profile  
Reply with quote  
PostPosted: Wed Aug 19, 2009 5:51 am 
Offline

Joined: Mon Aug 03, 2009 4:42 pm
Posts: 8
ok well i made two new server installs one centos 5 and ubuntu 8.04, installed all needed programs as the wiki have shown imported the working DB files and copy over my web dir files i im still getting the same issue.. ok on decrypt.php but status=BAD_OTP with verify.php i will add a copy of my phpinfo, what are the dependencies for running ykksm, ykval, yms and is there a need to edit php.ini or apache config for this to work, besides for logs, and or can you post a copy of the whole working www/ web dir?


thanks


Top
 Profile  
Reply with quote  
PostPosted: Wed Aug 19, 2009 12:20 pm 
Offline
Yubico Team
Yubico Team

Joined: Wed Oct 01, 2008 8:11 am
Posts: 210
Please find the attached "Yubico_YMS.tar.gz" file that contains the working web root directory along with the respective databases dumps. Also attached is the php.ini file of the server. We have installed the YMS server on ubuntu Linux. The OS details are as follows:
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!


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page Previous  1, 2

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group