Bitcoin Forum
December 10, 2016, 01:36:29 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 »
  Print  
Author Topic: Smartcoin Linux mining administration. [MULTI-MACHINE SUPPORT NOW IN!]  (Read 99706 times)
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 04:50:18 AM
 #101

dishwara

sudo rm /usr/bin smartcoin
should be
sudo rm /usr/bin/smartcoin


If you have 8 cards, you should see GPU[0], GPU[1].........GPU[7]

How many workers do you have set up? Is this an auto profile, or a manually created one?

I'd be interested in seeing your database
Code:
sudo mysqldump -p smartcoin --ignore-table=smartcoin.worker > ~/dump.sql
If you could post the dump here, or PM i'd gladly take a look at at and see what the problem might be (its a plain text file)


dishwara

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1481333789
Hero Member
*
Offline Offline

Posts: 1481333789

View Profile Personal Message (Offline)

Ignore
1481333789
Reply with quote  #2

1481333789
Report to moderator
1481333789
Hero Member
*
Offline Offline

Posts: 1481333789

View Profile Personal Message (Offline)

Ignore
1481333789
Reply with quote  #2

1481333789
Report to moderator
dishwara
Legendary
*
Offline Offline

Activity: 1386

Truth may get delay, but NEVER fails


View Profile
June 26, 2011, 04:56:50 AM
 #102

I created auto profile by choosing 7, then i chose wrongly 6 & also 8. since there is no way to come out(windows user, esc gets out), i did some thing wrong & getting 64 instances.
Here is the dump.

Also mysql asked password & i gave none. Do have to give password or can continue with just enter(no password)

Code:
DUMP

-- MySQL dump 10.13  Distrib 5.1.54, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: smartcoin
-- ------------------------------------------------------
-- Server version 5.1.54-1ubuntu4

/*!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 `current_profile`
--

DROP TABLE IF EXISTS `current_profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `current_profile` (
  `fk_machine` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  UNIQUE KEY `fk_machine` (`fk_machine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `current_profile`
--

LOCK TABLES `current_profile` WRITE;
/*!40000 ALTER TABLE `current_profile` DISABLE KEYS */;
INSERT INTO `current_profile` VALUES (1,-1);
/*!40000 ALTER TABLE `current_profile` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device`
--

DROP TABLE IF EXISTS `device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device` (
  `pk_device` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `device` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_device`),
  UNIQUE KEY `fk_machine_2` (`fk_machine`,`device`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device`
--

LOCK TABLES `device` WRITE;
/*!40000 ALTER TABLE `device` DISABLE KEYS */;
INSERT INTO `device` VALUES (1,1,'GPU[0]',0,'gpu',1,0),(2,1,'GPU[1]',1,'gpu',1,0),(3,1,'GPU[2]',2,'gpu',1,0),(4,1,'GPU[3]',3,'gpu',1,0),(5,1,'GPU[4]',4,'gpu',1,0),(6,1,'GPU[5]',5,'gpu',1,0),(7,1,'GPU[6]',6,'gpu',1,0),(8,1,'GPU[7]',7,'gpu',1,0),(9,1,'CPU[8]',8,'cpu',1,1);
/*!40000 ALTER TABLE `device` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `machine`
--

DROP TABLE IF EXISTS `machine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machine` (
  `pk_machine` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `server` varchar(100) DEFAULT NULL,
  `ssh_port` int(11) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_machine`),
  UNIQUE KEY `name` (`name`,`server`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machine`
--

LOCK TABLES `machine` WRITE;
/*!40000 ALTER TABLE `machine` DISABLE KEYS */;
INSERT INTO `machine` VALUES (1,'localhost','127.0.0.1',22,'dishwara00',1,0);
/*!40000 ALTER TABLE `machine` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macro`
--

DROP TABLE IF EXISTS `macro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macro` (
  `pk_macro` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_macro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macro`
--

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

--
-- Table structure for table `macro_map`
--

DROP TABLE IF EXISTS `macro_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macro_map` (
  `pk_macro_map` int(11) NOT NULL AUTO_INCREMENT,
  `fk_macro` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  `fk_machine` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_macro_map`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macro_map`
--

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

--
-- Table structure for table `miner`
--

DROP TABLE IF EXISTS `miner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `miner` (
  `pk_miner` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `launch` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `default_miner` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_miner`),
  UNIQUE KEY `fk_machine` (`fk_machine`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `miner`
--

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

--
-- Table structure for table `pool`
--

DROP TABLE IF EXISTS `pool`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool` (
  `pk_pool` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `server` varchar(32) DEFAULT NULL,
  `alternateServer` varchar(32) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `timeout` int(11) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_pool`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pool`
--

LOCK TABLES `pool` WRITE;
/*!40000 ALTER TABLE `pool` DISABLE KEYS */;
INSERT INTO `pool` VALUES (1,'DeepBit','deepbit.net',NULL,8332,60,1,0),(2,'Bitcoin.cz (slush)','mining.bitcoin.cz',NULL,8332,60,1,0),(3,'BTCGuild','btcguild.com',NULL,8332,60,1,0),(4,'BTCMine','btcmine.com',NULL,8332,60,1,0),(5,'Bitcoins.lc','bitcoins.lc',NULL,8080,60,1,0),(6,'SwePool','swepool.net',NULL,8337,60,1,0),(7,'Continuum','continuumpool.com',NULL,8332,60,1,0),(8,'MineCo','mineco.in',NULL,3000,60,1,0),(9,'Eligius','mining.eligius.st',NULL,8337,60,1,0),(10,'CoinMiner','173.0.52.116',NULL,8347,60,1,0),(11,'ZABitcoin','mine.zabitcoin.co.za',NULL,8332,60,1,0),(12,'BitClockers','pool.bitclockers.com',NULL,8332,60,1,0),(13,'MtRed','mtred.com',NULL,8337,60,1,0),(14,'SimpleCoin','simplecoin.us',NULL,8337,60,1,0),(15,'Ozco','ozco.in',NULL,8332,60,1,0),(16,'EclipseMC','us.eclipsemc.com',NULL,8332,60,1,0),(17,'BitP','pool.bitp.it',NULL,8334,60,1,0),(18,'BitcoinPool','bitcoinpool.com',NULL,8334,60,1,0),(19,'EcoCoin','ecocoin.org',NULL,8332,60,1,0),(20,'BitLottoPool','bitcoinpool.com',NULL,8337,60,1,0),(21,'X8S','pit.x8s.de',NULL,8337,60,1,0);
/*!40000 ALTER TABLE `pool` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile`
--

DROP TABLE IF EXISTS `profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile` (
  `pk_profile` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_profile`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile`
--

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

--
-- Table structure for table `profile_map`
--

DROP TABLE IF EXISTS `profile_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile_map` (
  `pk_profile_map` int(11) NOT NULL AUTO_INCREMENT,
  `fk_device` int(11) DEFAULT NULL,
  `fk_miner` int(11) DEFAULT NULL,
  `fk_worker` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_profile_map`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile_map`
--

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

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `pk_settings` int(11) NOT NULL AUTO_INCREMENT,
  `data` varchar(32) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pk_settings`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'donation_time','5','Hashpower donation minutes per day'),(2,'donation_start','632','Time to start hashpower donation each day');
/*!40000 ALTER TABLE `settings` 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 2011-06-26 10:25:46
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 05:21:32 AM
 #103

The password all depends on how you configured mysql at install.  If you didn't specify a password at install, then leaving it blank is the correct thing to do.

The only thing I see wrong at this point, is that you have no miners defined in the database.
Do you have phoenix or poclbm installed?

Also,  how many workers have you created?  If you created 8 workers, then that would account for smartcoin trying to load 64 instances (8 cards * 8 workers = 64).  If I were you, and you just wanted to mine to one pool, you only need one worker defined in the database.  You can delete any extras from the control screen.

Of course, it still won't work regardless until you get some miner information into the database...
Got to option 6) Configure miners, then A to add
then just fill out the information, such as the path (I.e. /home/your_user/phoenix/), give it a launch string such as:
Code:
phoenix.py -v -u http://<#user#>:<#pass#>@<#server#>:<#port#>/ -k $knl device=<#device#> worksize=128 vectors aggression=11 bfi_int fastloop=false
(the <#user#> etc. tags get replaced by worker and pool information,  so enter the line above verbatim)



Also,  since there is no exit (yet), if you find yourself in the wrong area of the menu system, just hit ctrl+c, then hit o (for Open) and you'll be back to the root of that screen

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
hipaulshi
Jr. Member
*
Offline Offline

Activity: 32


View Profile
June 26, 2011, 06:03:26 AM
 #104

line 940 of  smartcoin_control.sh
Code:
onfigure Devices Menu
when starting smartcoin, it complains no such command, syntax error?
dishwara
Legendary
*
Offline Offline

Activity: 1386

Truth may get delay, but NEVER fails


View Profile
June 26, 2011, 06:32:48 AM
 #105

Dump again. I did as you said, added miner in 6, even though their is phoenix.
still in main screen nothing is mining.
I already removed & reinstalled smartcoin & also created one worker as you said.
no mining is happening.

Code:
-- MySQL dump 10.13  Distrib 5.1.54, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: smartcoin
-- ------------------------------------------------------
-- Server version 5.1.54-1ubuntu4

/*!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 `current_profile`
--

DROP TABLE IF EXISTS `current_profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `current_profile` (
  `fk_machine` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  UNIQUE KEY `fk_machine` (`fk_machine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `current_profile`
--

LOCK TABLES `current_profile` WRITE;
/*!40000 ALTER TABLE `current_profile` DISABLE KEYS */;
INSERT INTO `current_profile` VALUES (1,-1);
/*!40000 ALTER TABLE `current_profile` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device`
--

DROP TABLE IF EXISTS `device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device` (
  `pk_device` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `device` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_device`),
  UNIQUE KEY `fk_machine_2` (`fk_machine`,`device`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device`
--

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

--
-- Table structure for table `machine`
--

DROP TABLE IF EXISTS `machine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machine` (
  `pk_machine` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `server` varchar(100) DEFAULT NULL,
  `ssh_port` int(11) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_machine`),
  UNIQUE KEY `name` (`name`,`server`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machine`
--

LOCK TABLES `machine` WRITE;
/*!40000 ALTER TABLE `machine` DISABLE KEYS */;
INSERT INTO `machine` VALUES (1,'localhost','127.0.0.1',22,'dishwara00',1,0);
/*!40000 ALTER TABLE `machine` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macro`
--

DROP TABLE IF EXISTS `macro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macro` (
  `pk_macro` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_macro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macro`
--

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

--
-- Table structure for table `macro_map`
--

DROP TABLE IF EXISTS `macro_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macro_map` (
  `pk_macro_map` int(11) NOT NULL AUTO_INCREMENT,
  `fk_macro` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  `fk_machine` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_macro_map`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macro_map`
--

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

--
-- Table structure for table `miner`
--

DROP TABLE IF EXISTS `miner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `miner` (
  `pk_miner` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `launch` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `default_miner` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_miner`),
  UNIQUE KEY `fk_machine` (`fk_machine`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `miner`
--

LOCK TABLES `miner` WRITE;
/*!40000 ALTER TABLE `miner` DISABLE KEYS */;
INSERT INTO `miner` VALUES (1,1,'phoenix','phoenix.py -v -u http://arawhsid.0:dish1979@api.bitcoin.cz:8332/ -k phatk device=0workze=256 vectors aggression=12 bfi_int','/home/dishwara00/Downloads/phoenix-1.48/phoenix.pyn/home/dishwara00/desktop/phoenix-1.48/phoenix.pyn/home/dishwara00/desktop/phoenix-1.50/phoenix.pyn/home/dishwara00/phoenix/phoenix.pyn/home/dishwara00/phoenix/trunk/',1,0);
/*!40000 ALTER TABLE `miner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pool`
--

DROP TABLE IF EXISTS `pool`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool` (
  `pk_pool` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `server` varchar(32) DEFAULT NULL,
  `alternateServer` varchar(32) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `timeout` int(11) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  `disabled` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_pool`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pool`
--

LOCK TABLES `pool` WRITE;
/*!40000 ALTER TABLE `pool` DISABLE KEYS */;
INSERT INTO `pool` VALUES (1,'DeepBit','deepbit.net',NULL,8332,60,1,0),(2,'Bitcoin.cz (slush)','mining.bitcoin.cz',NULL,8332,60,1,0),(3,'BTCGuild','btcguild.com',NULL,8332,60,1,0),(4,'BTCMine','btcmine.com',NULL,8332,60,1,0),(5,'Bitcoins.lc','bitcoins.lc',NULL,8080,60,1,0),(6,'SwePool','swepool.net',NULL,8337,60,1,0),(7,'Continuum','continuumpool.com',NULL,8332,60,1,0),(8,'MineCo','mineco.in',NULL,3000,60,1,0),(9,'Eligius','mining.eligius.st',NULL,8337,60,1,0),(10,'CoinMiner','173.0.52.116',NULL,8347,60,1,0),(11,'ZABitcoin','mine.zabitcoin.co.za',NULL,8332,60,1,0),(12,'BitClockers','pool.bitclockers.com',NULL,8332,60,1,0),(13,'MtRed','mtred.com',NULL,8337,60,1,0),(14,'SimpleCoin','simplecoin.us',NULL,8337,60,1,0),(15,'Ozco','ozco.in',NULL,8332,60,1,0),(16,'EclipseMC','us.eclipsemc.com',NULL,8332,60,1,0),(17,'BitP','pool.bitp.it',NULL,8334,60,1,0),(18,'BitcoinPool','bitcoinpool.com',NULL,8334,60,1,0),(19,'EcoCoin','ecocoin.org',NULL,8332,60,1,0),(20,'BitLottoPool','bitcoinpool.com',NULL,8337,60,1,0),(21,'X8S','pit.x8s.de',NULL,8337,60,1,0);
/*!40000 ALTER TABLE `pool` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile`
--

DROP TABLE IF EXISTS `profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile` (
  `pk_profile` int(11) NOT NULL AUTO_INCREMENT,
  `fk_machine` int(11) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `auto_allow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`pk_profile`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile`
--

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

--
-- Table structure for table `profile_map`
--

DROP TABLE IF EXISTS `profile_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile_map` (
  `pk_profile_map` int(11) NOT NULL AUTO_INCREMENT,
  `fk_device` int(11) DEFAULT NULL,
  `fk_miner` int(11) DEFAULT NULL,
  `fk_worker` int(11) DEFAULT NULL,
  `fk_profile` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_profile_map`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile_map`
--

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

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `pk_settings` int(11) NOT NULL AUTO_INCREMENT,
  `data` varchar(32) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pk_settings`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'donation_time','5','Hashpower donation minutes per day'),(2,'donation_start','1936','Time to start hashpower donation each day');
/*!40000 ALTER TABLE `settings` 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 2011-06-26 11:56:04
gyzer
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 26, 2011, 07:58:22 AM
 #106

When I go ahead and install I get an error at the point where it looks like the installer is trying to give permissions to the mysql database user smartcoin but it cannot. Afterwards it looks like it does load the schema, but it never creates the tables.

Any idea on what could cause that to happen?
burp
Member
**
Offline Offline

Activity: 98


View Profile
June 26, 2011, 11:49:37 AM
 #107

Why not use sqlite? It seems much more appropriate for this project.
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 02:25:10 PM
 #108

hipaulshi:
Quote
line 940 of  smartcoin_control.sh
Hmm, not sure or how that line got in there - maybe a rogue copy/paste or something.

I removed the offending line, you should svn update to bring the change in locally

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 02:31:18 PM
 #109

dishwara:
Looking at your database dump, I see 2 problems:
1) The entry for the miner is incorrect.  It needs to have the special <#user#>,<#pass#> etc tags where your real information would normally go.  These values are filled in by smartcoin depending on the pool/worker that is being processed. Also, it looks like you have 3 different phoenix installs, which confuses the installer.  You will want to manually edit the path as well, to the one you want to use.

2)  You device table is empty - got to configure devices and add them in. You can name them what you want, but by default they would have been named GPU[0].... etc

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 02:33:41 PM
 #110

burb:
Quote
Why not use sqlite? It seems much more appropriate for this project.

I may have to consider it.. While I've been maintaining and working  MySQL servers for a very long time,  i guess I shouldn't assume that users will be as familiar with it - and in fact I'm sure a lot of failed installations will be related to the server not being set up correctly at install (not remembering the password set, etc)

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 02:35:11 PM
 #111

gyzer:
Quote
When I go ahead and install I get an error at the point where it looks like the installer is trying to give permissions to the mysql database user smartcoin but it cannot. Afterwards it looks like it does load the schema, but it never creates the tables.

Any idea on what could cause that to happen?

Sounds like a mysql password issue (did you use the same password you set up mysql with?)
What exactly is the error?

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 03:00:52 PM
 #112

I've been doing some test this morning,  and as suggested, I'm going to add sqLite support.  This will make it easier to install for those that haven't used MySQL before!

I estimate a couple of hours, and i'll have the changes checked in. I'll update here once its done!

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
gyzer
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 26, 2011, 04:31:06 PM
 #113

Can you include full directions on how to fully remove mysql when you get sqllite support?
Clipse
Hero Member
*****
Offline Offline

Activity: 504


View Profile
June 26, 2011, 05:26:23 PM
 #114

Can you include full directions on how to fully remove mysql when you get sqllite support?

apt-get --purge remove sqlite

...In the land of the stale, the man with one share is king... >> Clipse

We pay miners at 130% PPS | Signup here : Bonus PPS Pool (Please read OP to understand the current process)
gyzer
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 26, 2011, 05:45:33 PM
 #115

Damn, I was missing the purge flag...THANKS!
ptshamrock
Sr. Member
****
Offline Offline

Activity: 479



View Profile
June 26, 2011, 05:51:34 PM
 #116

You also need to make sure that your $LD_LIBRARY_PATH for the ATI sdk is set in the environment



how can i acess this ?

"Money needs to be depoliticized, and the time has come for the separation of money and state to be accomplished."
gyzer
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 26, 2011, 06:02:28 PM
 #117

You also need to make sure that your $LD_LIBRARY_PATH for the ATI sdk is set in the environment



how can i acess this ?

I know what it is, but not where it is...

I hadn't gotten far enough to see if that was going to be a problem for me or not.
jondecker76
Full Member
***
Offline Offline

Activity: 238


View Profile
June 26, 2011, 06:18:22 PM
 #118

Ok, the new beta is up, now using sqLite3
People using the old beta, you should completely uninstall and do it fresh:
Code:
cd ~/
sudo rm -r smartcoin
sudo apt-get --purge remove mysql-server mysql-client

Here are the new install instructions:
Code:
cd ~/
mkdir smartcoin
cd smartcoin
svn checkout http://smartcoin.googlecode.com/svn/branches/beta1/smartcoin ./
./smartcoin_install.sh


For those having $LD_LIBRARY_PATH problems, enter this at the terminal before running smartcoin:
Code:
export $LD_LIBRARY_PATH="/home/your_username_here/AMD-APP-SDK-v2.4-lnx32/lib/x86/:$LD_LIBRARY_PATH"
(You must have your own correct path entered above, of course.  Please check the location on your own machine before adding it to $LD_Library_Path

I will likely add some detection in the installer, store the path in the database, and update LD_LIBRARY_PATH in code eventually.



KNOWN ISSUES:
All of my old queries that used CONCAT are no longer suppored in sqlite3 Sad
I have to go over all of them and change them to a syntax that sqlite likes. So if you get errors about CONCAT, thats why.
I'll fix them later tonight, I have a graduation party to go to now. EDIT: FIXED!

RollerBot Advanced Trading Platform
https://bitcointalk.org/index.php?topic=447727.0
BTC Donations for development: 1H36oTJsi3adFh68wwzz95tPP2xoAoTmhC
gyzer
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 26, 2011, 06:32:05 PM
 #119

I'm having problems with your export command. What file does that need to be changed in?
gyzer
Jr. Member
*
Offline Offline

Activity: 42


View Profile
June 26, 2011, 06:46:41 PM
 #120

Ok so I already have the LD_LIBRARY_PATH set and when I go to install it says that it isn't. I'm using a 64bit version of Ubuntu 10.04 and I'm using sdk 2.1 not 2.4. My phoenix miners work so my LD_LIBRARY_PATH in .bashrc is correct.

What am I doing wrong here?
Pages: « 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 »
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!