Hi Michal and List!
Oops, It seems I didn't read your message before Michal, sorry...
>I've tested version in cvs and there are still some problems while adding
>fields to existing index. Tomorrow I'll have a look at it and probably make
>some fix of it.
What are these problems and do you manage to fix them?
>And there also could be some JavaScript that would disable non-text fields,
>while selecting index type "FULLTEXT".
Hum, I'll try to have a look at this tomorrow.
To all: two questions about indexes...
1. Do we still need "Primary, Index...." to be displayed in the table
properties
for each colums? IMHO the patch from Michal is enough and those features
are deprecated.
2. What to do whith indexes while creating a table? Should we keep this
feature as is (maybe just replace the three checkboxes by a combo) or
extend the index creation so it looks like the patch from Michal?
... and one more: what do you think of a 2.2.2-rc1 tomorrow (or maybe
a 2.3.0-rc1 since there are a bunch of new functionnalities ?)?
Regards,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi List!
I forward this message from John Down (thanks to him):
----------------------------------------------------------------------
don't know, if that breaks anything in your code, but it seems to work
for me:
there is something in common.lib.php that makes it impossible to
connect to mysql on a Windows System via Pipes.
It's on lines 298-301:
// Don't use servers with no hostname
if (empty($val['host'])) {
unset($cfgServers[$key]);
}
If I comment this out, Pipes are also possible.
I just wanted to mention, maybe there are some people interested in
the "skip-networking" option for mysql, which makes it possible to
operate without an open 3306 tcp port on Windoze also.
At least I never saw this somewhere documented, but if you give no
hostname, php connects via pipes on the localhost.
Funny: $cfgServers[1]['connect_type'] = 'tcp'; has no meaning in that
case...
Have a nice day,
Jones
--------------------------------------------------------------------------
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi Oli!
>wow, good luck :)
Most of the work is already done and commited in the
CVS. I'm just waiting for the translation to start fine
testings.
>And what about the session-based stuff ? Have you
>already started to code something, or could I work
>on it ?
Well I can't find time to work on it the past week-end
and I'm afraid I won't find time time to do it this week.
So work on it if you can.
>well... I think the default settings (TCP, localhost) are fine for
>mostely everybody. I guess there is a little overhead if you
>use the TCP socket, but that's shouldn't be too bad... Any
>idea from mysql programmers ? :)
I was just wondering whether the $cfgServers[i]['socket'] is
usefull or not. I mean why not to use socket if
$cfgServers[i]['socket'] is defined, tcp else?
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi again!
I've just commited the patch from Michal Cihar that add
advanced generation/editing features for indexes.
Please test it.
Maybe we will have to debate on some improvements Michal
would like to implement before the plain 2.2.2 release.
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi All!
I didn't roll 2.2.2-rc1 during the past week-end because I'm
waiting for the Arabic translation: since it requires some
meaningfull changes in the code (for right to left writing) I
would like to have it included in the rc1 so it can be tested
and fixed for the plain 2.2.2.
It would be nice if someone who knows a bit about the use
of socket may have a look at this thread in the phpWizard forum:
http://www.phpwizard.net/phorum/read.php?f=1&i=6538&t=6532
(see the last post from Juergen Selent).
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi Marc!
>Loïc, do you need more testers of this patch?
>Will it go in 2.2.2?
Well have you tested the last beta? If you (and maybe others)
don't find bugs, I will commit it tonight (let's say about 5 or
6 hours from now).
Two notes:
- could you test the improvement I've commited this morning
while killing process (once killed, you should now come
back to the process list rather than the main page);
- I'm still searching a solution for bug #474943...
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
>mmm, if you can't look at the password column field, how can
>you check if the password is correct ? I don't get the point
>here :)
Since mysql_(p)connect will return an error or false if you try
to connect with an invalid login/password pair, you don't need
need to check it before. That's the way the current cvs version
(and also the 2.2.1) works (see "libraries/common.lib.php3").
>Olivier, from the first snowy day of the winter :)
Loïc, from the second snowy day of the winter :p
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
On Fri, Nov 09, 2001 at 04:34:24PM +0100, Loïc wrote:
> >use an home-made session system? This is not an
> >hard thing: it would just require a mysql table.
>
> I've started to work again on this but am facing a first problem.
> Let's say only the standard user may use the session table.
> Once the user is logged into, his login/password must be
> stored into this session table and the standard user must be
> able to get them, you know the standard user I've just removed
> every priv. on the "Password" column from the "mysql.user" table in order to
> improve security..... :(
mmm, if you can't look at the password column field, how can you check
if the password is correct ? I don't get the point here :)
> >it would just require a mysql table.
> >(id, session_id, username, db, passwd, ip, expiration, timestamp)
>
> Hum why:
> - id and session_id?
mmm, forget id, it's just a standard field in all my tables
(using mysql classes to access the data).
> - db (no very usefull without hostname and table name at least)?
was just a 2 min draft... with db I meant the db number from
$cfgServers[1], $cfgServers[2], etc...
> - expiration and timestamp?
expiration: to allow automatic deletion of session after a
defined time limit
timestamp: for admin information, to see last action
Olivier, from the first snowy day of the winter :)
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
Hi,
Looking at the stats for 2.2.1, there were 17300 downloads of a .php version and 3300 for a .php3
version. I presume that it means PHP4 is well deployed.
I think we could *add* another auth mecanism for PHP4 servers: session-based. I use it in all my
other LAMP-based projects (did not try it with WAMP) and my users have no problems.
Instead of
$cfgServers[1]['adv_auth']
we could have
$cfgServers[1]['auth']
with the possible choices:
'config':
the username/password are in the config file (old advanced=false)
'http'
http authentication (old advanced=true)
(still use stduser?)
'session'
session-based, customized login panel, session id propagated by URL
(still use stduser?)
Marc
Hey guys,
Just an odd request, some while ago, I recall seeing phpMyAdmin mentioned
on a news site somewhere. Do you know where?
Thanks in advance.
--
Robin Hugh Johnson
"Robbat2"
QTOD: "I used to be an idealist, but I got mugged by reality."
E-Mail : robbat2(a)orbis-terrarum.net
ICQ# : 30269588 or 41961639
Home Page : http://www.orbis-terrarum.net
Time Zone : Pacific Daylight (GMT - 8)
-----BEGIN GEEK CODE-----
geekcode.comebb.org/ungeek
GCS/M/IT d-(+) s+:- a--- C++++
U++++ L++++ P--(+) W++ K++ PS+
N++ w--- O E---- M-(+) V-- Y++
PE++ PGP++ t-- 5 X+ R tv- b+++
D++ G++ e(*) h! r-- !y+
------END GEEK CODE------
-----PGP INFO-{---
Key ID:0x7E20DFA1
FingerPrint:
5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1
---}-PGP INFO-----
