Smartcoin Linux mining administration. [MULTI-MACHINE SUPPORT NOW IN!] - page 38.

jondecker76

full member

Activity: 238

Merit: 100

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!

gyzer

jr. member

Activity: 50

Merit: 10

Quote from: ptshamrock on June 26, 2011, 12:51:34 PM

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.

ptshamrock

hero member

Activity: 484

Merit: 500

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 ?

gyzer

jr. member

Activity: 50

Merit: 10

Damn, I was missing the purge flag...THANKS!

Clipse

hero member

Activity: 504

Merit: 502

Quote from: gyzer on June 26, 2011, 11:31:06 AM

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

apt-get --purge remove sqlite

gyzer

jr. member

Activity: 50

Merit: 10

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

jondecker76

full member

Activity: 238

Merit: 100

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!

jondecker76

full member

Activity: 238

Merit: 100

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?

jondecker76

full member

Activity: 238

Merit: 100

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)

jondecker76

full member

Activity: 238

Merit: 100

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

hipaulshi

brand new

Activity: 0

Merit: 0

line 940 of smartcoin_control.sh

Code:

onfigure Devices Menu

when starting smartcoin, it complains no such command, syntax error?

jondecker76

full member

Activity: 238

Merit: 100

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

burp

member

Activity: 98

Merit: 10

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

gyzer

jr. member

Activity: 50

Merit: 10

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?

dishwara

legendary

Activity: 1855

Merit: 1016

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:[email protected]: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

jondecker76

full member

Activity: 238

Merit: 100

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

dishwara

legendary

Activity: 1855

Merit: 1016

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

Activity: 238

Merit: 100

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

dishwara

legendary

Activity: 1855

Merit: 1016

Code:

sudo rm /usr/bin smartcoin

gives this error.
rm: cannot remove `/usr/bin': Is a directory
rm: cannot remove `smartcoin': Is a directory

Also, i don't know what wrong i did, i see GPU[0]-GPU[8] 8 times & also no mining. It just idle.

can you help?

EDIT:

for a brief second, i saw starting miner...61,62,63,64.
Up to 64 miners it try to start & not able to mine.
I have 8 cards & tried to mine with 8 cards in bitcoin.cz

hipaulshi

brand new

Activity: 0

Merit: 0

The program caused weird problem for me. I used this guide (http://forum.bitcoin.org/index.php?topic=9239.0) to setup my miner originally, so most of the stuff were compiled directly.

I strongly suggest there be a configuration file so that I can point to compiled libs.

There were quite a few errors: The mysql database creation doesn't work. I need to specify -p to manually enter password even though it's performed under sudo

The program seemed to have crashed the ATI driver installation. After reboot, I can no longer run aticonfig, it says command not found. I tried to force remove using dpkg purge and apt-get remove --purge and reinstalled the debian ATI driver compiled using

Code:

sudo sh ati-driver-installer-11-5-x86.x86_64.run --buildpkg Ubuntu/natty

with no luck. Not sure what happened.

For suggestions, i recommend a return to upper menu option.

Topic: Smartcoin Linux mining administration. [MULTI-MACHINE SUPPORT NOW IN!] - page 38. (Read 105029 times)