This line? modparam("auth_db", "password_column", "password")
If so, yes, we did try altering that line to reflect the password for the 'openser' user. Is that what you mean?--If not, can you explain?
Thanks for the help.
-Ben-
----- Original Message ----- From: "Ovidiu Sas" sip.nslu@gmail.com To: "Ben Ferguson - backcountry.com" bferguson@backcountry.com Cc: users@openser.org Sent: Tuesday, February 20, 2007 6:36:50 PM (GMT-0700) US/Mountain Subject: Re: [Users] Re: openSER on OpenBSD: cannot start openser
Hi Ben,
Have you changed the password inside the openser.cfg file?
Regards, Ovidiu Sas
On 2/20/07, Ben Ferguson - backcountry.com bferguson@backcountry.com wrote:
After further investigation, it looks as though this is actually caused by changing the default passwords for the openser and openserro users. We tried changing the passwords in openserctlrc to correspond with the mysql user password changes. We granted the rights accordingly in mysql as well. We also found /usr/local/lib/openser/openserctl/openserctl.sqlbase and /usr/local/sbin/openser_mysql.sh that referenced the passwords and we changed them accordingly there and still had no luck. We could not find any other files that seemed to reference the actual passwords. So we then removed the database and tried a fresh install and got the same result. So again the database was removed and this time we altered /usr/local/lib/openser/openserctl/openserctl.sqlbase and /usr/local/sbin/openser_mysql.sh to reflect the passwords we wanted to use, and ran openser_mysql.sh create. This resulted in the same error as before. So, we set all the files back to default with the default passwords, removed all mysql database info and again ran operser_mysql.sh create. Then ran openserctl start again:
# openserctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded Starting OpenSER : \E[37;33mINFO: started (pid: 3947) #Sweet! We then stopped openser and went and changed the passwords again in mysql and in openserctlrc and got the same error as before. It is impossible to change the passwords for openser and openserro to something other than the default! Crazy! We do not want to run with the default passwords...
Any ideas?
We are using OpenBSD 4.0 i386, openSER-1.1.1-tls, mysql5.0.
Thanks, Ben
----- Original Message ----- From: "Ben Ferguson - backcountry.com" bferguson@backcountry.com To: users@openser.org Sent: Tuesday, February 20, 2007 2:04:15 PM (GMT-0700) US/Mountain Subject: openSER on OpenBSD: cannot start openser
Hello all,
I've just installed openSER on OpenBSD and I'm now trying to get openSER to start and am having trouble. I try openserctl start and here's what i get:
# openserctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded Starting OpenSER : \E[37;31mERROR: PID file /var/run/openser.pid does not exist -- OpenSER start failed #After a bunch of reading it seems as if openserctl is now obsolete (???) and that you should use the init script. I can't find reference for anyone running it like this on OpenBSD. I have found openser.init file in /<src directory>/packaging/gentoo and /<src directory>/packaging/rpm, but i am not sure how to use them on OpenBSD (I'm rather new to OpenBSD... I'm used to the rpm style of things.)
I've searched and searched but can't find any info... So. anybody out there using openSER on OpenBSD? Or anybody know howto (or whereto find the info to) set up the start script for openSER on OpenBSD?
Any help is greatly appreciated!
Thanks, Ben
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Ben,
the DB passoword is part of the DB url. See: http://www.openser.org/docs/modules/1.2.x/auth_db.html#AEN70
regards, bogdan
Ben Ferguson - backcountry.com wrote:
This line? modparam("auth_db", "password_column", "password")
If so, yes, we did try altering that line to reflect the password for the 'openser' user. Is that what you mean?--If not, can you explain?
Thanks for the help.
-Ben-
----- Original Message ----- From: "Ovidiu Sas" sip.nslu@gmail.com To: "Ben Ferguson - backcountry.com" bferguson@backcountry.com Cc: users@openser.org Sent: Tuesday, February 20, 2007 6:36:50 PM (GMT-0700) US/Mountain Subject: Re: [Users] Re: openSER on OpenBSD: cannot start openser
Hi Ben,
Have you changed the password inside the openser.cfg file?
Regards, Ovidiu Sas
On 2/20/07, Ben Ferguson - backcountry.com bferguson@backcountry.com wrote:
After further investigation, it looks as though this is actually caused by changing the default passwords for the openser and openserro users. We tried changing the passwords in openserctlrc to correspond with the mysql user password changes. We granted the rights accordingly in mysql as well. We also found /usr/local/lib/openser/openserctl/openserctl.sqlbase and /usr/local/sbin/openser_mysql.sh that referenced the passwords and we changed them accordingly there and still had no luck. We could not find any other files that seemed to reference the actual passwords. So we then removed the database and tried a fresh install and got the same result. So again the database was removed and this time we altered /usr/local/lib/openser/openserctl/openserctl.sqlbase and /usr/local/sbin/openser_mysql.sh to reflect the passwords we wanted to use, and ran openser_mysql.sh create. This resulted in the same error as before. So, we set all the files back to default with the default passwords, removed all mysql database info and again ran operser_mysql.sh create. Then ran openserctl start again:
# openserctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded Starting OpenSER : \E[37;33mINFO: started (pid: 3947) #Sweet! We then stopped openser and went and changed the passwords again in mysql and in openserctlrc and got the same error as before. It is impossible to change the passwords for openser and openserro to something other than the default! Crazy! We do not want to run with the default passwords...
Any ideas?
We are using OpenBSD 4.0 i386, openSER-1.1.1-tls, mysql5.0.
Thanks, Ben
----- Original Message ----- From: "Ben Ferguson - backcountry.com" bferguson@backcountry.com To: users@openser.org Sent: Tuesday, February 20, 2007 2:04:15 PM (GMT-0700) US/Mountain Subject: openSER on OpenBSD: cannot start openser
Hello all,
I've just installed openSER on OpenBSD and I'm now trying to get openSER to start and am having trouble. I try openserctl start and here's what i get:
# openserctl start database engine 'MYSQL' loaded Control engine 'FIFO' loaded Starting OpenSER : \E[37;31mERROR: PID file /var/run/openser.pid does not exist -- OpenSER start failed #After a bunch of reading it seems as if openserctl is now obsolete (???) and that you should use the init script. I can't find reference for anyone running it like this on OpenBSD. I have found openser.init file in /<src directory>/packaging/gentoo and /<src directory>/packaging/rpm, but i am not sure how to use them on OpenBSD (I'm rather new to OpenBSD... I'm used to the rpm style of things.)
I've searched and searched but can't find any info... So. anybody out there using openSER on OpenBSD? Or anybody know howto (or whereto find the info to) set up the start script for openSER on OpenBSD?
Any help is greatly appreciated!
Thanks, Ben
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Ben Ferguson - backcountry.com -
Bogdan-Andrei Iancu