Searching and views problem

[salexanov]

Hello,
I stiil watching several big problems:

1. In "Zone" section, when i select some zone by searching form
http://.....net/webdns/zones.php?filter=All&id=test.co.uk
after clicking on "All Records" (as well as "MX Records", " A Records",
"CNAME Records") i expected see all (or specific) records fo this
zone, but anything is visible, althoug in my db tables:
mysql> select id, domain_id, name, type, content from records where
domain_id=5;
+----+-----------+-------------+------+---------------------------------------------------------------------------+
| id | domain_id | name | type | content
|
+----+-----------+-------------+------+---------------------------------------------------------------------------+
| 16 | 5 | test2.co.uk | SOA | .....net hostmaster.....net
0608160002 10800 3600 604800 21600 |
| 17 | 5 | test2.co.uk | NS | .......net
|
| 18 | 5 | test2.co.uk | NS | ........net
|
| 19 | 5 | test2.co.uk | A | 2.3.4.5
|
+----+-----------+-------------+------+---------------------------------------------------------------------------+
I can see only SOA record by clicking
http://......net/webdns/zones.php?show=display_soa

Seems to me "Zone search" is not flexible if it using ajax-ed features,
for example: if i have 3 or more hundred zones with letter "f" in the
name of zone, and enter this letter into form - what i can see? list of
400 zone names?

2. "Find Records" form search nothing in any case i enter in search
field.

3. Users except admin-user still cant login into webdns gui.

[davet...@gmail.com]

salexanov wrote:
> Hello,
> I stiil watching several big problems:
>
> 1. In "Zone" section, when i select some zone by searching form
> http://.....net/webdns/zones.php?filter=All&id=test.co.uk
> after clicking on "All Records" (as well as "MX Records", " A Records",
> "CNAME Records") i expected see all (or specific) records fo this
> zone, but anything is visible, althoug in my db tables:
> mysql> select id, domain_id, name, type, content from records where
> domain_id=5;
> +----+-----------+-------------+------+---------------------------------------------------------------------------+
> | id | domain_id | name | type | content
> |
> +----+-----------+-------------+------+---------------------------------------------------------------------------+
> | 16 | 5 | test2.co.uk | SOA | .....net hostmaster.....net
> 0608160002 10800 3600 604800 21600 |
> | 17 | 5 | test2.co.uk | NS | .......net
> |
> | 18 | 5 | test2.co.uk | NS | ........net
> |
> | 19 | 5 | test2.co.uk | A | 2.3.4.5
> |
> +----+-----------+-------------+------+---------------------------------------------------------------------------+
> I can see only SOA record by clicking
> http://......net/webdns/zones.php?show=display_soa
>

The SOA record is only displayed by clicking the link by design. In
our setup, we did not want our outside customers seeing the SOA that we
had setup for them since it would inevitably cause more confusion or
questions by the more non-technical users. This is certainly a case
where we could add a configuration option to have the SOA record
viewable along with the other records.

> Seems to me "Zone search" is not flexible if it using ajax-ed features,
> for example: if i have 3 or more hundred zones with letter "f" in the
> name of zone, and enter this letter into form - what i can see? list of
> 400 zone names?
>

Absolutely correct. For all intents and purposes, you need to type in
more than a few letters to narrow down the results. Possibly in the
future, we could have the ajax not kick off until you have typed in 3
letters or something like that.

> 2. "Find Records" form search nothing in any case i enter in search
> field.
>

I have not been able to duplicate any issues with the "Find Records"
search form on the Zones page, either in the develpment site or my
fresh install. Are you getting anything back from the search? Any
errors? Any messages?

> 3. Users except admin-user still cant login into webdns gui.

This should be fixed now. You can see the fix in the "Creating Users"
thread of this group or at the following url:
https://webdns.bountysource.com/development.

[salexanov]

With viewing SOA record all right, but with other types of record - no.
How i can see any records stored in my DB? Guess by clicking on "All
Records" link
(or any of: MX Records :: A Records :: CNAME Records), but nothing
is arise in my browser window when i doit.

>
>
> > Seems to me "Zone search" is not flexible if it using ajax-ed features,
> > for example: if i have 3 or more hundred zones with letter "f" in the
> > name of zone, and enter this letter into form - what i can see? list of
> > 400 zone names?
> >
>
> Absolutely correct. For all intents and purposes, you need to type in
> more than a few letters to narrow down the results. Possibly in the
> future, we could have the ajax not kick off until you have typed in 3
> letters or something like that.

Sound good.

>
>
> > 2. "Find Records" form search nothing in any case i enter in search
> > field.
> >
>
> I have not been able to duplicate any issues with the "Find Records"
> search form on the Zones page, either in the develpment site or my
> fresh install. Are you getting anything back from the search? Any
> errors? Any messages?

Nothing. The idential fashion before i run searching.

>
>
> > 3. Users except admin-user still cant login into webdns gui.
>
> This should be fixed now. You can see the fix in the "Creating Users"
> thread of this group or at the following url:
> https://webdns.bountysource.com/development.

After update - login result is successfull, thanks.
Aditional question about zone - group reference:
How i can set other group fo specific zone, or more than one group (or
user) governing some zones?

[Arjan Schrijver]

I have exactly this same problem! With my completely fresh install of
everyting (apache, php, mysql, pdns, webdns, horde), I inserted some
records into the database. Now in the Search and Records pages, I get
nothing at all. Since I'm using Firefox, I analyzed the ajax traffic,
and found that this is being sent back by search_records.php:
<b>Notice</b>: Undefined variable: Sterm in
<b>/home/arjan/public_html/webdns/Zones/search_records.php</b> on line
<b>128</b><br />

Also nothing appears when I search for something in the Search page.
Every selectbox that should contain the zones is also empty.

Further more, on the Users screen, I get two of these for every Group I
have:
Notice: Undefined index: id in
/home/arjan/public_html/webdns/lib/Groups.php on line 198
Notice: Undefined index: name in
/home/arjan/public_html/webdns/lib/Groups.php on line 198

I like webdns very much, so I surely hope that these issues can be
resolved.

Regards,
Arjan

[davet...@gmail.com]

Arjan,
Could you let me know what version of WebDNS you have installed?

This is an odd issue since I haven't been able to duplicate it in my
fresh installs. Thank you for the troubleshooting with the Ajax, that
helps. The undefined index Sterm is the search term you enter into the
search field. Could you do something else for me? Add the following
javascript code to js/webdns.js on line 258: alert(url);, reload the
Zones page and then perform a search for a record. Let me know what
the alert message box says.

As for the Groups error you're getting on the Users page. In looking
at lib/Groups.php, you should only be seeing that error if there were
no groups found in the DB. So first of all, I need to report that
error more gracefully. Secondly, could you run the following query on
your database and let me know the results? "SELECT id, name FROM
groups".

Thanks, hopefully we can get these issues straightened out for you. We
use WebDNS daily without issue and it is really helpful.

Dave

[Arjan Schrijver]

davet...@gmail.com wrote:
> Arjan,
> Could you let me know what version of WebDNS you have installed?
>

That would be version 1.4.4, downloaded today.

> This is an odd issue since I haven't been able to duplicate it in my
> fresh installs. Thank you for the troubleshooting with the Ajax, that
> helps. The undefined index Sterm is the search term you enter into the
> search field. Could you do something else for me? Add the following
> javascript code to js/webdns.js on line 258: alert(url);, reload the
> Zones page and then perform a search for a record. Let me know what
> the alert message box says.
>

The ajax error I mentioned is being sent right after I open the Zones
page. That's why the list of zones is empty. On Opera I get a slightly
different result, I'm getting these (probably column titles):
Record Name TTL Type Content
And I get a total of 7 records in the blue field near "All Records for
test.com". But there is still no list of records... I can't see them.
Well, the search box is one of many ajax problems... It displays the
login page. This also happens most of the times when I click 'Add new
group' or any other such ajax action.
Today was my first WebDNS installation ever, so I might have done some
things wrong. I'll do a clean install tomorrow again.

> As for the Groups error you're getting on the Users page. In looking
> at lib/Groups.php, you should only be seeing that error if there were
> no groups found in the DB. So first of all, I need to report that
> error more gracefully. Secondly, could you run the following query on
> your database and let me know the results? "SELECT id, name FROM
> groups".
>

My groups table is filled, as you can see here:
mysql> select * from groups;
+----+------------+-------+-------+-----------+
| id | name | admin | ttl | zoneLimit |
+----+------------+-------+-------+-----------+
| 1 | Supers | 1 | 21600 | 0 |
| 2 | gebruikers | 0 | 43200 | 0 |
| 3 | testgroep | 0 | 21600 | 5 |
+----+------------+-------+-------+-----------+
3 rows in set (0.00 sec)

> Thanks, hopefully we can get these issues straightened out for you. We
> use WebDNS daily without issue and it is really helpful.
>

Thank you for your quick answer! I'll work some more on this tomorrow.
It's possible we might one day migrate to it at work.
Regards, Arjan

[davet...@gmail.com]

The fact that you're getting login pages where there shouldn't be login
pages tells me that you might have the $conf['cookie']['path'] set
incorrectly in horde/config/conf.php. Here are some of the common
settings that you should check:

Set $conf['cookie']['path'] to '/', instead of '/horde';

In the horde/config/registry.php file, make sure the webroot of WebDNS
is set appropriately. If you installed WebDNS in the web Server's root
dir, you can set it's webroot to '' instead of '/' or '/webdns'.

As for the error you're getting when you first view the Zones page,
it's odd because you're getting the error from a line in
search_records.php that you shouldn't be getting to. What is the URL
when you click on the Zones icon? It should read something like
http://servername/webdns/zones.php?filter=All&id=someZoneNameOrId. If
filter is not set in the URL, it will try to do a search (which seems
is what is happening to you).

I'm not surprised you get a different response from Opera. If I'm not
mistaken, Opera has issues handling XSLT. The list of records is sent
back as an XML file that gets parsed by the browser using XSLT
stylesheets.

[Arjan Schrijver]

Doing this solved nothing, the problem still existed. However, I solved
it by doing a fresh install of WebDNS into the virtual host's root dir.
The error on the Zones page is also vanished now.
But, this time there are lots of other errors, which I think could be
caused by version differences in the PEAR modules.
The problem on the Users page (undefined indexes) can be solved by
changing lines like this:
$result->fetchInto($row = array(), DB_FETCHMODE_ASSOC);
into this:
$result->fetchInto($row, DB_FETCHMODE_ASSOC);

Both the Search and Zones page (the search dropdown too) also give
undefined indexes on any ajax request it makes. These errors can be
found here: http://anymore.nl/webdns_zones_errors.txt
I traced these errors to webdns/lib/Search.php, line 252, where exactly
the same syntax for fetchInto() is being used. When I remove the ' =
array()', it works fine too.

So I'm guessing it's either a PEAR module version mismatch, or a misuse
of the fetchInto() function.
To make sure it's okay, here are my versions:
WebDNS 1.4.4
Horde 3.1.2
PHP 5.1.4
PEAR 1.4.9
PEAR-DB 1.7.6

And by the way, I suggest you add the PHP function requisites to the
Installation page. I've had to recompile PHP several times because I
was missing some functionality. For instance the 'bcmath' and 'ctype'
functions were not built in.

[Arjan Schrijver]

Yep, that was the solution! I removed the '= array()' from every
occurrence of the fetchInto() call, and now WebDNS works perfectly!
I guess this bug probably surfaced because of a (PHP?) version
mismatch, but I'm glad it's sorted out now. However, installing WebDNS
into a subdir on the virtual host requires some more documentation, I
still didn't manage to get it to work.
Anyway, it's a pretty impressive program.

[davet...@gmail.com]

Our development server has older versions of PEAR and PEAR_DB installed
but the system we've used to do new installs has the same version you
have listed. But in both cases, we're using PHP 4.3.10. We've never
tested it on PHP5. I'm glad to hear you got it working, I'm sure this
will be useful information to others. I'll put up some documentation
regarding your findings.

Thanks.

[salexanov]

davet...@gmail.com писал(а):

With viewing SOA record is everything all right,
but i cant see/modify any records except SOA record.
In any borwser that i try (opera, firefox, ieplorer) - the same result.
At present time there is a most painfull problem i can see.