mysql> select * from domains;
+----+------------------------------+---------------+--------+-------+---------+
| id | name                         | scalr_farm_id | type   | index | 
os_type |
+----+------------------------------+---------------+--------+-------+---------+
|  1 | f83290c12eac42.scalr-dns.net |             3 | NATIVE |  NULL | 
linux   |
+----+------------------------------+---------------+--------+-------+---------+
1 row in set (0.00 sec)

mysql> CREATE TABLE `domains` (`id` int(11) NOT NULL AUTO_INCREMENT, `name` 
varchar(36) DEFAULT NULL, `scalr_farm_id` int(11) DEFAULT NULL, `type` 
varchar(36) DEFAULT NULL, `index` int(11) DEFAULT NULL, `os_type` 
enum('windows','linux') DEFAULT 'linux', PRIMARY KEY (`id`), KEY `name` 
(`name`), KEY `scalr_farm_id` (`scalr_farm_id`) ) ENGINE=InnoDB DEFAULT 
CHARSET=latin1;

I created the above table from what I saw the php doing at it populated it 
as also shown above, I also looked through the source sql and dont see a 
domains table in it so I am wondering is there some other part or module I 
am missing?

On Thursday, June 12, 2014 2:40:33 PM UTC-7, Aatxe Urrutia wrote:
>
> mysqli error: [1146: Table 'scalr.domains' doesn't exist] in 
> EXECUTE("DELETE FROM `domains` WHERE scalr_farm_id =
>
> that is the error message I get
>
> On Thursday, June 12, 2014 2:39:57 PM UTC-7, Aatxe Urrutia wrote:
>>
>> I got scalr to write to both zone files and the 
>> /var/named/client_zones/zones.include
>>
>> however when I set it up via the UI to associate with a farm if I 
>> terminate the farm it complains that a domains table is missing. I checked 
>> the db and there is no domains table and the php class that calls it , is 
>> in fact looking for a scalr.domains table. i.e.
>>
>>
>>
>> On Tuesday, June 10, 2014 3:01:02 PM UTC-7, Aatxe Urrutia wrote:
>>>
>>> Thanks,
>>>
>>> I was away on vacation, got back and installed bind & traced logs for 
>>> errors and saw where it was expecting files, changed that and reloaded and 
>>> the dns zone was marked as active in scalr and the logs show it 
>>> communicating , additionally writing zone files and reloaded bind.
>>>
>>> thanks
>>>
>>> On Friday, May 9, 2014 12:44:48 PM UTC-7, Aatxe Urrutia wrote:
>>>>
>>>> OK, so I have my setup working , scale up, scale down, graphing, etc 
>>>> however now I have been tasked to look and see if I can look at the custom 
>>>> DNS options in scalr.
>>>>
>>>> Looking at the docs from the UI standpoint it seems the actual 
>>>> mechanism in which DNS is made to work is missing.
>>>>
>>>> I.e.
>>>>
>>>> I think this may be what is needed but am asking if this is correct.
>>>>
>>>>  install Bind on local scalr system and allow it to receive transfers 
>>>> from localhost? ( I would assume that scalr will make an API call to it)
>>>>
>>>>    -      The local DNS server will then notify its slaves
>>>>
>>>> The parent DNS I can forward a zone to the scalr system so any name 
>>>> scalr creates will still work in my  internally dc & office DNS.
>>>>
>>>>
>>>>
>>>> Am I missing anything?
>>>>
>>>>
>>>> Thanks in advance,
>>>>
>>>> -B
>>>>
>>>

-- 
You received this message because you are subscribed to the Google Groups 
"scalr-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to